Re: MAC-Authentication from Mysql

2010-11-23 Thread 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

Re: MAC-Authentication from Mysql

2010-11-23 Thread Alan DeKok
David Seira wrote: 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. The next logical step would be to post *that line* from the file, and ask What is wrong about

Re: MAC-Authentication from Mysql

2010-11-23 Thread David Seira
The next logical step would be to post *that line* from the file, and ask What is wrong about it? Yes, but I think it is not possible with SQL XLAT. For that reason, finally, I try with sql.authorize, as Arran advised me, and I think I've achieved the solution. The problem was I didn't

MAC-Authentication from Mysql

2010-11-22 Thread David Seira
Hi list. I'm trying to implement MAC-Authentication directly from a Mysql database. I follow the wiki page http://wiki.freeradius.org/Mac-Auth for authenticate macs from a file. I want to authenticate macs reading the authorized macs from a mysql database. I understand that in the radcheck table

Re: MAC-Authentication from Mysql

2010-11-22 Thread Alan DeKok
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

Re: MAC-Authentication from Mysql

2010-11-22 Thread David Seira
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

Re: MAC-Authentication from Mysql

2010-11-22 Thread Arran Cudbard-Bell
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

Re: MAC-Authentication from Mysql

2010-11-22 Thread 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 {