On 14 October 2011 08:46, Tom Hanstra <tom@nd.edu> wrote:
I'm not sure if this is a bug or a problem in how I'm running the clean_database.pl script...
Running the script, it says the sessions are going to be purged:
$ PERL5LIB=$PERL5LIB $KOHA_CRON_PATH/cleanup_database.pl -v --sessions --sessdays 2 Session purge triggered with days>2. 0 sessions were deleted. Done with session purge with days>2.
But there are sessions older than 2 days:
mysql> select * from sessions; | 00000ea4915d23eff57160797fdd1d55 | --- _SESSION_ATIME: '1315496500' _SESSION_CTIME: '1315496500' _SESSION_ID: 00000ea4915d23eff57160797fdd1d55 ...
and Unix time stamp '1315496500' translates to 'Thu, 08 Sep 2011 15:41:40 GMT'.
Hmm nope that should have worked. One thing I would encourage you to do Tom, is to switch from using mysql for session storage, to using memcached. You will get a nice speed increase and not have to worry about purging the db table also. If you are on 3.4.0 or later you should have this option available. Back to your problem what is the rest of the session data is there a bit that says lasttime: ? Chris