Re: postgresql database access failure
| From: | e-letter | Date: | Mon, 02 May 2011 07:22:14 +0000 |
| Subject: | Re: postgresql database access failure | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-312616@lists.php.net to get a copy of this message | ||
The query was:
$query = 'SELECT * FROM databasetablename';
So, database access seems to be the problem. Using the superuser
account 'postgres', a user 'httpd' was created and all privileges were
granted to the target database using the postgresql 'grant' command.
However the user 'httpd' is not the owner of the database so perhaps
that is the problem, although if this user could not access the
database that would cause an error in the log (but no such error is
seen)?