ABHIONLINUX
Site useful for linux administration and web hosting

2011/05/07

How to reset sshd config using WHM

In somecases your ssh config may have corrupted or ssh port may have blocked in the server due to mistake. In such cases, you can reset the sshd_config from whm.
Login to your whm, then you need to access the URL given below in your browser. Remember to replace the $IPADDRESS with your IP address. This will reset the ssh port to 22.


http://$IPADDRESS:2086/scripts2/doautofixer?autofix=safesshrestart

2011/05/05

Wrong mysql disk usage in cpanel.



You have zero databases in your cpanel account. After login to your cpanel, you can see the mysql database consuming more disk space.  This can be corrected by the following steps.

 Login to server and edit cpanel.config.

[root@server /]# vi /var/cpanel/users/cpanel.config

Replace 'disk_usage_include_sqldbs=0' with  'disk_usage_include_sqldbs=1'

Save this file and run the command given below.

[root@server /]# /scripts/update_db_cache

In the whm-tweak setting, you need to enable the option
'Use INFORMATION_SCHEMA to acquire MySQL disk usage (MySQL 5+ required) '