Re: Not able to connect to server from PHP

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
>