dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Ok thats good to know.  But I am curious because I would have thought that
would have been the default.  Can you remember what the default
listen_address was in postgresql.conf?  If it wasn't listening at least on
localhost then it means its inaccesable in the default install.


On 29 July 2013 19:53, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@xxxxxxx>wrote:

>  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
>
> *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            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****
>
> S hannan.khan.dhaka****
>
>   ****
>
> ** **
>
> On Fri, Jul 26, 2013 at 4:12 PM, 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****
>
> ** **
>
> _______________________________________________
> 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
>
>