Forums Read-only archive

Beginner 3rd party database setup

8 posts · Brekeke SIP Server Forum

achooi Original post
1. Brekeke Product Name and version: Brekeke SIP Server , Version 2.3.8.2 Standard

2. Java version: 1.5.0 (build 1.5.0_07-b03)

3. OS type and the version: Windows Server 2003 Ent. Edition. SP2

4. UA (phone), gateway or other hardware/software involved: pap2

5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/ ... terns.html : Pattern 4

6. Your problem:
I installed mysql 5.1 and followed the instructions from the "3rd party database" tutorial every single step. But now i'm getting an error that the database cannot open when I restart the BSS. There's no other databases on this server.

Here is the configuration I have on it:

Port number: 13306
On/off: On
Registered Database URL: jdbc:mysql://127.0.0.1/serverdb
Registered Database driver: mysql-connector-java-5.1.10-bin.jar
Username: blank
Password: ******

========================
Here is the log:

2009-11-06 17:36:57,281 [http-18080-Processor22] ERROR (?:?) -
com.brekeke.net.sip.sv.registrar.RegisteredDBCanNotOpenException: JDBC Driver load error .mysql-connector-java-5.1.10-bin.jar; prop={user=sa, password=*****, url=jdbc:mysql://localhost/serverdb, enabled=on, driver=mysql-connector-java-5.1.10-bin.jar, class=com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB}
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.getConnection(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.initConnection(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.open(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.<init>(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.initDatabase(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.startServer(Unknown Source)
at com.brekeke.sipadmin.web.ServerInvoker.exec(Unknown Source)
at com.brekeke.web.Bean.execMain(Unknown Source)
at com.brekeke.web.Bean.execute(Unknown Source)
at com.brekeke.web.Bean.go(Unknown Source)
at com.brekeke.web.Bean.startBean(Unknown Source)
at com.brekeke.web.GateServlet.performTask(Unknown Source)
at com.brekeke.web.GateServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
hope
Registered Database driver: mysql-connector-java-5.1.10-bin.jar
it is com.mysql.jdbc.Driver?
copy mysql-connector-java-5.1.10-bin.jar to WEB-INF/lib/
and restart db and bss service
voipunud
hope wrote:
Registered Database driver: mysql-connector-java-5.1.10-bin.jar
it is com.mysql.jdbc.Driver?
copy mysql-connector-java-5.1.10-bin.jar to WEB-INF/lib/
and restart db and bss service

can you give me example what i should fill in registered URL, registered Driver and user URl, user driver?i have download mysql-connector-java-5.1.10-bin.jar to WEB-INF/lib/ and i confuse what i should fill in that field when tru to connect brekeke with mysql.
hope
there is settings sample at
http://www.brekeke-sip.com/download/bss ... ase_en.pdf
Page 8-9
voipunud
hope wrote:there is settings sample at
http://www.brekeke-sip.com/download/bss ... ase_en.pdf
Page 8-9
i already follow those step. that make me confuse is what is registered database URL?
registered driver URL?
users database URL?
users database driver?
port embedded?

because i already use mysql connector-5.11.bin.jar and copy the mysql connector to WEB-INF/lib and fill the field. i have an error 'Cant open the Registered-DB. i use java jre 6-15 and fedora 11
hope
here is wiki post about database error:
http://wiki.brekeke.com/wiki/Error--Can ... n-database

In brekeke 3rd party DB tutorial, DB named "serverdb" is created on the same pc with brekeke SIP Server, and create tables under the same DB "serverdb", so Database URL is all like jdbc:mysql://localhost/serverdb

Embedded Database/port number: port Brekeke SIP Server used to connect to the database. If nothing set at this field. default port 9001 will be used.

Thirdparty Registered Database:
put data of registered users into table "t_registered" under DB at registered database URL
Thirdparty Users Database:
put data under sipserver/ User Authentication to table "t_userdir" under DB to the place at users database URL

registered database URL/users database URL:
where is DB and the name of DB, set as jdbc:mysql://<DB_IP>/<DB_name>

if tables "t_registered" and "t_userdir" are created at different pc or under different DB name, then the setting for registered database URL/users database URL will be different.

Database Driver: if other kind of DB than mysql is used, the driver will be different. For MySQL DB, it is com.mysql.jdbc.Driver
voipunud
hope wrote:here is wiki post about database error:
http://wiki.brekeke.com/wiki/Error--Can ... n-database

In brekeke 3rd party DB tutorial, DB named "serverdb" is created on the same pc with brekeke SIP Server, and create tables under the same DB "serverdb", so Database URL is all like jdbc:mysql://localhost/serverdb

Embedded Database/port number: port Brekeke SIP Server used to connect to the database. If nothing set at this field. default port 9001 will be used.

Thirdparty Registered Database:
put data of registered users into table "t_registered" under DB at registered database URL
Thirdparty Users Database:
put data under sipserver/ User Authentication to table "t_userdir" under DB to the place at users database URL

registered database URL/users database URL:
where is DB and the name of DB, set as jdbc:mysql://<DB_IP>/<DB_name>

if tables "t_registered" and "t_userdir" are created at different pc or under different DB name, then the setting for registered database URL/users database URL will be different.

Database Driver: if other kind of DB than mysql is used, the driver will be different. For MySQL DB, it is com.mysql.jdbc.Driver

thanks for your replay. It's done know..i already connect my brekeke sip server with mysql in same PC. But know i'm trying to connect with another pc. in this case mean my brekeke server separated with mysql server.
i have tried use the same way to configure the configuration but i have change the localhost with ip where my mysql server location. but it doesn't work. maybe you can share with me?

thanks
hope
is there any firewall at mysql server?
and maybe the following link can help you
http://forums.techguy.org/software-deve ... ccess.html
http://www.cyberciti.biz/tips/how-do-i- ... erver.html

if not work, you'd better check the error message shown in the
log.log file under webapps\proxy\WEB-INF\work\logs\