PostgreSQL support: Bugs

WMS

Active Member
Jul 18, 2003
40
0
156
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:
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
208
cPanel Access Level
DataCenter Provider
Originally posted by WMS
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:
Try the latest edge/release/stable builds.

They have a few more fixes

cPanel.net Support Ticket Number:
 

WMS

Active Member
Jul 18, 2003
40
0
156
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:
 

WMS

Active Member
Jul 18, 2003
40
0
156
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:
 

WMS

Active Member
Jul 18, 2003
40
0
156
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:
 

dgbaker

Well-Known Member
PartnerNOC
Sep 20, 2002
2,576
9
343
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:
 

dgbaker

Well-Known Member
PartnerNOC
Sep 20, 2002
2,576
9
343
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:
 

nlservices

Member
Mar 8, 2003
13
0
151
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: