Databases show 0MB in MySQL Databases

Edit /var/cpanel/cpanel.config

Change:
disk_usage_include_sqldbs=0

To:
disk_usage_include_sqldbs=1

Then run:
$ /scripts/update_db_cache

Awstats doesn't properly update

On cPanel, if Awstats only shows a small percentage of the actual visitors, do the following -

chmod 644 /home/USERNAME/tmp/awstats/awstats.domain.com.conf

Account does not exist error when trying to delete email account

 To resolve this:

• Logout of cPanel
• SSH to the server he is on
• $ cd /home/<user>/.cpanel/
• $ mv -v email_accounts.yaml email_accounts.yaml.orig
• $ mv -v email_accounts.cache email_accounts.cache.orig
• Log back into the cPanel -> Email Account ; and the issue should have been resolved

 

500 Internal Server Error on Suspended Account

If an account is suspended, the domains are redirected to http://domain.com/cgi-sys/suspendedpage.cgi. If this URL generates Internal Server Error, then the fix is:

chgrp wheel /usr/local/cpanel/cgi-sys/suspendedpage.cgi
chattr +i /usr/local/cpanel/cgi-sys/suspendedpage.cgi

Its a temporary fix. Seems cPanel updates revert the ownership back to root.root and the error reappears. 

Can't login to PHPMyAdmin via cPanel

can't login to PHPMyAdmin via cPanel, here's the fix:

If the cPanel user password and MySQL password are not the same, you can try resetting the account password in

WHM using Main >> Account Functions >> Password Modification. 

This function will attempt to reset the cPanel user password for the system and MySQL. This should result in the system password and MySQL password again being in sync, allowing the user to log in using the phpMyAdmin log-in page.

If its a server-wide issue with PHPMyAdmin, run the following command to force a reinstall of PHPMyAdmin:

/usr/local/cpanel/bin/updatephpmyadmin --force

If that doesn't fix the issue, rebuild cPanel/WHM's internal PHP:

/scripts/makecpphp