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!

Cannot manage PostgreSQL DBs/Tables with phpPgAdmin

Discussion in 'Database Discussion' started by Oldiesmann, Dec 29, 2016.

Tags:
  1. Oldiesmann

    Oldiesmann Active Member

    Joined:
    Dec 30, 2008
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Cincinnati, Ohio, USA
    cPanel Access Level:
    Root Administrator
    I am running CentOS 7 with PostgreSQL 9.2.18 and the latest release version of cPanel/WHM (it's a VPS). I mostly use PostgreSQL to test a forum script that I am a developer for. Recently we added a few more columns to one of the database tables. Since it's a development version, the simplest option was to go into phpPgAdmin and add the columns. However, upon trying to execute the changes, I just get an error saying "Error: must be owner of relation <table>". This is when logged in to cPanel as the account owner (not as root). All of the tables are owned by the user that created them, but the cPanel user doesn't have the appropriate privileges to fix the tables. I even tried granting the cPanel user all privileges on the database (which I was able to do), but I couldn't grant that user privileges. The only way I was able to add the columns was to login to PostgreSQL via the shell as the user that owned the database.

    In WHM I went in to the "Configure PostgreSQL" section and clicked "add users", but now trying to log in to phpPgAdmin fails entirely (it just says "Login failed").
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Oldiesmann, Dec 29, 2016
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,968
    Likes Received:
    2,119
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Our PostgreSQL Databases document offers a note that may explain the issue you are experiencing:

    Could you let us know if using the Synchronize Grants option helps?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jan 6, 2017
  3. Oldiesmann

    Oldiesmann Active Member

    Joined:
    Dec 30, 2008
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Cincinnati, Ohio, USA
    cPanel Access Level:
    Root Administrator
    The only way I'm able to login is if I use the synchronize grants option. However, I'm still unable to add columns to a table created by one of the database users.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 Oldiesmann, Jan 6, 2017
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,968
    Likes Received:
    2,119
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Jan 12, 2017
  5. Oldiesmann

    Oldiesmann Active Member

    Joined:
    Dec 30, 2008
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Cincinnati, Ohio, USA
    cPanel Access Level:
    Root Administrator
    Thanks. The ticket ID is 8129137. I also referenced this topic in the ticket.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 Oldiesmann, Jan 13, 2017
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,968
    Likes Received:
    2,119
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    To update, it looks like the issue was not reproducible and is no longer occurring.

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Jan 23, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - Cannot manage PostgreSQL
  1. Eclipsed830

    Cannot get DMARC records to stick?

    Eclipsed830, May 2, 2019, in forum: E-mail Discussion
    Replies:
    13
    Views:
    658
    djbaxter
    May 17, 2019 at 10:45 AM
  2. martin MHC

    You cannot remove the domain because it is still configured for HTTP use error

    martin MHC, Apr 29, 2019, in forum: Data Protection
    Replies:
    3
    Views:
    206
    martin MHC
    May 7, 2019
  3. renee.stein10

    Cannot connect to CalDav

    renee.stein10, Apr 28, 2019, in forum: E-mail Discussion
    Replies:
    1
    Views:
    334
    cPanelLauren
    Apr 30, 2019
  4. crudpuppy

    Cannot purge deleted emails in Horde tablet mode.

    crudpuppy, Apr 26, 2019, in forum: E-mail Discussion
    Replies:
    1
    Views:
    217
    cPanelLauren
    Apr 26, 2019
  5. Mel_Davies

    Junk Mail rejected, Cannot not receive any emails

    Mel_Davies, Apr 22, 2019, in forum: E-mail Discussion
    Replies:
    4
    Views:
    183
    cPanelLauren
    Apr 23, 2019

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.
    Accept Learn More...
    Dismiss Notice