Execute scheduled rules as super admin instead of Anonymous [#1793862]

Is there anyway to do this? I have a daily email sent out to site administrators that contains an embedded view of a content type that is only accessible by the admin role. Since the scheduler apparently executes the rule as Anonymous, all that is generated in the email is the default empty text for the view. Making the content type accessible to everyone fixes the problem, but is not really a solution in this case since it could contain personal data.

Comments

Comment #1

tevans CreditAttribution: tevans commented 27 September 2012 at 23:37

Status:

Closed (fixed)

» Active

It took some digging, but I figured it out. The problem is that in D7, cron is always run as "anonymous", so I had to update the PHP code in the message field to impersonate the super user before embedding the view, then switch back to "anonymous" afterwards:

<?php
  global $user;
  $original_user = $user;
  $old_state = drupal_save_session(FALSE);
  $user = user_load(1);

  $view = views_get_view('interactions' , TRUE);
  $views_result = $view->preview('block_1');
  $output = drupal_html_to_text($views_result);
  print $output;

  $user = $original_user;
  drupal_save_session($old_state);
?>

Comment #2

tevans CreditAttribution: tevans commented 27 September 2012 at 23:36

Status:

Active

» Closed (fixed)

Comment #3

timjh CreditAttribution: timjh commented 12 October 2012 at 13:27

Status:

Active

» Closed (fixed)

I have a very similar problem, and your solution may work for me, if I were to understand it. Could you please explain where exactly you put the PHP code above?

Comment #4

tevans CreditAttribution: tevans commented 12 October 2012 at 17:23

Sure. Add one of the following actions to your rule or component:

Send mail
Send mail to all users of a role

On the configuration screen for the action, there is a section labeled "Message". Put your code inside the value field in this section. If I recall correctly, you need to have the PHP filter module from Drupal core enabled for the PHP to be evaluated. You should see a "PHP Evaluation" section inside the "Message" section if it is enabled.

Comment #5

timjh CreditAttribution: timjh commented 12 October 2012 at 17:54

Ha! I didn't have PHP filter enabled. All is now clear. Many thanks.

Comment #6

timjh CreditAttribution: timjh commented 15 October 2012 at 15:07

Following recommendations, I have PHP filter restricted to administrator use only. Yet it works for anonymous user when invoked by Rules Scheduler!

Presumably Rules Scheduler impersonates the administrator in order to run PHP filter, but not when executing the filtered code (why not?). It must also impersonate the administrator for other rules actions not normally available to an anonymous user, such as publishing or unpublishing a node.

Comment #7

museumboy CreditAttribution: museumboy commented 2 February 2016 at 15:19

Issue summary:

View changes

I'm trying to do the exact thing as TEVANS. The PHP code did not work for me, but gave an out of memory error. I'm wondering if after 3 years a better way has come along.