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@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@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/usershtml
- 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