SMTP Error: Message size exceeds server limit

You seems got this error at Roundcube or Horde.

Here is explanation how it works:

Supposedly you’re trying to send message with an attachment file 44M

And you have the message_size_limit set in 50M as explained here

And you will not be able to send such message because attachments in a message are encoded by base64

It means your message will be by 30% bigger than expected, please see below calculation

44*0.30=57

You cannot send such message due to the limit in 50M, so you need either rise message_size_limit or upload and share your attachment to services like Gdrive/Dropbox/etc… Read the rest

How to fix RoundCube’s error: DATABASE ERROR: CONNECTION FAILED!

Mysql server and InnoDB engine must to be running!

Check mysql connection:

cat /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php |grep mysql:
$config['db_dsnw'] = 'mysql://roundcube:lasMubMX08D3HKtr@unix(/var/lib/mysql/mysql.sock)/roundcube';
mysql -u roundcube -p
show tables;

All tables should be in place:

+---------------------+
| Tables_in_roundcube |
+---------------------+
| cache               |
| cache_index         |
| cache_messages      |
| cache_shared        |
| cache_thread        |
| contactgroupmembers |
| contactgroups       |
| contacts            |
| cp_schema_version   |
| dictionary          |
| identities          |
| searches            |
| session             |
| system              |
| users               |
+---------------------+
15 rows in set (0.00 sec)

Cpanel keeps roundcube backups here:

/var/cpanel/roundcube

Go ahead and drop broken database

mysqladmin drop roundcube

Rebuild roundcube using the following two commands:

rpm -e --nodeps cpanel-roundcubemail

/usr/local/cpanel/scripts/check_cpanel_rpms --fix

Database roundcube should be recreated automatically.
Read the rest