powered by Jive Software

Help installing 3.3.2 with SQL 2005

I’‘ve installed Wildfire many many times before, and all of my installations are using SQL 2005. This is my first time installing “Openfire” and for some reason I am not able to get it working. I’‘ve created the database with a user, ran the query, and verified that SQL is working (it’'s also being used for Dell IT Assistant and ARCserve). No matter what i try, i get the same exact thing in the error log, which looks like this:

2007.07.02 10:44:51

[

|org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:68)]Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.

2007.07.02 10:44:51

[

|org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:470)]

java.lang.NullPointerException

at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.j ava:649)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:464)

at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:202)

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

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

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1074)

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

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1065)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1065)

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

at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:185)

at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:689)

at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:391)

at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollect ion.java:146)

at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)

at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)

at org.mortbay.jetty.Server.handle(Server.java:285)

at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:457)

at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:765 )

at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:627)

at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)

at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:357)

at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:329)

at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)

2007.07.02 10:44:51

[

|org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:68)]Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.

2007.07.02 10:44:51

[

|org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:95)]WARNING: ConnectionManager.getConnection() failed to obtain a connection.

FWIW, Windows Firewall is OFF and SQL server is installed as the (default) instance

My openfire.xml looks like this:

If anyone has any suggestions i would love to hear them…this is EXTREMELY frustrating

Thanks

Nevermind guys, i’‘m a dumbass. I didn’‘t have TCP/IP enabled for SQL, i just didn’'t think to check it since everything else (WSUS, arcserve) was working fine.