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 the properties file to use tables_mysql_innodb, it worked.
Thanks for your help. Cam Luc On 2016-08-25 02:39 (-0500), Francesco Chicchiriccò <ilgro...@apache.org> wrote: > 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/ > >