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
Refer to allowed characters variable within the sql config Sajeewa Warnakulasuriya Systems Development Manager ispONE is a wholesale ISP built to help internet access resellers and independent ISPs to compete in the Australian marketplace through ONE Brand, ONE Provider, ONE Solution. Level 14 520 Collins Street Melbourne 3000 VIC Phone: 1300 663 400 Fax: 1300 665 400 E-Mail: sajeewaw@ispone.com.au -----Original Message----- From: Ahmed Munir <ahmedmunir007@gmail.com> Sender: freeradius-users-bounces+sajeewaw=ispone.com.au@lists.freeradius.org Date: Tue, 25 May 2010 13:21:07 To: <freeradius-users@lists.freeradius.org> Reply-To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Decode + sign - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Ahmed Munir -
sajeewaw@ispone.com.au