After updating Openfire to 4.2.0, I can no longer login into admin console and no users can sign in their clients through LDAP or any other means. The only error we have seen is something like this: ERROR [Update Manager]: org.jivesoftware.util.JiveProperties - Unknown column ‘encrypted’ in ‘field …

strange, you may have other database schema corruption then. You could try this insert into ofVersion(name, version) values ('openfire', 25); and then restart openfire to see what happens

Openfire 4.2.0: Cannot login in admin console through LDAP

Openfire Openfire Support

akrherz December 5, 2017, 8:48pm 2

You are likely hitting this

can you restore from backup, fix the database and then upgrade again?