MySQL Databases not showing in CPanel

serlex

Well-Known Member
Oct 20, 2009
57
0
56
Hi,

MySQL databases page on a CPanel account isn't showing any of the existing databases:

:2083/frontend/x3/sql/index.html

Quota is unlimited
/tmp isn't full
server isn't out of space
/usr/local/cpanel/bin/checkperlmodules hasn't fixed it

/usr/local/cpanel/logs/error_logs:
Code:
[2011-03-28 12:46:27 +0100] warn [dbstoregrants] Failed to write /var/cpanel/databases/grants_lazaride.yaml: No such file or directory at /usr/local/cpanel/Cpanel/CachedDataStore.pm

Any ideas?

Regards
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Try to rebuild the MySQL database mapping users and permissions. If this doesn't work, try to create that missing file to see if that works:

Code:
/usr/local/cpanel/bin/setupdbmap
touch /var/cpanel/databases/grants_lazride.yaml
chmod 600 /var/cpanel/databases/grants_lazride.yaml
Only run the last 2 commands to create the yaml file and change the permissions if the file doesn't exist upon running the previously mentioned stat and cat commands by ThinIce.
 

serlex

Well-Known Member
Oct 20, 2009
57
0
56
I don't know which one of these fixed it but I did following

update cpanel via upcp
/usr/local/cpanel/bin/checkperlmodules -full
/usr/local/cpanel/bin/setupdbmap

Cheers
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
It would be the last one because your database mapping can't have been setup for that user and the other two commands will not perform that function, so setupdbmap would have created the grants for the user for the missing file.