I am having trouble with the ‘‘Database Settings’’ step in the web-based Wildfire setup on a Mac OS 10.4.4 Server Xserve.
The message in the Wildfire error.log reads:
2006.01.18 16:18:19 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:108)] Failed to create new connections on startup. Attempt 0 of 3
java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: java.net.ConnectException: Connection refused
- BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused
I believe this means that the JDBC driver is trying to connect to the MySQL database but is being refused. I can log in to the mysql with the user name I’'m supplying the Wildfire setup page and it seems to have the proper privs:
GRANT ALL PRIVILEGES ON . TO ‘‘wildadmin’’@’‘localhost’’ IDENTIFIED BY PASSWORD ‘’*79F2B8E7E556EEF3E8940D47D79A354CD32742CB’’ WITH GRANT OPTION
GRANT ALL PRIVILEGES ON wildfire
.wilddire
TO ‘‘wildadmin’’@’‘localhost’’ WITH GRANT OPTION
The database is created and populated with the data from wildfire_mysql.sql .
I can start wildfire with ‘’/opt/wildfire/bin/wildfire start’’ and connect to http://localhost:9090 but cannot get passed the ‘‘Database Settings’’ page.
I’'m using MySQL version 4.1.13a, java -version produces:
java version “1.5.0_05”
Java™ 2 Runtime Environment, Standard Edition (build 1.5.0_05-83)
Java HotSpot™ Client VM (build 1.5.0_05-48, mixed mode, sharing)
I’'ve exported these:
export JAVA_HOME=’’/System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/Home’’
export INSTALL4J_JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Versions/1.5.0/ Home/
On the ‘‘Database Settings’’ page I’'ve entered:
JDBC Driver: com.mysql.jdbc.Driver
Database URL: jdbc:mysql://localhost:3306/wildfire
Username: wildadmin
Password: *******
I’‘m stumped. Any ideas where I’'m going wrong here?