back up problem

[AngelsGrave]

Hello

i am going to get new server so i started to take a cpmove
so i given that command :

for i in `ls /var/cpanel/users`; do /scripts/pkgacct $i ; done

and i got that errors when packing :

Determining mysql dbs...DBD::mysql::db selectall_arrayref failed: Incorrect information in file: './roundcube/users.frm' at /usr/local/cpanel/bin/cpmysqladmin line 200.
DBD::mysql::db selectall_arrayref failed: Incorrect information in file: './roundcube/users.frm' at /usr/local/cpanel/bin/cpmysqladmin line 200.
...mysql version: 5.0......mysqldump version: 5.0...Saving mysql privs...Done
ERROR 1033 (HY000) at line 1: Incorrect information in file: './horde/kronolith_shares.frm'
ERROR 1033 (HY000) at line 1: Incorrect information in file: './horde/kronolith_shares.frm'
ERROR 1033 (HY000) at line 1: Incorrect information in file: './roundcube/users.frm'
...Done

Skipping Logaholic Backup. Logaholic is globally disabled on this system.

Storing mysql dbs............
banathi_games(43171819 bytes) horde.turba_objectswarn [pkgacct] horde.turba_objects: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_objects.frm' when doing LOCK TABLES

horde.turba_objects
Error    : Incorrect information in file: './horde/turba_objects.frm'
error    : Corrupt
warn [pkgacct] horde.turba_objects: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_objects.frm' when doing LOCK TABLES

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(753 bytes) warn [pkgacct] Failed to dump database horde
horde.turba_shareswarn [pkgacct] horde.turba_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_shares.frm' when doing LOCK TABLES

horde.turba_shares
Error    : Incorrect information in file: './horde/turba_shares.frm'
error    : Corrupt
warn [pkgacct] horde.turba_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/turba_shares.frm' when doing LOCK TABLES

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(753 bytes) warn [pkgacct] Failed to dump database horde
horde.horde_prefswarn [pkgacct] horde.horde_prefs: mysqldump: Got error: 1033: Incorrect information in file: './horde/horde_prefs.frm' when doing LOCK TABLES

