Enforcing Login-Time on NAS

[Suman Dash]

Glad to be of some help !!

Cheers

On Tue, Sep 27, 2011 at 8:53 PM, 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110927/1a02a2ac/attachment.html>