[rt-users] RT session cleanup - session table size

[Kevin Falcone]

On Mon, Jul 08, 2013 at 08:05:32PM +0200, Alex Decalli wrote:
>    Thanks a lot Kevin. Frankly I have been working on this server for like 1 week, this is RT3.8
>    on Ubuntu 11.04 (terrible, I know), it has no GUI installed (no problem for me), mysql 5.1 and
>    the administrator has left almost for 1 year, so no support for long time. The auto logoff was
>    not set, we are planning to find all the problems, announce downtime (this server is being
>    used globally) and make changes, I am planning to set the autologoff too. But now, how can I
>    at least manually clean this session table? is there any way? (I am new to this RT, so I am
>    really not sure how it works yet, I am studying it and I know that this data on session table
>    is really useless for future)

The SQL I mentioned was a bit of a hint.

>>      As for why nothing is deleted, if you log into your database (which
>>      database are you using?) you can run
>>      select min(LastUpdated) from sessions;
>>      to see what your data looks like.

You can delete from sessions where LastUpdated is old, as long as you
accept that RT does not *always* update the session for REST clients
and some other users, so if someone has hardcoded a cookie rather than
logging in and saving the cookie, there will be problems.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130709/c450ed95/attachment.sig>