Presence 8.0 with External Database (IM Logging)

Answered Question
Jul 29th, 2010
User Badges:

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.

    Correct Answer by skarahasan about 6 years 2 months ago

    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

    • 1
    • 2
    • 3
    • 4
    • 5
    Overall Rating: 5 (2 ratings)
    Loading.
    lordshawn Thu, 07/29/2010 - 10:46
    User Badges:

    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!!!!!!!!

    marknigh1 Thu, 01/06/2011 - 20:21
    User Badges:

    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.

    kalshetty Wed, 11/12/2014 - 23:16
    User Badges:

    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.
     

    Correct Answer
    skarahasan Tue, 01/11/2011 - 00:15
    User Badges:

    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

    lordshawn Tue, 01/11/2011 - 08:16
    User Badges:

    Yup that works.  Glad someone else found this post!

    jsmcniel88 Mon, 09/12/2011 - 14:13
    User Badges:

    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

    Actions

    This Discussion