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 support: Bugs

Discussion in 'General Discussion' started by WMS, Aug 15, 2003.

  1. WMS

    WMS Active Member

    Joined:
    Jul 18, 2003
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Moscow
    I've played with pgsql support and found couple of bugs:

    1. phpPgAdmin shows ALL the databases to user by default even if he's not the owner. It can be fixed by editing conf-file.
    2. By default pgsql does not allow network connections, but phpPgAdmin uses network connection to pgsql instead of unix domain socket.
    3. User is able to see all the databases in the system with psql AND ABLE TO CREATE TABLES IN DATABASES OF OTHER PERSONS (!!!!!!!!!)
    4. Unable to delete database through Cpanel (even if it's been created with Cpanel).

    Maybe I do something wrong?

    cPanel.net Support Ticket Number:

    cPanel.net Support Ticket Number:
     
  2. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    ** BUMP **

    cPanel.net Support Ticket Number:
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Try the latest edge/release/stable builds.

    They have a few more fixes

    cPanel.net Support Ticket Number:
     
  4. WMS

    WMS Active Member

    Joined:
    Jul 18, 2003
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Moscow
    I've upgraded to 7.4.2-S82.
    Now I'm able to remove databases, but no able to create.

    This is REALLY great!:(

    cPanel.net Support Ticket Number:
     
  5. WMS

    WMS Active Member

    Joined:
    Jul 18, 2003
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Moscow
    Sorry, everything's fine.:)

    I'm able to drop and create databases.

    But the problem #3: "User is able to see all the databases in the system with psql AND ABLE TO CREATE TABLES IN DATABASES OF OTHER PERSONS (!!!!!!!!!)" is still alive:)

    That's not good.

    cPanel.net Support Ticket Number:
     
  6. jcsolutions

    jcsolutions Well-Known Member

    Joined:
    Nov 4, 2002
    Messages:
    184
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Canada
    Check this post. I don't believe it solves the problem, but it may help a little.

    http://forums.cpanel.net/showthread.php?s=&threadid=13474#post63030

    cPanel.net Support Ticket Number:
     
  7. WMS

    WMS Active Member

    Joined:
    Jul 18, 2003
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Moscow
    Thanx! But I already did it.:)

    The problem is in psql or any other type of connection to postgresql (with php, perl or with shell).

    Any user is able to see ALL databases and able to create tables in ANY database.

    That's it:)

    cPanel.net Support Ticket Number:
     
  8. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    One more issue to add, cannot create if ID has a '-' in it. It will fail with ERROR: parser: parse error at or near "-" at character 12

    cPanel.net Support Ticket Number:
     
  9. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    Anyone with user ID with dash (-) in the name is screwed for using this version of PostGreSQL.

    Coming 7.4 Beta 1

    Allow username containing a dash GRANT permissions


    Nick - Is there any way around this?

    cPanel.net Support Ticket Number:
     
  10. nlservices

    nlservices Member

    Joined:
    Mar 8, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    postgreSQL Not included in backups??

    I reviewed our backup log today, and noticed that there is nothing listed as having backed up postgreSQL databases.

    pkgacctfile is: /backup/cpbackup/daily/aliweb.tar.gz
    Creating Archive ....Done
    Copying Mail files....Done
    Copying proftpd file....Done
    Grabbing mysql dbs...Done
    Grabbing mysql privs...Done
    Copying mailman lists....Done
    Copying mailman archives....Done
    Copying homedir....Done
    Copying cpuser file.......Done
    Copying quota info.......Done
    Storing Subdomains....
    Done
    Storing Parked Domains....
    Done
    Copying password.......Done
    Copying shell.......Done

    I see mySQL, but not postgreSQL. Anyone know if they are in fact being backed up?? Anyone tried to do a restore of a home backup to see if the databases reappear??

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page