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