Forums Read-only archive

Can not open database: BSS v3 with MySQL

4 posts · Brekeke SIP Server Forum

xuanmy92 Original post
1. Brekeke Product Name and Version:
Brekeke Sip Server - Evaluation Edition - v3.3.4.4

2. Java version: jre7

3. OS type and the version: Window 7

4. UA (phone), gateway or other hardware/software involved: X-lite

5. Your problem:
Currently, I have a advanced edition BSS V3.3.4.4 and I would like to migrate the database to MySQL. But I would like to check with evaluation edition before doing migration on advanced edition (because advanced edition one is operating, I can not stop it for checking).
But I am facing the error "Can not open database" when using Evaluation edition BSS with MySQL. I referred and followed the document :http://www.brekeke.com/doc/sip/3rd_party_database.pdf

So, my questions:
1. Do Evaluation edition BSS support for using third-party database (such as MySQL)?
2. How can we use BSS v3 with MySQL? I could not find the document for using third-party database for BSS v3. I saw the document: http://www.brekeke.com/doc/sip/3rd_party_database.pdf was written for BSS v2. It is too old (from 2009), some things are changed (e.g. MySQL, JDBC driver for MySQL).

Thank you in advance.
davi
The database structures are same in both v2 and v3.
So you can refer the above PDF.


For using MySQL.. have you copied MySQL's JDBC driver like the following?
mysql-connector-java-5.1.31-bin.jar

You need to download it from the MySQL's site.
https://dev.mysql.com/downloads/connector/j/5.1.html

And install it into
YOUR_INSTALL_DIRECTORY/webapps/sip/WEB-INF/lib
xuanmy92
I have connected BSS with MySQL. All things were corrected. One needed thing is to reboot the machine.
Thank you again. :)
davi
Glad to know!

To apply new JAR file, you need to reboot the OS.