Horde disabled but cpbackup/pkgacct tries to archive it anyway

[aww]

These are "soft" errors in the logs since they don't cause backup to fail but they are still annoying.

Probably time for cpanel to give the cpbackup/cpmove code a lookover for more intelligent processing?

If it's smart enough to skip logaholic, why not horde? (and innodb for that matter)

(BTW the grant error is from either skip-name-resolve or skip-networking and the innodb error is from skip-innodb, perhaps mysql could be queried for these before trying to do those operations)

DBD::mysql::st execute failed: There is no such grant defined for user on host at /usr/local/cpanel/Cpanel/Mysql.pm line 520.
DBD::mysql::db selectall_arrayref failed: Unknown table engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 195.
DBD::mysql::db selectall_arrayref failed: Unknown table engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 195.
...mysql version: 5.1......mysqldump version: 5.1...Saving mysql privs...Done
ERROR 1146 (42S02) at line 1: Table 'horde.kronolith_shares' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'horde.kronolith_shares' doesn't exist
ERROR 1286 (42000) at line 1: Unknown table engine 'InnoDB'
...Done

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

Storing mysql dbs............
horde.turba_objectshorde.turba_objects
Error    : Table 'horde.turba_objects' doesn't exist
status   : Operation failed
horde.horde_prefs(1690 bytes) horde.kronolith_shareshorde.kronolith_shares
Error    : Table 'horde.kronolith_shares' doesn't exist
status   : Operation failed
horde.kronolith_storagehorde.kronolith_storage
Error    : Table 'horde.kronolith_storage' doesn't exist
status   : Operation failed
horde.mnemo_memoshorde.mnemo_memos
Error    : Table 'horde.mnemo_memos' doesn't exist
status   : Operation failed
horde.nag_taskshorde.nag_tasks
Error    : Table 'horde.nag_tasks' doesn't exist
status   : Operation failed
...Done

Horde is the most annoying and should be easily detectable, just like they do for logaholic

 

[cPanelTristan]

Hello,

I've submitted case 58112 about this issue for Horde being set to skiphorde=1 in /var/cpanel/cpanel.config (WHM > Tweak Settings file) and our backup script (/usr/local/cpanel/scripts/cpbackup) trying to back up the Horde tables.

Thanks for bringing this to our attention.

 

[josh123456]

hello
i skipped hord in
skiphorde=1 in /var/cpanel/cpanel.config (WHM > Tweak Settings file)

but pkgacct still try to give backup from horde

warn [pkgacct] hdshopir_allgraphicd: mysqldump failed -- database may be corrupt
(57795 bytes) warn [pkgacct] Failed to dump database hdshopir_allgraphicd
horde.turba_objectswarn [pkgacct] horde.turba_objects: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

horde.turba_objects
note : The storage engine for the table doesn't support repair
warn [pkgacct] horde.turba_objects: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1163 bytes) warn [pkgacct] Failed to dump database horde
horde.horde_prefswarn [pkgacct] horde.horde_prefs: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

horde.horde_prefs
note : The storage engine for the table doesn't support repair
warn [pkgacct] horde.horde_prefs: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1155 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_shareswarn [pkgacct] horde.kronolith_shares: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

horde.kronolith_shares
note : The storage engine for the table doesn't support repair
warn [pkgacct] horde.kronolith_shares: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1181 bytes) warn [pkgacct] Failed to dump database horde
horde.kronolith_storagewarn [pkgacct] horde.kronolith_storage: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

horde.kronolith_storage
note : The storage engine for the table doesn't support repair
warn [pkgacct] horde.kronolith_storage: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1181 bytes) warn [pkgacct] Failed to dump database horde
horde.mnemo_memoswarn [pkgacct] horde.mnemo_memos: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

horde.mnemo_memos
note : The storage engine for the table doesn't support repair
warn [pkgacct] horde.mnemo_memos: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

warn [pkgacct] horde: mysqldump failed -- database may be corrupt
(1159 bytes) warn [pkgacct] Failed to dump database horde
horde.nag_taskswarn [pkgacct] horde.nag_tasks: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

horde.nag_tasks
note : The storage engine for the table doesn't support repair
warn [pkgacct] horde.nag_tasks: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'horde'': Cannot load from mysql.proc. The table is probably corrupted (1548)

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

ERROR: Failed to dump one or more databases

 

[cPanelTristan]

The internal case 58112 is still opened and not yet resolved on this issue. As such, yes it will still be backed up even if skipped.

 

[websterz]

Here is quick fix :
/http://websterz.info/horde-database-error-while-taking-backup-in-cpanelwhm-quick-fix/
Thank you!

 

[aww]

Creating all the tables is a bit nasty (there are a bunch of them).

What is the status of case 58112 anyway - still not addressed in 11.36?