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
