MAC-Auth + Freeradius + MySQL Database

[Russell Mike]

On Sun, Feb 24, 2013 at 2:20 PM, Alan DeKok <aland at deployingradius.com>wrote:

> Russell Mike wrote:
> > Thanks for guidelines. exactly, as you stated I simple want to store MAC
> > address somewhere & compair against the request. Can they be in
> > "radcheck"?
>
>   I wouldn't do that.  Just create your own table of MAC addresses.  If
> all you want is to list known MACs, you can do that with a custom table.
>
>   Then, do:
>
>         if ("%{sql: SELECT ...}") {
>                 # known MAC
>         }
>
>   Use a SQL client to write the correct SELECT statement, and then put
> it into the example above.  Then apply any "known MAC" rule inside of
> the "if" statement.
>
> > Secondly, i would have list of maximum 500 MACs, how about listing them
> > in a file. Would it be considerably slow reading from file than DB? I
> > have no idea because I never used radius with files.
>
>   See "man rlm_passwd".  It contains examples.  You could put the MACs
> into a group via that module, and then do group checking.
>
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>


Dear Alan De.

Thanks for your input, you are so helpful. And the information sent is also
very much useful, i will try to more forward base on your guidelines.
Thanks / Regards
RM --
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130224/c4fcbd79/attachment.html>