Issue
Openfire is unable to load correctly following an edit of the database via PHPMyAdmin
Accessing the console returns the user to the default setup wizard, in a loop
Currently unable to get access to the logs as the internet connection to the server has dropped out on attempting to access the error log.
System Details
Mac OS Server 10.5.6, Openfire 3.6.2a (I think its a as I downloaded it in the last week or so)
MySQL Database on localhost
Database History.
MySQL on Windows Server 2003 SP2,
Migrated to Mac OS Server 10.5.5 using PHPMyAdmin,
Migrated to Mac OS Server 10.5.6 using PHPMyAdmin after server reload.
Database Edit & Reason
Updated the gateway registrations in table - ofGatewayRegistration, field - jid from *@127.0.0.1 to *@openfire.mydomain via PHPMyAdmin on 8 records
This edit was done because the existing gateway would not connect, however on deleting one, and recreating it @openfire.mydomain was the jid utilised, so the remaining entries were updated to reflect this jid.
Upon deselecting the gateway and selecting it again, the correct path was visible in the OpenFire Admin Console under registrations, yet upon reconnecting in the client, it was not apart from the entry created through the console.
As a result the server was rebooted to see if this would resolve the issue.
However, upon a server reboot, any account was unable to connect, and connecting to the Admin Console, returned the default setup page.
Once this setup page has been run, it calls the setup page again.
/usr/local/openfire/conf/openfire.xml was checked, and “…” had been replaced with
I have experienced this issue before on a database edit, in that case to blank out the admin password, allowing me to gain access to the database after the migration, which produced the same issue. Resolution in that case, having been just post migration, was to restore the database again from PHPMyAdmin
true also is set in the configuration file.