I’‘m really eager to move from jabberd2 to wildfire/openfire. It has a lot of the features i’'ve been looking for.
I am at the initial install stage. on the 3rd page of the wizard where it asks you for set up info.
So far i have the following :
Domain: jabber (this resolves on my system in /etc/hosts and bind)
admin console port 9090
secure admin console port 9091
Standard Database connection
JDBC Driver Class: com.mysql.jdbc.Driver
Database URL: jdbc:mysql://jabber:3306/openfire
password: (password here)
Minimum Connections: 5
Maximum Connections: 15
Connection Timeout: 1.0 days
When i hit continue i see “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.”
The error log is here: http://www.feline-soul.com/files/error.log I will leave it there till the issue is resolved.
To see if anything else was blocking 3306 i did a netstat -pant and got:
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 6250/mysqld
so i know mysqld is up and running (not to mention that everything else that uses it, is running fine)
It seems to be a connection error, but i can connect to the database using mysql and browse the tables, which are empty, but the structure is in place. In other words i can connect with root and the password. I have to figure out how to change the privileges in mysql so that my "jabber’’ user can connect to it instead of root, but for now i just want to get connected.
Any help or pointers would be appreciated. Is my Java version too new?