cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2775
Views
5
Helpful
7
Replies
Highlighted
Beginner

Presence 8.0 with External Database (IM Logging)

I downloded the POstgres databse windows installer and have installed it on a seperate server.

I followed the Doc from Cisco but I get this error.

Verify external database server connectivity (database connection check):

The following CUP node to external database server connection(s) failed:

  • presence >> tcmadb (Message Archiver)
  • Solution:

    Verify the hostname, username, and password are valid

    Well they are??

    HOst i put the IP, 10.10.10.18

    Any help?  Username is right since i can login on the server itself.

    1 ACCEPTED SOLUTION

    Accepted Solutions
    Highlighted
    Beginner

    After 2 days of time wasting , I tried lordshawn 's method and it finally worked...

    Try creating an admin user in windows named tcuser and it should help

    View solution in original post

    7 REPLIES 7
    Highlighted
    Beginner

    So two days of hacking i got it to pass. I made a user account named "TCUSER" on the windows server with ADMIN rights.   That WAS NOT in the documentation!!!!!!!!

    Highlighted

    Can you elaborate on the TCUser? I have getting the same error message and I am sure the hostname, username and pas
    sword are correct.

    Did you create a TCUSER as a database login user? if so, what rights did you give them. Did you use the default database postgres?

    Thanks for your help.

    Highlighted

    check this link for tcuser...

    http://www.cisco.com/en/US/docs/voice_ip_comm/cups/8_0/english/install_upgrade/database/guide/Installing_Configuring_Postgre.html#wpxref31145

    you should alter tcuser as superuser in the db which you create..

    Highlighted

    I am also facing the same issue, need help. I have installed PostgressSQL 9.0 and 9.3 on my Laptop. While connecting database from Presence Server, putting Hostname as my Laptop's IP address.
     

    Highlighted
    Beginner

    After 2 days of time wasting , I tried lordshawn 's method and it finally worked...

    Try creating an admin user in windows named tcuser and it should help

    View solution in original post

    Highlighted

    Yup that works.  Glad someone else found this post!

    Highlighted

    You must edit the pg_hba.conf file to allow connections from your CUPS server. Without this you will get the "

    Verify the hostname, username, and password are valid" error.

    While this is documented it is not completely clear as documented on this page:

    http://www.cisco.com/en/US/docs/voice_ip_comm/cups/8_0/english/install_upgrade/database/guide/Preparing_database_setup.html#wp1055358

    Content for Community-Ad