Brekeke Forum Index » Brekeke SIP Server Forum

Post new topic   Reply to topic
Can not open database: BSS v3 with MySQL
Author Message
xuanmy92
Brekeke Newbie


Joined: 30 Jun 2014
Posts: 3

PostPosted: Mon Jun 30, 2014 11:23 am    Post subject: Can not open database: BSS v3 with MySQL Reply with quote

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.
Back to top
View user's profile
davi
Brekeke Addict


Joined: 26 Jan 2011
Posts: 34

PostPosted: Mon Jun 30, 2014 10:37 pm    Post subject: Reply with quote

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
Back to top
View user's profile
xuanmy92
Brekeke Newbie


Joined: 30 Jun 2014
Posts: 3

PostPosted: Wed Jul 02, 2014 7:51 am    Post subject: Reply with quote

I have connected BSS with MySQL. All things were corrected. One needed thing is to reboot the machine.
Thank you again. Smile
Back to top
View user's profile
davi
Brekeke Addict


Joined: 26 Jan 2011
Posts: 34

PostPosted: Wed Jul 02, 2014 10:09 am    Post subject: Reply with quote

Glad to know!

To apply new JAR file, you need to reboot the OS.
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    Brekeke Forum Index » Brekeke SIP Server Forum All times are GMT - 7 Hours
Page 1 of 1