Hi all, I'm using FR 2.2.0 with Oracle 11g. Now I'm collecting Accounting records into Oracle DB with sql xlat which call a function in PL/SQL. For example in debug mode it expands like below: "%{sql:select wifi_acct.onlineStart(..., '%{Class[*]}',..) from dual}" "TestCL: v=1234;TestCL2: w=5678" => "TestCL: v=3D123456=3BTestCL2: w=3D5678" Here comes the problem, through xlat content of '%{Class[*]}' in SQL string was turned into something like URL encoded string(but not exactly the same) while executing my PL/SQL function. Anyone knows what encode format it is? Any advice would be appreciated! Okis
On 4 Sep 2013, at 05:05, Okis Chuang <okischuang@outlook.com> wrote:
Hi all,
I’m using FR 2.2.0 with Oracle 11g.
Now I’m collecting Accounting records into Oracle DB with sql xlat which call a function in PL/SQL. For example in debug mode it expands like below:
“%{sql:select wifi_acct.onlineStart(….., ‘%{Class[*]}’,……) from dual}”
“TestCL: v=1234;TestCL2: w=5678” => “TestCL: v=3D123456=3BTestCL2: w=3D5678”
Here comes the problem, through xlat content of ‘%{Class[*]}’ in SQL string was turned into something like URL encoded string(but not exactly the same) while executing my PL/SQL function.
Anyone knows what encode format it is?
=<octal ASCII value> You can edit safe_characters in dialup.conf to include additional chars that you don't want to convert. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
participants (2)
-
Arran Cudbard-Bell -
Okis Chuang