User's Guide
What It Is
What's New
Key Features List
ClearBox Enterprise vs ClearBox
System Requirements
Purchasing Licenses
Getting Started
Quick Start
Understanding Server Components
Managing User Accounts
Configuring RADIUS Realms
Realm Settings
Realm Rules
Dynamic Realm Rules
Authentication Protocols Compatibility
Logging Authentication Packets
Logging Discarded Requests
Account Log Files
Realm Settings
Configuring SQL Queries
Private RADIUS Attributes
Regular Expressions Syntax
RADIUS Clients
RADIUS Client Settings
Dynamic Clients Settings
SQL Data Sources
SQL Data Source Settings
LDAP Servers
LDAP Server Settings
Remote RADIUS Servers
Remote RADIUS Server Settings
State Servers
State Server Settings
Meta Configuration
Meta Configuration
Meta Configuration Settings
Meta Base Schema
TLS Settings
Creating SSL Certificates
Creating Server Sertificate
Requesting Server Certificate
Creating Client Certificates
Revoking a Certificate or Renewing CRL
Exporting CA Certificate
Issuing a Certificate in Active Directory CA
Remote Configuration
Advanced ISP Billing Integration
DTH Billing Integration
Platypus Billing System Intergration
OnDO SIP Server Integration
How Do I...
Wi-Fi Security
Wireless Authentication
Wi-Fi and RADIUS
Supported EAP Authentication Types
Security Considerations
10 Tips for Wireless Network Security
Administering the Server
Debug Logs
Using Client Tool
List of Server Errors
Maintaining RADIUS Dictionary
Basic Concepts
Wireless Authentication
Authentication Protocols
RADIUS Attributes
Example of RADIUS Packet Transactions
List of Standard RADIUS Attributes
Technical Support
Purchasing Licenses

ClearBox Enterprise Server 2.0 Online Manual
Prev Page Next Page
ClearBox Enterprise Serverâ„¢ 2.0. User's Guide

Advanced ISP Billing Integration

Here you find the instructions on how to setup ClearBox Server properly so to integrate it with the Advanced ISP Billing system for Windows. ClearBox Server is tested with MS SQL Server installation only.


Once the service has been installed, read and follow the instructions below for integrating ClearBox with the Advanced ISP Billing. Instructions for configuring ClearBox are below. If problems still exist, see ClearBox's manual for more information.

ODBC Configuration (DSN)

For ClearBox to connect to the ISP Billing an ODBC DSN (Data Source Name) is used. It is recommended that if this has not already been done, these drivers must be updated with the most current versions available. These updated drivers can be found at Microsoft, where the most current drivers are released in the MDAC (Microsoft Data Access Components) executable. Go to the link below for downloading or more information on MDAC.

Once MDAC has been updated, a DSN can be created. This is done from the Windows Control Panel, under the icon for ODBC Data Sources.

Once the Data Sources window has been opened...

1. Click on the System DSN tab. If 'ispbilling' name is already there, no further DSN installation is necessary.

2. Click "Add".
Choose the SQL Server or SQL Server(32-bit) driver
Click "Finished"

3. Enter a name for the DSN (ex. 'ispbilling')
The description field is not required
Enter the IP address or name of the SQL Server
Click "Next"

4. Select "With SQL Server Authentication"
Enter the ispbilling login and password
Click the "Client Configuration" button
Choose TCP/IP for the network protocol
Make sure the port # is 1433
Click "OK"
Press Next.

5. Check the "change default database to" checkbox
Verify that the ispbilling database is listed as the default database.

6. To finish creating this DSN...
Press Next. Press Finish. Press OK.
Press OK again to exit the ODBC Control Panel.

ClearBox Configuration

Now that a data source has been created, ClearBox needs to be configured to use this data source and the proper configuration file.

1. Make a backup copy of config.xml (full path is <server installation folder>\AAA\config.xml). Name it 'config_copy.xml', for instance.

2. Run Configurator, which is found in the Start menu under ClearBox RADIUS Server, and open 'advanced_isp_billing_config.xml' file. Then save it as 'config.xml', replacing the old one.

3. Once the configuration window is open, select "aib" under the Data Sources group. Make sure that DSN name matches one you have configured.

If they don't, choose the data source that was created in the last section. Next, enter the database owner login and password into the User name and Password fields. This should be the same User name and Password that was used in the SQL Server Script section.

Next, click "Test Connection" to make sure that ClearBox can connect to the Advanced ISP Billing database. If that test is successful, click "Apply Changes" and close the application to save the configuration.

That's it for the change to ClearBox. All that needs to be done now is to restart the "ClearBox Enterprise Radius Server" service, which is found in the Windows Control Panel under Services.

For More Information

Be sure to check out the ClearBox documentation or the Advanced ISP Billing help file for more information or any added features which are not covered in this document, or how the radius server works or is configured. Also, remember that if you are having problems with the setup or need a more detailed explanation, write at You can also contact ClearBox support by email at:

© 2001-2007 XPerience Technologies.
Converted from CHM to HTML with chm2web Pro 2.7 (unicode)