CGI::Sessions : Deleting expired sessions

[Vito Corleone]

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

[Mohammd M. Hussain]

Vito Corleone <corleone@godfather.com> wrote in message news:<20040615162632.29e5353c.corleone@godfather.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.