Beginner 3rd party database setup

achooi · Brekeke Member Joined: 17 Aug 2009 Posts: 21

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/networkpatterns.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 (? Confused

) -
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 · Brekeke Master Guru Joined: 15 Jan 2008 Posts: 862

voipunud · Posted: Mon Feb 08, 2010 9:55 pm Post subject: need help

hope · Brekeke Master Guru Joined: 15 Jan 2008 Posts: 862

there is settings sample at
http://www.brekeke-sip.com/download/bss/v2_x/3rd_party_database_en.pdf
Page 8-9

voipunud · Posted: Tue Feb 09, 2010 8:07 pm Post subject:

hope · Brekeke Master Guru Joined: 15 Jan 2008 Posts: 862

here is wiki post about database error:
http://wiki.brekeke.com/wiki/Error--Can-not-open-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 · Posted: Thu Feb 11, 2010 10:32 pm Post subject:

hope · Brekeke Master Guru Joined: 15 Jan 2008 Posts: 862

is there any firewall at mysql server?
and maybe the following link can help you
http://forums.techguy.org/software-development/623379-solved-how-enable-remote-access.html
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

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