Horde problem after cPanel update

[closet geek]

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

 

[closet geek]

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

 

[closet geek]

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

 

[k1k]

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..).

 

[closet geek]

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

 

[k1k]

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.

 

[closet geek]

Hi,

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

Thanks,

cg

 

[ckh]

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:

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

 

[celliott]

/scripts/fullhordereset has fixed every horde problem I have come accross.

 

[WebHostPro]

/scripts/fullhordereset has fixed every horde problem I have come accross.

Didn't work for me.

 

[promixe]

My problem is:

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.

 

[sanjuabrahamk]

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