CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • ACL Issues: civicrm_acl table and Assign Users to Role function
Pages: [1]

Author Topic: ACL Issues: civicrm_acl table and Assign Users to Role function  (Read 5894 times)

Alan.Guggenheim

  • Guest
ACL Issues: civicrm_acl table and Assign Users to Role function
January 30, 2010, 08:37:07 pm
My ACL list in "Assign Users to Role" page keeps growing with strange (incomplete) and many duplicate lines. Here is a sample:


ACL Role         Assigned To                  Enabled? 
                     Events: Administrator     Yes
                     Events: Administrator     Yes
                     Events: Administrator     Yes
                     Activism: Administrator    Yes
.........
.......
Administrator    Administrators                Yes
Data Entry       Data Entry                     Yes


The MySQL civicrm_acl seems to be the corresponding table. Any suggestions?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
January 31, 2010, 06:54:01 am

check your permissions and ensure that anon user does not have access to the "manage acl" screen

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Alan.Guggenheim

  • Guest
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
January 31, 2010, 07:17:37 am
Thanks, but I do not see where you see permissions for "Manage ACL screen": is it in Drupal or CiviCRM?
The manage ACL screen I found is in CiviCRM, and that one looks OK.

Alan.Guggenheim

  • Guest
ACL Issues: Assign Users to Role page error: time out, thousands of bad records
March 22, 2010, 10:05:21 am
Assign users to Roles has now thousands of "incomplete" lines.
The ACL Role column is empty, and the same Assigned to is repeated hundreds or thousands of times, making the page time out with a script running too lon error, and creating other problems.
How do I clean-up that mess? Is there a MySQL Table holding these and which one?
Is there an other way to clean-up?
How do we find and fix this bug?

Alan.Guggenheim

  • Guest
ACL Assign Users to Role function civicrm_acl_entity_role table keeps growing
March 22, 2010, 11:24:21 am
Lobo,
I went directly to MySQL. The table that seems to be holding these entries is civicrm_acl_entity_role ? I have currently 4,038 rows in it (Should have about 20)
Here is a sample:
3, 5, 'civicrm_group', 19, 1
19, 96, 'civicrm_group', 42, 1
79, 80, 'civicrm_group', 70, 1
102, 90, 'civicrm_group', 43, 1
104, 92, 'civicrm_group', 65, 1
106, 94, 'civicrm_group', 66, 1
112, 100, 'civicrm_group', 68, 1
131, 119, 'civicrm_group', 81, 1
139, 127, 'civicrm_group', 69, 1
141, 129, 'civicrm_group', 84, 1
142, 130, 'civicrm_group', 84, 1
143, 131, 'civicrm_group', 84, 1
144, 132, 'civicrm_group', 84, 1
145, 133, 'civicrm_group', 84, 1
146, 134, 'civicrm_group', 84, 1
147, 135, 'civicrm_group', 84, 1
148, 136, 'civicrm_group', 84, 1
149, 137, 'civicrm_group', 84, 1
150, 138, 'civicrm_group', 84, 1
151, 139, 'civicrm_group', 84, 1
152, 140, 'civicrm_group', 84, 1
153, 141, 'civicrm_group', 84, 1
154, 142, 'civicrm_group', 84, 1
155, 143, 'civicrm_group', 84, 1
156, 144, 'civicrm_group', 84, 1
157, 145, 'civicrm_group', 84, 1
158, 146, 'civicrm_group', 84, 1
159, 147, 'civicrm_group', 84, 1
160, 148, 'civicrm_group', 84, 1
161, 149, 'civicrm_group', 84, 1
162, 150, 'civicrm_group', 84, 1
163, 151, 'civicrm_group', 84, 1
164, 152, 'civicrm_group', 84, 1
165, 153, 'civicrm_group', 84, 1
166, 154, 'civicrm_group', 84, 1
167, 155, 'civicrm_group', 84, 1
168, 156, 'civicrm_group', 84, 1
169, 157, 'civicrm_group', 84, 1
170, 158, 'civicrm_group', 84, 1
171, 159, 'civicrm_group', 84, 1
172, 160, 'civicrm_group', 84, 1
173, 161, 'civicrm_group', 84, 1
174, 162, 'civicrm_group', 84, 1
175, 163, 'civicrm_group', 84, 1
176, 164, 'civicrm_group', 84, 1
177, 165, 'civicrm_group', 84, 1
178, 166, 'civicrm_group', 84, 1
179, 167, 'civicrm_group', 84, 1
180, 168, 'civicrm_group', 84, 1
181, 169, 'civicrm_group', 69, 1
182, 170, 'civicrm_group', 48, 1
183, 171, 'civicrm_group', 81, 1
184, 172, 'civicrm_group', 81, 1
185, 173, 'civicrm_group', 81, 1
186, 174, 'civicrm_group', 81, 1
187, 175, 'civicrm_group', 81, 1
188, 176, 'civicrm_group', 81, 1
189, 177, 'civicrm_group', 81, 1
190, 178, 'civicrm_group', 84, 1
191, 179, 'civicrm_group', 81, 1
192, 180, 'civicrm_group', 68, 1
193, 181, 'civicrm_group', 68, 1
194, 182, 'civicrm_group', 43, 1
195, 183, 'civicrm_group', 43, 1
196, 184, 'civicrm_group', 42, 1
197, 185, 'civicrm_group', 42, 1
198, 186, 'civicrm_group', 42, 1


