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@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@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