Help~~~ cannot login after rollback to 2.1.6 from 2.1.7

[Migrated From Jforum.net]

I have backup mysql in 2.1.6

after fail to deploy 2.1.7, I try to roll back to 2.1.6

(both DB and Webapps)

It has no error when starting tomcat, but when I login the forum ...

it appear

<!-- BEGIN ERROR STACK TRACE <br /> java.lang.reflect.InvocationTargetException <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br /> at java.lang.reflect.Method.invoke(Method.java:585) <br /> at net.jforum.Command.process(Command.java:116) <br /> at net.jforum.JForum.service(JForum.java:182) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) <br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) <br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) <br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) <br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) <br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) <br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) <br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) <br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) <br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) <br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) <br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) <br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) <br /> at java.lang.Thread.run(Thread.java:595) <br /> Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: <br /> <br /> ** BEGIN NESTED EXCEPTION ** <br /> <br /> java.io.EOFException <br /> <br /> STACKTRACE: <br /> <br /> java.io.EOFException <br /> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905) <br /> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351) <br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) <br /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) <br /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) <br /> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) <br /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) <br /> at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) <br /> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) <br /> at net.jforum.dao.generic.GenericUserSessionDAO.selectById(GenericUserSessionDAO.java:110) <br /> at net.jforum.view.forum.UserAction.validateLogin(UserAction.java:369) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br /> at java.lang.reflect.Method.invoke(Method.java:585) <br /> at net.jforum.Command.process(Command.java:116) <br /> at net.jforum.JForum.service(JForum.java:182) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) <br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) <br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) <br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) <br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) <br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) <br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) <br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) <br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) <br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) <br /> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) <br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) <br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) <br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) <br /> at java.lang.Thread.run(Thread.java:595) <br /> <br /> <br /> ** END NESTED EXCEPTION ** <br /> <br /> <br /> <br /> Last packet sent to the server was 10 ms ago. <br /> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563) <br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) <br /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) <br /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) <br /> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) <br /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) <br /> at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) <br /> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) <br /> at net.jforum.dao.generic.GenericUserSessionDAO.selectById(GenericUserSessionDAO.java:110) <br /> at net.jforum.view.forum.UserAction.validateLogin(UserAction.java:369) <br /> ... 24 more <br /> <br /> END ERROR STACK TRACE-->
[originally posted on jforum.net by Ryu]

[Migrated From Jforum.net]

How did you backup and restore your database?


[originally posted on jforum.net by lazee]

[Migrated From Jforum.net]

First of all, why didn't 2.1.7 worked for you? what went wrong?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

lazee wrote:How did you backup and restore your database?

tar zcvfmp jforum.tar.gz /var/lib/mysql/jforum


and after I restore the DB, and all data looks fine.
[originally posted on jforum.net by Ryu]

[Migrated From Jforum.net]

Rafael Steil wrote:First of all, why didn't 2.1.7 worked for you? what went wrong?

Rafael

just cannot start Tomcat... just 1 message in catalina.out
something like

[jforum-2.1.7 cannot start duel to previous error]

and... Listener Fail to start ... something like that
[originally posted on jforum.net by Ryu]

[Migrated From Jforum.net]

Ah, right..

This is because the first package is missing the log4j jar - shame on us.

Add it to WEB-INF/lib and it should work.

We'll fix the package.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Rafael Steil wrote:Ah, right..

This is because the first package is missing the log4j jar - shame on us.

Add it to WEB-INF/lib and it should work.

We'll fix the package.

Rafael

For some reason the log4j package were commented out in build.xml. I have absolutely no idea why this is done. I will upload a new build2 of 2.1.7 monday morning.

Sorry about this mistake
[originally posted on jforum.net by lazee]