MySQL on a different server - cPanel doesn't see DB sizes

[remik]

Hello.
I have this kind of configuration:
cpanel.server.com - my cPanel, mail etc. server
mysql.server.com - my MySQL server

MySQL on the second server was installed using WHM. My users are able to use different cPanel tools to create databases, users etc. PHPMyAdmin is also working fine.

On my cpanel server I have the file /root/.my.cnf which allows root to connect to mysql on the second server without extra parameters on the command line.

One of our clients has the exact same configuration on his machines (we provide him with administrative services).

After a recent cPanel update two things stopped working (on both configurations):

1) munin stopped reporting MySQL traffic on it's graphs - I have probably solved this problem by creating an additional file at /home/munin/.my.cnf to tell munin how to connect to the database (still waiting for munin to update the graphs)

2) cPanel stopped reporting DB sizes


I couldn't find any solution for number 2. When You login to cPanel and go to MySQL databases the list of DBs apears and shows all of the DBs, but every DB is showed with a size of 0 MBs.

Please help. How can I fix this problem?

[cpanelnick]

Originally Posted by remik

Hello.
I have this kind of configuration:
cpanel.server.com - my cPanel, mail etc. server
mysql.server.com - my MySQL server

MySQL on the second server was installed using WHM. My users are able to use different cPanel tools to create databases, users etc. PHPMyAdmin is also working fine.

On my cpanel server I have the file /root/.my.cnf which allows root to connect to mysql on the second server without extra parameters on the command line.

One of our clients has the exact same configuration on his machines (we provide him with administrative services).

After a recent cPanel update two things stopped working (on both configurations):

1) munin stopped reporting MySQL traffic on it's graphs - I have probably solved this problem by creating an additional file at /home/munin/.my.cnf to tell munin how to connect to the database (still waiting for munin to update the graphs)

2) cPanel stopped reporting DB sizes


I couldn't find any solution for number 2. When You login to cPanel and go to MySQL databases the list of DBs apears and shows all of the DBs, but every DB is showed with a size of 0 MBs.

Please help. How can I fix this problem?


Best regards,
Remigiusz Samborski

You'll need cPanel 11.25+ and mySQL 5+ to see remote disk usage.

[remik]

I am running updates in CURRENT type. My version shows: cPanel 11.24.5-C38506, which is the almost the newest version in this branch. MySQL 5.1 is installed.

Does this mean I have to use EDGE? How long may it take for this functionality to be added in CURRENT?


Cheers,
Remik