Hi,

I am trying to do mac authorization as per http://wiki.freeradius.org/Mac-Auth#Mac-Auth+authorisation+by+SSID+SQL

In fact my attempt is much simpler as I just have a very simple table containing the mac address of system to accept. My conf looks like that:

authorize {

...

        # newer authorized macs

        if("%{sql_local:SELECT COUNT(mac) FROM authorized_macs WHERE mac ='%{Calling-Station-ID}'}" > 0){

                update control {

                        Auth-Type := Accept

                }

                ok = return

        }

...

}

But when doing an authentication attemp I get the following in the debug logs :

...

Thu Aug 25 16:52:56 2011 : Info: ++? if (ok) -> FALSE

Thu Aug 25 16:52:56 2011 : Info: ++? if ("%{sql_local:SELECT COUNT(mac) FROM authorized_macs WHERE mac ='%{Calling-Station-ID}'}" > 0)

Thu Aug 25 16:52:56 2011 : Info: WARNING: Unknown module "sql_local" in string expansion "%"

Thu Aug 25 16:52:56 2011 : Info: ? Evaluating ("%{sql_local:SELECT COUNT(mac) FROM authorized_macs WHERE mac ='%{Calling-Station-ID}'}" > 0) -> FALSE

Thu Aug 25 16:52:56 2011 : Info: ++? if ("%{sql_local:SELECT COUNT(mac) FROM authorized_macs WHERE mac ='%{Calling-Station-ID}'}" > 0) -> FALSE

...

As far as I can understand the documentation this should be working (http://wiki.freeradius.org/Rlm_sql#SQL+xlat). Any helpful hand which can bring some light to the darkness of my intellect?

Cheers,

seb.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html