Please join your peers on either March 26 (8pm GMT) or March 28 (8am GMT) to watch as user extraordinaire and forum legend @"lindsay.stevens" demonstrates OpenClinica Insight.

See preview and register at https://openclinica.com/insight-webinar

Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.

FATAL: Ident authentication failed for user ""clinica

I have installed as per instructions:
Centos 5.3
Postgres 8.4.4
Apache Tomcat 6.0.24
Java 2 SDK 1.6.0-14
I successfully have executed the create create_role.sql and create_db.sql
But when I try and deploy the war file and restart tomcat I get this
error in the logfile:
SEVERE: Exception sending context initialized event to listener
instance of class
org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'liquibase' defined in file
[/usr/local/apache-tomcat-6.0.29/webapps/OpenClinica/
WEB-INF/classes/org/akaza/openclinica/applicationContext-core-db.xml]:
Invocation of init method failed; nested exception is
liquibase.exception.JDBCException: org.apac
he.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (FATAL: Ident authentication failed for user
"clinica")
I can connect using:
psql -U clinica -d openclinica
Any help would sure be appreciated as I did a google search and did
not find many posts on this error.
Thanks
Jim

Comments

  • miklamikla Posts: 20
    You should try to set FALSE in databasechangeloglock table. I guess it helps.
    On Thu, Oct 28, 2010 at 3:30 PM, Jim Van Etten wrote:
    I have installed as per instructions:
    Centos 5.3
    Postgres 8.4.4
    Apache Tomcat 6.0.24
    Java 2 SDK 1.6.0-14
    I successfully have executed the create create_role.sql and create_db.sql
    But when I try and deploy the war file and restart tomcat I get this
    error in the logfile:
    SEVERE: Exception sending context initialized event to listener
    instance of class
    org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error
    creating bean with name 'liquibase' defined in file
    [/usr/local/apache-tomcat-6.0.29/webapps/OpenClinica/
    WEB-INF/classes/org/akaza/openclinica/applicationContext-core-db.xml]:
    Invocation of init method failed; nested exception is
    liquibase.exception.JDBCException: org.apac
    he.commons.dbcp.SQLNestedException: Cannot create
    PoolableConnectionFactory (FATAL: Ident authentication failed for user
    "clinica")
    I can connect using:
    psql -U clinica -d openclinica
    Any help would sure be appreciated as I did a google search and did
    not find many posts on this error.
    Thanks
    Jim
  • GerbenRienkGerbenRienk Posts: 769 ✭✭✭
    Hello Jim,
    Maybe this has to do with your CentOS.
    Have a look at http://www.depesz.com/index.php/2007/10/04/ident/ and your
    pg_hba.conf
    Hope this helps,
    Gerben Rienk Visser
    http://www.trialdatasolutions.com
    -----Oorspronkelijk bericht-----
    Van: [email protected] [mailto:[email protected]]
    Namens Jim Van Etten
    Verzonden: donderdag 28 oktober 2010 14:31
    Aan: [email protected]
    Onderwerp: [Users] FATAL: Ident authentication failed for user "clinica"
    I have installed as per instructions:
    Centos 5.3
    Postgres 8.4.4
    Apache Tomcat 6.0.24
    Java 2 SDK 1.6.0-14
    I successfully have executed the create create_role.sql and create_db.sql
    But when I try and deploy the war file and restart tomcat I get this
    error in the logfile:
    SEVERE: Exception sending context initialized event to listener
    instance of class
    org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error
    creating bean with name 'liquibase' defined in file
    [/usr/local/apache-tomcat-6.0.29/webapps/OpenClinica/
    WEB-INF/classes/org/akaza/openclinica/applicationContext-core-db.xml]:
    Invocation of init method failed; nested exception is
    liquibase.exception.JDBCException: org.apac
    he.commons.dbcp.SQLNestedException: Cannot create
    PoolableConnectionFactory (FATAL: Ident authentication failed for user
    "clinica")
    I can connect using:
    psql -U clinica -d openclinica
    Any help would sure be appreciated as I did a google search and did
    not find many posts on this error.
    Thanks
    Jim
  • Thnk you, it was the conf settings
    > On Oct 28, 2010 6:06 PM, "Gerben Rienk" wrote:
    >
    > Hello Jim,
    >
    > Maybe this has to do with your CentOS.
    > Have a look at http://www.depesz.com/index.php/2007/10/04/ident/ and your
    > pg_hba.conf
    > Hope this helps,
    >
    > Gerben Rienk Visser
    > http://www.trialdatasolutions.com
    >
    > -----Oorspronkelijk bericht-----
    > Van: [email protected] [mailto:[email protected]]
    > Namens Jim Van Etten
    > Verzonden: donderdag 28 oktober 2010 14:31
    > Aan: [email protected]
    > Onderwerp: [Users] FATAL: Ident authentication failed for user "clinica"
    >
    > I have installed as per instructions: Centos 5.3 Postgres 8.4.4 Apache Tomcat 6.0.24 Java 2 SDK 1....
    >
    >
This discussion has been closed.