MySQL Management in the control panel times out

[braf]

Hi,

I've recently done a fresh install of DirectAdmin and am using custombuild 2. For some reason when you go into MySQL Management in the directadmin control panel all I get is an endlessly loading page until it times out.

I've checked all the logs that I can think of all the DA logs and the MySQL logs and there is nothing to indicate why this is occurring. I've also tried recompiling MySQL using different versions but I've still not had any luck. I can log into phpMyAdmin using the da_dbuser credentials and can use MySQL using the CLI.

Does anybody have any ideas on how to solve this or to get some debug information as to why this is happening? Any suggestions would be most appreciated.

Cheers.

 

[ditto]

Please try this: "option to not show the realtime database disk usage" http://www.directadmin.com/features.php?id=664

If a mysql database has too many tables, it can cause a timeout while trying to view the mysql page in DA because DA will go through each table to it's size.

So, you just add this to directadmin.conf and restart directadmin afterwards:

show_db_usage=0

 

[braf]

Thanks for the suggestion. I did see this when I was searching for a fix but I didn't try it due to the fact that I don't have any databases on the server yet so they can't be too big or too many! I wanted to get it working before I added any

Regardless I've given it a try and it hasn't helped unfortunately . Just on a side note if refresh too many times directadmin dies and will not respond to any requests even after restarting the service and I have to reboot the server to restore it.

 

[scsi]

Try debug mode:

http://help.directadmin.com/item.php?id=293

Do you get any timeouts with the mysql cli such as using the following command:

SHOW DATABASES;

 

[braf]

Thanks for the suggestion but I'm still facing the same problem. I've even done a complete reinstall of directadmin and am still getting the same problem.

Debug mode gets to this point and never does anything after that.

Command::doCommand(/CMD_DB)
Database::setDBTableToken 1 domain=blahblah.com

Running show databases runs consistently in 0.0 seconds, so instantly!

 

[DirectAdmin Support]

Just as a followup, this was Debian 7.5, 64-bit (if my memory is correct).
The issue was somewhere in the libmysqlclient.so file, within the static directadmin binary itself.
The version compiled into DA, didn't match the version of MySQL running, so the fix was to install a custom dynamic set of binaries for the account.
If you hit the same issue, just send us an email and we can send over the URL to grab the dynamic pack.

John