MAC Auth (new problem)

[tnt at kalik.net]

That SQL statement looks scary but it's not that bad. You can play with
the SELECT part until you get the data you want and then just add INSERT
bit in front and populate the database.

Ivan Kalik
Kalik Informatika ISP


Dana 16/12/2008, "Nataniel Klug" <nata at cnett.com.br> piše:

>Ok... Thank you Ivan. I can't change my system but I can make scripts in
>my Linux Box that could make this happens.
>
>tnt at kalik.net escreveu:
>> Or fill with a single sql statement:
>>
>> INSERT INTO radcheck (username, op attribute, value) SELECT value, ':='
>> AS op, Cleartext-Password (or Auth-Type) AS attribute, that fixed
>> password (or Accept - if you don't want to check mac passwords and opt
>> for auth type) AS value FROM radcheck WHERE
>> attribute='Calling-Station-Id'
>>
>> probably should add ON DUPLICATE blah, blah in order to prevent
>> duplication of mac-as-user entries.
>>
>> Nataniel, populating this is trivial stuff. You should really put your
>> effort into creating a proper user database. If you AP is going to ask
>> for user nicknames and mac addresses as usernames, your database should
>> provide them - as usernames.
>>
>> Ivan Kalik
>> Kalik Informatika ISP
>>
>> Dana 16/12/2008, "Alan DeKok" <aland at deployingradius.com> piše:
>>
>>
>>> Nataniel Klug wrote:
>>>
>>>> I would like to have this easy configuration but this is not possible at
>>>> the moment. Lazy = spend a lot of money...
>>>>
>>>  Nonsense.  A short Perl script could walk through your existing DB,
>>> and re-write entries into another table, or add new entries to an
>>> existing table.
>>>
>>>  Alan DeKok.
>>> -
>>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/usershtml
>>>
>>>
>>>
>>
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>
>>
>
>--
>Att,
>
>NATANIEL KLUG
>nata at cnett.com.br
>
>LEIA O DIA-A-DIA DO NATA
>http://nataklug.blogspot.com/
>
>Cyber Nett - Internet Banda Larga
>www.cnett.com.br
>(42) 3635-2957
>Rua Diogo Pinto, 1046, Centro
>Laranjeiras do Sul - PR
>Brasil - 85301-290
>
>"... também os sábios possuem coraça~o tangível e podem, por vezes, usar da cie^ncia como meio de demonstrar impresso~es sentimentais de que muitos na~o os julgam suscetíveis."
>Visconde de Taunay
>
>
>