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