<html><div style='background-color:'><DIV class=RTE>
<P>I have one question to this, you suposed that RADIUS and DataBase services are in the same machine, what happens if these services are in severa or there are replicate servers?<BR></P></DIV>
<DIV></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">>My advice is to create a database trigger on INSERTs, UPDATEs,<BR>>DELETEs.<BR>>For example, my postgresql trigger written in plperlu:<BR>><BR>>CREATE OR REPLACE FUNCTION restart_radiusd() RETURNS TRIGGER AS $rr_rad$<BR>> system("/usr/bin/sudo /usr/bin/killall -HUP radiusd");<BR>> return;<BR>>$rr_rad$ LANGUAGE plperlu;<BR>>DROP TRIGGER IF EXISTS need_to_restart_radiusd ON nas_table;<BR>>CREATE TRIGGER need_to_restart_radiusd AFTER INSERT OR UPDATE OR DELETE ON nas_table<BR>>FOR EACH STATEMENT EXECUTE PROCEDURE
restart_radiusd();<BR>><BR>>/etc/sudoers:<BR>>postgresqluser ALL=(radiususer) NOPASSWD: /usr/bin/killall -HUP radiusd<BR>><BR>><BR>>This way, you will restart freeradius only when needed.<BR>>You said that your backend is mysql, you will probably be able to come<BR>>up with the mysql version, but your main issue is not that.<BR>>SIGHUP must work.</FONT></BLOCKQUOTE></div><br clear=all><hr>Coches nuevos, coches de ocasión, coches de Km 0 <a href="http://g.msn.com/8HMAESES/2746??PS=47575" target="_top">Si piensas en cambiar de coche, MSN Motor.</a> </html>