Can''t connect to a MS SQL

Openfire Openfire Support
1

Can’'t connect to a MS SQL db A connection to the database could not be

made. View the error message by opening the

“[jiveHome]\logs\jive.error.log” log file, then go back to fix the problem. 2006.08.25 15:58:19

[org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:85) at

org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvi der.java:83) at

org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:441)

at

org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._jsp Service(setup_002ddatasource_002dstandard_jsp.java:194) at

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at

javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at

org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:830)

at

com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118 ) at

com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi lter.java:41) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.j ava:471) at

org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at

org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at

org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.jav a:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at

org.mortbay.http.HttpServer.service(HttpServer.java:909) at

org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at

org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982) at

org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at

org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at

org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at

org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Caused by:

java.net.UnknownHostException: at

java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at

java.net.Socket.connect(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

net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:28 9)

at net.sourceforge.jtds.jdbc.SharedSocket.(ConnectionPool.java:85) at

org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvi der.java:83) at

org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:441)

at

org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._jsp Service(setup_002ddatasource_002dstandard_jsp.java:194) at

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at

javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at

org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:830)

at

com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118 ) at

com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi lter.java:41) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.j ava:471) at

org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at

org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at

org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.jav a:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at

org.mortbay.http.HttpServer.service(HttpServer.java:909) at

org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at

org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982) at

org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at

org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at

org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at

org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Caused by:

java.net.UnknownHostException: at

java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at

java.net.Socket.connect(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

net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:28 9)

at net.sourceforge.jtds.jdbc.SharedSocket.(ConnectionPool.java:85) at

org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvi der.java:83) at

org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:441)

at

org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._jsp Service(setup_002ddatasource_002dstandard_jsp.java:194) at

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at

javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at

org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:830)

at

com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118 ) at

com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi lter.java:41) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.j ava:471) at

org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at

org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at

org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.jav a:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at

org.mortbay.http.HttpServer.service(HttpServer.java:909) at

org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at

org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982) at

org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at

org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at

org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at

org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Caused by:

java.net.UnknownHostException: at

java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at

java.net.Socket.connect(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

net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:28 9)

at net.sourceforge.jtds.jdbc.SharedSocket.(ConnectionJDBC2.java:297) … 36 more 2006.08.25 15:58:49

org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvi der.java:88)

java.io.IOException at

org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:120) at

org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProvi der.java:83) at

org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:441)

at

org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._jsp Service(setup_002ddatasource_002dstandard_jsp.java:194) at

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at

javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at

org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:830)

at

com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118 ) at

com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi lter.java:41) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.j ava:471) at

org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at

org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at

org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.jav a:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at

org.mortbay.http.HttpServer.service(HttpServer.java:909) at

org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at

org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982) at

org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at

org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at

org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at

org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 2006.08.25 15:58:49

[org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:68)

] Warning: DbConnectionDefaultPool.getConnection() was called before

the internal pool has been initialized. 2006.08.25 15:58:49

[org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:452)

] java.lang.NullPointerException at

org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.ja va:626) at

org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:446)

at

org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._jsp Service(setup_002ddatasource_002dstandard_jsp.java:194) at

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at

javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at

org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:830)

at

com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118 ) at

com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFi lter.java:41) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821)

at

org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98) at

org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicat ionHandler.java:821) at

org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.j ava:471) at

org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at

org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at

org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.jav a:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at

org.mortbay.http.HttpServer.service(HttpServer.java:909) at

org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at

org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982) at

org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at

org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at

org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at

org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 2006.08.25 15:58:49

[org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:68)

] Warning: DbConnectionDefaultPool.getConnection() was called before

the internal pool has been initialized. 2006.08.25 15:58:49

[org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:92)

] WARNING: ConnectionManager.getConnection() failed to obtain a

connection.

2

Hi,

can your server resolve “w-mum-asdbld-05”? I assume it can’'t, so we see this error: “Unknown server host name ‘‘w-mum-asdbld-05’’. at …”

LG

3

Thanks, I got the Solution. Port 1433 ws blocked by the administrator. Fr those facing similar problem:

Try

Telnet 1433

if it doesnt wrk, u need to disable firewall client if SQL server is on your test machine or enable port 1433 in SQL DB properties window using enterprise manager(Named pipes wont work)

I was trying to use microsoft jdbc drivers but ive heard they run slower than the default wildfire drivers given on sourceforge.net