Wildfire database Connectivity problem :(

Syed_Muhammad_ALi_Na · June 29, 2006, 4:52pm

Hello friends,

I am unable to connect wildfire with the mysql database.

here are the steps i followed :-

mysqladmin create ‘‘wildfire’’

#cat wildfire_mysql.sql | mysql ‘‘wildfire’’;

Parameters i am using to connect mysql database :-

Database Driver Presets: Pick Database…• MySQL•

JDBC Driver Class: com.mysql.jdbc.Driver

Database URL: jdbc:mysql://zoheb:3306/wildfire

even i tried

Database URL: jdbc:mysql://10.1.10.238:3306/wildfire

Database URL: jdbc:mysql://zoheb:pralmtu.com/wildfire

but when i tried to connect to database i am getting the following error.

cat /etc/hosts

Do not remove the following line, or various programs
that require network functionality will fail.

127.0.0.1 Zoheb localhost.localdomain localhost

10.1.10.238 pralmtu.com zoheb.pralmtu.com

netstat -ant

Active Internet connections (servers and established)

Proto Recv-Q Send-Q Local Address Foreign Address State

tcp 0 0 0.0.0.0:32769 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN

tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN

tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN

tcp 0 0 :::9090 :::* LISTEN

tcp 0 0 :::9091 :::* LISTEN

tcp 0 0 :::22 :::* LISTEN

tcp 0 0 ::ffff:10.1.10.238:22 ::ffff:10.1.10.7:1051 ESTABLISHED

tcp 0 492 ::ffff:10.1.10.238:22 ::ffff:10.1.10.31:2719 ESTABLISHED

vi error.log

2006.06.29 21:39:36 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(DefaultConnectionProv ider.java:83)

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

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:689)

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:830)

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:821)

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java: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.ja va: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.06.29 21:39:36 org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnect ionProvider.java:68) Warning: DbConnectionDefaultPool.getConnection() was called before the internal pool has been initialized.

2006.06.29 21:39:36 org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnection Manager.java:450)

java.lang.NullPointerException

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

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