"+" string converted to "=2B" in SQL request
Tony LEMEUNIER
Tony.Lemeunier at novelcom.fr
Mon Mar 5 17:13:36 CET 2018
Hi everybody,
I'am using Freeradius 3.0.12 with backend MySQL.
I customized my SQL groupreply request like this:
authorize_group_reply_query = "\
SELECT id, groupname, attribute, \
value, op \
FROM ${groupreply_table} \
WHERE groupname = '%{${group_attribute}}' AND value LIKE '%%%{Called-Station-Id}%%' \
ORDER BY id"
%(Called-Station-Id) can be phone number like +33567897654, and the request sent to MySQL is:
SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = GROUP' AND value LIKE '%=2B33567897654%' ORDER BY id
'+' string was converted to "=2B'.
How can I do to preserve + string
Best Regards,
Tony LEMEUNIER
Tony LEMEUNIER
More information about the Freeradius-Users
mailing list