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