Re: Sql mac authentication, module not instantiated

22 Oct 2013

      Hello All,

Figured it out this morning.

Alan DeKok would have told me to read the config file, which I did and now
it works.

All I had to do was to put sql_mac into the instantiate section.

My apologies,
Bertalan

On 21 October 2013 16:22, Bertalan Voros <bertalan.voros@gmail.com> wrote:
...
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
-- 
Bertalan Voros
m: 07932858025