Cleanup Radacct table (Need Help)

[tnt at kalik.co.yu]

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" <jeffa at jahelpdesk.com> 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
>
>