This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

During retain installation I get The following errors occurred during database configuration: Cannot create DB connection. Check dbURL/dbUser/dbPassword fields

I created the DB using Pgadmin 4 and can connect to it using the rtuser login. So I know the password is correct for the account. 

I am using google chrome and was able to change the paths through the web browsers in step 1. 

I am running the installation wizard from my desktop. 

I have tried localhost

ip address of the server 10.0.50.57

Ip address of the server with postgres port 10.0.50.57:5432

I dropped the F/W, but no luck.

I tried the same accounts and IP addresses on the actual server using fire fox, still get the same connection error.

Any thoughts would be appreciated. 

Parents
  • 0

    I have look at the catalina log file and found this error:

    29-Oct-2021 14:33:10.961 SEVERE [ajp-nio-127.0.0.1-48009-exec-2] org.postgresql.Driver.connect Connection error:
    org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "rtuser"

    In the retain server log I get this error:

    14:33:10, 962[ajp-nio-127.0.0.1-48009-exec-2] [FATAL] SetupWizard: DB connection credentials are wrong
    14:33:10, 962[ajp-nio-127.0.0.1-48009-exec-2] [ERROR] SetupWizard: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "rtuser"

    The var/log/messages has the same message as the catalina log.

    I was getting connection resfused by postgresql.Driver.Connect.  It seems that has cleared up after removing all my changes to pg_hba.conf, pg_ident.conf to allow the postrgres db user rtuser access to the postgresaql retain database. rtuser has full super user access.  

    I am not sure why the user is being denied by ident authentication.  

    I have even created and added a system sles account called rtuser with the same password used in the retain.db. and made the account part of the www and tomcat groups. But still getting the above error.

    I have look in the knowedge base, but nothing comes up regarding this problem.  You would think out of the box the postgressql db user would be able to connect to its own database. Not sure why the user is being denied. 

    Any help would be appreciated.

Reply
  • 0

    I have look at the catalina log file and found this error:

    29-Oct-2021 14:33:10.961 SEVERE [ajp-nio-127.0.0.1-48009-exec-2] org.postgresql.Driver.connect Connection error:
    org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "rtuser"

    In the retain server log I get this error:

    14:33:10, 962[ajp-nio-127.0.0.1-48009-exec-2] [FATAL] SetupWizard: DB connection credentials are wrong
    14:33:10, 962[ajp-nio-127.0.0.1-48009-exec-2] [ERROR] SetupWizard: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "rtuser"

    The var/log/messages has the same message as the catalina log.

    I was getting connection resfused by postgresql.Driver.Connect.  It seems that has cleared up after removing all my changes to pg_hba.conf, pg_ident.conf to allow the postrgres db user rtuser access to the postgresaql retain database. rtuser has full super user access.  

    I am not sure why the user is being denied by ident authentication.  

    I have even created and added a system sles account called rtuser with the same password used in the retain.db. and made the account part of the www and tomcat groups. But still getting the above error.

    I have look in the knowedge base, but nothing comes up regarding this problem.  You would think out of the box the postgressql db user would be able to connect to its own database. Not sure why the user is being denied. 

    Any help would be appreciated.

Children