After installing Openfire for the first time, everything went smoothly and the server started without problems. However, after rebooting the server Openfire won’t start at all. This is what happens:
# sudo service openfire start best java alternative in: /usr/lib/jvm/java-7-openjdk-amd64/jre Starting openfire: openfire.
- and nothing happens *
Error log is here: http://pastebin.com/raw.php?i=Fqt9jwnd
It seems that Openfire cannot connect to mysql even though
- The username and password are correct
- I can log in to mysql with the same credentials from the command line: # mysql -u openfire -p
- Mysql is running and is listening to port 3306
- Mysql user ‘openfire’@‘localhost’ does have sufficient permissions
- Everything worked perfectly before the reboot…
These are my database settings from /etc/openfire/openfire.xml:
<connectionProvider> <className>org.jivesoftware.database.DefaultConnectionProvider</className> </connectionProvider> <database> <defaultProvider> <driver>com.mysql.jdbc.Driver</driver> <serverURL>jdbc:mysql://localhost:3306/openfire?rewriteBatchedStatements=true</serverURL> <username encrypted="true">c03b4b0f...</username> <password encrypted="true">637a448f...</password> <testSQL>select 1</testSQL> <testBeforeUse>false</testBeforeUse> <testAfterUse>false</testAfterUse> <minConnections>5</minConnections> <maxConnections>25</maxConnections> <connectionTimeout>1.0</connectionTimeout> </defaultProvider> </database> <setup>true</setup>
I managed to start the server with a trick: I disabled write access to openfire.xml, started Openfire service and re-enabled the write access. Openfire then showed the setup page to which I entered all the settings again - and voilà - the server is up and running. However, nobody can actually log in to the xmpp server. Everybody just gets “Not Authorized” error exept the admin account that was updated during the setup. Deleting and re-installing server certificate on the client doesn’t work. The users are still in the database and are listed in the admin panel. This trick also reset all server settings. And if I restart openfire, it’s the same thing all over again (access denied for user ‘openfire’…)
Any help would be very much appreciated!