Re: db connection fails

Mark -

A few random thoughts-

When we installed Apache, the user it ran under by default was "www-data".
Are you sure it is running using "apache"?

Have you tried doing a network connection with your "apache" user? (su -
apache; psql -h localhost group3.)

Log file locations may vary by OS flavor, but in Debian, you can find a log
in /var/log/postresql.log. You may have to turn on logging in
postgresql.conf.

-Nick

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

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Mark Tessier
> Sent: Saturday, June 29, 2002 2:41 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] db connection fails
>
>
> I get a script error when trying to connect to postgres. It fails
> in the following part of the script:
>
> PgDatabase conn ("host=localhost dbname=group3");
>
> if (conn.ConnectionBad())
> {
>     ...
> }
>
> /var/log/messages shows
>
> authentication failure; logname=capmag uid=502 euid=0 tty= ruser
> = rhost= user=postgres
>
> As "capmag" user with DBCREATE privileges, created db called
> group3. As I'm accessing group3 via html and C++ script in
> cgi-bin, I've created a user named "apache" with grant all
> priviledges in group3.
>
>
> Mark
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>