Skip site navigation (1) Skip section navigation (2)

Fw: Re: connection refused

From: Bruce Hyatt <brucejhyatt(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Fw: Re: connection refused
Date: 2008-12-16 00:12:35
Message-ID: 286409.96866.qm@web34401.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- On Fri, 12/12/08, Bastiaan Olij <lists(at)basenlily(dot)nl> wrote:

> If you are on Mac or
> Linux, are
> the privileges set correctly? On one of our Mac servers we
> it took us
> some time to figure out Postgres was simply ignoring the
> files because
> the privileges where set different then it wanted, even
> though it did
> seem to have access.
>
> Greetz,
>
> Bas

I think the problem is something along these lines. I originally had the authentication method set to "MD5" in pg_hba.conf. I changed it to "trust" (and restarted postgres) just to try to get it working, without success. I happened to reboot the postgres host (linux) and httpd wouldn't start because it couldn't find mod_auth_pgsql.so. I commented out the line in auth_pgsql.conf loading it and apache complained that it needed the ssl passphrase.

I have mod_auth_pgsql.so so I'm going to try to mollify apache with that and see where it leads.

As for Tom's suggestion that the firewall is the problem, I don't think it is, having looked at the IPTables rules. There are essentially no restrictions (the network is behind a firewall). Having said that, I don't know much about IPTables and there were 1 or 2 entries that I definitely didn't understand. I plan to learn IPTables too though.

Thanks for the help,
Bruce Hyatt

>
> Bruce Hyatt wrote:
> > I've been over my pg_hba.conf and postgresql.conf
> files again and again, restarting after changes and I always
> get 08004 connection refused when I try to connect through
> the postgresql jdbc from another machine.
> >
> > The user name I'm using works from the postgresql
> host and I have enabled IP/TCP connections to the database.
> >
> > Anything else? Surely this is something obvious
> I'm overlooking.
> >
> > Thanks,
> > Bruce Hyatt


      

pgsql-novice by date

Next:From: Wright, GeorgeDate: 2008-12-16 14:18:52
Subject: strange looking error
Previous:From: Tom LaneDate: 2008-12-13 04:41:30
Subject: Re: connection refused

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group