MAC-Authentication from Mysql
David Seira
davidseira at gmail.com
Tue Nov 23 10:22:49 CET 2010
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>
More information about the Freeradius-Users
mailing list