Re: Logging Question
29-Jan-03 at 17:42, Brandon Lehmann ([EMAIL PROTECTED]) wrote : > 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. Get a mail client not made by Microsoft : you run (X-Mailer: Internet Mail Service (5.5.2653.19)) Then, you can sort mailing lists in to separate folders with regexps, order by thread, and easily watch your thread to see when replies come in. -- |-Simon White, Internet Services Manager, Certified Check Point CCSA. |-MTDS Internet, Security, Anti-Virus, Linux and Hosting Solutions. |-MTDS 14, rue du 16 novembre, Agdal, Rabat, Morocco. |-MTDS tel +212.3.767.4861 - fax +212.3.767.4863 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Logging Question
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
Re: Logging Question
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
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
