Hello community,
Need some help upon configuring SQL accounting on JSBR.
The goal is to pass string attribute values to Oracle database using dictionary file rather than numeric values. For instance, we should pass ïEthernetÍ for NAS-Port-Type RADIUS attribute instead of passing numeric value ï15Í.
VALUE NAS-Port-Type Ethernet 15
Any ideas?
Regards,
Evgeny
Solved! Go to Solution.
Hello Apaul,
Thanks for the reply.I managed to do a work around.
I created attribute Filters using 'replace' action. They're using a static logic, for instance, Acct-Status-Type is replaced by a string AVP which has value "Start".
I also added the following piece of configuration to directed realm:
[Acct]
FilterOut = KZTBNG11-attributes_replacement
Evgeny
As Far as I understand, Attribute Filter scripts might be used in this case.
Does SBR require a license in this case? Can I use attribute filter scripts for modifying the values of RADIUS attributes in order to pass values to SQL INSERT in desired format?
/ET
Java Script is a licensed feature on SBR.
And yes, scripted attribute filters enable you to specify detailed algorithms to read, write, modify, and delete request and response attribute values.
Hello Apaul,
Thanks for the reply.I managed to do a work around.
I created attribute Filters using 'replace' action. They're using a static logic, for instance, Acct-Status-Type is replaced by a string AVP which has value "Start".
I also added the following piece of configuration to directed realm:
[Acct]
FilterOut = KZTBNG11-attributes_replacement
Evgeny