Horde Session problem since upgrade

[chrisbond]

Since upgrade to latest stable/release having problems with people not able to login to horde. Ive checked all the recent threads and those fixes dont work. Im my horde.log ive got:

Feb 16 13:05:05 HORDE [error] [horde] Error retrieving session data (id = 992eb5513b9811bcff6f8e6f577567eb) [on line 113 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Feb 16 13:05:05 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Feb 16 13:05:09 HORDE [error] [horde] Error retrieving session data (id = 9a322189c13a718a2a881eb0026fa9c2) [on line 113 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Feb 16 13:05:09 HORDE [error] [horde] Error garbage collecting old sessions [on line 190 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Feb 16 13:05:09 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Feb 16 13:05:09 HORDE [error] [horde] Error retrieving session data (id = 9a322189c13a718a2a881eb0026fa9c2) [on line 113 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Feb 16 13:05:10 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]


Any ideas on how to fix this one?

 

[wulfhere]

I've been getting the same problem. When customers try to use Horde, it prompts them for a language over and over again. In horde.log, I get this:

Mar 01 08:12:50 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:51 HORDE [error] [horde] Error retrieving session data (id = 97a0f8de5434b9834c3f3e5126599483) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:51 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:51 HORDE [error] [horde] Error retrieving session data (id = 97a0f8de5434b9834c3f3e5126599483) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:51 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:53 HORDE [error] [horde] Error retrieving session data (id = 97a0f8de5434b9834c3f3e5126599483) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:53 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:53 HORDE [error] [horde] Error retrieving session data (id = bb74b66d27e2abd4e9ba41a6c17e72ad) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:53 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:53 HORDE [error] [horde] Error retrieving session data (id = bb74b66d27e2abd4e9ba41a6c17e72ad) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]
Mar 01 08:12:53 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 14:49:33 HORDE [error] [horde] Error retrieving session data (id = 23a83f79c801e0a375e9156d1f46bd92) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]
Mar 01 14:49:33 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 14:49:33 HORDE [error] [horde] Error retrieving session data (id = 23a83f79c801e0a375e9156d1f46bd92) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]
Mar 01 14:49:33 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 01 14:49:35 HORDE [error] [horde] Error retrieving session data (id = 23a83f79c801e0a375e9156d1f46bd92) [on line 113 of "/usr/local/cpanel/base/horde/lib
/Horde/SessionHandler/mysql.php"]

 

[amal]

Me having the same problem ..........

I'm also having the same problem.. Still no fix.. :-(

************
Mar 11 18:25:03 HORDE [error] [horde] Error retrieving session data (id = 80d32f8cc8e5f0ea8f9924fd8b09f326) [on line 113 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 11 18:25:04 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 11 18:25:05 HORDE [error] [horde] Error retrieving session data (id = 80d32f8cc8e5f0ea8f9924fd8b09f326) [on line 113 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 11 18:25:05 HORDE [error] [horde] Error writing session data [on line 138 of "/usr/local/cpanel/base/horde/lib/Horde/SessionHandler/mysql.php"]
***********

 

[dgbaker]

What O/S? Are you running SecureTmp? etc.....

 

[amal]

Issue is fixed....

I was able to fix the issue..

The table - horde_sessionhandler in the database - horde was corrupt. I fixed it using the command -

repair table horde_sessionhandler

from mysql. And everything is back to normal.... Hope, it works fine for others as well...

 

[wulfhere]

That did it! Thank you very much!

 

[TSJasonH]

hooray

Here it is 5 months later and this post is still helpful. Thanks!

 

[Arsalan]

This is how you fix this (for novice users)

Login to the server via SSH (root)




root@sun [/root]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5589 to server version: 4.0.25-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use horde
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'horde_sessionhandler'
Database changed
mysql> repair table horde_sessionhandler;
+----------------------------+--------+----------+------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+--------+----------+------------------------------------------------------+
| horde.horde_sessionhandler | repair | info | Found block that points outside data file at 9872836 |
| horde.horde_sessionhandler | repair | warning | Number of rows changed from 9 to 8 |
| horde.horde_sessionhandler | repair | status | OK |
+----------------------------+--------+----------+------------------------------------------------------+
3 rows in set (0.54 sec)

mysql>


That should work.

 

[tedderz]

corrupt mysql

I'm having the same problem, except it gets corrupted every day.

I've repaired the tables for horde many times, yet about once a day they keep getting corrupted again, any ideas on what I can do to stop it from getting corrupted every day?

 

[amal]

Could be due to harddisk errors...

I'm having the same problem, except it gets corrupted every day.

I've repaired the tables for horde many times, yet about once a day they keep getting corrupted again, any ideas on what I can do to stop it from getting corrupted every day?

If it's getting corrupted every day, then it could be due to bad sectors or file system errors in your harddisk.. Do make sure that there are no such errors... A simple way to check for harddisk errors would be to use

/scripts/smartcheck

 

[oderland]

have same problem here. Second time this week one of our server has this problem. Repair fix it for some days.
/scripts/smartcheck gives just OK on both disks. No error messages i messeges file on disks

any clue?

 

[amal]

have same problem here. Second time this week one of our server has this problem. Repair fix it for some days.
/scripts/smartcheck gives just OK on both disks. No error messages i messeges file on disks

any clue?

Run

/usr/local/cpanel/3rdparty/bin/smartctl -l /dev/hda
(NOTE: I assume that u have installed cpanel on the hda drive, if not make the necessary change )

and paste the result

 

[oderland]

Run

/usr/local/cpanel/3rdparty/bin/smartctl -l /dev/hda
(NOTE: I assume that u have installed cpanel on the hda drive, if not make the necessary change )

and paste the result

/usr/local/cpanel/3rdparty/bin/smartctl -l /dev/sda
/usr/local/cpanel/3rdparty/bin/smartctl -l /dev/sdb

says nothing...