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
