Horde Session problem since upgrade

chrisbond

Well-Known Member
Apr 12, 2003
59
0
156
Hereford, United Kingdom
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

Member
Apr 26, 2004
5
0
151
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

Well-Known Member
Nov 22, 2003
155
0
166
India
cPanel Access Level
Root Administrator
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"]
***********
 

amal

Well-Known Member
Nov 22, 2003
155
0
166
India
cPanel Access Level
Root Administrator
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... :)
 

TSJasonH

Active Member
PartnerNOC
Nov 25, 2003
34
0
156
Chicago, IL
hooray

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

Arsalan

Well-Known Member
Jan 5, 2002
51
0
306
This is how you fix this (for novice users)

Login to the server via SSH (root)




[email protected] [/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

Member
Mar 11, 2003
8
0
151
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

Well-Known Member
Nov 22, 2003
155
0
166
India
cPanel Access Level
Root Administrator
Could be due to harddisk errors...

tedderz said:
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

Well-Known Member
PartnerNOC
Dec 30, 2002
103
0
166
Kungsbacka, Sweden
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

Well-Known Member
Nov 22, 2003
155
0
166
India
cPanel Access Level
Root Administrator
oderland said:
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

Well-Known Member
PartnerNOC
Dec 30, 2002
103
0
166
Kungsbacka, Sweden
amal said:
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...