powered by Jive Software

Cant seem to get Openfire to load

I’ve uninstalled and reinstalled several times but keep getting the following (win10) If anyone has any ideas please let me know. Sorry the Errorlog.txt was uploaded but somehow it ended up in the middle of sentence below. Any help would be much appreciated. Thanks

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionMerrorlog.txt (124.6 KB)
anager.getConnection() failed to obtain a connection after 11 retries. The exceptionE rrfmro hotel rsastartnit attepmg the server. Please check the log files frot is as follows: java.sql.SQLException: Database lock acquisition failure: lokc more information.
File: org.hsqldb.persist.LockFile@a090bba9[file =C:\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-12-13 21:05:58 heartbeat - read: -8368 ms.
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:820)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:543)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:163)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:102)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:81)
at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:94)
at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:25)
Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@a090bba9[file =C:\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-12-13 21:05:58 heartbeat - read: -8368 ms.
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:152)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:810)
… 16 more
Server halted

It looks like the DB lock file is present when it shouldn’t be. Try deleting C:\Openfire\embedded-db\openfire.lck

Greg

1 Like

Already replied on another thread. You run the launcher when it already runs as a service, that’s the cause of this lock.

1 Like

Thanks guys - I made sure the services were stopped and reinstalled. All seems to be working. I stopped the service and launched via the gui the following info kicked at start. Is this just informational - do you think its something to be concerned with before going live.

Openfire 4.2.3 [Dec 14, 2018 11:28:28 AM]
Admin console listening at http://cowm38-dd01:9090
Successfully loaded plugin ‘admin’.
Dec 14, 2018 11:28:28 AM com.sun.jersey.api.core.PackagesResourceConfig init
INFO: Scanning for root resource and provider classes in the packages:
org.jivesoftware.openfire.plugin
Dec 14, 2018 11:28:29 AM com.sun.jersey.server.impl.application.WebApplicationImpl _initiate
INFO: Initiating Jersey application, version ‘Jersey: 1.19.4 05/24/2017 03:46 PM’
Successfully loaded plugin ‘monitoring (1)’.
Finished processing all plugins.

Thanks for your help - appreciate it

Yes, these are just informational messages and should be gone in the next version. https://issues.igniterealtime.org/browse/OF-1524