Re: db connection fails

> > Have you tried doing a network connection with your "apache" user? (su -
> > apache; psql -h localhost group3.)
>
> Yes, I've tried it and get the following:
>
> psql: could not connect to server: Connection refused
> Is the server running on host 192.168.1.2 and accepting
> TCP/IP connections on port 5432?

This is a useful clue. It suggests that your code may be fine and that the
problem is in the networking or authentication setup. (You're using TCP/IP
even if you are on the same box.)

If you haven't already done so, take a look at your pg_hba.conf file. Info
on how to set it up can be found here:

http://www.postgresql.org/idocs/index.php?client-authentication.html

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/