check_mysql has determined that there are corrupted database tables

Gianpiero Colagiacomo

• August 10, 2015 11:54

Since our WHM's last upgrade we've been getting an email reporting corrupted horde database tables:
horde.content_schema_info Error : Table 'horde.content_schema_info' doesn't exist horde.horde_alarm_schema_info Error : Table 'horde.horde_alarm_schema_info' doesn't exist horde.horde_alarms Error : Table 'horde.horde_alarms' doesn't exist horde.horde_auth_schema_info Error : Table 'horde.horde_auth_schema_info' doesn't exist horde.horde_cache Error : Table 'horde.horde_cache' doesn't exist horde.horde_cache_schema_info Error : Table 'horde.horde_cache_schema_info' doesn't exist horde.horde_core_schema_info Error : Table 'horde.horde_core_schema_info' doesn't exist horde.horde_datatree Error : Table 'horde.horde_datatree' doesn't exist horde.horde_datatree_attributes Error : Table 'horde.horde_datatree_attributes' doesn't exist horde.horde_dav_collections Error : Table 'horde.horde_dav_collections' doesn't exist horde.horde_dav_objects Error : Table 'horde.horde_dav_objects' doesn't exist horde.horde_dav_schema_info Error : Table 'horde.horde_dav_schema_info' doesn't exist horde.horde_group_schema_info Error : Table 'horde.horde_group_schema_info' doesn't exist horde.horde_groups Error : Table 'horde.horde_groups' doesn't exist horde.horde_groups_members Error : Table 'horde.horde_groups_members' doesn't exist horde.horde_histories Error : Table 'horde.horde_histories' doesn't exist horde.horde_histories_modseq Error : Table 'horde.horde_histories_modseq' doesn't exist horde.horde_history_schema_info Error : Table 'horde.horde_history_schema_info' doesn't exist horde.horde_imap_client_data Error : Table 'horde.horde_imap_client_data' doesn't exist horde.horde_imap_client_message Error : Table 'horde.horde_imap_client_message' doesn't exist horde.horde_imap_client_metadata Error : Table 'horde.horde_imap_client_metadata' doesn't exist horde.horde_imap_client_schema_info Error : Table 'horde.horde_imap_client_schema_info' doesn't exist horde.horde_lock_schema_info Error : Table 'horde.horde_lock_schema_info' doesn't exist horde.horde_locks Error : Table 'horde.horde_locks' doesn't exist horde.horde_muvfs Error : Table 'horde.horde_muvfs' doesn't exist horde.horde_perms Error : Table 'horde.horde_perms' doesn't exist horde.horde_perms_schema_info Error : Table 'horde.horde_perms_schema_info' doesn't exist horde.horde_prefs Error : Table 'horde.horde_prefs' doesn't exist horde.horde_prefs_schema_info Error : Table 'horde.horde_prefs_schema_info' doesn't exist horde.horde_queue_schema_info Error : Table 'horde.horde_queue_schema_info' doesn't exist horde.horde_queue_tasks Error : Table 'horde.horde_queue_tasks' doesn't exist horde.horde_sessionhandler Error : Table 'horde.horde_sessionhandler' doesn't exist horde.horde_sessionhandler_schema_info Error : Table 'horde.horde_sessionhandler_schema_info' doesn't exist horde.horde_signups Error : Table 'horde.horde_signups' doesn't exist horde.horde_syncml_anchors Error : Table 'horde.horde_syncml_anchors' doesn't exist horde.horde_syncml_map Error : Table 'horde.horde_syncml_map' doesn't exist horde.horde_syncml_schema_info Error : Table 'horde.horde_syncml_schema_info' doesn't exist horde.horde_token_schema_info Error : Table 'horde.horde_token_schema_info' doesn't exist horde.horde_tokens Error : Table 'horde.horde_tokens' doesn't exist horde.horde_users Error : Table 'horde.horde_users' doesn't exist horde.horde_vfs Error : Table 'horde.horde_vfs' doesn't exist horde.horde_vfs_schema_info Error : Table 'horde.horde_vfs_schema_info' doesn't exist horde.imp_schema_info Error : Table 'horde.imp_schema_info' doesn't exist horde.imp_sentmail Error : Table 'horde.imp_sentmail' doesn't exist horde.ingo_forwards Error : Table 'horde.ingo_forwards' doesn't exist horde.ingo_lists Error : Table 'horde.ingo_lists' doesn't exist horde.ingo_rules Error : Table 'horde.ingo_rules' doesn't exist horde.ingo_schema_info Error : Table 'horde.ingo_schema_info' doesn't exist horde.ingo_shares Error : Table 'horde.ingo_shares' doesn't exist horde.ingo_shares_groups Error : Table 'horde.ingo_shares_groups' doesn't exist horde.ingo_shares_users Error : Table 'horde.ingo_shares_users' doesn't exist horde.ingo_sharesng Error : Table 'horde.ingo_sharesng' doesn't exist horde.ingo_sharesng_groups Error : Table 'horde.ingo_sharesng_groups' doesn't exist horde.ingo_sharesng_users Error : Table 'horde.ingo_sharesng_users' doesn't exist horde.ingo_spam Error : Table 'horde.ingo_spam' doesn't exist horde.ingo_vacations Error : Table 'horde.ingo_vacations' doesn't exist horde.kronolith_events Error : Table 'horde.kronolith_events' doesn't exist horde.kronolith_events_geo Error : Table 'horde.kronolith_events_geo' doesn't exist horde.kronolith_events_mysqlgeo Error : Table 'horde.kronolith_events_mysqlgeo' doesn't exist horde.kronolith_resources Error : Table 'horde.kronolith_resources' doesn't exist horde.kronolith_schema_info Error : Table 'horde.kronolith_schema_info' doesn't exist horde.kronolith_shares Error : Table 'horde.kronolith_shares' doesn't exist horde.kronolith_shares_groups Error : Table 'horde.kronolith_shares_groups' doesn't exist horde.kronolith_shares_users Error : Table 'horde.kronolith_shares_users' doesn't exist horde.kronolith_sharesng Error : Table 'horde.kronolith_sharesng' doesn't exist horde.kronolith_sharesng_groups Error : Table 'horde.kronolith_sharesng_groups' doesn't exist horde.kronolith_sharesng_users Error : Table 'horde.kronolith_sharesng_users' doesn't exist horde.kronolith_storage Error : Table 'horde.kronolith_storage' doesn't exist horde.mnemo_memos Error : Table 'horde.mnemo_memos' doesn't exist horde.mnemo_schema_info Error : Table 'horde.mnemo_schema_info' doesn't exist horde.mnemo_shares Error : Table 'horde.mnemo_shares' doesn't exist horde.mnemo_shares_groups Error : Table 'horde.mnemo_shares_groups' doesn't exist horde.mnemo_shares_users Error : Table 'horde.mnemo_shares_users' doesn't exist horde.mnemo_sharesng Error : Table 'horde.mnemo_sharesng' doesn't exist horde.mnemo_sharesng_groups Error : Table 'horde.mnemo_sharesng_groups' doesn't exist horde.mnemo_sharesng_users Error : Table 'horde.mnemo_sharesng_users' doesn't exist horde.nag_schema_info Error : Table 'horde.nag_schema_info' doesn't exist horde.nag_shares Error : Table 'horde.nag_shares' doesn't exist horde.nag_shares_groups Error : Table 'horde.nag_shares_groups' doesn't exist horde.nag_shares_users Error : Table 'horde.nag_shares_users' doesn't exist horde.nag_sharesng Error : Table 'horde.nag_sharesng' doesn't exist horde.nag_sharesng_groups Error : Table 'horde.nag_sharesng_groups' doesn't exist horde.nag_sharesng_users Error : Table 'horde.nag_sharesng_users' doesn't exist horde.nag_tasks Error : Table 'horde.nag_tasks' doesn't exist horde.rampage_objects Error : Table 'horde.rampage_objects' doesn't exist horde.rampage_tag_stats Error : Table 'horde.rampage_tag_stats' doesn't exist horde.rampage_tagged Error : Table 'horde.rampage_tagged' doesn't exist horde.rampage_tags Error : Table 'horde.rampage_tags' doesn't exist horde.rampage_types Error : Table 'horde.rampage_types' doesn't exist horde.rampage_user_tag_stats Error : Table 'horde.rampage_user_tag_stats' doesn't exist horde.rampage_users Error : Table 'horde.rampage_users' doesn't exist horde.trean_bookmarks Error : Table 'horde.trean_bookmarks' doesn't exist horde.trean_schema_info Error : Table 'horde.trean_schema_info' doesn't exist horde.turba_objects Error : Table 'horde.turba_objects' doesn't exist horde.turba_schema_info Error : Table 'horde.turba_schema_info' doesn't exist horde.turba_shares Error : Table 'horde.turba_shares' doesn't exist horde.turba_shares_groups Error : Table 'horde.turba_shares_groups' doesn't exist horde.turba_shares_users Error : Table 'horde.turba_shares_users' doesn't exist horde.turba_sharesng Error : Table 'horde.turba_sharesng' doesn't exist horde.turba_sharesng_groups Error : Table 'horde.turba_sharesng_groups' doesn't exist horde.turba_sharesng_users Error : Table 'horde.turba_sharesng_users' doesn't exist
Now I understand that Horde was updated in this last WHM upgrade and that the upgrade changed Horde from using MySQL to another database so I'm wondering if what I should be doing is dropping the Horde db entirely? Can anyone offer advice on what we ought to do to resolve this please? We don't use webmail so its not causing any operational issues but it would be nice to have everything in order and to stop receiving this email. Thanks! Forgot to post the WHM version: [LIST]

WHM 11.50.0 (build 29)

• 

  cPanelMichael

  • August 24, 2015 17:27

  We don't use webmail so its not causing any operational issues but it would be nice to have everything in order and to stop receiving this email.

  
  Hello :) You can backup the horde database via:
  mysqldump horde > /root/path/to/horde.sql
  You can then delete the database via phpMyAdmin or via the MySQL command line if you do not use Webmail and don't need to verify the data was converted to the SQLite databases successfully. Thank you.

  0

Please sign in to leave a comment.