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

[Jeffrey Girard]

Florian –
          Thanks for the response.

          Yes, I have already turned off the firewall completely

          No, I have not done any config in the hba.conf  -  I don’t know what that is or where its located

------------------------------------------------------------------------------------
Dr. Jeffrey T. Girard (Jeff), PhD
Colonel, United States Army (Retired)
Senior Network Engineer / VoIP Engineer - WireMeHappy.com
reply to: jeffrey.girard at wiremehappy.com<mailto:jeffrey.girard at wiremehappy.com>
(607)835-0406 (home office)
(845)764-1661 (mobile)
(607)835-0458 (fax)

From: Florian Kroessbacher [mailto:florian.kroessbacher at gmail.com]
Sent: Thursday, March 20, 2014 12:26 PM
To: Jeffrey Girard
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Instructions on installing/configuring PostgreSQL on Windows for Presence and IM?

hy

have u checked the local fw on the windows server for inbound connection from the presence server.

have u done the config in the hba.conf and so on

Am Donnerstag, 20. März 2014 schrieb 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



--
--
Florian Kroessbacher
gmail: florian.kroessbacher at gmail.com<mailto:florian.kroessbacher at gmail.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140320/669151db/attachment.html>