Hi Francesco,
I was using the Create project with maven. So I modified Master.properties,
context.xml, but did not modify provisioning.properties. Provisioning was
taking the default sql script for postgre, and run it on mysql - so it failed
to create the necessary tables. After modifying
Hi,
I assume that you've been using the GUI installer with Tomcat: correct?
if I remember well, MySQL is configured for InnoDB by default on MySQL:
this means that the provisioning.properties [1] should be referencing
quartz.sql=tables_mysql_innodb.sql
rather than
quartz.sql=tables_mysql.sql
It turned out that on Ubuntu, MySQL table names are case sensitive. The syncope
database has a table qrtz_locks - notice syncope is looking for QRTZ_LOCKS. I
tried renaming the table to upper case, and the error went away.
Now I got another error. Syncope is looking for QRTZ_JOB_DETAILS, but the
Environment: Ubuntu 16 64bit
Application server: Tomcat 8
JDK: Java 8
Syncope version: 2.0.0-M4
Syncope internal database: MySQL
I am a new user. After being able to connect MySQL as the internal storage (all
tables are created in syncope database), I created a MySQL connector, and a
Users resou