External CDR Interface

Feature Description

The UCx External CDR Interface application was developed to give a simple method of allowing read only access to CDR records from a remote server. This allows the user to access the data with a standard MySQL client or third party application to access the data directly for their specific purposes.The External CDR Interface application has the following attributes:

  • Configuration is done through the UCx web interface 
  • A user name and password can be configured with remote read only access privileges to the CDR records
  • Remote access can be enabled and disabled
This functionality is not supported on the Galaxy Mini hardware platform.

 

Pre-Requisites

  1. UCx server is installed with the latest E-Metrotel software.
  2. An updated license to include the UCx External CDR Interface software.
  3. An external MySQL client or third party application to access data.

Back Up MySQL Database

The MySQL database should be backed up when installing, upgrading or uninstalling the External CDR Interface feature.

Go to Backup page for details on how to create a backup.

From the Perform a Backup panel:

  1. Select the MySQL Database checkbox
  2. Press the Process button to create the backup

Install License String

Go to Licenses page for details on how to:

  • Obtain a new license for the External CDR interface
  • Enter the updated license. 

Install Software Package

First you will need to have the latest UCx software. Go to Software Update page in the Administration Guide for details on updating your software.

Next you need to install the ucx-eci package. Go to Packages page in the Administration Guide for details on installing packages.

From the Packages panel:

  1. Select the Show Filter tab and enter ucx-eci for the Name, enter All for the Status
  2. Click the Install link under the Status column to install the package

Enable External Access

To access the External CDR Interface configuration page, perform the following steps:

  1. Open the UCx Web-based Configuration Utility
  2. From the System tab, select Accessories
  3. From the left side column, select External CDR Interface
  4. In the External Access field, select Enabled from the drop-down list
  5. Enter a user name in the User ID field
  6. Enter a password in the Password field
  7. Press the Save button

SystemAccessoriesExternalCDREnabled.png

Disable External Access

To disable external access to CDR records, follow the steps in the previous section to access the External CDR Interface configuration page.

From the External CDR Interface page:

  1. In the External Access field, select Disabled from the drop-down list
  2. Press the Save button

SystemAccessoriesExternalCDRDisabled.png

Testing the Interface

The following steps describe a simple method to test the External CDR Interface application: 

  1. Complete the setup and configuration as described on this page, making sure that External Access is Enabled
  2. Download and install a MySQL Client application (e.g. Heidi SQL).
  3. Launch the MySQL Client application, create a session that connects to the UCx Server. Enter the IP address of the UCx Server and the External CDR interface account that was created.
    If the client is located outside of the firewall where the UCx resides, the firewall is required to be configured to allow inbound TCP packets on the Port configured in the above dialog box (i.e. TCP port 3306 by default).

       

  4. Open the session and you should see two database schema files: information_schema and asteriskcdrdb.
  5. Expand the schemas to see the data as desired.
Page Tags: 
cdr
external interface