← Back to team overview

dhis2-users team mailing list archive

Re: DHIS can't connect to Postgres

 

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 should be
the same route taken by java.

Roger, if my earlier suggestion didn't work send a copy of your pg_hba.conf
file so we can have a look.  I must confess I have no idea what the default
one looks like on windows.


On 26 July 2013 12:12, Morten Olav Hansen <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> 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
>> 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
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References