"+" string converted to "=2B" in SQL request

5 Mar 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