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'"