I am installing Wildfire 2.5 on Windows Server 2003 Standard Edition but i am getting following error while setting up database…
A connection to the database could not be made. View the error message by opening the “\logs\error.log” log file, then go back to fix the problem.
Database Driver Presets: Microsoft SQL Server
JDBC Driver Class: net.sourceforge.jtds.jdbc.Driver
Dstabase URL: jdbc:jtds:sqlserver://serverip/Messenger;appName=jive
Message was edited by: Deepak Sakpal
View
the error message by opening the “\logs\error.log”
log file, then go back to fix the problem.
So what’'s in this log? It should be at C:\Program Files\Wildfire\logs\ by default.
2006.03.04 01:12:17 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:120)
at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProv ider.java:83)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:351)
at org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:194)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)
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.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2006.03.04 01:12:49 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:68)
] Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.
2006.03.04 01:12:49 [org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnecti onManager.java:369)
]
java.lang.NullPointerException
at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectionManager.j ava:533)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:356)
at org.jivesoftware.wildfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:194)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)
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.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2006.03.04 01:12:49 [org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConne ctionProvider.java:68)
] Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.
2006.03.04 01:12:49 [org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManage r.java:116)
] WARNING: ConnectionManager.getConnection() failed to obtain a connection.
This is a bit of a shot in the dark (I use MySQL for Wildfire, but I do have a fair bit of SQL Server experience), but have you set up the JDBC driver for SQL Server? Links to the latest versions are below (you’‘ll have to piece together the URLs - the forum doesn’'t handle URLs this long properly):
SQL Server 2000:
http://www.microsoft.com/downloads/info.aspx?na=22&p=1&SrcDisplayLang=en&SrcCate goryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d07287b11-0502-46 1a-b138-2aa54bfdc03a%26DisplayLang%3den
SQL Server 2005:
http://www.microsoft.com/downloads/info.aspx?na=22&p=2&SrcDisplayLang=en&SrcCate goryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3de22bc83b-32ff-44 74-a44a-22b6ae2c4e17%26DisplayLang%3den
See the installed help documentation after installation on how to configure it.
Good luck!
U mean I have to install JDBC Driver for SQL Server on my Database Server?
Thanks for replying.
Hi, Deepak,
Yes. Wildfire uses the Java Database Connector (JDBC) to talk to SQL Server, and for SQL Server to reply, it requires the driver.
The Wildfire documentation recommends a different JDBC driver. See documentation here: http://www.jivesoftware.org/builds/wildfire/docs/latest/documentation/database.h tml
I find the server runs well on MySQL, but if you’'re using SQL Server for other things, you might as well keep one database server for everything.
You also need to set up the database schema before Wildfire will be happy. The instructions are listed in the URL above - there is a script supplied with Wildfire that builds the necessary tables, etc.