Date: Sat, 5 Jun 1999 12:57:44 -0400 From: "Jim Freeze" <jim@freeze.org> To: <pgsql-novice@postgreSQL.org>, <freebsd-questions@FreeBSD.ORG> Subject: PostgreSQL query has permission denied error Message-ID: <000a01beaf74$88f55840$e06ec8d0@lexmark.com>
next in thread | raw e-mail | index | archive | help
I am using FreeBSD 3.1 and netscape on a standalone system. I have the ports install of apache, php3 and postgreSQL installed. I have created a database called mydb with a table tableone and two fields, fieldone and fieldtwo. I have also added two rows of information. My goal is to access this database from a web page. Although I can get the name of the database, I cannot perform queries on the databse. The following code <?php $dbName = pg_dbname($dbc); if (!$dbc) { echo "An error occured.\n"; exit; } $result = pg_Exec($dbc, "SELECT * FROM tableone"); if (!$result) { echo "An error occured.\n"; exit; } ?> produces the following error Warning: PostgresSQL query failed: ERROR: tableone: Permission denied. in /usr/local/www/data/php1.php3 on line 17 An error occured. where line 17 is 17: $result = pg_Exec($dbc, "SELECT * FROM tableone"); Since I don't understand what is going on here, I tried logging into my BSD account as root, pgsql and postgres, and accessing the web page, but I received the same error. In case it helps, the following is an excerpt of my passwd file. nobody:*:65534:65534:Unprivileged user:/nonexistent:/sbin/nologin jfreeze:*:1001:1001:User &Jim Freeze:/usr/jfreeze:/bin/csh pgsql:*:70:70:PostgreSQL pseudo-user:/usr/local/pgsql:/bin/sh postgres:*:1002:1002:User &PostgreSQL SuperUser:/usr/postgres:/bin/sh I do not know how to list the pgsql users and privelages, if that info is needed. Thanks for any help. ================== Dr Jim D. Freeze jim@freeze.org ================== To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000a01beaf74$88f55840$e06ec8d0>