Question in Mind:
How to fix Joomla and CiviCRM Access Control (ACL) Permission for Individual Groups
Why do my CiviCRM Access Permission are not save or reset automatically?
How can I give access permission for CiviCRM to Manager, Administrator or Any other Group to Use?
Hi
If you are having problem with Joomla Access Control (ACL) and CiviCRM Access Rules Permission For User Groups then follow me.
Problem:
- My CiviCRM only can accessible by Super Admin and any other user group can’t able to access.
- I Can’t Able to Set CiviCRM Access permission from CiviCRM >Administer> User And Permission>
Permissions (Access Control) > Joomla Access Control and try to give access, but when I press “save” or “save and close” the screen redirect to the Joomla “Global Configuration” screen and doesn’t save any permissions. - I buy “ACL Manager” Plugin and Tried to give access for a specific user group but permission not saved.
Solution:
Go to Joomla Database then select “jom_assets” Table and view “Structure” Checked “rules” Column then Edit Type and change “varchar” to “longtext” then select “com_civicrm” from name column and look at rules column you will see in side rules column array data are not closed properly:
{"core.admin":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"core.manage":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"civicrm.add_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_deleted_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.import_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_uploaded_files":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings_and_forms":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_create":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_edit":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_view":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_custom_data":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_dashboard":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.translate_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_tagsets":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_tags":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_dedupe_rules":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.merge_duplicate_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_debug_output":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_notes":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_ajax_api":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_reference_fields":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.create_manual_batch":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_contributions":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.make_online_contributions":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_memberships":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicampaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.manage_campaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.reserve_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.release_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.interview_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.gotv_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.sign_civicrm_petition":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_pledges":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail_subscribe_unsubscribe_pages":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_public_civimail_content":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civireport":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_report_criteria":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_grants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_my_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.add_cases":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civievent":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_event_participants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_events":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.register_for_events":{"1":1,"2":1,"6":1,"9":0,"10": // here you can see array for CiviCRM rules data are not completed
Now you have to copy this incomplete array data then fix them with proper permission with all civicrm table. then save it. do it carefully after fix it will looks like below:
{"core.admin":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"core.manage":{"6":1,"9":0,"10":0,"11":0,"12":0,"13":0,"14":0},"civicrm.add_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_deleted_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.import_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_uploaded_files":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings_and_forms":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_listings":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_create":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_edit":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.profile_view":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_custom_data":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_dashboard":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.translate_civicrm":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_groups":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_tagsets":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_tags":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_dedupe_rules":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.merge_duplicate_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_debug_output":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_notes":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_ajax_api":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_contact_reference_fields":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.create_manual_batch":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_own_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.export_all_manual_batches":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_contributions":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.make_online_contributions":{"1":1,"2":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicontribute":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_memberships":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimember":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicampaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.manage_campaign":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.reserve_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.release_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.interview_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.gotv_campaign_contacts":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.sign_civicrm_petition":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_pledges":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civipledge":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civimail_subscribe_unsubscribe_pages":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civimail":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_public_civimail_content":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civireport":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_report_criteria":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reserved_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_reports":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_grants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civigrant":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.administer_civicase":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_my_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_all_cases_and_activities":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.add_cases":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.access_civievent":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_event_participants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.edit_all_events":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.register_for_events":{"1":1,"2":1,"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_event_info":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.view_event_participants":{"6":1,"9":0,"10":0,"11":0,"12":0},"civicrm.delete_in_civievent":{"6":1,"9":0,"10":0,"11":0,"12":0}}
// here you can see i have completed Array data for Rules successfully.
{"6":1,"9":0,"10":0,"11":0,"12":0} // this is user group access permission data
//when you set your own permissions you have to follow your own permission data copied from table column.
Now go to CiviCRM >Administer> User And Permission> Permissions (Access Control) > Joomla Access Control and try to give access. You can see now access permissions are save properly.
Note: This solution for mid and advanced level Joomla user who have clear knowledge about Joomla.