How to set independent time for Xen VPS

If you host your VPS with Xen environment, you will found out your local time will follow the dom0(host) time.

To get this fixed, you may follow here,
1. Edit the value in /proc/sys/xen/independent_wallclock,

echo 1 > /proc/sys/xen/independent_wallclock

2. The make sure the setting run on boot, edit the file /etc/sysctl.conf, enter the following line to new line.

xen.independent_wallclock = 1

3. Lastly, log into WHM, select Server Configuration, select Server time and Sync it with Time server.

cPanel: Database size is Zero

Wonder why cPanel database size is not calculated and it is always showing zero (0) in the database section?

You may fix this by 2 options,
Option 1:
1. Log into WHM(Web Host Manager).
2. Go to Server Configuration and look for Tweak Settings.
3. Look for “Include databases in disk usage calculations” and enable it.
4. Save it.

Option 2:
1. Log into SSH.
2. Open the file named /var/cpanel/cpanel.config.
vi /var/cpanel/cpanel.config
3. Search “disk_usage_include_sqldbs” and change the value to 1.
4. Lastly, run the command as below,
/scripts/update_db_cache