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
Anyway, in order to fix your deployment you will need to:
1. stop Tomcat
2. execute [2] in the database instance used as internal storage
2. start Tomcat again
HTH
Regards.
[1]
https://github.com/apache/syncope/blob/syncope-2.0.0-M4/fit/core-reference/src/main/resources/mysql/provisioning.properties
[2]
https://github.com/apache/syncope/blob/syncope-2.0.0-M4/core/provisioning-java/src/main/resources/quartz/tables_mysql_innodb.sql
On 24/08/2016 21:22, Cam Luc wrote:
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
syncope database does not have that table, either in lower case or upper case.
My syncope database has 118 tables.
On 2016-08-24 13:41 (-0500), "Cam Luc"<cluc.star...@gmail.com> wrote:
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 resource. The
connector and resource seem to work, as I am able to view the users with "explore
resource". But when creating a Pull task to pull users from MySQL into Syncope, I
encountered the following error:
ERROR org.apache.syncope.client.console.wizards.AjaxWizard - Wizard error on
finish
org.apache.syncope.common.lib.SyncopeClientException: Scheduling [Failure
obtaining db row lock: Table 'syncope.QRTZ_LOCKS' doesn't exist {prepstmnt
913057574 SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'scheduler' AND LOCK_NAME
= ? FOR UPDATE} [code=1146, state=42S02]]
at
org.apache.syncope.common.lib.SyncopeClientException.build(SyncopeClientException.java:37)
~[syncope-common-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.lib.RestClientExceptionMapper.checkSyncopeClientCompositeException(RestClientExceptionMapper.java:147)
~[syncope-client-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:58)
~[syncope-client-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:42)
~[syncope-client-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:303)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:793)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:755)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.invoke(ClientProxyImpl.java:228)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at com.sun.proxy.$Proxy237.create(Unknown Source) ~[?:?]
at
org.apache.syncope.client.console.rest.TaskRestClient.create(TaskRestClient.java:202)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.tasks.SchedTaskWizardBuilder.onApplyInternal(SchedTaskWizardBuilder.java:96)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.tasks.SchedTaskWizardBuilder.onApplyInternal(SchedTaskWizardBuilder.java:56)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.wizards.AjaxWizardBuilder$1.onApplyInternal(AjaxWizardBuilder.java:104)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.wizards.AjaxWizard.onFinish(AjaxWizard.java:182)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC,
CXF Committer, OpenJPA Committer, PonyMail PPMC
http://home.apache.org/~ilgrosso/