3 major issues with CPanel/MySQL/PHPMyAdmin

JeremyL

Well-Known Member
Aug 10, 2001
87
0
306
There are three major issues that need to be fixed ASAP that have to do with CPanel/MySQL/PHPMyAdmin.

The most recent one is the latest to show up. If you go to PHPMyAdmin first and then go to the screen where you add delete db\'s and users you get some really strange results. Please see the attached screenshot for what I mean. This can\'t be left as is.

The other two have been brought up before and bug reports added but still don\'t work.
Second.
--------------------------
When you are in the MySql, there are tables like WOMEN, BASKET, CATEGORY,
etc. Just try to go for example to WOMEN. Then choose SELECT. Then put some
number (which exist) - for example 201 to the field ID and click on GO. And
you will get the white screen. The same will happen, if you make any change
in any table there and then click on SAVE.

I am speaking about work in database in URL
http://domain.com:2082/3rdparty/phpMyAdmin/index.php which is
accessible through control panel as MySql.
--------------------------------

I have verified this on all accounts. Anyone know a fix?


Lastly. PHPMyAdmin will let clients create databases. Shouldn\'t this be removed so that they have to create the databases in CPanel? The databases are not created using their user name and they can\'t add user access to it.

Wil someone please fix these bugs ASAP. THey have made MySQL almost unusable for my clients.
 

kosmo

Well-Known Member
Verifed Vendor
Aug 12, 2001
403
0
316
All over Europe
I confirm the \"/var/cpanel/user/cpanel/\" issue. I have this for at least 2 or 3 weeks now and the support tickets have a growth of almost 100%.

The correct db and dbuser names appear if someone reloads the page. Just a hint, not a solution.

kosmo
 

JeremyL

Well-Known Member
Aug 10, 2001
87
0
306
Yes it does on all 3 bugs. A screenshot of the defualt theme is below.

It\'s really weird, the bug in the screenshot only happens if you open up PHPMyAdmin (in a new window in my case) and then leave the add/delete database screen and come back into it. The PHPMyAdmin screen can be open at this time or closed. You just have to visit it before hand.
 

moronhead

Well-Known Member
Aug 12, 2001
706
0
316
While you are at it, could you change the spelling of \"avalible\" in the JDB section of the DB usage instructions? That\'s embedded somewhere in the code I believe.
 

JeremyL

Well-Known Member
Aug 10, 2001
87
0
306
OK being able to create databases with PHPMyAdmin is gone.

The screenshot bug is now harder to recreate but it is still there.

And the third one I saw you closed out of bugzill but it\'s still broke in 198

And I restarted cpanel like you said.
 

JeremyL

Well-Known Member
Aug 10, 2001
87
0
306
I\'m not sure which one this has to do with but while testing the bugs I got this in the shell screen running in the background

[email protected] [~]# Connection Timeout at /usr/local/cpanel/cpaneld line 763.
Connection Timeout at /usr/local/cpanel/cpaneld line 763.
Connection Timeout at /usr/local/cpanel/cpaneld line 763.
Connection Timeout at /usr/local/cpanel/cpaneld line 763.

[email protected] [~]# Connection Timeout at /usr/local/cpanel/cpaneld line 763.
 

moronhead

Well-Known Member
Aug 12, 2001
706
0
316
[quote:0030e33111]PHPMyAdmin will let clients create databases. Shouldn\'t this be removed so that they have to create the databases in CPanel? The databases are not created using their user name and they can\'t add user access to it. [/quote:0030e33111]
Nick has offered a permanent solution to this issue. You can find it at http://support.cpanel.net/new/viewthread.php?tid=813.
 

JeremyL

Well-Known Member
Aug 10, 2001
87
0
306
Build 199 same thing

New shell printout too

Connection Timeout at /usr/local/cpanel/cpaneld line 763.
Bad arg length for Socket::inet_ntoa, length is 0, should be 4 at /usr/local/cpanel/cpaneld line 148.
 

moronhead

Well-Known Member
Aug 12, 2001
706
0
316
[quote:67c83dbda7]I tried that but the bugs are still there.[/quote:67c83dbda7]
So when you did this you still had the bug about creating test databases?

[code:1:67c83dbda7]# mysql mysql
mysql> delete from db where Db REGEXP \'^test\';[/code:1:67c83dbda7]
 

JeremyL

Well-Known Member
Aug 10, 2001
87
0
306
[quote:a914cba4e4][i:a914cba4e4]Originally posted by moronhead[/i:a914cba4e4]
[quote:a914cba4e4]I tried that but the bugs are still there.[/quote:a914cba4e4]
So when you did this you still had the bug about creating test databases?

[code:1:a914cba4e4]# mysql mysql
mysql> delete from db where Db REGEXP \'^test\';[/code:1:a914cba4e4] [/quote:a914cba4e4]

I am not talking about that one anymore. In a post above I said that was gone. I am speaking of the other ones.
 

moronhead

Well-Known Member
Aug 12, 2001
706
0
316
[quote:25e2fd5e16]I am not talking about that one anymore. In a post above I said that was gone. [[/quote:25e2fd5e16]Sorry, I can see that now.