OS: Debian 6
JRE: Sun Java6
I was using an embedded-db based setup which i decided to move to external db (MySQL).
So i followed instructions from - http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html#mysql
I changed bind to the Servers IP address in my.cnf and granted all rights to the user on the database.
I then blanked the value of openfire.xml and accessed the web interface to run setup again.
i went through the setup and selected MySQL, gave all credentials(user:root) and the db name along with the server’s IP address. Setup completed *successfully. *I then set the value of to true. When i tried accessing the servers web interface i get the Setup screen again.
I’ve verifed that the admin user got created in mysql, I have given all permissions i could think of.
What am i missing here?