In order to change the default character set in MySQL follow the given steps: First login to the server as root Open the file /etc/my.cnf vi /etc/my.cnf Add the following lines below [client] section: default-character-set=utf8 Add the following lines below [mysqld] section: default-character-set=utf8 init_connect=’SET NAMES utf8′ Once done restart your mysql service. service mysql restart […]
Webmail error : The server was not able to find the document (./502.shtml)
When we logged into webmail, we usually see the options choose Horde, Squirrel, Round Cube. But when we click any of them,sometimes we get the following Not Found Error: This might be occur due to some configuration issues with cPanel’s default PHP. You can simply fix it with the following script. /scripts/makecpphp […]
Error: Horde Webmail “User xxx is not authorised for xxx”
Do the following steps in order to resolve this cd /var/lib/mysql mysqldump horde > horde.sql mysqladmin drop horde /scripts/fullhordereset mysqlcheck -r -o horde After that try logging into horde. […]
How to re- install spamassassin in server
We can use the following script to re install spamassassin on the server. /scripts/perlinstaller –force Mail::Spamassassin If the above script is giving errors, do the following steps: export unset PERL5LIB unset PERL_LOCAL_LIB_ROOT rm /usr/bin/spamd rm /usr/bin/spamc /scripts/installspam –force /scripts/perlinstaller –force Mail::SpamAssassin […]
How to check if SSL is working fine on a site
To check if SSL is working fine on a site use the following php code on a test file and check it with https. <?php if($_SERVER[‘HTTPS’]){ echo ‘You have initiated an SSL connection. You are secured’; }else{ echo ‘You have initiated a NON-SSL connection. You are not secured’; } ?> If SSL is working fine, […]
Rvsite builder license issues
Sometimes we are facing license related issues even after updating license for rvsite in the server, To test the license run: /var/cpanel/rvglobalsoft/rvsitebuilder/www/ionctestlicense.php To update license run the following: /var/cpanel/rvglobalsoft/rvsitebuilder/updatelicense.php This will help to resolve the error no need to reinstall rvsitebuilder. […]
Exclude accounts or files from cpbackup
There are two files in cPanel that will help to exclude files or accounts from cpbackups. To exclude a user in the server from cPanel backup, add the user to the file: […]
Icons not displaying in cpanel
If icons not displaying in cPanel, run script : /usr/local/cpanel/bin/rebuild_sprites […]
Redirect site without changing url
To redirect site without changing url add the following code to index.php or index.html file: […]
FTP connection problem
Sometimes while accessing FTP you receive following error: In order to solve above problem follow the steps: 1) Login to WHM with root user. 2) Go To : Service Configuration >> FTP Server Configuration and then check if the setting : TLS Encryption Support : is configured to read to “Optional” if not, set the […]