On Wed, 29 Jan 2003, Brandon Lehmann wrote: > Hello List, > > I have looked through quite a bit of the archives and did not see > anything along this question. I currently have Freeradius running > perfectly as a proxy system. The accounting data is saved to a file and > forwarded to the actual auth server. No problems there. I also have another > log file (detail.log) that contains lines similar to this: > > Wed Jan 29 17:23:02 2003 : Auth: Login OK: [[EMAIL PROTECTED]/] (from > client rad2.cisp.proxy port 16928 cli 4193558974) > Wed Jan 29 17:23:04 2003 : Auth: Login incorrect (Home Server says so): > [[EMAIL PROTECTED]/] (from client rad1.cisp.proxy port 17871 cli > 4195882771) > (some wrapping may have occured). > > I am currently trying to get FreeRadius to log everything to a MySQL > server (for testing then to a MSSQL server). The accounting data (start & > stop packets... etc) are making it into the MySQL database just fine. The > problem lies in the fact that I can not find any way to log the information > that goes into detail.log to a MySQL database. We are looking for the > ability to rapidly search through our users login attempts during a certain > date range or even the current date to see #1 if we receive the auth > request, #2 if their password is correct, and #3 was it ok. Any help would > be greatly appreciated. Please reply both on-list and off.
Check out the log_badlogins script in dialup_admin. > > Brandon Lehmann CCNA, CFOT, A+ > Network Co-Administrator > Networld Online Inc. > WorldTeq Group Intl > 2201 Commerce Drive > Fremont, OH 43420 > 800-644-6638 > [EMAIL PROTECTED] > www.nwonline.net > > - > 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
