Re: Not able to connect to server from PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx
> >
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
-- 
ÿþS



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux