Professional Web Applications Themes

CGI::Sessions : Deleting expired sessions - PERL Modules

Hi, I use CGI::Sessions to save the sessions into MySQL. The problem is, if the user just close the browser windows without logging off, I can't delete the sessions. The sessions will just stay in the DB even when they are already expired. Is there any way to deal with this? Do I have to create a script to delete the expired sessions manually from MySQL? Thanks, Vito...

  1. #1

    Default CGI::Sessions : Deleting expired sessions

    Hi,
    I use CGI::Sessions to save the sessions into MySQL. The problem is, if
    the user just close the browser windows without logging off, I can't
    delete the sessions. The sessions will just stay in the DB even when
    they are already expired. Is there any way to deal with this? Do I have
    to create a script to delete the expired sessions manually from MySQL?

    Thanks,
    Vito
    Vito Corleone Guest

  2. #2

    Default Re: CGI::Sessions : Deleting expired sessions

    Vito Corleone <corleonegodfather.com> wrote in message news:<20040615162632.29e5353c.corleonegodfather.c om>...
    > Hi,
    > I use CGI::Sessions to save the sessions into MySQL. The problem is, if
    > the user just close the browser windows without logging off, I can't
    > delete the sessions. The sessions will just stay in the DB even when
    > they are already expired. Is there any way to deal with this? Do I have
    > to create a script to delete the expired sessions manually from MySQL?
    >
    > Thanks,
    > Vito
    Hi,

    You can delete expired sessions when you _initialize_ user's session.
    If the script never gets executed then that means nobody is viewing
    the script so it doesn't matter whether their sessions are expired or
    not because once a user executes your script, the initialization
    routine will remove all expired sessions.
    Mohammd M. Hussain Guest

Similar Threads

  1. Replies: 4
    Last Post: November 22nd, 08:36 PM
  2. sessions and what not
    By ruben in forum PHP Development
    Replies: 0
    Last Post: November 13th, 09:38 AM
  3. [PHP] sessions and php
    By Justin French in forum PHP Development
    Replies: 0
    Last Post: September 19th, 04:48 AM
  4. Database sessions and file sessions
    By Cditty in forum PHP Development
    Replies: 1
    Last Post: September 9th, 01:34 AM
  5. Relationship between IIS Sessions and ASP.NET Sessions?
    By Luther Miller in forum ASP.NET General
    Replies: 0
    Last Post: August 8th, 03:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139