Re: SIGTERM somewhere in SQL accounting (using MySQL)
At 11:26 AM 2/24/2003 -0500, Derrik Pates wrote: For some reason, I've started to see FreeRADIUS die of a SIGTERM somewhere in its SQL accounting code. It's going something like this: radius_xlat: 'SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='USERNAME' AND AcctStopTime = 0' Terminated I'm running it now with an strace, to see where it's dying more specifically. I'm using the code from a CVS snap from 10 days ago (20030214), if that helps to narrow it down. Use GDB it's much handier at finding the cause of the sigterm than strace. -Chris -- \\\|||/// \ StarNet Inc. \ Chris Parker \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering | @ @ |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Wholesale Internet Services - http://www.megapop.net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: SIGTERM somewhere in SQL accounting (using MySQL)
On Mon, Feb 24, 2003 at 10:40:13AM -0600, Chris Parker wrote: Use GDB it's much handier at finding the cause of the sigterm than strace. Actually, it pointed me in the right direction anyway - the checkrad script tried talking to the RAS server via SNMP, and got no response, and died of SIGTERM, for whatever reason knocking radiusd over with it. Anyone have any insight on that? -- Derrik Pates [EMAIL PROTECTED] [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: SIGTERM somewhere in SQL accounting (using MySQL)
[EMAIL PROTECTED] (Derrik Pates) wrote: Actually, it pointed me in the right direction anyway - the checkrad script tried talking to the RAS server via SNMP, and got no response, and died of SIGTERM, for whatever reason knocking radiusd over with it. Anyone have any insight on that? There was a long discussion on this list last Friday about exactly this issue. See the archives for details. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Accounting using mySQL
I am using freeRADIUS snapshot-20020128 and mySQL module for the accounting. The module stores only the start/stop requests. I want to store bad password attempts or double logins also. Any ideas? Thanks for your time. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - 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: Accounting using mySQL
Andrew Kelaidis [EMAIL PROTECTED] wrote: The module stores only the start/stop requests. I want to store bad password attempts or double logins also. Any ideas? I don't think that you can right now. But it should be possible, soon. As always, suggestions patches are welcome. 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: Accounting using mySQL
On Sat, 9 Feb 2002, Andrew Kelaidis wrote: I am using freeRADIUS snapshot-20020128 and mySQL module for the accounting. The module stores only the start/stop requests. I want to store bad password attempts or double logins also. Any ideas? Thanks for your time. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html You could use the log_badlogins perl script from dialup_admin. It will store all bad logins (login incorrect,double logins etc) in the sql database with a corresponding terminate cause. -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 10 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Accounting using mySQL
I am using freeRADIUS snapshot-20020128 and mySQL module for the accounting. The module stores only the start/stop requests. I want to store bad password attempts or double logins also. Any ideas? Thanks for your time. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Accounting using mySQL
Andrew Kelaidis [EMAIL PROTECTED] wrote: The module stores only the start/stop requests. I want to store bad password attempts or double logins also. Any ideas? I don't think that you can right now. But it should be possible, soon. As always, suggestions patches are welcome. Alan Dekok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html