while starting the openfire, getting error in the UpdateManager
java.net.UnknownHostException: www.igniterealtime.org
..................
at org.jivesoftware.openfire.update.UpdateManager.checkForServerUpdate(UpdateManager.java:223)
at org.jivesoftware.openfire.update.UpdateManager$1.run(UpdateManager.java:136)
And maybe due to this update not happening,
there is another error while logging to Administration console
ERROR 2018-03-01 15:16:19,681 org.jivesoftware.util.JiveProperties.insertProperty(JiveProperties.java:363) - ERROR: column "encrypted" of relation "ofproperty" does not exist
Position: 41
com.edb.util.PSQLException: ERROR: column "encrypted" of relation "ofproperty" does not exist
My server is not connected to the internet. Is the UpdateManager only for database upgrade ?
Is there a way I could run the updates manually using some database scripts ?
Or is it mandatory that the server must be on the internet for this ?
UpdateManager is probably only for checks about new version of Openfire and to check and install new versions of plugins. Database scheme is updated on the first run after upgrading with an installer (it uses local sql scripts to do this).
The database schema has not been updated during the first run. Is there a configuration that we can set so that
schema is updated during the next restart ?
I’m not that familiar with db changes and don’t have Openfire here. But i think upgrade scripts are in /openfire/database folder. You can check the latest script and see what db version it should set and then check your actual database and see what version is there.
ofversion was 21 and hence the upgrade was trying to update from version 21 to 26.
The database already had updates till version 25, and it was failing.
Manually updated ofversion to 25 and restarted openfire. Works fine now.
On the other point, if your server is not connected to the internet you can get rid of the “java.net.UnknownHostException: www.igniterealtime.org” errors by setting the system property update.service-enabled to false