Why not create a view in the database that joins the two tables? Then you can get the login time in a single query. On 28/09/2011, at 1:23 AM, shiv <shivkumar.jags@gmail.com> wrote:
Update - I've managed to get it working against a custom table in the mysql radius database. The sites-enabled/default authorize section is as below:-
update request { Huntgroup-Name := "%{sql:SELECT `groupname` FROM `radhuntgroup` WHERE rtrmac='%{Called-Station-Id}'}" }
if ("%{Huntgroup-Name}" != "") { update request{ Tmp-String-0 = "%{sql:SELECT `logintime` FROM `wifihotspots` WHERE hotspotname='%{Huntgroup-Name}'}" } }
if ( "%{Tmp-String-0}" != "") { update control{ Login-Time := "%{Tmp-String-0}" }
}
The wifihotspots table contains Huntgroup-Name and its Corresponding Login-Time Thanks again for the help!
-- View this message in context: http://freeradius.1045715.n5.nabble.com/Enforcing-Login-Time-on-NAS-tp484514... Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html