On Sun, Jan 05, 2003 at 08:04:29AM -0800, bogdan wrote: > I had this problem today, it didn't clean them up, i had to do it > manually, anyhow i say ups the machines dealing aaa, as i did today > :).
ah cool. We're currently provisioning a better UPS at the moment, largely because the original one was only meant to arrest the flickers we get far more often than a prolonged outage. It also doesn't support system notification, since it's a workstation model. I'll make sure the new one does, so the radius server can kick everyone off then shut down cleanly. > > --- > Use phpMyadmin, its usefull... and do this operation : I am using phpmyadmin. it's very handy :) > > SELECT DISTINCT UserName,AcctStartTime,FramedIPAddress,CallingStationId FROM radacct >WHERE AcctStopTime = '0'; hmm. DISTINCT is a new one on me. *checks the mysql manual*. hmm. why would you need to use distinct? they all look like they'd be fairly distinct already... > > So then you can clean them up good :). Brute force. yeah. i'll have to write a quick python script to fix them up. just at least make sure the sessions are completely closed off, and approximate the kill-time. won't be able to guess the download time tho, but we don't have too many clients on that plan that aren't using satellite (where we charge rates for the satellite instead of the dialup downloads) Thanks Andrew Pilley > --- > > Hope it helped. > > --- > Best regards, > Bogdan > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html