RE: Feeding accounting logs into mysql/Corrupted database
I have the same problem with Stephan. But my priority now is how to re-install the Radius database without re-installing the whole Freeradius package. Or can anybody supply me with its data structure so that I could reconstruct it manually. Pleas help. Don -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephan von Krawczynski Sent: Friday, July 09, 2004 10:40 PM To: [EMAIL PROTECTED] Subject: Re: Feeding accounting logs into mysql On Fri, 9 Jul 2004 16:19:30 +0300 (EEST) Kostas Kalevras [EMAIL PROTECTED] wrote: On Fri, 9 Jul 2004, Stephan von Krawczynski wrote: Hello all, has anybody a script at hand for feeding some (old) freeradius accounting log files into a mySQL db? I know I read somewhere about such a script... I would suggest just using radrelay with a properly configured radius server. Yes, that would be handy indeed. The only thing I don't get about this is why there is no mode for radrelay to feed the given detail file and then just exit. At least the man-page and doc files tell that the thing truncs the detail file and stays online for feeding further data being added to the detail file later on. How do you prevent this? Or is this only a lack of documentation? The situation is having around 150 old detail files that should be fed into the new mysql-accounting freeradius. Thanks for your help Stephan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- This message has been scanned by MailScanner and is believed to be clean. Thank you. -- This message has been scanned by MailScanner and is believed to be clean. Thank you. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Feeding accounting logs into mysql/Corrupted database
I have the same problem with Stephan. But my priority now is how to re-install the Radius database without re-installing the whole Freeradius package. Or can anybody supply me with its data structure so that I could reconstruct it manually. this can be done on many ways. a. you can use a separate test bed server and do you thing b. you can build and install it on different PREFIX or path location //milver - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Feeding accounting logs into mysql
Stephan von Krawczynski [EMAIL PROTECTED] wrote: Yes, that would be handy indeed. The only thing I don't get about this is why there is no mode for radrelay to feed the given detail file and then just exit. Submit a patch. It shouldn't be too difficult. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Feeding accounting logs into mysql
Hello all, has anybody a script at hand for feeding some (old) freeradius accounting log files into a mySQL db? I know I read somewhere about such a script... Thanks for any hints Stephan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Feeding accounting logs into mysql
On Fri, 9 Jul 2004, Stephan von Krawczynski wrote: Hello all, has anybody a script at hand for feeding some (old) freeradius accounting log files into a mySQL db? I know I read somewhere about such a script... I would suggest just using radrelay with a properly configured radius server. Thanks for any hints Stephan - 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: Feeding accounting logs into mysql
I just happen to have such a script.. it's based of something I found a year or so back, and modified quite a bit. It does the job for me. Unless you use USR/3com/name_of_the_week Total Control, you'll probably need to do some modifications. On Fri, 9 Jul 2004, Stephan von Krawczynski wrote: Hello all, has anybody a script at hand for feeding some (old) freeradius accounting log files into a mySQL db? I know I read somewhere about such a script... Thanks for any hints Stephan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -Mike == Network Engineer Pathway Internet Services 616.774.3131 parse_radius_detail.pl Description: Perl program
Re: Feeding accounting logs into mysql
On Fri, 9 Jul 2004 16:19:30 +0300 (EEST) Kostas Kalevras [EMAIL PROTECTED] wrote: On Fri, 9 Jul 2004, Stephan von Krawczynski wrote: Hello all, has anybody a script at hand for feeding some (old) freeradius accounting log files into a mySQL db? I know I read somewhere about such a script... I would suggest just using radrelay with a properly configured radius server. Yes, that would be handy indeed. The only thing I don't get about this is why there is no mode for radrelay to feed the given detail file and then just exit. At least the man-page and doc files tell that the thing truncs the detail file and stays online for feeding further data being added to the detail file later on. How do you prevent this? Or is this only a lack of documentation? The situation is having around 150 old detail files that should be fed into the new mysql-accounting freeradius. Thanks for your help Stephan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html