ezzadin
Brekeke Junior Member
Joined: 25 May 2011
Posts: 8
|
 Posted: Thu Apr 25, 2013 6:34 pm Post subject: JDBC issue - MS SQL 2005 |
 |
|
1. Brekeke Product Name and Version: Brekeke SIP server Version 3.1.7.8 Standard 3.1.7.8/348.2
2. Java version:1.7.0_17 64BIT
3. OS type and the version:Windows Server 2008 R2
4. UA (phone), gateway or other hardware/software involved: n/a
5. Your problem:
Hi All,
I cannot make MS SQL 2005 to work with Brekeke SIP Server.
I have created a database called "Brekeke" on SQL 2005 and downloaded Microsoft JDBC Driver 4.0 for SQL Server.
I have copied sqljdbc.jar and sqljdbc4.jar to:
D:\Program Files\Brekeke\sip\webapps\sip\WEB-INF\lib
and
D:\Program Files\Brekeke\sip\lib
Under "Configuration"--> "Database/Radius" I set Thirdparty Users Database to:
ON
Users Database URL: jdbc:sqlserver://192.168.1.198:1433;DatabaseName=Brekeke
User Database Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
User: sa
pass: mysaPassword
I have rebooted the server after the change and when I start SIP server I get the following error:
Can not open the registered-DB. Check entries under Configuration | Database, then try restarting SIP Server.
And I get the following error in the logs:
| Code: |
com.brekeke.net.usrdir.UserDirException: Connection error jdbc:sqlserver://192.168.1.198:1433;DatabaseName=Brekeke
at com.brekeke.sipadmin.plugins.SqlUserDir.newConnection(Unknown Source)
at com.brekeke.sipadmin.plugins.SqlUserDir.initConnection(Unknown Source)
at com.brekeke.sipadmin.plugins.SqlUserDir.open(Unknown Source)
at com.brekeke.sipadmin.plugins.SqlUserDir.<init>(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.initDatabase(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.initApp(Unknown Source)
at com.brekeke.sipadmin.web.Initializer.initialize(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.brekeke.web.GateServlet.init(Unknown Source)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
2013-04-25 20:30:39,774 [http-18080-1] ERROR (?:?) -
|
- Firewall is off on both servers (Brekeke and MS SQL).
- Telnet 192.168.1.198 1433 works.
- Table t_userdir created in Brekeke database under MS SQL.
- I have tried to use different User Drivers: com.microsoft.jdbc.sqlserver.SQLServerDriver
- port 1433 is not being used.
- JDBC is not being used by any other software.
- Using Java 64bit
Can someone please help me with this?
Thanks. |
|
