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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Tessier > Sent: Saturday, June 29, 2002 2:41 PM > To: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED]) > > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org