perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Nachbaur <>
Subject RE: cleaning old Apache::Session's
Date Thu, 01 Jun 2000 23:35:14 GMT
Theres a problem with that assumes you use mySQL.  I use Oracle, and it doesn't
provide that functionality; you need to alter the INSERT or UPDATE statements to include passing
a SYSDATE into the timestamp field.  'Course, you could create a trigger that adds the SYSDATE
after an insert or update, but thats not really elegant...and PL_SQL really sucks (warning...flamebait)


-----Original Message-----
From: Richard Dice []
Sent: Thursday, June 01, 2000 4:31 PM
To: Adam Cassar
Subject: Re: cleaning old Apache::Session's

> I was wondering how people are clearing out old Apache::Session's
> No timestamp is used on the fields used by Apache::Session, so how do
> we clear the old sessions?
> I am not talking about the delete() method to remove a session, as that
> presumes that a user will always leave your site via pre-defined access
> points.

This is how I handle it...

Your 'sessions' table schema has to have _at least_ the columns in it that
are talked about in the Apache::Session documentation.  That doesn't mean
that you can't add on your own timestamp column as well.  Your program
can use that as a basis upon which to delete rows.


 Richard Dice * Personal 514 816 9568 * Fax 514 816 9569
 ShadNet Creator * *
 Occasional Writer, HotWired *
     "squeeze the world 'til it's small enough to join us heel to toe"
         - jesus jones

View raw message