Syncope (TIdM) with MySQL - Login to Syncope console is not possible

Symptoms

When logging on to the Syncope console, the following error appears: Alert: Session expired: please login again.

 

Diagnosis

Check to see if the Syncope module is deployed. In the catalina.out logs, you will see that it isn't:

28-Jun-2017 10:14:55.179 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Error listenerStart 
28-Jun-2017 10:14:55.181 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/syncope] startup failed due to previous errors

 

Solution

In the localhost log for Tomcat you will see an error. It is pointing to a file that is not being found.

Note: It is important to look in the localhost*.log as well as the catalina.out log.

java.io.FileNotFoundException: class path resource [audit/audit_sqlServer.sql] cannot be opened because it does not exist

 

If you check the configuration, persistence.properties is pointing to this file. Since you are using MySQL, make the following changes to the config file:

## for mysql 
quartz.sql=tables_mysql_innodb.sql 
audit.sql=audit_mysql_innodb.sql 
## for mssql 
#quartz.sql=tables_sqlServer.sql 
#audit.sql=audit_sqlServer.sql 

After restarting Tomcat, everything should work properly with no errors.

 

Additional Information

All the steps of setting up Syncope with a database are provided here:

https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments

Version history
Revision #:
5 of 5
Last update:
‎09-19-2017 02:01 PM
Updated by:
 
Contributors