Openfire Error with database connectivity

Dear Experts,

I am using openfire in linux with MySQL4.1.7. I am not able to connect openfire with the database.

org.jivesoftware.database.DefaultConnectionProvider.start(D efaultConnectionProvider.java:88)

java.io.IOException

at org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:1 23)

at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConn ectionProvider.java:83)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(D bConnectionManager.java:459)

at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstanda rd_jsp._jspService(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(Servlet Handler.java:1074)

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

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacte rEncodingFilter.java:41)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

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

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

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

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

at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand lerCollection.java:146)

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

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

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

at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:45 7)

at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio n.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.ja va:329)

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

2007.06.28 11:40:06 org.jivesoftware.database.DefaultConnectionProvider.getConn ection(DefaultConnectionProvider.java:68) Warning: DbConnectionDefaultPool.getC onnection() was called before the internal pool has been initialized.

2007.06.28 11:40:06 org.jivesoftware.database.DbConnectionManager.setConnection Provider(DbConnectionManager.java:470)

java.lang.NullPointerException

at org.jivesoftware.database.DbConnectionManager.setMetaData(DbConnectio nManager.java:649)

at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(D bConnectionManager.java:464)

at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstanda rd_jsp._jspService(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(Servlet Handler.java:1074)

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

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacte rEncodingFilter.java:41)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet Handler.java:1065)

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

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

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

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

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

at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand lerCollection.java:146)

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

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

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

at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:45 7)

at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio n.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.ja va:329)

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

2007.06.28 11:40:06 org.jivesoftware.database.DefaultConnectionProvider.getConn ection(DefaultConnectionProvider.java:68) Warning: DbConnectionDefaultPool.getC onnection() was called before the internal pool has been initialized.

2007.06.28 11:40:06 org.jivesoftware.database.DbConnectionManager.getConnection (DbConnectionManager.java:95) WARNING: ConnectionManager.getConnection() failed to obtain a connection.

Please Help In This Issue.

Regards,

Balaji

balaji140780@gmail.com

Hey balaji_sysadm,

The most relevant error is missing from the log that you pasted. Hiding in your log you will find some JDBC error that explains the real problem. If you are not connecting from the same machine where the DB is running make sure that you configured the DB to accept remote TCP connections. Also make sure that the DB is up and running. No firewall is blocking the port and that the user that you are using has permission to use the desired DB from the machine you are connecting from.

Regards,

– Gato