Openfire was restarted, now no users can connect

I had to reboot my server and when it came back up no one can connect to openfire. The server is running in the services menu, but when I login with spark it tells me invalid username or password. I can go into the admin panel and reset the password then it works. However, when I restart the openfire services, it no longer works! I do not want to have to reset all my users accounts everytime the service gets rebooted! Any help would greatly be appreciated.

My error log

Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2622)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
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 org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Wrapper$$EnhancerByProxool$$f21af6c7.execute()
at org.jivesoftware.openfire.spi.PresenceManagerImpl.userUnavailable(PresenceManag erImpl.java:265)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:145)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:112)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:176)
at org.jivesoftware.openfire.PresenceRouter.handle(PresenceRouter.java:134)
at org.jivesoftware.openfire.PresenceRouter.route(PresenceRouter.java:70)
at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:76)
at org.jivesoftware.openfire.SessionManager$ClientSessionListener.onConnectionClos e(SessionManager.java:1133)
at org.jivesoftware.openfire.nio.NIOConnection.notifyCloseListeners(NIOConnection. java:183)
at org.jivesoftware.openfire.nio.NIOConnection.close(NIOConnection.java:166)
at org.jivesoftware.openfire.nio.NIOConnection.systemShutdown(NIOConnection.java:1 73)
at org.jivesoftware.openfire.spi.LocalRoutingTable.stop(LocalRoutingTable.java:126 )
at org.jivesoftware.openfire.spi.RoutingTableImpl.stop(RoutingTableImpl.java:759)
at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:930)
at org.jivesoftware.openfire.XMPPServer.access$600(XMPPServer.java:97)
at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:881 )
2008.08.15 14:50:44 [org.jivesoftware.util.log.util.CommonsLogFactory$1.error(CommonsLogFactory.jav a:88)

I have same problem, please help us

Sounds like Openfire can not write data to your database. Possibly your database user has not all necessary rights.

This logfile is not helpful. The first few lines of each log entry are the most important one.

From the log file I can see you are using MySQL.

  1. Login to MySQL as root:
shell> mysql -p -u root
  1. execute these commands, where “user” is your database user and “database” the name of Openfire’s database:
mysql> REVOKE ALL ON *.* FROM user;
mysql> GRANT ALL ON database.* TO user;

This will give “user” ALL rights for “database” and revoke all rights for other databases.

I can use ;

Database and Version: HSQL Database Engine 1.8.0

JDBC Driver Version: 1.8.0

Error log

java.lang.NumberFormatException: For input string: "1024000
"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at org.jivesoftware.openfire.OfflineMessageStrategy.initialize(OfflineMessageStrat egy.java:182)
at org.jivesoftware.openfire.XMPPServer.initModules(XMPPServer.java:575)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:464)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
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.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
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)
java.util.ConcurrentModificationException
at java.util.LinkedHashMap$LinkedHashIterator.nextEntry(Unknown Source)
at java.util.LinkedHashMap$ValueIterator.next(Unknown Source)
at org.jivesoftware.openfire.XMPPServer.initModules(XMPPServer.java:572)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:464)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
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.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarEerrto.rrajs v:aat0r6t1)nig
ta
he sretov r.ejrig .Pevesaoslftwrae ceehckt o.he log files for moreipnefno ifmraetrsit.noare.r
.
SterverStarter.main(ServerStarter.java:51)
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)
java.lang.NullPointerException
at org.jivesoftware.openfire.handler.IQOfflineMessagesHandler.stop(IQOfflineMessag esHandler.java:194)
at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:930)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:491)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
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.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
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)

@biryclzkn: Are you using a standalone version of HSQLDB or the embedded database? In first case do the same thing: Check if the database user has full permission for Openfire’s database. In second case, check if the user that runs Openfire has write permission to the database directory? I don’t know where it is, but it must be somewhere inside the Openfire directory.