Suddenyl I can''t login

Openfire Openfire Support
1

I’'ev had Jive running successfully for a week or so now, and everything seemed fine until I tried to login this morning. I kept getting authentication failures, so I restarted the server. The auth failures kept happening, and I got an auth error when trying to login to the admin system.

In the error.log file I get the following output every time I try to login (as a non java person I don’'t know where things are going wrong). I am still able to connect to the DB through command line and through web apps, so I doubt it is an issue with this.

2005.08.14 16:59:35 org.jivesoftware.messenger.auth.DefaultAuthProvider.authenticate(DefaultAuthProv ider.java:59) Exception in DbAuthProvider

java.sql.SQLException: No operations allowed after connection closed.

Connection was closed due to the following exception:

  • BEGIN NESTED EXCEPTION **

java.sql.SQLException

MESSAGE: Communication link failure: java.io.EOFException, underlying cause: null

  • BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)

at org.jivesoftware.messenger.user.DefaultUserProvider.loadUser(DefaultUserProvide r.java:66)

at org.jivesoftware.messenger.user.UserManager.getUser(UserManager.java:157)

at org.jivesoftware.messenger.roster.Roster.(Roster.java:84)

at org.jivesoftware.messenger.roster.RosterManager.getRoster(RosterManager.java:69 )

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.broadcastUpdate(Presen ceUpdateHandler.java:238)

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:90)

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:141)

at org.jivesoftware.messenger.PresenceRouter.handle(PresenceRouter.java:87)

at org.jivesoftware.messenger.PresenceRouter.route(PresenceRouter.java:60)

at org.jivesoftware.messenger.PacketRouter.route(PacketRouter.java:73)

at org.jivesoftware.messenger.net.SocketReader.processPresence(SocketReader.java:3 01)

at org.jivesoftware.messenger.net.ClientSocketReader.processPresence(ClientSocketR eader.java:49)

at org.jivesoftware.messenger.net.SocketReader.readStream(SocketReader.java:208)

at org.jivesoftware.messenger.net.SocketReader.run(SocketReader.java:111)

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

  • END NESTED EXCEPTION **

STACKTRACE:

java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null

  • BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)

at org.jivesoftware.messenger.user.DefaultUserProvider.loadUser(DefaultUserProvide r.java:66)

at org.jivesoftware.messenger.user.UserManager.getUser(UserManager.java:157)

at org.jivesoftware.messenger.roster.Roster.(Roster.java:84)

at org.jivesoftware.messenger.roster.RosterManager.getRoster(RosterManager.java:69 )

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.broadcastUpdate(Presen ceUpdateHandler.java:238)

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:90)

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:141)

at org.jivesoftware.messenger.PresenceRouter.handle(PresenceRouter.java:87)

at org.jivesoftware.messenger.PresenceRouter.route(PresenceRouter.java:60)

at org.jivesoftware.messenger.PacketRouter.route(PacketRouter.java:73)

at org.jivesoftware.messenger.net.SocketReader.processPresence(SocketReader.java:3 01)

at org.jivesoftware.messenger.net.ClientSocketReader.processPresence(ClientSocketR eader.java:49)

at org.jivesoftware.messenger.net.SocketReader.readStream(SocketReader.java:208)

at org.jivesoftware.messenger.net.SocketReader.run(SocketReader.java:111)

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

  • END NESTED EXCEPTION **

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1713)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)

at org.jivesoftware.messenger.user.DefaultUserProvider.loadUser(DefaultUserProvide r.java:66)

at org.jivesoftware.messenger.user.UserManager.getUser(UserManager.java:157)

at org.jivesoftware.messenger.roster.Roster.(Roster.java:84)

at org.jivesoftware.messenger.roster.RosterManager.getRoster(RosterManager.java:69 )

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.broadcastUpdate(Presen ceUpdateHandler.java:238)

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:90)

at org.jivesoftware.messenger.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:141)

at org.jivesoftware.messenger.PresenceRouter.handle(PresenceRouter.java:87)

at org.jivesoftware.messenger.PresenceRouter.route(PresenceRouter.java:60)

at org.jivesoftware.messenger.PacketRouter.route(PacketRouter.java:73)

at org.jivesoftware.messenger.net.SocketReader.processPresence(SocketReader.java:3 01)

at org.jivesoftware.messenger.net.ClientSocketReader.processPresence(ClientSocketR eader.java:49)

at org.jivesoftware.messenger.net.SocketReader.readStream(SocketReader.java:208)

at org.jivesoftware.messenger.net.SocketReader.run(SocketReader.java:111)

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

  • END NESTED EXCEPTION **

at com.mysql.jdbc.Connection.checkClosed(Connection.java:2474)

at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1370)

at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1350)

at org.jivesoftware.database.AbstractConnection.prepareStatement(AbstractConnectio n.java:36)

at org.jivesoftware.messenger.auth.DefaultAuthProvider.authenticate(DefaultAuthPro vider.java:47)

at org.jivesoftware.messenger.auth.AuthFactory.authenticate(AuthFactory.java:97)

at org.jivesoftware.messenger.admin.login_jsp._jspService(login_jsp.java:136)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

at org.mortbay.http.HttpServer.service(HttpServer.java:896)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2

My only guess is that something changed with your database setup. For some reason, Jive Messenger isn’'t able to communicate with it. A few things to check:

  1. Make sure that the settings are correct in the JM config file – ie, did the config get corrupted somehow.

  2. Check to see if there were any changes in your network.

Regards,

Matt

3

Matt,

The database set-up hasn’'t changed in any way.

My config file (which i think looks ok) looks like:

4

this is hardly the same situation, but we should check all possibilities. In other thread you said you are using Exodus. So Exodus throws this Auth error? And when you press Connect link too. Have you tried to go to Sing On/Off menu and then to Profile Details and check if password field is not clear? In my case when i’'m getting such auth errors with Exodus i have to fill password field again.

Dont know if this is only Exodus issue, i think i have already reported it on Exodus Bug Tracker.

5

wroot,

Thanks for this info, but the problem is occuring in exodus, trillian and the admin control panel as well.

But thanks for the pointer.

6

Worked it out… told the jive server to stop… did a ps and found there was still a copy running. Did a kill -9 on it and then restarted the jive server and it works a charm. thanks for the help peoples