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

[Florian Kroessbacher]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140320/c219fa52/attachment.html>