I have to
setup Syncope on Windows R2 x64, but I am constantly getting the error session
expired when logging on to the web-console. I am making use of MySQL as
database for Syncope checked everything with a setup on Ubuntu Linux where I
have
Syncope
working
without any issues.
-
First
problems I did run into was the auto creation of tables and views for syncope in
the MySQL database that made my MySQL crash and did leave an uncomplete created
syncope database behind
-
I
created a backup from the syncope database on my Linux machine and imported on
Windows
MySQL, this solved all my database related errors I had before in catalina.out
and tomcat7-stderr.log
-
I
still receive the session expired in the Syncope web console
-
In
the tomcat localhost.{date}.log I receive an error that is probably the cause
of this behavior but I have no clue how
to resolve it
Hopefully
someone can help me out on this error
Oct 04, 2014 11:15:17 AM org.apache.catalina.core.StandardContext
listenerStart
SEVERE: Exception sending context initialized event to listener instance
of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'accountPolicyEnforcer': Injection of autowired dependencies
failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Could not autowire
field: private org.apache.syncope.core.policy.UserSuspender
org.apache.syncope.core.policy.AccountPolicyEnforcer.userSuspender; nested
exception is org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'workflowUserSuspender': Injection of autowired
dependencies failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Could not autowire
field: private org.apache.syncope.core.workflow.user.UserWorkflowAdapter
org.apache.syncope.core.workflow.WorkflowUserSuspender.uwfAdapter; nested
exception is org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'uwfAdapter': Injection of autowired dependencies
failed; nested exception is
org.springframework.beans.factory.BeanCreationException:
Could not autowire field: private org.activiti.engine.RuntimeService
org.apache.syncope.core.workflow.user.activiti.ActivitiUserWorkflowAdapter.runtimeService;
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'processEngine': FactoryBean threw exception on
object creation; nested exception is org.activiti.engine.ActivitiException:
Version of activiti database (5.14) is more recent than the engine (5.13) at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:288)
Below are my settings in tomcat conf/context.xml
<Context>
<!-- Default set of
monitored resources -->
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<!-- Uncomment this to
disable session persistence across Tomcat restarts -->
<Manager
pathname="" />
<Resource
name="jdbc/syncopeDataSource" auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
maxActive="100"
minIdle="2"
maxWait="10000"
initialSize="2"
removeAbandonedTimeout="20000"
removeAbandoned="true"
logAbandoned="true"
suspectTimeout="20000"
timeBetweenEvictionRunsMillis="5000"
minEvictableIdleTimeMillis="5000"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="username"
password="password" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8"/>
</Context>
Below are my settings in syncope-console
/WEB-INF/classes/configuration.properties
scheme=http
host=localhost
port=8040
rootPath=/syncope/rest/
Below are my settings in syncope
/WEB-INF/web.xml
<!-- Uncomment this when
using JNDI DataSource -->
<resource-ref>
<res-ref-name>jdbc/syncopeDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
/WEB-INF/classes/persistence.properties
jpa.driverClassName=com.mysql.jdbc.Driver
jpa.url=jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8
jpa.username=username
jpa.password=password
jpa.dialect=org.apache.openjpa.jdbc.sql.MySQLDictionary
quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
quartz.sql=tables_mysql.sql
logback.sql=mysql.sql