Is is safe to delete all but one of each "entity_id" ?
What else do you need to debug?
This is undoubtly part of my performance issues and slowing down our system.
Thanks

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
March 22, 2010, 01:24:37 pm

seems like you have lots of ACL roles and hence lots of entries there. I'm not sure who's creating them/why/how etc

Maybe an issue with the CiviCRM OG Sync module? You'll need to investigate and figure things out. Please update the forum topic when u've found the cause

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Alan.Guggenheim

  • Guest
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
March 22, 2010, 02:11:37 pm
Lobo,
No, I have only 26 roles currently. Most of them come automatically from Drupal OG, correct. But that does not expalin why 4000+ half empty entries.
I agree with you that it looks like an issue with the CiviCRM OG Sync module. Aren't you in that team?
Is it best to contact them on CiviCRM forum or Drupal Forum?
Thanks

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
March 22, 2010, 02:34:21 pm

We maintain that module within the CiviCRM repository (was a result of some client work). However we are not active users of that module and we rely on community members like yourself to help investigate and fix issues as they find them.

Would be great if you can trace thru the code on your site and figure out whats happening and why. if you need help getting started, ping us on IRC

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Alan.Guggenheim

  • Guest
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
March 22, 2010, 02:40:31 pm
Sure do need help to get started, but I can try. See you on IRC.

Thanks

Alan.Guggenheim

  • Guest
Re: ACL Issues: civicrm_acl_entity_role table keeps growing with invalid records
April 08, 2010, 08:49:13 am
Was not lucky on the IRC.
My civicrm_acl_entity_role table is now over 9000 records! I need some help.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
April 08, 2010, 09:32:29 pm

might want to consider hiring someone from http://civicrm.org/professional/ to help investigate and fix the problem

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Alan.Guggenheim

  • Guest
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
April 09, 2010, 07:15:49 am
lobo,

Thanks, but as ayoung non profit, we do not have the budget to hire people. Do you know who did the module that manages the ACL functions for the drupal/civicrm integration? I assume it is part of the Organic group Synchronization, but I am not sure.
How do we find out?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
April 09, 2010, 03:37:51 pm

The core team did this work for a client (Democrats Abroad) in 1.9 or so. If you can find a volunteer in your organization willing to debug and figure out whats happening and why that would be great

At this point we have no idea what is happening with your setup and why.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Alan.Guggenheim

  • Guest
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
April 09, 2010, 05:14:38 pm
lobo,

We are building our team, and so far, we do not have anybody with php knowledge. If I get some (a bit specific) pointers, I can try to debug, but will need help.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: ACL Issues: civicrm_acl table and Assign Users to Role function
April 09, 2010, 09:21:10 pm

its normal php debugging. start off with the civicrm_og_sync.module and add debugging statements to the relevant hooks etc.

Definitely recommend that the person who tackles it knows PHP (or is willing to read the manual and learn as he goes)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • ACL Issues: civicrm_acl table and Assign Users to Role function

This forum was archived on 2017-11-26.