Error in mySQL stats on cPanel

LuxSpaces

Registered
Sep 16, 2009
2
0
51
Everytime i create a new account from whm ( i login whm as root user ) on client's cpanel there's always show that already 1 mysql database exist on cpanel stats.



But in mysql panel itself shown there's no mysql database exist




how i can fix this?

here my phpinfo if needed

Code:
http://rootzone.net/inf.php
Thx in advanced
 
Last edited:

MattCurry

Well-Known Member
Aug 18, 2009
275
0
66
Houston, Tx
Hello,

This can be caused by a couple of things, but I need a little more info before I could say for sure. First, have you isntalled postgres or mysql or both? The reason I ask is with postgres it will show 1 when there are zero if the install wasn't completed. So you can either finish the install or remove the binary from the machine. Second, you can check that and you can also check /home/USER/.cpanel/datastore/
There will be two files there:
mysql-db-count
postgres-db-count
The cpanel install takes the number in these files and adds them together. This will be the number that you see on the page (1 database). So you can correct it there as well.

Please let me know if this resolves your issue, if you additional questions feel free to ask.

Thank you,
Matthew Curry
 

LuxSpaces

Registered
Sep 16, 2009
2
0
51
problem is resolved :)

trully it's on the postgresql installation, i've reinstall postgresql and my problem is solved


thx so much sir for your help