I use automatic timestamps on update /default and run a script every minute to check if there are some records which hasn't been updated for 15minutes or more
J. -- Jonathan De Graeve Network/System Administrator Imelda vzw Informatica Dienst 015/50.52.98 [EMAIL PROTECTED] -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Michael Markstaller Verzonden: dinsdag 25 oktober 2005 20:58 Aan: FreeRadius users mailing list Onderwerp: RE: adding a stop packet I'm running something like this from crontab: UPDATE radacct SET AcctStopTime = FROM_UNIXTIME(unix_timestamp(AcctStartTime) + AcctSessionTime), AcctTerminateCause = 'NoStopRecv', AcctStopDelay = (unix_timestamp(now()) - (unix_timestamp(AcctStartTime) + AcctSessionTime)), AcctSessionTime = AcctSessionTime + 300 WHERE AcctStopTime = '' AND (unix_timestamp(now()) - (unix_timestamp(AcctStartTime) + AcctSessionTime)) > 3660 AND AcctSessiontime > 0 ; UPDATE radacct SET AcctStopTime = AcctStartTime, AcctTerminateCause = 'NoStop-AliveRecv', AcctStopDelay = (unix_timestamp(now()) - (unix_timestamp(AcctStartTime))) WHERE AcctStopTime = '' AND AcctSessionTime = 0 AND (unix_timestamp(now()) - unix_timestamp(AcctStartTime)) > 86400 ; /* Purge failed attempts */ DELETE FROM radacct WHERE AcctStopTime > 0 AND AcctSessionTime = 0 AND AcctStopTime <= DATE_SUB(CURDATE(),INTERVAL 7 DAY); Michael > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Chuck > Sent: Tuesday, October 25, 2005 8:30 PM > To: freeradius-users@lists.freeradius.org > Subject: adding a stop packet > > > We are using freeradius with mysql. Is there some kind of > script to easily add > a fake stop date/time to a user when one gets missed? > Currently I am looking > them up in the accounting table and manually editing the > entry. Would like to > find something that just takes username as input and creates > a stop based on > current date/time. We don't use the accounting for anything > other than > getting usage reports so if a few users are incorrect , no matter. > > This happens frequently ( several times a week) that we don't > get stop packets > from our upstream. Then when users attempt a login, > simultaneous use check > item kicks in and denies them. They claim there is nothing > they can do about > it. > > -- > > Chuck > > - > 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