The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Horde disabled but cpbackup/pkgacct tries to archive it anyway

Discussion in 'Data Protection' started by aww, Mar 12, 2012.

  1. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  3. josh123456

    josh123456 Member

    Joined:
    Jun 19, 2010
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  5. websterz

    websterz Registered

    Joined:
    Apr 24, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Here is quick fix :
    /http://websterz.info/horde-database-error-while-taking-backup-in-cpanelwhm-quick-fix/
    Thank you!
     
  6. aww

    aww Well-Known Member

    Joined:
    Feb 10, 2005
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    16
    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?
     
Loading...

Share This Page