Spark will not connect to the server

Kyle_Frick · November 16, 2016, 4:24pm

We had a power outage for probably half a second. It brought our servers down and our entire Openfire down as well. When everything was booted back up, everything but the Spark application came up and working correctly. Whenever I try logging into spark, it states this:

Can’t connect to server: invalid name or server not reachable

I have tried uninstalling and reinstalling both spark and openfire because that is what our reboot instructions tell us to do, however this does not work anymore.

Please help.

wroot · November 16, 2016, 7:50pm

I think this is most probably a server problem and not Spark. Are you able to login to your Openfire’s Admin Console? Maybe its database got corrupted during the outage, so the reinstall won’t help as the database is still the old one. Btw, what database are you using?

Kyle_Frick · November 16, 2016, 8:16pm

After working around a bit I was able to login to the Admin Console, but the Database was set up at this company before I had been added on. The previous guy who was working on this knew the location but hadn’t told me before he left and left no evidence of where it could be. We have backups of our configuration before hand, if I used that openfire.xml file would it connect to the correct database now or no? I believe that we were using an Active Directory, but not entirely sure.

wroot · November 16, 2016, 9:19pm

Restoring openfire.xml won’t help if database is corrupted. You can check the openfire.xml file and see what database it is set to connect to. E.g.

org.jivesoftware.database.EmbeddedConnectionProvider

means it is using the embedded database.

If you are able to login to Admin Console, then maybe this is not a database issue. Do you see anything in Openfire’s logs? Are you logging into Admin Console remotely or directly on the server? If you can login remotely, then the server should be fine. If not, maybe that’s your network what is at fault (some switch or router). Can you ping the server with Openfire from Spark PC (if ping is not blocked by firewall)?

Kyle_Frick · November 16, 2016, 9:50pm

I’m able to connect remotely. I just don’t have access to the database. Is there some way that I could get all the information off that one database and instead put it on an embedded database so therefore I can access it from the Admin Console?

wroot · November 16, 2016, 10:12pm

Have you checked your openfire.xml for database information?

Have you checked Openfire’s logs?

Kyle_Frick · November 16, 2016, 10:19pm

These are the errors closest to the time of power outage.

2016.11.15 15:54:10 org.jivesoftware.openfire.container.AdminConsolePlugin - An exception occurred while trying to make available the admin console via HTTPS.

java.lang.NullPointerException

at org.jivesoftware.openfire.container.AdminConsolePlugin.startup(AdminConsolePlug in.java:144)

at org.jivesoftware.openfire.container.AdminConsolePlugin.initializePlugin(AdminCo nsolePlugin.java:244)

at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java :447)

at org.jivesoftware.openfire.container.PluginManager.access$300(PluginManager.java :68)

at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:1037)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301 (Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2016.11.15 15:54:10 org.jivesoftware.openfire.container.AdminConsolePlugin - Could not start admin console server

java.net.BindException: Address already in use: bind

at sun.nio.ch.Net.bind0(Native Method)

at sun.nio.ch.Net.bind(Unknown Source)

at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)

at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)

at org.eclipse.jetty.server.ServerConnector.open(ServerConnector.java:321)

at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnec tor.java:80)

at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:236)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java :68)

at org.eclipse.jetty.server.Server.doStart(Server.java:366)

at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java :68)

at org.jivesoftware.openfire.container.AdminConsolePlugin.startup(AdminConsolePlug in.java:208)