[files] expand: %{User-Name} -> john [files] sql_set_user escaped user --> 'john' rlm_sql (sql): Reserving sql socket id: 1 [files] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup *WHERE username = 'john' ORDER BY priority [files] sql_groupcmp finished: User is a member of group Guests rlm_sql (sql): Released sql socket id: 1 [files] users: Matched entry DEFAULT at line 18* ++[files] returns ok ++[expiration] returns noop ++[logintime] returns noop [pap] Found existing Auth-Type, not changing it. ++[pap] returns noop Found Auth-Type = EAP +- entering group authenticate {...} [eap] Request found, released from the list [eap] EAP/mschapv2 [eap] processing type mschapv2 [mschapv2] +- entering group MS-CHAP {...} [mschap] Told to do MS-CHAPv2 for john with NT-Password [mschap] adding MS-CHAPv2 MPPE keys ++[mschap] returns ok MSCHAP Success
Thanks, that worked a treat, users is now found in SQL-Group == Guests
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html