[cisco-voip] Instructions on installing/configuring PostgreSQL on Windows for Presence and IM?

[Jeffrey Girard]

I have searched the Cisco site and there are tons of documents on how to configure the database for *nix installs.  I, unfortunately, am not skilled in that arena.

I have downloaded and installed PostgreSQL on a Win2k8R2 server.

I tried to interpret the Cisco doc instructions as best I could

I have created a new database called tcmadb

I have created a new entity under Login Roles called tcuser and gave that user superadmin rights

I went back to the tcmadb database and made the tcuser the owner of the database

In CUPS, I created the new external database:

          Database name -> tcmadb
          Username -> tcuser
          Pasword -> password that I assigned to tcuser when I created it in the database
          Hostname -> IP address of my win2K8 server
          Port Number -> 5432.

After several failures, I found a thread that indicated that I should create a new user in the Windows domain called tcuser.  I did that, and gave that user domain admin privileges.

I get the failure to connect error under External Database Status

Green check for reachability
Failure on connectivity to database "Verify the hostname, username, and password are valid"

Does it have anything to do with the postgres user account?

Jeff

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140320/15648025/attachment.html>