Author |
Message |
achooi Brekeke Member
![](images/spacer.gif)
Joined: 17 Aug 2009 Posts: 21
|
Posted: Fri Nov 06, 2009 6:43 pm Post subject: Beginner 3rd party database setup |
|
|
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 (? ) -
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) |
|
Back to top |
|
hope Brekeke Master Guru
![](images/spacer.gif)
Joined: 15 Jan 2008 Posts: 862
|
Posted: Mon Nov 09, 2009 10:32 am Post subject: |
|
|
Quote: |
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 |
|
Back to top |
|
voipunud Brekeke Member
![](images/spacer.gif)
Joined: 02 Sep 2009 Posts: 14
Location: indonesia
|
Posted: Mon Feb 08, 2010 9:55 pm Post subject: need help |
|
|
hope wrote: |
Quote: |
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. |
|
Back to top |
|
hope Brekeke Master Guru
![](images/spacer.gif)
Joined: 15 Jan 2008 Posts: 862
|
|
Back to top |
|
voipunud Brekeke Member
![](images/spacer.gif)
Joined: 02 Sep 2009 Posts: 14
Location: indonesia
|
Posted: Tue Feb 09, 2010 8:07 pm Post subject: |
|
|
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 |
|
Back to top |
|
hope Brekeke Master Guru
![](images/spacer.gif)
Joined: 15 Jan 2008 Posts: 862
|
Posted: Wed Feb 10, 2010 11:24 am Post subject: |
|
|
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 |
|
Back to top |
|
voipunud Brekeke Member
![](images/spacer.gif)
Joined: 02 Sep 2009 Posts: 14
Location: indonesia
|
Posted: Thu Feb 11, 2010 10:32 pm Post subject: |
|
|
hope wrote: |
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 |
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 |
|
Back to top |
|
hope Brekeke Master Guru
![](images/spacer.gif)
Joined: 15 Jan 2008 Posts: 862
|
|
Back to top |
|
|