The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgresql users problem

Discussion in 'General Discussion' started by Misiek, Nov 6, 2004.

  1. Misiek

    Misiek Well-Known Member

    Joined:
    Feb 23, 2004
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    6
    I have postgre installed, and have one major problem i can add db i can add users i can assaign user to db.

    For example i created user _test and dbs test and i assigned user _test to dbs test

    i login to pgadmin as user _test but after login i dont see any dbs thats my problem can somebody help me ??
     
  2. Sabaote

    Sabaote Well-Known Member

    Joined:
    Dec 19, 2003
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Ribeirao Preto, Brazil
    I'm having problem with postgresql+cpanel too..

    I try add a DB or an User.. But when i see in cPanel don't shows anything..
    When i try use the PhpPgAdmin the login Fail.. I can't access...
    So please.. if anyone can help me..

    Thanks!!
     
  3. internetfab

    internetfab Well-Known Member
    PartnerNOC

    Joined:
    Feb 20, 2003
    Messages:
    336
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Gothenburg, Sweden
    cPanel Access Level:
    DataCenter Provider
    I have the exactly same issue.. just 2 years later ;)
    Anyone know why?
     
  4. lehels

    lehels Well-Known Member

    Joined:
    Jul 10, 2006
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    same problem one year later,
     
  5. crisdias

    crisdias Member

    Joined:
    Dec 8, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Me too, and on the same day! :cool:
     
  6. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brno, Czech Republic
  7. esteban

    esteban Registered

    Joined:
    Sep 20, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
  8. esteban

    esteban Registered

    Joined:
    Sep 20, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1

    Same problem !
    WHM 11.2.0 cPanel 11.11.0-R16715
    Postgre 7.4.19-1.el4_6.1
     
  9. lukemcr

    lukemcr Member

    Joined:
    Feb 29, 2008
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Me too. :-(

    To be specific, I get errors when I open phpPgAdmin from the user's cPanel.


    Warning: session_start() [function.session-start]: open(/tmp/sess_b43f28b343e91a5d0c61a83615111dd4, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php on line 56

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php:56) in /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php on line 56

    Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpPgAdmin/libraries/lib.inc.php:56) in /usr/local/cpanel/base/3rdparty/phpPgAdmin/classes/Misc.php on line 359

    Any ideas?
     
    #9 lukemcr, Mar 5, 2008
    Last edited: Mar 5, 2008
  10. djbob2

    djbob2 Well-Known Member

    Joined:
    May 14, 2005
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    #10 djbob2, Mar 7, 2008
    Last edited: Mar 7, 2008
  11. ReiJu

    ReiJu Well-Known Member

    Joined:
    Mar 14, 2008
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    6
    Got the exactly same problem here.

    The problem is that cPanel cannot assign the created user to access a database. When you list postgres dbs from CLI,
    Code:
    # psql -U postgres -l
    you can see that the dbs only owned by the main unix user, not the user assigned to it by cPanel. So if you log in to phppgadmin using main unix user, with it's password, you can browse all of your postgres databases.

    Hoping some cPanel guys can enlighten us to fix this. A single working link will do.
     
  12. ReiJu

    ReiJu Well-Known Member

    Joined:
    Mar 14, 2008
    Messages:
    57
    Likes Received:
    1
    Trophy Points:
    6
    :cool: not even a glance from cPanel guys?
     
  13. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    For a response from our staff, I recommend submitting a support ticket: http://tickets.cpanel.net

    These are not official support forums, therefore our support staff does not routinely monitor threads there.
     
  14. Kevinfrom

    Kevinfrom Well-Known Member

    Joined:
    Jan 18, 2008
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Only the main cPanel user has access to pgsql databases using phpPgAdmin by default.

    If you wish to grant full ownership of the database to a particular user, you
    will first need to alter the database owner by executing the following command from CLI:

    psql -U postgres -c 'ALTER DATABASE database_name OWNER TO user_name' template1

    Note: database_name and user_name should be replaced with the database and user
    names respectively.

    Once you have done this, you will need to grant access to each individual
    table. To get a listing of all tables contained in a database, execute the
    following:

    psql -U postgres -c '\dt' database_name

    You can then execute the following for each of the tables:

    psql -U postgres -c 'GRANT ALL ON table_name TO user_name' database_name

    The following portions of the vendor documentation describe the syntax for
    these operations.

    http://www.postgresql.org/docs/8.1/static/sql-alterdatabase.html
    http://www.postgresql.org/docs/8.1/static/sql-altertable.html
     
Loading...

Share This Page