Hi Tom,
Maybe your entity engine configuration is wrong or you postgres database
isn't configure to receive the connection.
By default on debian isn't correct to contact the db with the postgres
user over localhost
Nicolas
Le 21/06/2015 06:20, Tom Running a écrit :
Try to start ofbiz and it had the following error. Using 14.2 with ./ant
load-seed
****ERRORS **********************
[java] Caused by: java.sql.SQLException: Unable to acquire a new
connection from the pool
[java] at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:130)
~[commons-dbcp2-2.1.jar:2.1]
[java] ... 8 more
[java] Caused by: org.postgresql.util.PSQLException: FATAL: Ident
authentication failed for user "postgres"
[java] at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:420)
~[postgresql-9.4-1201.jdbc41.jar:9.4]
*************Postgres database info **************
Information postgres user:
erp=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
erp | | {}
erpadmin | | {}
erpolap | | {}
erptenant | | {}
postgres | Superuser, Create role, Create DB, Replication | {}
erp=# ALTER USER postgres WITH PASSWORD 'admin';
ALTER ROLE
ALTER USER postgres WITH PASSWORD 'admin' ;
***************small portion of
/ofbiz/framework/entity/config/entityengine.xml *******************
I have the following user's info in the file
/ofbiz/framework/entity/config/entityengine.xml
jdbc-uri="jdbc:postgresql://127.0.0.1/erp"
jdbc-username="postgres"
jdbc-password="admin"
************ postgres configuration file pg_hba.conf ****************
# "local" is for Unix domain socket connections only
local all all ident
local erp postgres password
local erpolap postgres password
local erptenant postgres password
# IPv4 local connections:
host all all 127.0.0.1/32 ident
host erp postgres 127.0.0.1/32 password
host erpolap postgrep 127.0.0.1/32 password
host erptenant postgres 127.0.0.1/32 password
********* postgres database log ***********
FATAL: Ident authentication failed for user "postgres"
LOG: could not connect to Ident server at address "127.0.0.1", port 113:
Connection refused
********Postgres ran on post 5432 ***************
-bash-4.2$ netstat -an | grep 5432
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:5432 127.0.0.1:48491
TIME_WAIT
tcp6 0 0 ::1:5432 :::* LISTEN
tcp6 0 0 127.0.0.1:48493 127.0.0.1:5432
TIME_WAIT
unix 2 [ ACC ] STREAM LISTENING 468877
/var/run/postgresql/.s.PGSQL.5432
unix 2 [ ACC ] STREAM LISTENING 468879
/tmp/.s.PGSQL.5432
Anyone have any it complain about port 113 ???
ANY insight will be appreciate it.
Thanks,
T
