Re: [Dev] PostgreSQL Connection error when starting up API Manager 1.6.0

2014-05-22 Thread Chamara Ariyarathne
Finally got it to work after a few iterations. The correct entry to the pg_hba.conf should be as following. #TYPE DATABASE USER CIDR-ADDRESS IP-MASK METHOD host all all 172.16.2.10 255.255.255.255 md5 After successfully connected to the database the -Dsetup also worked and the tables in the jdbc/

Re: [Dev] PostgreSQL Connection error when starting up API Manager 1.6.0

2014-05-20 Thread Bhathiya Jayasekara
On Tue, May 20, 2014 at 9:31 AM, Bhathiya Jayasekara wrote: > Hi Chamara, > > Where do you have the database server? Locally or remote? If it's remote > you will have to enable TCP/IP connections for db server ( > *tcpip_socket=true* in postgresql.conf) and allow connections from APIM > machine. Y

Re: [Dev] PostgreSQL Connection error when starting up API Manager 1.6.0

2014-05-20 Thread Bhathiya Jayasekara
Hi Chamara, Where do you have the database server? Locally or remote? If it's remote you will have to enable TCP/IP connections for db server ( *tcpip_socket=true* in postgresql.conf) and allow connections from APIM machine. You can do this by adding a host entry to *pg_hba.conf.* Thanks, Bhathiy

[Dev] PostgreSQL Connection error when starting up API Manager 1.6.0

2014-05-20 Thread Chamara Ariyarathne
Has anyone seen this error before with a WSO2 product? I'm getting this connection error when API Manager is configured to use a postgresql database. [2014-05-20 17:14:36,796] FATAL - DatabaseCreator Failed to create database tables for registry resource store. FATAL: no pg_hba.conf entry for host