The following document describes how to integrate UC500 with the WinRadius Radius accounting software, for demonstration purposes. The goal is to show how account codes (both forced and non-forced) are sent to Radius in a VoIP/Voice Call Detail Record (CDR) generated by the UC500.
WinRadius has been chosen for this example because it is very easy to install and administer. Also, WinRadius uses Open Database Connectivity (ODBC) by default, which can be read by Microsoft Access. WinRadius can also integrate with other database servers (like SQL, MySQL or Oracle according to the software vendor) but that is not covered in this document.
The accounting-to-billing transformations are not included in this document. Interpretation software like Vermamark's Verasmart (www.verramark.com) is required for this purpose.
DISCLAIMER: The following configuration is a bona fide example offered "as is" and by no means suggests or promotes any endorsement, by Cisco, of the WinRadius Software, its quality, its security, its stability, its scalability, the opinions of its owners or any other of WinRadius' related projects.
IMPORTANT: WinRadius is free to download and install, but according to their website, a right to use license must be purchased.
1) Download and install WinRadius. WinRadius can be obtained from the following location:
Once the above configuration is complete, Call Detail Records (CDR's) will be sent to WinRadius and presented in the log file on the screen.
a. Non Forced Account Codes will appear in the "account-code" attribute:
b. Forced Authorization Codes will appear in the "gw-collected-cdn" attribute:
c. You can also open the "WinRadius.mdb" file using Microsoft Access and export the accounting entries for further processing, but notice that WinRadius database tables do NOT include the account code information, unfortunately:
Is the Cisco 2702i series access point constructed and suitable for "Clean Room" (Healthcare environment) so that it can handle the daily chemical cleaning process like the Cisco 3602i and 3702i series access points are constructed to hand...
router Cisco RV340W dual wan, the firmware is the latest 1.0.03.24, 2 providers are connected, the Internet works in 2 local networks, everything is separate, everything is OK, each locale has its own white ipwhen applying any IPv4 rule in the firewall (F...
I have a cisco rv325 that has been working fine for a few years now. I upgraded to the latest firmware v22.214.171.124 (2020-10-27, 13:37:43) a few months ago. I started having problems with some UDP ports that I had allowed to be forwarded. It seems now the ap...
Hello For CISCO Catalyst 2960 firmware updated from Version 15.2(2)E5, to Version 15.2(7)E4. different password set for user exec and privileged exec mode. After Firmware updation User exec level 1 (i.e., con 0 ) is accepting privileged pa...