Roundcube corrupt tables with this webapp disabled

urgido

• August 02, 2018 10:44

Hi Today, I am facing a problem with roundcube database.Here is the log: [QUOTE]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

  • August 02, 2018 15:59

  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.

  0
• 

  urgido

  • August 02, 2018 23:48

  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

  0
• 

  urgido

  • August 02, 2018 23:52

  When I tried to delete the DB through PHPMYADMIN I got the following error on my screen: [QUOTE]#2013 - Lost connection to MySQL server during query
  But MySQL is running. Any idea?

  0
• 

  cPanelMichael

  • August 03, 2018 16:05

  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.

  0
• 

  urgido

  • August 03, 2018 19:23

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

  
  [QUOTE]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;

  
  [QUOTE]DROP DATABASE roundcube; ERROR 2013 (HY000): Lost connection to MySQL server during query
  

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

  
  [QUOTE]/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.
  [QUOTE]service mysql status SUCCESS! MySQL running (15294)
  These are the steps with their output. Thanks,

  0
• 

  cPanelMichael

  • August 06, 2018 15:31

  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.

  0

Please sign in to leave a comment.