I'm sorry I got my log files mixed up. Either way I want the "information from the server" (radius.log) to log to sql. I may just have to fire a cronjob to parse it and toss it into the sql dbase but thats the complex way out. The detail.log has the accounting data that is going to the SQL server already.
Why reply off list? - I am subscribed to too many mailing lists and its hard to tell if someone responds to my posts. However I didn't know if someone else might one day have the same question as I and they could then go through the archive and find it. 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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alan DeKok Sent: Wednesday, January 29, 2003 12:29 PM To: [EMAIL PROTECTED] Subject: Re: Logging Question Brandon Lehmann <[EMAIL PROTECTED]> wrote: > 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) That's not the detail log file. It's the log file describing what the server is doing. > 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. You can't. It's not meant to go into a database. It doesn't contain much additional information over the accounting logs. > 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. Grab the latest CVS snapshot. There is the ability to do things (including logging to SQL) after a user has been authenticated (or failed authentication), but before the Reject packet is sent to the client. > Please reply both on-list and off. Why? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html