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 Session problem since upgrade

Discussion in 'General Discussion' started by chrisbond, Feb 16, 2005.

  1. chrisbond

    chrisbond Well-Known Member

    Joined:
    Apr 12, 2003
    Messages:
    59
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    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?
     
  2. wulfhere

    wulfhere Member

    Joined:
    Apr 26, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    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"]
     
  3. amal

    amal Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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"]
    ***********
     
  4. dgbaker

    dgbaker Well-Known Member
    PartnerNOC

    Joined:
    Sep 20, 2002
    Messages:
    2,578
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Toronto, Ontario Canada
    cPanel Access Level:
    DataCenter Provider
    What O/S? Are you running SecureTmp? etc.....
     
  5. amal

    amal Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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... :)
     
  6. wulfhere

    wulfhere Member

    Joined:
    Apr 26, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    That did it! Thank you very much!
     
  7. TSJasonH

    TSJasonH Active Member
    PartnerNOC

    Joined:
    Nov 25, 2003
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Chicago, IL
    hooray

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

    Arsalan Well-Known Member

    Joined:
    Jan 5, 2002
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  9. tedderz

    tedderz Member

    Joined:
    Mar 11, 2003
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  10. amal

    amal Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Could be due to harddisk errors...

    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
     
  11. oderland

    oderland Well-Known Member
    PartnerNOC

    Joined:
    Dec 30, 2002
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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?
     
  12. amal

    amal Well-Known Member

    Joined:
    Nov 22, 2003
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    Root Administrator
    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
     
  13. oderland

    oderland Well-Known Member
    PartnerNOC

    Joined:
    Dec 30, 2002
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Kungsbacka, Sweden


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

    says nothing...
     
Loading...

Share This Page