Can not open database: BSS v3 with MySQL

Discuss any topic about Brekeke SIP Server.

Moderator: Brekeke Support Team

Post Reply
xuanmy92
Posts: 3
Joined: Mon Jun 30, 2014 10:47 am

Can not open database: BSS v3 with MySQL

Post by xuanmy92 »

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
Posts: 34
Joined: Wed Jan 26, 2011 4:34 pm

Post by 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
Posts: 3
Joined: Mon Jun 30, 2014 10:47 am

Post by xuanmy92 »

I have connected BSS with MySQL. All things were corrected. One needed thing is to reboot the machine.
Thank you again. :)
davi
Posts: 34
Joined: Wed Jan 26, 2011 4:34 pm

Post by davi »

Glad to know!

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