Sql mac authentication, module not instantiated

[Bertalan Voros]

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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131022/d522ac84/attachment.html>