In addition to that, check you pg_hba.conf file for restrictions to
using the db over ip.
Rgds,
Stephan
On Wed, 2002-01-23 at 08:49, jeff fitzmyers wrote:
> I'm not sure, but you might try: CREATE USER www-data;
> and then give the user permissions for the table:
> GRANT INSERT,SELECT,UPDATE ON "personnel" TO "www-data";
>
> jeff
>
>
> On Tuesday, January 22, 2002, at 01:18 PM, Jeff Self wrote:
>
> > Ok, I tried this and this is the error message I get now:
> >
> > Warning: Unable to connect to PostgreSQL server: FATAL 1: user
> > "www-data" does not exist in /var/www/personnel/include/database.inc on
> > line 9
> > Could not connect to database.
> >
> > www-data is the user and group for apache. I don't know what to make of
> > this.
> >
> > Here's my database.inc file:
> >
> > <?php
> > //
> > // database.inc
> > //
> > // Database Information
> >
> > $dbname = "personnel";
> >
> > $conn = pg_pconnect("host=localhost port=5432 dbname=$dbname");
> > if (!$conn) {
> > echo "Could not connect to database.";
> > exit;
> > }
> > ?>
> >
> >
> > On Tue, 2002-01-22 at 15:54, timothy_maguire@hartehanks.com wrote:
> >>
> >> When I connect I don't like to use the user name attribute. You might
> >> also
> >> want to try the port attribute.
> >>
> >> Try something like this:
> >>
> >> $conn =pg_connect("host=localhost port=5432 dbname=personnel") or die
> >> ("unable to connect to Internal DB");
> >>
> >> Tim.
> >>
> >> Timothy P. Maguire
> >> Web Developer II
> >> Harte-Hanks
> >> 978 436 3325
> >
> > --
> > Jeff Self
> > Information Technology Analyst
> > Department of Personnel
> > City of Newport News
> > 2400 Washington Ave.
> > Newport News, VA 23607
> > 757-926-6930
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
ÿþS