PostgreSQL support: Bugs

[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:

 

[sexy_guy]

** BUMP **

cPanel.net Support Ticket Number:

 

[cPanelNick]

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]

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]

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:

 

[jcsolutions]

Originally posted by WMS
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

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:

 

[WMS]

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]

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]

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]

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: