Author |
Message |
xuanmy92 Brekeke Newbie
Joined: 30 Jun 2014 Posts: 3
|
Posted: Mon Jun 30, 2014 11:23 am Post subject: Can not open database: BSS v3 with MySQL |
|
|
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 |
|
davi Brekeke Addict
Joined: 26 Jan 2011 Posts: 34
|
Posted: Mon Jun 30, 2014 10:37 pm Post subject: |
|
|
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 |
|
xuanmy92 Brekeke Newbie
Joined: 30 Jun 2014 Posts: 3
|
Posted: Wed Jul 02, 2014 7:51 am Post subject: |
|
|
I have connected BSS with MySQL. All things were corrected. One needed thing is to reboot the machine.
Thank you again. |
|
Back to top |
|
davi Brekeke Addict
Joined: 26 Jan 2011 Posts: 34
|
Posted: Wed Jul 02, 2014 10:09 am Post subject: |
|
|
Glad to know!
To apply new JAR file, you need to reboot the OS. |
|
Back to top |
|
|