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.

Installation

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.

http://www.microsoft.com/data

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 support@advancedispbilling.com. You can also contact ClearBox support by email at: support@xperiencetech.com.