I have been having problems with my Wildfire installation. I posted about this a couple of months ago and was asked to upgrade my mysql db to the latest which I did - I’'m now running 5.0.21. I also moved the database to the same server as the Wildire install. But now the problems have returned. All will work well for a few days, sometimes less, and then users will not be able to login. Exodus says password wrong or user already logged in. The database seems to be fine, I have logged into it via several tools and looked around in the Wildfire tables with no trouble. Here are the last few entries from my error log. I am using LDAP btw. Any ideas would be greatly appreciated.
2006.07.27 08:31:01 [org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(P rivacyListProvider.java:168)
] Error loading default privacy list of username: myj
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
- BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Software caused connection abort: socket write error
STACKTRACE:
java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr ivacyListProvider.java:159)
at org.jivesoftware.wildfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv acyListManager.java:106)
at org.jivesoftware.wildfire.roster.Roster.broadcastPresence(Roster.java:521)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:258)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:96)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:153)
at org.jivesoftware.wildfire.PresenceRouter.handle(PresenceRouter.java:92)
at org.jivesoftware.wildfire.PresenceRouter.route(PresenceRouter.java:61)
at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:73)
at org.jivesoftware.wildfire.net.SocketReader.processPresence(SocketReader.java:44 5)
at org.jivesoftware.wildfire.net.ClientSocketReader.processPresence(ClientSocketRe ader.java:56)
at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.java:242)
at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)
at java.lang.Thread.run(Unknown Source)
- END NESTED EXCEPTION **
Last packet sent to the server was 15 ms ago.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2710)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr ivacyListProvider.java:159)
at org.jivesoftware.wildfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv acyListManager.java:106)
at org.jivesoftware.wildfire.roster.Roster.broadcastPresence(Roster.java:521)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:258)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:96)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:153)
at org.jivesoftware.wildfire.PresenceRouter.handle(PresenceRouter.java:92)
at org.jivesoftware.wildfire.PresenceRouter.route(PresenceRouter.java:61)
at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:73)
at org.jivesoftware.wildfire.net.SocketReader.processPresence(SocketReader.java:44 5)
at org.jivesoftware.wildfire.net.ClientSocketReader.processPresence(ClientSocketRe ader.java:56)
at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.java:242)
at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)
at java.lang.Thread.run(Unknown Source)
Message was edited by: zepzep