Thanks for all the help. Hannan Khan's answer made the difference -- setting listen_address in postgresql.conf
From: Hannan Khan [mailto:hann...@gmail.com] Sent: Monday, July 29, 2013 2:33 AM To: Morten Olav Hansen Cc: Friedman, Roger (CDC/CGH/DGHA) (CTR); dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] DHIS can't connect to Postgres For windows you have to the following two lines in pg_hba.conf # IPv4 local connections: host all all 127.0.0.1/32<http://127.0.0.1/32> md5 # IPv6 local connections: host all all ::1/128 md5 In the postgresql.conf the following line should be there listen_addresses = 'localhost' I presume that tomcat and postgres are on the same computer. Hope that will help. Also check the white space in the hibernate file as Bob mentioned. If not solved send us the tomcat cat log, postgres log, and the .conf files. Regards Muhammad Abdul Hannan Khan Senior Technical Advisor - HIS Priority Area Health Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh GIZ-DGHS Room # 304, Shahid Dr. Milon Bhaban Director General of Health Service of MoHFW Mohakhali, Dhaka T +880-2- 8816459, 8816412 ext 118 M+88 01819 239 241 M+88 01534 312 066 F +880-2-8813875 E hannan.k...@giz.de<mailto:hannan.k...@giz.de> S hannan.khan.dhaka On Fri, Jul 26, 2013 at 4:12 PM, Morten Olav Hansen <morte...@gmail.com<mailto:morte...@gmail.com>> wrote: Did you switch to using md5 auth in pg_hba.conf? local all all md5 Not sure what's the default on windows, but on Ubuntu you always have to do that.. -- Morten On Fri, Jul 26, 2013 at 5:09 PM, Friedman, Roger (CDC/CGH/DGHA) (CTR) <r...@cdc.gov<mailto:r...@cdc.gov>> wrote: We have a new 64-bit installation: Windows, Tomcat7, Postgres9.2. hibernate.properties like manual, connection //localhost:8080/dhis. Tomcat log shows authentication error making connection, and login rejection can be seen in Postgres log. This happens with 2 different username/password pairs, both of which work when used with pgAdmin. Any ideas? _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
