Sergio Belkin <sebelk@gmail.com> wrote:
2009/10/23 Alexander Clouter <alex@digriz.org.uk>:
Sergio Belkin <sebelk@gmail.com> 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.