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" <[email protected]> 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. > >[email protected] 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" <[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/usershtml >>> >>> >>> >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> >> > >-- >Att, > >NATANIEL KLUG >[email protected] > >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 > > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
