FATAL: Ident authentication failed for user postgres Retrying...(1/4)

0
Hi All,   I am trying to set up a onsite deployment of Mendix on Redhat.  when starting the runtime we run into the following postgreSQL error....   any thoughts on what could cause this error?     2017-12-14 09:36:30.402 INFO - Core: Mendix Runtime 7.9.0 (build 17331.1). Copyright © 2003-2017 Mendix bv. All rights reserved. 2017-12-14 09:36:30.970 INFO - Services: Adding 0 authority certificate(s) 2017-12-14 09:36:33.458 WARNING - ConnectionBus: Database connections: 0 active, 0 idle. 2017-12-14 09:36:33.463 ERROR - ConnectionBus: Opening JDBC connection to Some(127.0.0.1:5432) failed with SQLState: 28000 Error code: 0 Message: FATAL: Ident authentication failed for user "postgres" Retrying...(1/4) 2017-12-14 09:36:33.574 WARNING - ConnectionBus: Database connections: 0 active, 0 idle. 2017-12-14 09:36:33.575 ERROR - ConnectionBus: Opening JDBC connection to Some(127.0.0.1:5432) failed with SQLState: 28000 Error code: 0 Message: FATAL: Ident authentication failed for user "postgres" Retrying...(2/4) 2017-12-14 09:36:33.785 WARNING - ConnectionBus: Database connections: 0 active, 0 idle. 2017-12-14 09:36:33.785 ERROR - ConnectionBus: Opening JDBC connection to Some(127.0.0.1:5432) failed with SQLState: 28000 Error code: 0 Message: FATAL: Ident authentication failed for user "postgres" Retrying...(3/4) 2017-12-14 09:36:34.195 WARNING - ConnectionBus: Database connections: 0 active, 0 idle. 2017-12-14 09:36:34.195 ERROR - ConnectionBus: Opening JDBC connection to Some(127.0.0.1:5432) failed with SQLState: 28000 Error code: 0 Message: FATAL: Ident authentication failed for user "postgres", giving up...(4/4) 2017-12-14 09:36:34.198 ERROR - M2EE: An error occurred while initializing the Runtime: Error on initializing database connection. 2017-12-14 09:36:34.198 ERROR - M2EE: com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime: Error on initializing database connection.         at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:350)   Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Error on initializing database connection.         at com.mendix.connectionbus.ConnectionBusInitializer.throwDefault$1(ConnectionBusInitializer.scala:58)   Caused by: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "postgres"         at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:438)         at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)         at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)         at org.postgresql.Driver.makeConnection(Driver.java:450)         at org.postgresql.Driver.connect(Driver.java:252)         at java.sql.DriverManager.getConnection(DriverManager.java:664)         at java.sql.DriverManager.getConnection(DriverManager.java:247)         at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94)         at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:79)         at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:44)         at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)         at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861)         at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)         at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)         at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)         at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49)         at com.mendix.connectionbus.ConnectionBusInitializer.$anonfun$createConnection$1(ConnectionBusInitializer.scala:52)         at scala.util.Try$.apply(Try.scala:209)         at com.mendix.connectionbus.ConnectionBusInitializer.retry(ConnectionBusInitializer.scala:60)         at com.mendix.connectionbus.ConnectionBusInitializer.createConnection(ConnectionBusInitializer.scala:52)         at com.mendix.connectionbus.ConnectionBusInitializer.initialize(ConnectionBusInitializer.scala:42)         at com.mendix.connectionbus.ConnectionBusImpl.initialize(ConnectionBusImpl.java:295)         at com.mendix.basis.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:483)         at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:321)         at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:277)         at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:49)         at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:30)         at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:119)         at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)         at org.eclipse.jetty.server.Server.handle(Server.java:561)         at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)         at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)         at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)         at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)         at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)         at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)         at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)         at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)         at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243)         at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)         at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)         at java.lang.Thread.run(Thread.java:748)
asked
2 answers
1

The most obvious reason would be that your database requires a different username / password combination than what you entered in the service console.

answered
0

It's most likely the login method of the client. Ident-based authentication instead of password authentication.

"Caused by: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "postgres"

 

 

answered