[
https://issues.apache.org/jira/browse/SYNCOPE-903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15370605#comment-15370605
]
fabio martelli commented on SYNCOPE-903:
----------------------------------------
Hi, you have to act just into src/main/resources. Target directory is related
to the build.
About the documentation you are right, it is quite limited. BTW the community
is working to improve it before the 2.0.0 release.
Regards,
F.
> Scheduler not operational due to lowercase MySQL tables
> -------------------------------------------------------
>
> Key: SYNCOPE-903
> URL: https://issues.apache.org/jira/browse/SYNCOPE-903
> Project: Syncope
> Issue Type: Bug
> Components: archetype, core
> Affects Versions: 2.0.0-M4
> Environment: MySQL Database
> Reporter: Jeffrey Everling
>
> Hello,
> After deploying the latest version of Syncope, I noticed that I could not
> create any pull tasks. When I took a look at the error and compared this to
> the database structure it has generated, I noticed that Syncope is searching
> for an uppercase name where my database tables are lower case.
> Error:
> 17:40:22.279 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
> 1156556661 SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME =
> 'scheduler' AND LOCK_NAME = ? FOR UPDATE} [code=1146, state=42S02]]
> SQL table view:
> +--------------------------------+
> | Tables_in_syncope |
> +--------------------------------+
> | ACT_EVT_LOG |
> | ACT_GE_BYTEARRAY |
> | ACT_GE_PROPERTY |
> | ACT_HI_ACTINST |
> | ACT_HI_ATTACHMENT |
> | ACT_HI_COMMENT |
> | ACT_HI_DETAIL |
> | ACT_HI_IDENTITYLINK |
> | ACT_HI_PROCINST |
> | ACT_HI_TASKINST |
> | ACT_HI_VARINST |
> | ACT_ID_GROUP |
> | ACT_ID_INFO |
> | ACT_ID_MEMBERSHIP |
> | ACT_ID_USER |
> | ACT_PROCDEF_INFO |
> | ACT_RE_DEPLOYMENT |
> | ACT_RE_MODEL |
> | ACT_RE_PROCDEF |
> | ACT_RU_EVENT_SUBSCR |
> | ACT_RU_EXECUTION |
> | ACT_RU_IDENTITYLINK |
> | ACT_RU_JOB |
> | ACT_RU_TASK |
> | ACT_RU_VARIABLE |
> | ADynGroupMembership |
> | ADynGroupMembership_AnyObject |
> | AMembership |
> | APlainAttr |
> | APlainAttrUniqueValue |
> | APlainAttrValue |
> | ARelationship |
> | AccountPolicy |
> | AccountPolicy_ExternalResource |
> | AccountRuleConfInstance |
> | AnyAbout |
> | AnyObject |
> | AnyObject_AnyTypeClass |
> | AnyObject_ExternalResource |
> | AnyTemplatePullTask |
> | AnyTemplateRealm |
> | AnyType |
> | AnyTypeClass |
> | AnyType_AnyTypeClass |
> | CPlainAttr |
> | CPlainAttrUniqueValue |
> | CPlainAttrValue |
> | ConnInstance |
> | ConnInstance_capabilities |
> | DerSchema |
> | DynRoleMembership |
> | DynRoleMembership_User |
> | ExternalResource |
> | ExternalResource_PropActions |
> | ExternalResource_capOverride |
> | GPlainAttr |
> | GPlainAttrUniqueValue |
> | GPlainAttrValue |
> | MailTemplate |
> | Mapping |
> | MappingItem |
> | MappingItem_Transformer |
> | Notification |
> | NotificationTask_recipients |
> | Notification_events |
> | Notification_staticRecipients |
> | OPENJPA_SEQUENCES_TABLE |
> | PasswordPolicy |
> | PasswordRuleConfInstance |
> | PlainSchema |
> | Provision |
> | PullPolicy |
> | PullTask_actionsClassNames |
> | PushPolicy |
> | PushTaskAnyFilter |
> | PushTask_actionsClassNames |
> | Realm |
> | Realm_actionsClassNames |
> | RelationshipType |
> | Report |
> | ReportExec |
> | ReportTemplate |
> | ReportletConfInstance |
> | SYNCOPEAUDIT |
> | SecurityQuestion |
> | SyncopeConf |
> | SyncopeDomain |
> | SyncopeGroup |
> | SyncopeGroup_AnyTypeClass |
> | SyncopeGroup_ExternalResource |
> | SyncopeLogger |
> | SyncopeRole |
> | SyncopeRole_Realm |
> | SyncopeRole_entitlements |
> | SyncopeUser |
> | SyncopeUser_AnyTypeClass |
> | SyncopeUser_ExternalResource |
> | SyncopeUser_SyncopeRole |
> | SyncopeUser_passwordHistory |
> | Task |
> | TaskExec |
> | TypeExtension |
> | TypeExtension_AnyTypeClass |
> | UDynGroupMembership |
> | UDynGroupMembership_User |
> | UMembership |
> | UPlainAttr |
> | UPlainAttrUniqueValue |
> | UPlainAttrValue |
> | URelationship |
> | VirSchema |
> | anyObject_search |
> | anyObject_search_adyngmemb |
> | anyObject_search_amembership |
> | anyObject_search_arelationship |
> | anyObject_search_attr |
> | anyObject_search_group_res |
> | anyObject_search_null_attr |
> | anyObject_search_resource |
> | anyObject_search_unique_attr |
> | group_search |
> | group_search_attr |
> | group_search_null_attr |
> | group_search_resource |
> | group_search_unique_attr |
> | qrtz_fired_triggers |
> | qrtz_locks |
> | qrtz_paused_trigger_grps |
> | qrtz_scheduler_state |
> | user_search |
> | user_search_attr |
> | user_search_dynrmemb |
> | user_search_group_res |
> | user_search_null_attr |
> | user_search_resource |
> | user_search_role |
> | user_search_udyngmemb |
> | user_search_umembership |
> | user_search_unique_attr |
> | user_search_urelationship |
> +--------------------------------+
> I discussed this issue over IRC and as per advice I have tried upgrading the
> database (Current MySQL version: 5.5). The JDBC connector was already the
> latest version.
> But still MySQL is operating in a case sensitive way as far as I can check by
> performing the following queries:
> mysql> select * from QRTZ_LOCKS;
> ERROR 1146 (42S02): Table 'syncope.QRTZ_LOCKS' doesn't exist
> mysql> select * from qrtz_locks;
> Empty set (0.00 sec)
> Can you please advise about this matter? I would like to continue building
> the demo, but I would like to hear first if I can simply rename the database
> tables, or that I should proceed in another way.
> Kind regards,
> Jeffrey Everling
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
