Hi,
I want to know how can I decode + sign in radius? Because in radcheck table the username I enlisted is +911234567789, when I want to register on this number the output I'm getting is listed down below;
[sql] expand: %{Stripped-User-Name} -> +911234567789
[sql] sql_set_user escaped user --> '+911234567789'
rlm_sql (sql): Reserving sql socket id: 2
[sql] expand: SELECT id, username, attribute, value, op FROM rad_check WHERE username = '%{SQL-User-Name}' -> SELECT id, name, attribute, secret, op FROM rad_check WHERE username = '=2B911234567789' ORDER BY id
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '=2B911234567789' ORDER BY priority
rlm_sql (sql): Released sql socket id: 2
[sql] User +911234567789 not found
++[sql] returns notfound
++[expiration] returns noop
++[logintime] returns noop
[pap] WARNING! No "known good" password found for the user. Authentication may fail because of this.
The SQL is converting + sign to 2B, that is why I can't get registered to radius. Please advise how can I resolve this issue.
--
Regards,
Ahmed Munir