Call detailed records (CDR) Settings
This page shows the explanation of new CDR feature from Brekeke SIP Server / Brekeke PBX version 3.8 and later.
With this new CDR, call records can be written into a database or files without any additional programming or products, and it offers customizable records fields to easily work with any billing systems.
Step 1 . Turn on CDR feature
Move to the [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 default, CDR data is output into files.
<Case1 : Output type = File>
Step 3. Enter the Output Path
Move to Step 6. >>
<Case2: Output type = Database>
Step 3. Install JDBC Driver
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 database.
User Name/Password : Enter the user name and password that BSS/Brekeke PBX can connect to database with.
Here are examples of Database Driver and URL.
Driver = com.mysql.jdbc.Driver URL = jdbc:mysql://127.0.0.1:3306/dbname
Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver URL = jdbc:sqlserver://192.168.10.15
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 is automatically created.
If you would like to create a table with this statement, click “Create table” button.
If you customize the create statement and create table manually, click “Back” button after copy the statement.
Step 6. Restart BSS/Brekeke PBX
CDR feature runs after restart BSS 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.