Mysql Database size showing '0' in cPanel

In cPanel >> mysql databases , it shows database size as 0 even if it is not.

Make the following changes to fix.

nano var/cpanel/cpanel.config 

and search for following line.

disk_usage_include_sqldbs=0 ( set it to 1 instead of 0 )

then run following command

/scripts/update_db_cache

You are done.

Recipient receiving same emails many times

It happens that when you send email, the recipient receive the same email many times in period of intervals. It is because of exim database corrupted and also you receive following error in exim_mainlog.

Berkeley DB error: /var/spool/exim/db/retry: unexpected file type or format

Apply following solution to fix this issue.

Stop exim service using following command

/etc/init.d/exim stop
or
service exim stop

then go to /var/spool/exim/db/ and remove all the files. Make sure to take the backup of /db folder if in case if there is another problem arise. 

Start Exim service.

/etc/init.d/exim start
or
service exim start

After starting exim service, It will rebuild exim database. 

How to enable .zip file import in PHPMyAdmin

If you have cPanel server and you are not able to import .zip file in PHPMyAdmin then make following changes and you will be able to do it.

Nano /var/cpanel/easy/apache/profile/makecpphp.profile.yaml

Search for following line

Cpanel::Easy::PHP5::Zip: 0=0

Change it to

Cpanel::Easy::PHP5::Zip: 1

Save the file

and run /scripts/makecpphp

Roundcube not sending mails

You will get the following error while sending email from rouncube.

SMTP Error: SMTP error: Connection failed: Failed to connect socket: Connection timed out in /usr/local/cpanel/base/3rdparty/roundcube/program/steps/mail/func.inc on line 1418

It happens if you have CSF firewall installed and it is upgraded automatically or something like that. Just make following changes in to firewall configuration and it will fix the issue

nano /etc/csf/csf.conf
and search for 
SMTP_ALLOWLOCAL = 1 
Replace it with 
SMTP_ALLOWLOCAL = 0

It will fix the issue.

Rouncube hangs while sending message

Whenever you compose email and click send, it just never sends the message. A circle keeps rotating at the top saying Sending.

Solution is:

Login to server with root user and made following changes.

vi /usr/local/cpanel/base/3rdparty/roundcube/config/main.inc.php

and serach for following line

$rcmail_config['smtp_user'] = '%u';
Replace it with
$rcmail_config['smtp_user'] = '';

Phplist shows internal server error while get in to admin

After installing PHPList from fantastico, You will get Internal server Error while trying to get in to PhpList Admin.

You will get that error when you have SUEXEC server and it does not allow php parameters in .htaccess file. Normally during phplist installation, it does create .htaccess file with following line in it.

php_flag magic_quotes_gpc on

Just comment the above line and you will not receive internal server error.

webcalender Error Cache error: Could not write file /tmp

After installing web calender from fantastico, you will get the following error.

Error

Cache error: Could not write file /tmp/d16090f5de830d7675276b6523ce3f59.dat. 

Solution is:

Edit settings.php file which you will find under includes folder.
Search for
db_cachedir: /tmp
and replace it with following
db_cachedir: /home/user/public_html/tmp

Save the file then create tmp folder under public_html and assign 777 permission.

That is all

cheers.



/home/user/public_html/includes/settings.php