Do first "select * from ..." to check if those are the records you want deleted:
DELETE FROM radacct WHERE AcctStopTime=0 AND AcctStartTime < DATE_SUB(NOW(), INTERVAL 5 HOUR) Ivan Kalik Kalik Informatika ISP Dana 27/6/2007, "Jeff" <[EMAIL PROTECTED]> piše: >Seems like everyday from one upstream provider we use I get accouting record >start and for some reason i get no stop packet on customers. I also use same >radius with YourNetPlus and I am not seeing this issue with them. So it leads >me to believe its something between I and GlobalPOPS. My question is mysql >programming knowledge is not that strong does anyone know of a query I could >run every so often that would cleanup the raddact table of records as such. > >For example I would like to clear all records with start time greater than 5 >hours old from the time the query runs with no stop time. I have session tme >out of 4 hours so there is not much chance that a user is still connected. >At least that way my users online listing, etc won't be cluttered with old >users on, and possibly be blocking a user access due to it thinking they are >still connected. > >I know globalpops is going to tell me this is latency on our network and not >theirs. But if that was the case I would see several happen from the >yournetplus network also. > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
