CLASS value in SQL xlat

[Arran Cudbard-Bell]

On 4 Sep 2013, at 05:05, Okis Chuang <okischuang at 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 at freeradius.org>
FreeRADIUS Development Team