Brekeke Documents

Find user guides, developer guides, API references, tutorials, and more!

Brekeke SIP Server Wiki

  1. Brekeke SIP Server Basic Info
  2. Security
  3. Update & Upgrade
  4. Configuration
    1. Installation
    2. Basic Setup
    3. BSS Administration Tool
    4. Network Configuration
    5. Dial Plan
    6. Block List
    7. Provisioning
    8. Push Notification
    9. SDN
    10. STIR/SHAKEN
    11. Advanced Edition
      1. Alias function
      2. Call detailed records (CDR)
        1. Variables for CDR
      3. Failover
      4. Load balancing by BSS
      5. RADIUS
      6. TLS
      7. SRTP Conversion
      8. Redundancy
      9. Brekeke Heartbeat Remote Access Setup
      10. Brekeke SIP Server Failure Notification
      11. Heavy loads alert with Brekeke Heartbeat
      12. Monitoring SIP Devices with Heartbeat
    12. Other Functions
    13. Third-Party Database
    14. Environment Variables
  5. Troubleshooting
  6. Developer's Guide
  7. Version History

Call detailed records (CDR) Settings

With CDR function (Call detailed records) function, call records can be written into a database or files without any additional programming or products. For easier integration with a billing system, it offers customizable records fields. CDR function is available for the version 3.8 or later on both Brekeke SIP Server and Brekeke PBX.

 

Quick Start
Step 1 . Turn on CDR

Open product admintool > [SIP Server] > [CDR] > [Settings] page. Check the “On” radio button of the [On/Off] field at [General] section.

 

Step 2.  Select output type

Select “File” or “Database” at [Output type]. As a default, CDR data is set to output into files.

<Case1 : Output type = File>
Step 3. Enter the Output Path
At [File Setting] section, under the [Output Path] field, enter the path where the CDR output files will be stored. As default “log/cdr” is set here, and Brekeke SIP Server outputs the CDR data into the following directory.
   Brekeke SIP Server:
     <YOUR_INSTALL_DIRECTORY>/webapps/sip/WEB-INF/work/sv/log/cdr
   Brekeke PBX:
    <YOUR_INSTALL_DIRECTORY>/webapps/pbx/WEB-INF/work/sv/log/cdr
 Move to Step 6. >>

 

<Case2: Output type = Database>
Step 3. Install JDBC Driver
Download JDBC driver for your database from a DB vendor’s web site, and put it under the following directory.
    Brekeke SIP Server:
     <YOUR_INSTALL_DIRECTORY>/webapps/sip/WEB-INF/lib
   Brekeke PBX:
     <YOUR_INSTALL_DIRECTORY>/webapps/pbx/WEB-INF/lib

 

Step 4. Database settings

Table Name: Enter the table name that CDR data will be stored.
Database Driver: Enter the name of database driver.
Database URL: Enter the URL of the database.
User Name/Password: Enter the user name and password that Brekeke SIP Server/Brekeke PBX can connect to the database with.

Here are examples of Database Driver and URL.

<MySQL>
Driver = com.mysql.jdbc.Driver
URL = jdbc:mysql://127.0.0.1:3306/dbname
<SQL Server>
Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
URL = jdbc:sqlserver://192.168.10.15
<Oracle>
Driver = oracle.jdbc.OracleDriver
URL = jdbc:oracle:thin:@//192.168.50.11
Step 5. Initialize a table

Click “Initialize a table” and move on to the “Initialize a table” page. Based on the “CDR Format” in the Settings page, a Create Statement (image below) is automatically created.

To create a table with this statement, click “Create table” button.  To customize the create statement and create table manually, click “Back” button after copy the statement.

 

Step 6. Restart Brekeke SIP Server/Brekeke PBX

CDR feature runs after restart Brekeke SIP Server or Brekeke PBX. The status can be shown at [SIP SERVER] > [CDR] > [Status] page.

 

How to customize CDR format?

You can customize CDR format by editing  varialbels at the [CDR Format] field.

For the list of CDR variables, refer to the “Variable for CDR” page.

 

Yes No
« Create a DialPlan RuleVariables for CDR »
Suggest Edit