horde.horde_prefs
Error    : Incorrect information in file: './horde/horde_prefs.frm'
error    : Corrupt
warn [pkgacct] horde.horde_prefs: mysqldump: Got error: 1033: Incorrect information in file: './horde/horde_prefs.frm' when doing LOCK TABLES

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(753 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_shareswarn [pkgacct] horde.kronolith_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_shares.frm' when doing LOCK TABLES

horde.kronolith_shares
Error    : Incorrect information in file: './horde/kronolith_shares.frm'
error    : Corrupt
warn [pkgacct] horde.kronolith_shares: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_shares.frm' when doing LOCK TABLES

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(753 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_storagewarn [pkgacct] horde.kronolith_storage: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_storage.frm' when doing LOCK TABLES

horde.kronolith_storage
Error    : Incorrect information in file: './horde/kronolith_storage.frm'
error    : Corrupt
warn [pkgacct] horde.kronolith_storage: mysqldump: Got error: 1033: Incorrect information in file: './horde/kronolith_storage.frm' when doing LOCK TABLES

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(753 bytes) warn [pkgacct] Failed to dump database horde
horde.mnemo_memoswarn [pkgacct] horde.mnemo_memos: mysqldump: Got error: 1033: Incorrect information in file: './horde/mnemo_memos.frm' when doing LOCK TABLES

horde.mnemo_memos
Error    : Incorrect information in file: './horde/mnemo_memos.frm'
error    : Corrupt
warn [pkgacct] horde.mnemo_memos: mysqldump: Got error: 1033: Incorrect information in file: './horde/mnemo_memos.frm' when doing LOCK TABLES

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(753 bytes) warn [pkgacct] Failed to dump database horde
horde.nag_taskswarn [pkgacct] horde.nag_tasks: mysqldump: Got error: 1033: Incorrect information in file: './horde/nag_tasks.frm' when doing LOCK TABLES

horde.nag_tasks
Error    : Incorrect information in file: './horde/nag_tasks.frm'
error    : Corrupt
warn [pkgacct] horde.nag_tasks: mysqldump: Got error: 1033: Incorrect information in file: './horde/nag_tasks.frm' when doing LOCK TABLES

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(753 bytes) warn [pkgacct] Failed to dump database horde

ERROR: Failed to dump one or more databases
...Done

then i tried the other command :

/scripts/pkgacct

and it gived me the same errors

what do i do ?
Help please

 

[24x7server]

As per the provided logs, I can see your horde database is corrupted so I will suggest you try to reset full horde on your server, Try to run the following commands on your server

/scripts/fullhordereset
/usr/local/cpanel/bin/update-horde –-force

That will drop the existing horde database, and rebuild it. Then see if you can manually package that account.

 

[cPanelMichael]

Hello

The error messages you provided indicate the Horde and Roundcube databases may be corrupted. You can find information on repairing these databases at:

How to Repair MyISAM Tables - MySQL 5.5
How to Repair MyISAM Tables - MySQL 5.1

Dropping the databases and reinstalling the Horde/Roundcube applications is also an option, but you will lose data stored in the those databases.

Thank you.

 

[AngelsGrave]

Thanks for your help Michael ... the result :
PS : there is many errors coz of the nginx in the end ... could it be the reason of that errors ??
coz before the website goes down ( - link removed no need - ) there was 504 nginx error .

Updating Horde 1.2.11.cp7
tar -x -p -z --no-same-owner -f /usr/local/cpanel/src/3rdparty/gpl/horde-webmail-1.2.11.tar.gz
info [update-horde] Applied patch '0001-remove-test.php-files.patch'
patching file imp/test.php
patching file ingo/test.php
patching file kronolith/test.php
patching file lib/Horde/Kolab/Server/test.php
patching file test.php
patching file turba/test.php
info [update-horde] Applied patch '0002-get-user-and-password-values-from-env.patch'
patching file imp/lib/Compose.php
patching file imp/lib/IMAP.php
patching file imp/templates/login/login.html
patching file templates/login/login.inc
info [update-horde] Applied patch '0003-case-45312-height-directive-causing-text-to-disappea.patch'
patching file themes/safari.css
info [update-horde] Applied patch '0004-remove-apps-from-menu.patch'
patching file dimp/config/conf.php
info [update-horde] Applied patch '0005-use-driver-prefs.patch'
patching file ingo/config/conf.php
info [update-horde] Applied patch '0006-compare-applications-horde-webroot-with-current-URL.patch'
patching file lib/Horde/Registry.php
info [update-horde] Applied patch '0007-use-macro-for-database-creation.patch'
patching file scripts/sql/groupware.mysql.sql
info [update-horde] Applied patch '0008-set-server_name-as-localhost-and-from_addr-as-cpanel.patch'
patching file kronolith/config/conf.php
info [update-horde] Applied patch '0009-legacy-patch-disable-server_list-openssl-crt.patch'
patching file imp/config/conf.php
info [update-horde] Applied patch '0010-sanitize-preferences.patch'
patching file lib/Horde/Prefs.php
info [update-horde] Applied patch '0011-add-imap-and-default-config.patch'
patching file config/conf.php.in
patching file imp/config/servers.php.in
info [update-horde] Applied patch '0012-Case-60020-Add-ie9-compatibility.patch'
patching file dimp/lib/DIMP.php
patching file imp/templates/common-header.inc
patching file lib/Horde/Browser.php
info [update-horde] Applied patch '0013-Fix-XSS-vulnerabilities-in-portal-blocks.patch'
patching file kronolith/lib/Block/monthlist.php
patching file kronolith/lib/Block/prevmonthlist.php
info [update-horde] Applied patch '0014-Fix-empty-sorting-preferences.patch'
patching file imp/lib/IMP.php
info [update-horde] Successfully applied 14 patches
Apply patchset to Horde sources
Archiving current Horde data to /var/cpanel/horde/horde.backup.sql.1374003521
mysqldump: Got error: 1033: Incorrect information in file: './horde/horde_alarms.frm' when using LOCK TABLES
Failed to backup existing Horde DB. DB likely did not exist./usr/bin/mysqladmin: DROP DATABASE horde failed;
error: 'Error on delete of './horde/nag_shares_groups.MYI' (Errcode: 2)'
Cleaning old Horde data archives
Creating Horde database
ERROR 1007 (HY000) at line 48: Can't create database 'horde'; database exists
Horde updated to 1.2.11.cp7
No database backup found to restore.
/usr/bin/IndexSrv-nginx-vhost-creator: line 7: /usr/local/nginx/conf/vhost.conf: No such file or directory
/usr/bin/IndexSrv-nginx-vhost-creator: line 9: /usr/local/nginx/conf/vhost.conf: No such file or directory
/usr/bin/IndexSrv-nginx-vhost-creator: line 22: /usr/local/nginx/conf/vhost.conf: No such file or directory
/usr/bin/IndexSrv-nginx-vhost-creator: line 150: /usr/local/nginx/conf/vhost.conf: No such file or directory
/usr/bin/IndexSrv-nginx-vhost-creator: line 176: /usr/local/nginx/conf/vhost.conf: No such file or directory

Your horde password is above.  Horde has been reset
root AT server.domain.com[~]# /usr/local/cpanel/bin/update-horde .-force
Horde is up to date. Execute '/usr/local/cpanel/bin/update-horde --force' to force an update.

 

[cPanelMichael]

Did you try repairing the database first, or did you try the method offered by the other poster? The error log indicates the database is still corrupted. You will need to try repairing it, or back it up and delete it before attempting to reinstall Horde.

Thank you.

 

[AngelsGrave]

i am very very sorry but i am not that strong in shell ... would you please give me a moment and tell me what to do :$

 

[cPanelMichael]

You can check to see which version of MySQL is installed on your system with the following command:

mysql -V

Then, you can follow the appropriate guide for repairing the databases:

How to Repair MyISAM Tables - MySQL 5.5
How to Repair MyISAM Tables - MySQL 5.1

If you prefer to completely delete your Horde/Roundcube databases (and lose user configured data for those webmail applications), you can drop them via PHPMyAdmin and then run:

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

Thank you.

 

[AngelsGrave]

Really thanks for helping me out

this have been done after opening a ticket to CPanel support and they did fix it ... thanks aloooooooooooot for this