phpPgAdmin permissions errors

philpem

Member
Aug 12, 2005
17
0
151
Hi.
I've created a PostgreSQL database using cPanel. Everything seems to work fine - I can access the database from PHP, add and delete records, drop tables, and so forth. However, if I try and manipulate the data with phpPgAdmin, I get various problems. If I log in to PgAdmin as "myusername" (the cpanel default), I can browse all my databases, but if I try and open a table I get the error "ERROR: mytable: permission denied". If I log in as "myusername_mydatabase" I can't see any databases in the listing.
What am I doing wrong? All I wanted to do was take a look at some data in a DB and watch it change as my PHP script edits it.

Thanks,
Phil.
 

maximus_marcus

Well-Known Member
Mar 9, 2006
58
0
156
Hello,

Checkout the permission of the folder /var/lib/mysql on the server and if necessary also refer to the mysql log for more help .
 

bijo

Well-Known Member
Aug 21, 2004
475
0
166
India