Login to activiti-explorer and activiti-probe problem

[activitiuser]

Hi,

after having installed demo I cannot login to activiti-explorer and activiti-probe with standard users that is kermit/kermit or gonzo/gonzo. I get the message: The system was unable to log you in.

Do I have to set something more to be able to login in?
Thank you in advance for any hint.

With regards,
activitiuser

[activitiuser]

This is the error log from Tomcat:

org.apache.ibatis.exceptions.PersistenceException:
### Error opening session.  Cause: org.h2.jdbc.JdbcSQLException: Polaczenie uszk
odzone: "session closed"
Connection is broken: "session closed" [90067-132]
### The error may exist in org/activiti/db/ibatis/variable.mapping.xml
### The error occurred while processing mapper_resultMap[byteArrayResultMap_post
gres]
### Cause: org.h2.jdbc.JdbcSQLException: Polaczenie uszkodzone: "session closed"

Connection is broken: "session closed" [90067-132]
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(Exception
Factory.java:8)
        at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessi
onFromDataSource(DefaultSqlSessionFactory.java:81)
        at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessi
on(DefaultSqlSessionFactory.java:40)
        at org.activiti.engine.impl.db.DbSqlSessionFactory.dbSchemaCheckVersion(
DbSqlSessionFactory.java:137)
        at org.activiti.engine.impl.ProcessEngineImpl.performSchemaOperationsCre
ate(ProcessEngineImpl.java:118)
        at org.activiti.engine.impl.ProcessEngineImpl$1.execute(ProcessEngineImp
l.java:85)
        at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(Comm
andExecutorImpl.java:22)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execut
e(CommandContextInterceptor.java:37)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterc
eptor.java:33)
        at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.j
ava:83)
        at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProc
essEngine(ProcessEngineConfigurationImpl.java:215)
        at org.activiti.engine.ProcessEngines.buildProcessEngine(ProcessEngines.
java:151)
        at org.activiti.engine.ProcessEngines.initProcessEnginFromResource(Proce
ssEngines.java:124)
        at org.activiti.engine.ProcessEngines.init(ProcessEngines.java:83)
        at org.activiti.engine.ProcessEngines.getProcessEngine(ProcessEngines.ja
va:181)
        at org.activiti.rest.util.ActivitiWebScript.getProcessEngine(ActivitiWeb
Script.java:115)
        at org.activiti.rest.util.ActivitiWebScript.getIdentityService(ActivitiW
ebScript.java:124)
        at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScrip
t.java:73)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execut
e(DeclarativeWebScript.java:64)
        at org.springframework.extensions.webscripts.PresentationContainer.execu
teScript(PresentationContainer.java:69)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScri
pt(AbstractRuntime.java:333)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScri
pt(AbstractRuntime.java:189)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.se
rvice(WebScriptServlet.java:118)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:662)
Caused by: org.h2.jdbc.JdbcSQLException: Polaczenie uszkodzone: "session closed"

Connection is broken: "session closed" [90067-132]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:447)
        at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:326)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.jav
a:219)
        at org.h2.engine.SessionRemote.createSession(SessionRemote.java:213)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
        at org.h2.Driver.connect(Driver.java:58)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnectio
n(UnpooledDataSource.java:64)
        at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(Po
oledDataSource.java:349)
        at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(Po
oledDataSource.java:55)
        at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessi
onFromDataSource(DefaultSqlSessionFactory.java:72)
        … 34 more
java.lang.NullPointerException
        at org.json.JSONTokener.more(JSONTokener.java:98)
        at org.json.JSONTokener.next(JSONTokener.java:108)
        at org.json.JSONTokener.nextClean(JSONTokener.java:162)
        at org.json.JSONObject.<init>(JSONObject.java:178)
        at org.json.JSONObject.<init>(JSONObject.java:326)
        at org.activiti.surf.ActivitiRESTAuthenticator.authenticate(ActivitiREST
Authenticator.java:96)
        at org.springframework.extensions.webscripts.connector.AuthenticatingCon
