UPDATE radacct SET AcctStopTime = 'time of breakdown', AcctSessionTime = UNIX_TIMESTAMP('time of breakdown') - UNIX_TIMESTAMP(AcctStartTime) WHERE AcctStopTime = 0 AND AcctStartTime < 'time of breakdown'
Just rework accounting_onoff_query form sql.conf. Ivan Kalik Kalik Informatika ISP Dana 17/6/2008, "Leander S." <[EMAIL PROTECTED]> piše: >How would such an query look like? >I'm also very interested in a solution. > >Leander > > >Ivan Kalik schrieb: >> Find and delete the open session(s) in mysql. If you have time on your >> hands and you know when did the server fail you can create a query that >> will close them by updating AcctStopTime and AcctSessionTime fields for >> open sessions. >> >> Ivan Kalik >> Kalik Informatika ISP >> >> >> Dana 17/6/2008, "Sascha Kiefer" <[EMAIL PROTECTED]> piše: >> >> >>> Hi, >>> >>> I'm running mysql + radius. >>> Now it happened, that a user is no longer connected, but radius still things >>> he is connected. >>> My NAS vpn server died; probably thats why. What do i have to do make this >>> straight? >>> >>> >>> - >>> List info/subscribe/unsubscribe? See >>> http://www.freeradius.org/list/usershtml >>> >>> >>> >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> >> > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html