Roundcube corrupt tables with this webapp disabled

[urgido]

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]

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:

/usr/local/cpanel/bin/update-roundcube-db

Thank you.

 

[urgido]

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

It's necessary reinstall roundcube or Can I just delete it and nothing else? Really I don't like roundcube

 

[urgido]

When I tried to delete the DB through PHPMYADMIN I got the following error on my screen:

#2013 - Lost connection to MySQL server during query

But MySQL is running. Any idea?

 

[cPanelMichael]

Hello @urgido,

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

/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:

mysql
mysql> DROP DATABASE roundcube;

Then, rebuild the database using the following command:

/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]

/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,

 

[cPanelMichael]

ERROR 2013 (HY000): Lost connection to MySQL server during query

Hello @urgido,

Can you let us know the output to the MySQL error log (/var/lib/mysql/$hostname.err) when reproducing this error message? Also, can you share the contents of the /etc/my.cnf file on this system?

Thank you.