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 problem after cPanel update

Discussion in 'General Discussion' started by closet geek, Dec 11, 2006.

  1. closet geek

    closet geek Well-Known Member

    Joined:
    Mar 19, 2004
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    I can't get past the login screen. Trying: /usr/local/cpanel/bin/update-horde --force

    Database "horde" dropped
    Creating Horde database
    ERROR 2013 (HY000) at line 61: Lost connection to MySQL server during query
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    ERROR 2013 (HY000) at line 36: Lost connection to MySQL server during query
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    ERROR 2013 (HY000) at line 36: Lost connection to MySQL server during query
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Updating Pear modules ...Done
    Restoring Horde data
    Resyncing Horde database items
    DBD::mysql::st execute failed: Table 'horde.horde_vfs' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.DBD::mysql::st execute failed: Table 'horde.kronolith_events' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.kronolith_storage' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.mnemo_memos' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.nag_tasks' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.

    The problem seems to be with using the GRANT command. However the server has been running MySQL 4.1.21 for ages now and Horde has always worked before. I've tried msqlup --force but it didn't help.

    Running WHM 10.8.0 cPanel 10.9.0-R95.

    cg
     
  2. closet geek

    closet geek Well-Known Member

    Joined:
    Mar 19, 2004
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON horde_users TO 'horde'@'localhost';
    ERROR 2013 (HY000): Lost connection to MySQL server during query

    That error message gets printed instantly.

    cg
     
  3. closet geek

    closet geek Well-Known Member

    Joined:
    Mar 19, 2004
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Now fixed: columns_priv.MYI was missing from /var/lib/mysql/mysql I only found this out when trying to GRANT via the privileges tab in phpMyAdmin. The fix is to run:

    mysqlcheck -r --use-frm mysql

    Sigh. Why do I always have to deal with things like this after cPanel updates?!

    cg
     
  4. k1k

    k1k Active Member

    Joined:
    Mar 24, 2006
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Horde issues

    Hello,

    The procedure that you have used is good for you (maybe), but bad for the customers on the server. Their personal settings/list... are stored the horde database. You have dropped the DB
    and they have lost their data. I personally prefer

    mysqldump --add-drop-table horde > horde.sql.

    Then you will be sure that you wont loose any data. Then you could simply reinstall the whole horde "/scripts/fullhordereset".
    When you are ready, then you wont have any issues with the sql access and the only thing that you have to do is to apply the sql dump.
    However such errors, that contain "gone away" are usually caused from the mysql configuration and its *timeout entries(but the horde queries are really fast..).
     
  5. closet geek

    closet geek Well-Known Member

    Joined:
    Mar 19, 2004
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    The database was already hosed by the cPanel update, there were only four tables in it which is nowhere near right.

    I accept your point, but in my case I was repairing damage caused by an update. Note, that this wasn't a timeout issue but was caused by columns_priv.MYI having been deleted from /var/lib/mysql/mysql during the update.

    Very strange, very annoying.

    cg
     
  6. k1k

    k1k Active Member

    Joined:
    Mar 24, 2006
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Hey

    Hello again,

    I think that I know what has happened with the database. Please make sure that your mysql configuration support InnoDB tables. The easiest way for that is to check if you have skip-innodb option in your "/etc/my.cnf". If yes - then remove that line. Then restart the mysql service and everything should be fine.
     
  7. closet geek

    closet geek Well-Known Member

    Joined:
    Mar 19, 2004
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    Yes our MySQL supports InnoDB, this was not the issue.

    Thanks,

    cg
     
  8. ckh

    ckh Well-Known Member

    Joined:
    Dec 6, 2003
    Messages:
    356
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Phoenix, AZ
    cPanel Access Level:
    DataCenter Provider
    In my case, the session_handler table was toast, the file was missing from the directory. I simply went to another server, dumped the table structure, went back, dropped the session_handler table and and issued the sql query:

    Code:
    CREATE TABLE `horde_sessionhandler` (
      `session_id` varchar(32) NOT NULL default '',
      `session_lastmodified` int(11) NOT NULL default '0',
      `session_data` longblob,
      PRIMARY KEY  (`session_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    That fixed it on 2 servers for me.

    Chris
     
  9. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    /scripts/fullhordereset has fixed every horde problem I have come accross.
     
  10. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Didn't work for me. :mad:
     
  11. promixe

    promixe Registered

    Joined:
    Jul 4, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    My problem is:

    Code:
    blue# /scripts/fullhordereset
    
    New horde password: FFkVGKSC
    
    [: mysqld is alive: unexpected operator
    [: localhost: unexpected operator
    [: 3.1.3: unexpected operator
    Archiving current Horde data to /var/cpanel/horde/horde.backup.sql.1170910741
    mysqldump: Got error: 1049: Unknown database 'horde' when selecting the database
    Cleaning old Horde data archives
    Skipping /var/cpanel/horde/horde.backup.sql.1170910741 (archived)
    Skipping /var/cpanel/horde/horde.backup.sql.1170910216 (archived)
    Skipping /var/cpanel/horde/horde.backup.sql.1170910154 (archived)
    Skipping /var/cpanel/horde/horde.backup.sql.1170900416 (archived)
    /var/cpanel/horde/horde.backup.sql.1170900060
    [: 0: unexpected operator
    mysqladmin: DROP DATABASE horde failed;
    error: 'Table 'mysql.proc' doesn't exist'
    Creating Horde database
    ERROR 2013 (HY000) at line 61: Lost connection to MySQL server during query
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    [: unexpected operator
    Updating Pear modules ...Done
    Restoring Horde data
    Resyncing Horde database items
    DBD::mysql::st execute failed: Table 'horde.horde_vfs' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.kronolith_events' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.kronolith_storage' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.mnemo_memos' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.nag_tasks' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    DBD::mysql::st execute failed: Table 'horde.turba_objects' doesn't exist at /usr/local/cpanel/bin/horde_update_usernames line 38.
    Done. Horde updated to 3.1.3
    
    Your horde password is above.  Horde has been reset
    
    MySQL is 5.0.27 and the OS is FreeBSD 6.2
    InnoDB is not disabled in /etc/my.cnf
    I can't seem to manually insert anything from phpMyAdmin nor can I manually do any mysql < file
    Any attemt gives me SQL error 2013 (which there is no valuable information about on the internet)

    Most of forums (SMF & IPB) and other DB scripts work just fine.

    I've had random tables missing before from Horde database but it was easy enough to fix. Now I don't know what's going on. Thanks.
     
  12. sanjuabrahamk

    sanjuabrahamk Active Member

    Joined:
    Jan 26, 2006
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    Try this solution

    take the backup of the horde database

    cp -prf /var/lib/mysql/horde /var/lib/mysql/horde.bak

    mysql
    mysql> use horde;
    mysql> drop table horde_sessionhandler;
    mysql> CREATE TABLE horde_sessionhandler (
    session_id VARCHAR(32) NOT NULL,
    session_lastmodified INT NOT NULL,
    session_data LONGBLOB,

    PRIMARY KEY (session_id)
    ) ENGINE = InnoDB;


    Sanju Abraham
    www.mycutelife.net
     
Loading...

Share This Page