How to enable the slow query log

To enable slow query log in cPanel server, you can use following steps. Its pretty simple. Add following to following to /etc/my.cnf file on server. # vi /etc/my.cnf log-slow-queries=/var/lib/mysql/slow.log After that,  do the following commands to create the file with the right ownership and file permissions: # touch /var/lib/mysql/slow.log # chmod 660 /var/lib/mysql/slow.log # chown […]

See More

Retry time not reached for any host after a long failure period

If you are receiving the following error in exim_mainlog file then refer to the following solution. =========================== Exim : retry time not reached for any host after a long failure period =========================== The issue is because of the corrupted exim db files. Go to /var/spool/exim/db and delete files: retry , retry.lockfile , wait-remote_smtp, wait-remote_smtp.lockfile #cd […]

See More

Error : 111 Can’t open SMTP stream – SquirrelMail

                       Error : 111 Can’t open SMTP stream – SquirrelMail ERROR: Message not sent. Server replied: Connection refused 111 Can’t open SMTP stream.   Resolution : One common problem people have is an incorrectly setup mail system. Here is a list of rules that must […]

See More