Brekeke SIP Server Wiki

BSS settings for Third-Party Database

1. Install the JDBC driver

Please download the latest JDBC driver for MySQL “MySQL Connector/J” from the link below.

https://www.mysql.com/products/connector/

Copy the file named “mysql-connector-java-3.0.XX-ga-bin.jar” into the following directory.

YOUR_INSTALL_DIRECTORY\webapps\sip\WEB-INF\lib

 

Note: If you are using the bundled SIP Server for Brekeke PBX, please use the following directory instead.

YOUR_INSTALL_DIRECTORY\webapps\pbx\WEB-INF\lib

 

 

2. Settings at Brekeke SIP Server

Login to the Admintool and go to [Configuration] > [Database/Radius] page.

At the [Database/Radius] page, you can set third party databases. (fig.1)

After you change settings, press [Save] button and restart the server machine.

fig.1 [Database/Radius] page

 

Thirdparty Registered Database
Field Name Explanation
On/Off Select “on” to enable a Third-Party Registered Database
Registered Database URL URL for the Registered Database

(e.g. jdbc:mysql://localhost/serverdb)

Registered Database Driver JDBC Driver for the Registered Database

(e.g. com.mysql.jdbc.Driver)

User Name User name for the Registered Database
Password Password for the Registered Database

Before you configure the above settings, the Registered table needs to be created.

 

Thirdparty Users Database
Field Name Explanation
On/Off Select “on” to enable a Third-Party Users Database
Encrypt Users Passwords Select “false” to record users’ passwords in plain text
Users Database URL URL for the Users Database

(e.g. jdbc:mysql://localhost/serverdb)

Users Database Driver JDBC Driver for the Users Database

(e.g. com.mysql.jdbc.Driver)

User Name User name for the Users Database
Password Password for the Users Database

Before you configure the above settings, the Users table needs to be created.

 

Thirdparty Alias Database
Field Name Explanation
On/Off Select “on” to enable a Third-Party Alias Database
Alias Database URL URL for the Alias Database

(e.g. jdbc:mysql://localhost/serverdb)

Alias Database Driver JDBC Driver for the Alias Database

(e.g. com.mysql.jdbc.Driver)

User Name User name for the Alias Database
Password Password for the Alias Database

Before you configure the above settings, the Alias table needs to be created.

 

Thirdparty Block Database
Field Name Explanation
On/Off Select “on” to enable a Third-Party Database for Block list.
Block Database URL URL for the Block Database

(e.g. jdbc:mysql://localhost/serverdb)

Block Database Driver JDBC Driver for the Block Database

(e.g. com.mysql.jdbc.Driver)

User Name User name for the Alias Database
Password Password for the Alias Database
Queue Size The size of the queue for writing to the Block Database

 

Thirdparty Push Notification (PN) Database (v3.4 or later)
Field Name Explanation
On/Off Select “on” to enable a Third-Party Push Notification Database
Push Notification Database URL URL for the Push Notification Database

(e.g. jdbc:mysql://localhost/serverdb)

Push Notification Database Driver JDBC Driver for the Push Notification Database

(e.g. com.mysql.jdbc.Driver)

User Name User name for the Push Notification Database
Password Password for the Push Notification Database

 

Thirdparty Phone book Database
Field Name Explanation
On/Off Select “on” to enable a Third-Party Phone book Database
Phone book Database URL URL for the Phone book Database

(e.g. jdbc:mysql://localhost/serverdb)

Phone book Database Driver JDBC Driver for the Phone book Database

(e.g. com.mysql.jdbc.Driver)

User Name User name for the Phone book Database
Password Password for the Phone book Database

 

 

Troubleshooting:

If you receive the error message “Can not open a database” at the Brekeke SIP Server’s Admintool after you setup third-party database, refer to the following troubleshooting page:

Error “Cannot open database” >>

 

 

Yes No
Suggest Edit