At 01:06 PM 3/4/00 -0600, you wrote:
On Fri, 3 Mar 2000, Jeff Mcadams wrote:
I use a modified version of Cistron RADIUS with the MySQL patches, with the following notable reworks:
- keeps active sessions in one table, prior sessions (not start/stop records) in another.
- Uses persistent MySQL connection.
- Handles database-down condition more gracefully, it queues to a temp file and then when the db comes back up, forks a child to clean up. The original code also forks but then waits for the child, which causes a big pileup of accounting records on the NASen.
- Disconnects/reconnects from the database on SIGUSR1 (on Linux, anyway) to make "planned" database downtime a little smoother.
The code and table structures could probably stand some cleanup, but it's in production use here with no major problems. I also have a companion script that reads the "online" table and walks through checking each supposedly-online user against the HARC via snmp, and kills off any stale records (which really only ever show up if a HARC gets rebooted unexpectedly.)
If anyone wants it I'll clean up a little and put the diffs up for download.
Yes, I would appreciate having a copy. Thanks. Lyle Evans Blacksburg.Net - To unsubscribe to usr-tc, send an email to "majordomo@xmission.com" with "unsubscribe usr-tc" in the body of the message. For information on digests or retrieving files and old messages send "help" to the same address. Do not use quotes in your message.