Horde disabled but cpbackup/pkgacct tries to archive it anyway

aww

Well-Known Member
Feb 10, 2005
152
0
166
cPanel Access Level
Root Administrator
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)

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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
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

Member
Jun 19, 2010
8
0
51
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

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

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
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

Registered
Apr 24, 2010
2
0
51
Here is quick fix :
/http://websterz.info/horde-database-error-while-taking-backup-in-cpanelwhm-quick-fix/
Thank you!
 

aww

Well-Known Member
Feb 10, 2005
152
0
166
cPanel Access Level
Root Administrator
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?