Roundcube corrupt tables with this webapp disabled

urgido

Well-Known Member
Jul 19, 2005
129
10
168
cPanel Access Level
Root Administrator
Hi
Today, I am facing a problem with roundcube database.Here is the log:

roundcube roundcube.cache
Error : Table 'roundcube.cache' doesn't exist
roundcube.cache_index
Error : Table 'roundcube.cache_index' doesn't exist
roundcube.cache_messages
Error : Table 'roundcube.cache_messages' doesn't exist
roundcube.cache_shared
Error : Table 'roundcube.cache_shared' doesn't exist
roundcube.cache_thread
Error : Table 'roundcube.cache_thread' doesn't exist
roundcube.contactgroupmembers
Error : Table 'roundcube.contactgroupmembers' doesn't exist
roundcube.contacts
Error : Table 'roundcube.contacts' doesn't exist
roundcube.dictionary
Error : Table 'roundcube.dictionary' doesn't exist

I only have enabled horde as only option for webmail. Really, I don't like roundcube. Is possible uninstall toally from the server? I want to keep away roundcube from mysql server :)



Thanks!
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello @urgido,

You can disable Roundcube by unchecking the Enable Roundcube webmail option under the Mail tab in WHM >> Tweak Settings.

That said, you should still address the error message noted in your post. Assuming you have no Roundcube data to preserve, converting Roundcube to SQLite should address those errors. We document how to do this at:

How to Convert Roundcube to SQLite - cPanel Knowledge Base - cPanel Documentation

Or, delete the roundcube database using WHM >> phpMyAdmin and then reinstall it using the following command:

Code:
/usr/local/cpanel/bin/update-roundcube-db
Thank you.
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello @urgido,

First, verify if the following command succeeds before attempting to manually remove the roundcube database:

Code:
/usr/local/cpanel/bin/update-roundcube-db --force
If it doesn't, you can also try deleting the database by logging in via SSH as the root user and running the "DROP DATABASE" command via the MySQL command line:

Code:
mysql
mysql> DROP DATABASE roundcube;
Then, rebuild the database using the following command:

Code:
/usr/local/cpanel/bin/update-roundcube-db
Note these steps only apply if you have no Roundcube data to preserve (e.g. Roundcube address books, signatures, etc).

It's necessary reinstall roundcube or Can I just delete it and nothing else? Really I don't like roundcube
While it's not required, it's a good idea to solve the database errors even if you disable Roundcube in WHM >> Tweak Settings.

Thank you.
 

urgido

Well-Known Member
Jul 19, 2005
129
10
168
cPanel Access Level
Root Administrator
/usr/local/cpanel/bin/update-roundcube-db --force
Roundcube update from 1.3.3-5.cp1164 to 1.3.3-5.cp116 4 in progress.
info [update-roundcube-db] Roundcube will be locked out during this process.
info [update-roundcube-db] Archiving current Roundcube data to /var/cpanel/round cube/roundcube.backup.sql.1533323915
warn [update-roundcube-db] Failed to backup existing Roundcube DB: mysqldump: Go t error: 1146: Table 'roundcube.cache_index' doesn't exist when using LOCK TABLE S
info [update-roundcube-db] Cleaning old Roundcube data archives
info [update-roundcube-db] Schema update to 1.3.3-5.cp1164 was successful
info [update-roundcube-db] Roundcube updated to 1.3.3-5.cp1164

mysql mysql> DROP DATABASE roundcube;
DROP DATABASE roundcube;
ERROR 2013 (HY000): Lost connection to MySQL server during query

/usr/local/cpanel/bin/update-roundcube-db
/usr/local/cpanel/bin/update-roundcube-db
Roundcube is up to date. Execute '/usr/local/cpanel/bin/update-roundcube-db --force' to force an update.


service mysql status
SUCCESS! MySQL running (15294)


These are the steps with their output.
Thanks,