dhis2-users team mailing list archive

["Friedman, Roger (CDC/CGH/DGHA) (CTR)" <rdf4@xxxxxxx>]

The default is * which works in 32-bit but not 64-bit Win 7.

From: Friedman, Roger (CDC/CGH/DGHA) (CTR)
Sent: Monday, July 29, 2013 2:54 PM
To: Hannan Khan; Morten Olav Hansen
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: RE: [Dhis2-users] DHIS can't connect to Postgres

Thanks for all the help.  Hannan Khan's answer made the difference -- setting listen_address in postgresql.conf

From: Hannan Khan [mailto:hannank@xxxxxxxxx]
Sent: Monday, July 29, 2013 2:33 AM
To: Morten Olav Hansen
Cc: Friedman, Roger (CDC/CGH/DGHA) (CTR); dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
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.khan@xxxxxx<mailto:hannan.khan@xxxxxx>

S hannan.khan.dhaka


On Fri, Jul 26, 2013 at 4:12 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx<mailto:mortenoh@xxxxxxxxx>> 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) <rdf4@xxxxxxx<mailto:rdf4@xxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp