AnsweredAssumed Answered

Nobody can log into Spark this morning, can't log in to Openfire Admin console

Question asked by Paul Febre on Mar 7, 2017
Latest reply on Mar 9, 2017 by wroot

Hello.

This morning when we came in nobody can log into spark, even those that have had their passwords saved and should be able to automatically log in. Says their passwords are incorrect.

So I tried going into the openfire admin console. After clicking "Login" it doesn't do anything for a while, and then on the openfire console window I get this:

 

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: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Network error IOExceptioEn: Connection timed out: conrnect

  at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:770)

  at org.jiveorfostware.openfire.XMPPServer.start(XMPPeSr starting the server. Please check the log files for more inforartvmoire.n.java:486)

  at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:216)

a

t 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:113)

  at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:58)

  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(Unknown Source)

  at com.exe4j.runtime.WinLauncher.main(Unknown Source)

  at com.install4j.runtime.launcher.WinLauncher.main(Unknown Source)

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: Network error IOException: Connection timed out: connect

  at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:151)

  at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:760)

  ... 16 more

Server halted

 

Please help? My OpenFire version is 3.9.1. Thank you!

Outcomes