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" <[email protected]> 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
