Sql mac authentication, module not instantiated

21 Oct 2013

      Hello All,

I am trying to do this:
           if (Called-Station-ID =~ /:ssid$/) {
                rewrite_calling_station_id
                if(!"%{sql_mac:SELECT COUNT(*) FROM 'arguswifi.macaddress'
WHERE mac = '%{Calling-Station-ID}' = 1}"){
                        reject
                }
        }

But getting the following in -X:
WARNING: Unknown module "sql_mac" in string expansion "%"
Also if I look through the debug log there seems to be no mentioning of
sql_mac.
sql.conf is uncommented in radiusd.conf.

My sql.conf:
sql sql_mac {
        database = "mysql"
        driver = "rlm_sql_${database}"
        server = "mysql.server"
        login = "dbuser"
        password = "dpPwd"
        radius_db = "macdb"
        sqltrace = yes
        sqltracefile = ${logdir}/sqltrace.sql
        num_sql_socks = 5
        connect_failure_retry_delay = 60
        lifetime = 0
        max_queries = 0
}

What am I doing wrong?

Thanks again,
Bertalan

Sql mac authentication, module not instantiated

Bertalan Voros