Month: October 2018

Fatal error: Uncaught exception ‘Illuminate\Database\QueryException’ with message ‘SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from `tblinvoices` where `id` = 33 limit 1)

Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from `tblinvoices` where `id` = 33 limit 1) (SQL: select * from `tblinvoices` where `id` = 33 limit 1)' in /home/bunnytech/public_html/control/includes/classes/WHMCS/Terminus.php:0 Stack trace: #0 [internal function]: WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException)) #1 {main} thrown in /home/bunnytech/public_html/control/includes/classes/WHMCS/Terminus.php on line 0 Fix … Continue reading Fatal error: Uncaught exception ‘Illuminate\Database\QueryException’ with message ‘SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from `tblinvoices` where `id` = 33 limit 1) →

softaculous php version not detected while upgrading and Installing Drupal in a cPanel server

Fix For upgradation issue # cd /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/hooks # cp -p pre_upgrade.txt pre_upgrade.php # vi pre_upgrade.php function __pre_upgrade($installation){ global $soft, $software, $globals; // Do stuff here e.g. is as follows if($soft == 26){ /* Do things only if its WordPress */ } $version = '5.6.16'; define('php_version', $version); } For installation issue # cp -p pre_install.txt pre_install.php … Continue reading softaculous php version not detected while upgrading and Installing Drupal in a cPanel server →

How to prevent DNS recursion attack

DNS recursion attacks are common in cPanel linux servers. During recursion attcks server load increases and in the /var/log/messages file you will find domain queries which are not present in the server. Fix ** Add this to the "options" section of /etc/named.conf recursion no; additional-from-auth no; additional-from-cache no;

“err: Could not retrieve catalog from remote server: SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed”

Puppet error : If you got this error "err: Could not retrieve catalog from remote server: SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed" while running puppetd --test on agent server, mostly its because of incorrect time. Fix You need to correct the time and re-initiate puppetd --test again. It will fix … Continue reading “err: Could not retrieve catalog from remote server: SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed” →

Install chkrootkit in a ubuntu server

Download latest chkrootkit and the md5 file from the source. # wget -c ftp://ftp.pangeia.com.br/pub/seg/pac/chkrootkit.tar.gz # wget -c ftp://ftp.pangeia.com.br/pub/seg/pac/chkrootkit.md5 Check the md5 file to make sure it is not corrupted. It should show OK. # md5sum -c chkrootkit.md5 chkrootkit.tar.gz: OK Extract it. # tar -xzvf chkrootkit.tar.gz compile after extraction. # cd chkrootkit-0.52 # make sense To … Continue reading Install chkrootkit in a ubuntu server →

To change wordpress theme via backend using database commands

To change the current theme to twentyfourteen default theme >> mysql >> use database_name; To see current theme >> select * from wp_options where option_name = 'template' or option_name = 'stylesheet' or option_name = 'current_theme'; >> update wp_options set option_value = 'twentyfourteen' where option_name = 'template'; >> update wp_options set option_value = 'twentyfourteen' where option_name … Continue reading To change wordpress theme via backend using database commands →

email ip does not change in /etc/mailips issue

Firstly found that there was lsattr set for the file. Tried by removing and resetting the lsattr but no use. Fix Found that in whm exim config settings this should be like this Send mail from account’s dedicated IP address Off Reference /etc/mailhelo for outgoing SMTP HELO Off Reference /etc/mailips for outgoing SMTP connections On … Continue reading email ip does not change in /etc/mailips issue →