[Nufw-devel] auth_mysql cache

[Francesco Varano]

Hi, 
 I'm trying to implement a cache system both for user and ipauth checks
in auth_mysql module and I would like to ask for any suggestion from
you.
 Should I use cache_manager (with a dedicated thread) or could I
implement cache directly inside auth_mysql code? I begun with the second
case (it seemed simpler to me) but now I'm stuck on one doubt:
 If there are more than one ip_auth thread should I care about mutexes
on the cache? Or it will result in a per-thread cache and thus useless?

 Finally I would like to add that cache system could be useful to manage
and update a new column in ipauth_sessions table (i.e. last_session)
that can be updated with the time of last_session from that ip. This way
it could be simpler to automatically logout a user after a period of
inactivity: just a SELECT on ipauth_sessions table.

thank you in advance for you help.
Francesco Varano.