On Thu 21 Dec 2006 05:41, Alan DeKok wrote:
Cory Robson wrote:
Has anyone written a script or event process to monitor the update packets against the users apparently online and in the event that no update is received in a 20 min period (my updates are every 15 mins from the NAS) create a close session event?
I don't think one has been written, but it shouldn't be too hard to write something that does the proper SQL SELECTs.
If you do write one, *please* submit it back, and we'll include it in the next release
This is so trivial to do that I am surprised that it takes up a thread on the mailing list :-) We run the following from cron: # crontab -l 0 23 * * * /usr/local/bin/radcleanunknowns # cat /usr/local/bin/radcleanunknowns #!/bin/sh /bin/su postgres -c 'cd ~ && echo "" && psql -d radius -f /etc/radsql/drop_unkowns.sql' # cat /etc/radsql/drop_unkowns.sql UPDATE radacct SET acctstoptime = acctstarttime, acctsessiontime = 0 WHERE acctstoptime IS NULL AND (now() - acctstarttime) > '23 hour'::interval AND acctsessiontime IS NULL; UPDATE radacct SET acctstoptime = (acctstarttime + acctsessiontime::text::interval) WHERE acctstoptime IS NULL AND (now() - acctstarttime - acctsessiontime::text::interval) > '1 hour'::interval ; Just adjust it to suit your needs... -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc