Details
Major Description
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
[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