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
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
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
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
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
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
5. Check the "change default database to" checkbox
Verify that the ispbilling database is listed as the default
6. To finish creating this DSN...
Press Next. Press Finish. Press OK.
Press OK again to exit the ODBC Control Panel.
Now that a data source has been created, ClearBox needs to be
configured to use this data source and the proper configuration
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
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
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
You can also contact ClearBox support by email at: firstname.lastname@example.org.
© 2001-2007 XPerience Technologies. www.xperiencetech.com