Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-30 Thread Friedman, Roger (CDC/CGH/DGHA) (CTR)
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@lists.launchpad.net Subject: RE: [Dhis2-users] DHIS can't connect to Postgres Thanks for all the

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-29 Thread Bob Jolliffe
3 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 > &

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-29 Thread Friedman, Roger (CDC/CGH/DGHA) (CTR)
d.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: hostall all 127.0.0.1/32<http://127.0.0.1/32> md5 # IPv6 local connections: hostall

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-28 Thread Hannan Khan
For windows you have to the following two lines in pg_hba.conf # IPv4 local connections: hostall all 127.0.0.1/32md5 # IPv6 local connections: hostall all ::1/128 md5 In the postgresql.conf the following line shou

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-28 Thread Wilson,Randy
Jolliffe Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] DHIS can't connect to Postgres Dear All, Please check the hibernet.properties file which is keep inside dhis folder or inside dhis.war file. Several time iface same problem and solved by using this hibernet.properties file.

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-28 Thread Uddin Fatema
Dear All, Please check the hibernet.properties file which is keep inside dhis folder or inside dhis.war file. Several time iface same problem and solved by using this hibernet.properties file. I am giving one hibernet.properties file here -- hibernate.dialect = org.hibernate.d

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-26 Thread Bob Jolliffe
No you don't. local is for unix domain sockets which are not used by java. Also windoze doesn't have them either so I doubt if this line has any effect at all. If Roger is authenticating through pgadmin on windows then he must be connecting via tcp (host or hostssl line in pg_hba.conf) so it sho

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-26 Thread Bob Jolliffe
Most likely is trailing spaces at the end of lines in hibernate.properties. Make sure there is no whitespace before the line ending or it will be seen as part of the credential string. On 26 July 2013 12:09, Friedman, Roger (CDC/CGH/DGHA) (CTR) wrote: > We have a new 64-bit installation: Wind

Re: [Dhis2-users] DHIS can't connect to Postgres

2013-07-26 Thread Morten Olav Hansen
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

[Dhis2-users] DHIS can't connect to Postgres

2013-07-26 Thread Friedman, Roger (CDC/CGH/DGHA) (CTR)
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