Enforcing Login-Time on NAS

[Frank Ranner]

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 at 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-tp4845142p4845762.html
> Sent from the FreeRadius - User mailing list archive at Nabble.com.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html