Sergio Belkin <[email protected]> wrote: > > 2009/10/23 Alexander Clouter <[email protected]>: > >> Sergio Belkin <[email protected]> wrote: >>> >>> Is there a way to get the las time that user got Accept-Accept and >>> Accept-Reject, of course I can parse log files but I wonder if there a >>> radius tool that can do it. >>> >> <your data> -> SQL >> >> SELECT * FROM postauth WHERE user_name = '<blar>' AND packet_type = >> 'Access-Reject' ORDER BY timestamp DESC LIMIT 1 >> >> Then for the latter replace 'Access-Accept' with 'Access-Reject'? >> > > Ooops, I have no mysql > That is a *good* thing, use PostgreSQL...
> except that there is a way to dump log files to mysql database :) > > Sorry if the question sounds stupid :) > It is, thats why there is documentation... http://freeradius.org/radiusd/man/rlm_sql.html Cheers -- Alexander Clouter .sigmonster says: Read the fine print. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
