Roundcube is one of the best email clients for cPanel servers, way better than the old Horde and Squirrelmail. However, Roudcube is not as stable as Horde and Squirrelmail, and sometimes its database gets corrupted or affected in some way. This leads to users complaining about not accesing their emails as they want. Today we will learn how to force roundcube update on cPanel.
Sometimes the Roundcube Database may fail and it’s common to see this kind of errors while accessing Roundcube:
DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
Fixing Roundcube Database
There are many ways to fix this, the most common is to restart MYSQL server if it was down:
service mysql restart
And if that doesn’t fix your issue, you can repair Roundcube Database too:
mysqlcheck -r roundcube
How to Force Roundcube Update
Finally, if your problem still happening, you will be forced to apply a forced Roundcube Update.
By forcing a roundcube update you will probably fix all the common issues that this webmail client faces, this will get rid of 99% of the issues you are having. Just try to make a backup before you run the update process, just in case.
This can be done running the following command as root:
This will output something like this:
[email@example.com:~]/usr/local/cpanel/bin/update-roundcube --force info [update-roundcube] Roundcube update from 1.1.4-7.cp1158 to 1.1.4-7.cp1158 in progress. info [update-roundcube] Roundcube will be locked out during this process. info [update-roundcube] Archiving current Roundcube data to /var/cpanel/roundcube/roundcube.backup.sql.1476378703 info [update-roundcube] Roundcube DB successfully archived info [update-roundcube] Cleaning old Roundcube data archives info [update-roundcube] Schema update to 1.1.4-7.cp1158 was successful info [update-roundcube] Roundcube updated to 1.1.4-7.cp1158 [firstname.lastname@example.org:~]
All done, now your Roundcube webmail client should be working fine.
Please let us know if you have any other ways to fix roundcube database or session issues.