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