On Tue August 26 2003 07:41, Scott wrote: > I have freeradius running and authenticating/accounting via mysql. Very > slick. > > I can see the accounting showing up in mysql with an accurate > AcctSessionTime. Is there a way to keep a running total of these times per > user and authenticate not only on the basis of password but also on the > value of the total connection time? > > I've searched the web and found some references to some python hacks but > not really come across anything concrete.
It shouldn't be too difficult to do with some stored procedures on your DB, but as you are using MySQL you will probably have to do it another way. A small amount of Perl or Python could also do it.. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
