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
    12. Other Functions
    13. Third-Party Database
      1. 1. Create Database - MySQL
      2. 2. Create the Registered Table - MySQL
      3. 3. Create the Users Table - MySQL
      4. 4. Create the Alias Table - MySQL
      5. 5. Create the Phone Book Table - MySQL
      6. BSS settings for Third-Party DB
    14. Environment Variables
  5. Troubleshooting
  6. Developer's Guide
  7. Version History

Third-Party Database

This section describes steps needed to use a third party database instead of using the embedded database in Brekeke SIP Server. You can add or modify the database from your own database management tool.

Brekeke SIP Server uses the following database tables.

Table Name Purpose
t_registered Registered Table
This table stores the data of registered user agents. The data will be updated by REGISTER requests and used for the session routing.
t_userdir Users Table
This table stores authentication data of users.
t_alias Alias Table
This table stores alias data.
Note: Alias Database is available in Advanced Edition only.
t_contact

t_contact_tel

 Phone Book Tables

Those tables store phone book data.
t_blocked_ip

t_blocked_user

 Block Tables

Those tables store blocked node/user data.

*Those tables will be created automatically when the third-pary database is enabled on BSS on settings.
t_pn_device Push Notification Table

* “Push Notification” license option is needed to use PN features.

Push Notification >>

*The tables will be created automatically when the third-pary database is enabled on BSS settings.

 

To view a topic of your interest, please click on the topics listed in the left column.

Note: The following sections are using MySQL as an example but other databases can be used in a similar way.

 

Step 1. Create Tables on Third-Party Database

1. Create Database

2. Create the Registered Table

3. Create the Users Table

4. Create the Alias Table

5. Create the Phone Book Tables

 

Step 2. Brekeke SIP Server settings for Third-Party Database

BSS settings for Third-Party DB

 

Yes No
« Get free certificates from "Let's Encrypt"1. Create Database - MySQL »
Suggest Edit