CLASS value in SQL xlat

Arran Cudbard-Bell a.cudbardb at
Wed Sep 4 09:48:05 CEST 2013

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

More information about the Freeradius-Users mailing list