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
pgpbfX88siDXk.pgp
Description: PGP signature
