active_sessions

Ashley M. Kirchner ashley@pcraft.com
Thu, 13 Dec 2001 02:30:49 -0700


    I'm having a really odd problem and I'm not sure how to fix it.  I'm using Horde 1.2.6 and IMP 2.2.6, running on MySQL 3.23.41.  I've noticed that my active_sessions table gets filled up with a whole bunch of sesisons that are just dead, or empty.  And I've tracked it down to the following (which is better explained):

    When I first hit IMP, a session gets inserted in the table.  I do what I need to do, all my mail operations, all fine and dandy.  During this time, IMP continues to use that same session (based on the sid).  But then, when I log out, IMP *inserts* a new session in the table.  So I end up with 2 records which don't get deleted afterwards.

    Here's what the table shows:

    When I first hit IMP, it created the following session:

mysql> select * from active_sessions\G
*************************** 1. row ***************************
    sid: d23e9f4b97bc32f2ec5735b3a77dd87d
   name: HordeSession
    val: base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7IA==
changed: 20011213022030

    ...and I can see that sid value in my browser's address bar as well.  I do what I have to do, then I hit log out, and when I looked at the table again, I found this:


mysql> select * from active_sessions\G
*************************** 1. row ***************************
    sid: d23e9f4b97bc32f2ec5735b3a77dd87d
   name: HordeSession
    val: base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7IA==
changed: 20011213022030
*************************** 2. row ***************************
    sid: 35698f69991a38108acff7aff7a0b09e
   name: HordeSession
    val: base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7IA==
changed: 20011213022032


    Where did that second sid come from?  No one else was using IMP at the time, only me.  And in my browser address bar, the sid displayed was the first one above.  So where did the second one come from?

    This is something I can repeat over and over again, without failing.  Every time I log in and out, IMP leaves two records in the table.  Why is that?

--
H | "Life is the art of drawing without an eraser." - John Gardner
  +--------------------------------------------------------------------
  Ashley M. Kirchner <mailto:ashley@pcraft.com>   .   303.442.6410 x130
  Director of Internet Operations / SysAdmin    .     800.441.3873 x130
  Photo Craft Laboratories, Inc.            .     3550 Arapahoe Ave, #6
  http://www.pcraft.com ..... .  .    .       Boulder, CO 80303, U.S.A.