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)
>
>