Error: There are no domains which have awstats stats to display



While checking the Awstats from your cPanel >> logs >> Awstats and you are getting below error message.
“There are no domains which have awstats stats to display”

Check the permission and symlink of below files :-

[root@server ~]# ls -lah /usr/local/cpanel/3rdparty/bin/  ====> Should have 755 permissions
[root@server ~]# ls -lah /usr/local/cpanel/base/ ====> should be have a symlink to /usr/local/cpanel/3rdparty/bin/

Correct the permission and restart the cPanel service.

[root@server ~]# /scripts/runweblogs cPanel_username

[root@server ~]# /etc/init.d/cpanel restart

Now  check it again and it is working fine. 😀

How to check the load of dcpumon(cPanel) logs


You can check it from the below simple script.

[root@alam ~]# for i in `find /var/log/dcpumon/ -name *.gz` ; do echo $i; zgrep load $i; done

How you can check/preview your website before switching DNS?


You can Locate the HOSTS file on your computer. Depending on the operating system you have, the following are locations you may be able to find this file.

Windows NT/2000/XP/2003/Vista:


Windows 95/98/Me:


Open the above  file with any text editor such as notepad or wordpad.
You will see two columns of information, the first containing IP addresses and the second containing host names.

By default it is look like as below  entry. localhost

You will need to add lines just underneath to the  existing line.

Suppose the IP address of your new server is “” and the domain you want to preview/check  is “”:

You will need to add the lines just underneath the existing line that will point requests from
your computer to your new server’s IP address.

Now just save the file and chek/preview your site in any browser as follows or  to test your new server.

Note: When you are finished testing your new server please don’t forget to revert the changes i.e to remove the lines you added above.

eMail Spamming Troubleshoot


Some scripts that are used to send out spam emails :

[root@support ~]#grep “cwd=” /var/log/exim_mainlog|awk ‘{for(i=1;i<=10;i++){print $i}}’|sort|uniq -c|grep cwd|sort -n

[root@support ~]#eximstats -t5 /var/log/exim_mainlog > teststats

Script to know the mail count by various accounts
[root@support ~]#grep “cwd=” /var/log/exim_mainlog|awk ‘{for(i=1;i<=10;i++){print $i}}’|sort|uniq -c|grep cwd|sort -n

The number of mails by a domain
[root@support ~]#exigrep /var/log/exim_mainlog|grep 2009-04-17|grep Completed|wc -l

[root@support ~]#ps -C exim -fH ewww |grep home, it shows the mails going from the server.
It shows from which user’s home the mail is going, so that you can easily trace it and block it if needed.

[root@support ~]#eximstats -ne -nr /var/log/exim_mainlog
It shows top 50 domains using mail server with options.

[root@support ~]#exim -bp | exiqsumm
It shows the main domains receiving and sending mails on the server.

[root@support ~]# netstat -plan|grep :25|awk {‘print $5′}|cut -d: -f 1|sort|uniq -c|sort -nk 1
It shows the IPs which are connected to server through port number 25. It one particular Ip is using more than 10 connection you can block it in the server firewall.

In order to find “nobody” spamming, issue the following command
[root@support ~]#ps -C exim -fH ewww|awk ‘{for(i=1;i<=40;i++){print $i}}’|sort|uniq -c|grep PWD|sort -n
It will give as like below result :-
Example :
6 PWD=/
347 PWD=/home/sample/public_html/test
Count the PWD and if it is a large value check the files in the directory listed in PWD
(Ignore if it is / or /var/spool/mail /var/spool/exim)

The above command is valid only if the spamming is currently in progress. If the spamming has happened some hours before, use the following command.

Command :
[root@support ~]#grep “cwd=” /var/log/exim_mainlog|awk ‘{for(i=1;i<=10;i++){print $i}}’|sort|uniq -c|grep cwd|sort -n
This will result in something like :
96 cwd=/root
4583 cwd=/home/sample/public_html/test

Count the cwd and if it is a large value check the files in the directory listed in cwd
(Ignore if it is / or /var/spool/mail /var/spool/exim)

Pass the below mentioned command at your command prompt to find the domain which is being used by spammers.

[root@support ~]#exim -bpr | exiqsumm -c | head
[root@support ~]#exiqgrep -ir <domain> | xargs -n1 exim -Mrm

That should remove any e-mail that is in the queue that is waiting to be delivered to POP accounts at <domain>.

Take below Precautions:
I)Turn on the SMTP tweak. It will block the users to bypass the mail server for sending out spam.
II)Turn on blacklisting ability in whm.
III)Use spamassassin to stop receiving spam mails.

SPF record and domain keys


You can set SPF records and domain keys in cpanel server via below steps :-
First login to cpanel >> Email Authentication >> and there you can enable the SPF record and the Domain keys.
[root@support ~]#/usr/local/cpanel/bin/spf_installer (cPanel username)
[root@support ~]#/usr/local/cpanel/bin/domain_keys_installer (cPanel username)
Or you can use the script
[root@support ~]# for i in `ls /var/cpanel/users` ;do /usr/local/cpanel/bin/domain_keys_installer $i ;done
To enable Domain keys by default for all the accounts created.
Edit /scripts/postwwwacct and adding:
my %OPTS = @ARGV;
my $user = $OPTS{’user’};
/usr/local/cpanel/bin/domain_keys_installer $user
To install SPF record for all the domains use :
[root@support ~]#for i in `ls /var/cpanel/users` ;do /usr/local/cpanel/bin/spf_installer $i ;done

Cpanel shows 0mb size for all databases after migration


Solution :
[root@server1 ~]# vi /var/cpanel/cpanel.config
Change :
[root@server1 ~]# /scripts/update_db_cache
Wait for few minutes depending upon the databases and the users and this should fix the problem.

How to Change Server Name in cPanel


You can see Current Hostname is ( while in cPanel you can see Server Name is (server)  and not the actual server name.
If you want to change the hostname you can do,it from the below  :-

Ans :-
This is the intended behavior for the side bar in cPanel. The “ServerName” statistic will display the name before the domain name of the hostname. For example, if the hostname of the server is “”, then the “Server Name” will output “server”.
You can use the Branding Editor to edit the “extended_statsbar.html” page. Simply change “shorthostname” to “hostname” and it will output the full hostname in cPanel. This option is found at:
“WHM >> Branding Editor >> Edit Branding Style >> Edit HTML Pages”