# Executing section authorize from file /etc/freeradius/sites-enabled/default
+- entering group authorize {...}
++[preprocess] returns ok
[chap] Setting 'Auth-Type := CHAP'
++[chap] returns ok
++[mschap] returns noop
++[digest] returns noop
[suffix] No '@' in User-Name = "14-F6-5A-F0-80-61-0000000010", looking up realm NULL
[suffix] No such realm "NULL"
++[suffix] returns noop
[eap] No EAP-Message, not doing EAP
++[eap] returns noop
++[files] returns noop
[sql] expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010
[sql] sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'
rlm_sql (sql): Reserving sql socket id: 4
[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '14-F6-5A-F0-80-61-0000000010' ORDER BY id
[sql] User found in radcheck table
[sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = '14-F6-5A-F0-80-61-0000000010' ORDER BY id
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '14-F6-5A-F0-80-61-0000000010' ORDER BY priority
rlm_sql (sql): Released sql socket id: 4
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
[pap] WARNING: Auth-Type already set. Not setting to PAP
++[pap] returns noop
sql_xlat
expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010
sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'
expand: select id from radcheck where username='%{User-Name}' order by id desc limit 1 -> select id from radcheck where username='14-F6-5A-F0-80-61-0000000010' order by id desc limit 1
rlm_sql (sql): Reserving sql socket id: 3
sql_xlat finished
rlm_sql (sql): Released sql socket id: 3
expand: %{sql: select id from radcheck where username='%{User-Name}' order by id desc limit 1} -> 24
++[control] returns noop
sql_xlat
expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010
sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'
expand: select ExpiryDate from radcheck where id = '%{My-Local-Int-1}' -> select ExpiryDate from radcheck where id = ' '
rlm_sql (sql): Reserving sql socket id: 2
SQL query did not return any results
rlm_sql (sql): Released sql socket id: 2
expand: %{sql: select ExpiryDate from radcheck where id = '%{My-Local-Int-1}'} ->
++[reply] returns noop
Found Auth-Type = CHAP
# Executing group from file /etc/freeradius/sites-enabled/default
+- entering group CHAP {...}
[chap] login attempt by "14-F6-5A-F0-80-61-0000000010" with CHAP password
[chap] Using clear text password "14-F6-5A-F0-80-61-0000000010" for user 14-F6-5A-F0-80-61-0000000010 authentication.
[chap] chap user 14-F6-5A-F0-80-61-0000000010 authenticated succesfully
++[chap] returns ok
# Executing section post-auth from file /etc/freeradius/sites-enabled/default
+- entering group post-auth {...}
[sql] expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010
[sql] sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'
[sql] expand: %{User-Password} ->
[sql] ... expanding second conditional
[sql] expand: %{Chap-Password} -> 0x00d3c7d69aaad14438d01478ad05d2ad00