complain about port 113 ???

[Tom Running]

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

[Nicolas Malin-2]

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
>