Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

PostgreSQL/phpPgAdmin Permission Question

Discussion in 'General Discussion' started by mixx941, Dec 13, 2006.

  1. mixx941

    mixx941 Well-Known Member

    Joined:
    Oct 28, 2003
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    156
    Hi everyone.

    I installed PostgreSQL last night as per the instructions and everything went very smoothly. So far creating databases, adding users, giving users permissions to a database and all that works fine in cPanel. My question is about giving permission for the cPanel user to access the Postgres databases.

    Right now, I can login to phpPgAdmin with the cPanel username and password and it lists the databases and tables fine. However if I try to browse a table, I get "Permission denied for table_name" and cannot proceed. If I try to login to phpPgAdmin with the database username and password that owns the tables, I get "No databases found". I've done forum searches about this and so far have found more questions than answers. One thread pointed to a Usenet suggestion to do a "GRANT ALL ON table TO user" which worked, but that would be very inconvenient for a client to have to do that for every table they want to access via phpPgAdmin.

    Is there some way to do this so all a user's Postgres databases/tables/data can be accessed easily via phpPgAdmin with the cPanel username/password and without the user having to do anything special? Something similar to how phpMyAdmin allows access would be great.

    Thanks in advance.

    -Mark
    cPanel 10.9.0-CURRENT 93
    FreeBSD 6.1-RELEASE
    PostgreSQL 8.2.0
     
  2. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    166
    Bump..

    Bump - I am having the same issue now. Created a database, and a user, and associated the two. Next, when I use PhpPgAdmin, it hasn't associated the two! What gives??!! Is PostgreSQL supported by Cpanel or not? :mad:
     
  3. rimoun

    rimoun Registered

    Joined:
    Dec 3, 2005
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    I'm Having the same problem also!!
    Anyone can help ??!
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice