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
Attachment:
pgpPxgiLaYbqc.pgp
Description: PGP signature