On Wed, 2 Mar 2005, Mark Elkins wrote:
I want to put the contents of radius.log into a MySQL Database - in **real time**.
ie - lines that read something like... Fri Feb 25 18:50:37 2005 : Auth: Login OK: [EMAIL PROTECTED] (from client adsl1 port 123456789)
How do I do this?
This is so various support type people can see when things go wrong... eg... Mon Feb 21 17:50:04 2005 : Auth: Login incorrect (rlm_pap: User password not available): [EMAIL PROTECTED]/testpass] (from client adsl1 port 123456789) ... and fix the problem.
All my current interfaces are in web/php/apache - on different machines from where the flat file info is currently logged...
For bad logins, see bin/log_badlogins in dialupadmin
You can also use the postauth facility of rlm_sql.
If we are talking about successful logins you don't need to do much, they will appear on the accounting table automatically (if you 've enabled mysql accounting).
-- . . ___. .__ Posix Systems - Sth Africa. e.164 VOIP ready /| /| / /__ [EMAIL PROTECTED] - Mark J Elkins, Cisco CCIE / |/ |ARK \_/ /__ LKINS Tel: +27 12 807 0590 Cell: +27 82 601 0496
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html