MAC-Authentication from Mysql

[David Seira]

Thanks for your responses.

I tried SQL XLAT yesterday but I had the next radiusd -X errors:

/usr/local/etc/raddb/sites-enabled/default[598]: Failed to parse "if"
subsection.
/usr/local/etc/raddb/sites-enabled/default[485]: Errors parsing post-auth
section.

I think it is not possible to that with SQL XLAT. Is it possible to store
the return code of a sql query with SQL XLAT?

I'll try with sql.authorize.

Thanks.

Regards,
David

2010/11/23 EasyHorpak.com <info at easyhorpak.com>

>  On 22/11/2553 22:41, David Seira wrote:
>
> Hi Alan.
>
>  Thanks for your time.
>
>  In the authorize section I have the next instructions for authorize users
> in a mac file:
>
>   if((Service-Type == 'Call-Check') || (User-Name =~
> /^%{Calling-Station-Id}$/i)){
>  update control {
>  Auth-Type = 'CSID'
>  }
>  }
>
>  I don't know how to call the sql module for read the list users from
> mysql. If I put in that section the sql instruction I don't know how compare
> the sql results with the Calling-Station-Id that the NAS return in the
> request.
>
>  Another thing is that I don't know why the authorization is made in
> post-auth section.
>
>  Thanks for your help.
>
>  Regards,
> David
>
>
> 2010/11/22 Alan DeKok <aland at deployingradius.com>
>
>> David Seira wrote:
>> > I don't know where put the sql instruction for read macs from database.
>>
>>   Read raddb/sites-available/default.  Look for "sql".
>>
>>  Alan DeKok.
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>  try
> "%{sql: SELECT Value from radcheck WHERE Value='%{User-Name}' and
> Attribute='Cleartext-Password'"
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20101123/166bf856/attachment.html>