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@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@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/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Att, NATANIEL KLUG nata@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