GCIS

Active Member
Dec 12, 2006
26
0
151
One of my cPanel boxes has begun experiencing massive SQL related problems over the past 24 hours. This problem appeared spontaneously today, and no software changes have been made on this specific system recently.

This may or may not be related to a recent cPanel update; I have yet to see similar problems described via the support forums over the past few weeks.


The first and by far most important problem has to do with MySQL account and database listing and creation. Accounts and databases are not displayed on any cPanel MySQL administration page. This applies to all user accounts on the machine. New users and databases cannot be created.

Even though databases cannot be listed or created, and user accounts cannot be created, listed, or granted permissions, all existing databases still exist, and all MySQL user accounts can still access them. Furthermore, all cPanel user accounts can use phpMyAdmin, although root cannot.


The second problem deals with MySQL root access. root cannot access phpMyAdmin, and receives an access denied error upon every attempt. Attempts to reset the root password are met with an error as follows (reproduced in entirety):
Code:
Mysql password change failed!!
A forced reset will now be attempted.
Reset MySQL Password

Waiting for mysql to restart.....This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, stored procedures, or
more secure passwords in 4.1

done
Done
Changing Password....Done
Reloading Mysqld...
Done
Waiting for mysql to terminate.....

Restarting MySQL ....Starting MySQL[ OK ] Done

The MySQL root password has been changed.
Password changed for root to [ROOT PASSWORD REMOVED]
Although the script reports a successful root password change, the root password does not change. Furthermore, neither the old nor new root passwords enable root MySQL access; MySQL reports an authentication failure upon access attempts.


The third problem experienced related to PgSQL. Some cPanel user accounts are showing "1/NA" in the PgSQL database usage field. PgSQL is not used on this machine, and is not even running (and never has been). This problem is not important to the proper operation of the machine, but is odd enough that it certainly warrants attention from support staff, as something quite odd is happening with cPanel's internals.



Upgrades (and forced upgrades) of cPanel in general, as well as MySQL specifically (via cpup and mysqlup) fail to remedy this problem.


Are any of these known issues with current releases of cPanel? If this is a known issue, I'd rather take care of it now before I have to spend hours tracing it down in the system's internals.
 

equens

Well-Known Member
Feb 8, 2002
278
3
318
MySQL root password problems

Same problem here:


HTML:
Mysql password change failed!!
A forced reset will now be attempted.
Reset MySQL Password

Waiting for mysql to restart.....This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, stored procedures, or
more secure passwords in 4.1

done
Done
Changing Password....Done
Reloading Mysqld...
Done
Waiting for mysql to terminate.....

Restarting MySQL ....Starting MySQL[ OK ] Done

The MySQL root password has been changed.
Password changed for root to xxxxxxxxxxxx
HTML:
Attempting to restart mysql  	
Waiting for mysql to restart.... . . . . . . . . . . finished.

mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' mysql has failed, please contact the sysadmin (result was "mysql has failed").
 

eNetHosts

Well-Known Member
Apr 21, 2007
191
0
166
force update cpanel ??
/scripts/upcp --force

force reinstall mysql ?
/scripts/mysqlup --force

:)
Sound's like an idea + restart cPanel after

SSH line: /etc/init.d/cpanel restart