nector.handshake(AuthenticatingConnector.java:403)
        at org.activiti.surf.ActivitiUserFactory.authenticate(ActivitiUserFactor
y.java:137)
        at org.springframework.extensions.surf.mvc.LoginController.handleRequest
Internal(LoginController.java:67)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(
AbstractController.java:153)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.ha
ndle(SimpleControllerHandlerAdapter.java:48)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
erServlet.java:771)
        at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
rServlet.java:716)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(Frame
workServlet.java:647)
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServ
let.java:563)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:436)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:374)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:302)
        at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(Normal
RewrittenUrl.java:195)
        at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.j
ava:159)
        at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:14
1)
        at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewri
ter.java:90)
        at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewrit
eFilter.java:417)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:662)
00:00:58,343  ERROR [extensions.webscripts.AbstractRuntime] Exception from execu
teScript - redirecting to status template error: 11100000 Wrapped Exception (wit
h status template): null
org.springframework.extensions.webscripts.WebScriptException: 11100000 Wrapped E
xception (with status template): null
        at org.springframework.extensions.webscripts.AbstractWebScript.createSta
tusException(AbstractWebScript.java:742)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execut
e(DeclarativeWebScript.java:167)
        at org.springframework.extensions.webscripts.PresentationContainer.execu
teScript(PresentationContainer.java:69)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScri
pt(AbstractRuntime.java:333)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScri
pt(AbstractRuntime.java:189)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.se
rvice(WebScriptServlet.java:118)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NullPointerException
        at org.activiti.rest.util.ActivitiWebScript.getIdentityService(ActivitiW
ebScript.java:124)
        at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScrip
t.java:80)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execut
e(DeclarativeWebScript.java:64)
        … 17 more

[frederikherema1]

Are you using the default demo running on H2? Seems like postgres-specific statements are used on a H2 database, strange.

What does your build.properties look like?


### The error may exist in org/activiti/db/ibatis/variable.mapping.xml
### The error occurred while processing mapper_resultMap[byteArrayResultMap_post
gres]
### Cause: org.h2.jdbc.JdbcSQLException: Polaczenie uszkodzone: "session closed"


[jcosano]

I have the same problem.

I install activiti first with h2 database.

After, i change to mysql, and run cfg.create and I put my new cfg file into tomcat lib.

Then, first time that I start explorer show this error… after a while all begin to work fine… but first time the error is showed!

[frederikherema1]

After you have altered the database config, you should run the demo.install again (and possibly demo.stop) to get the right libs copied to tomcat, based on your DB-config.

Alternative is to copy the required libs for the DB yourself (all of these can be found in de distro /setup/files/dependencies/libs/ folder, except for oracle JDBC-driver)

[jcosano]

I copy all but initial error persists.

Error is showed only first time that I try to login, error is show, but after a seconds, login is complete, and all begin to work fine… (logout and login works, and error is not show)

[frederikherema1]

Woops,

I meant that the new config should be present (activiti.cfg.xml) on the tomcat's classpatch, not the DB-drivers

[jcosano]

My activiti-cfg.jar is in tomcat lib too! and with mysql

[jcosano]

I do:

ant demo.clean
ant cfg.create
ant demo.start

and problem solve!

[chibsta]

Hi I am also facing the same problem using activiti 5.2 configured with mysql. I got rid of the H2 error by replacing activiti-cfg.xml in ../kickstart/WEB-INF/lib with the newly created activiti-cfg.xml containing my mysql config as the one with the H2 config was not replaced during setup. So I no longer have any errors my server logs but still I am getting the message:

The system was unable to log you in. in the browser and Connection refused: connect in the server logs. I suspect this has something to do with connection to MySQL (using MySQL 5.1.2). I have tried to replace the mysql-connector-java-5.0.4-bin that ships with activiti-5.2 with mysql-connector-java-5.0.7-bin to no avail.

Any thoughts anyone?

Regards,