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 CiviReport (Moderator: Dave Greenberg) »
  • Cron Mail Report using wget permissions error
Pages: [1]

Author Topic: Cron Mail Report using wget permissions error  (Read 2062 times)

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Cron Mail Report using wget permissions error
May 15, 2013, 09:56:39 am
After upgraded to 4.3.x from 4.2.x my wget cron job no longer works. I get access denied. I even made that user an administrator and they still can't run the report. When I run the report via "Execute Now" it works just fine. Is anyone else having a similar issue?
-justin

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: Cron Mail Report using wget permissions error
May 15, 2013, 11:42:06 am

might want to fill out your forum profile and add your cms name and version

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

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Cron Mail Report using wget permissions error
May 15, 2013, 12:34:03 pm
Thanks Lobo, profile updated.

Civi 4.3.2
Drupal 7.22
PHP 5.3
MySQL 5.1
-justin

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: Cron Mail Report using wget permissions error
May 15, 2013, 12:56:05 pm

can u cut-n-paste your the cron line u use. You can suppress the host name. what report instance r u using and trying to get mailed

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

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Cron Mail Report using wget permissions error
May 15, 2013, 01:11:17 pm
0 0 * * * wget -O - -q -t 1 'http://XXXXXXXXX.com/sites/all/modules/civicrm/bin/cron.php?job=mail_report&instanceId=39&format=csv&name=USERNAME&pass=PASSWORD&key=XXXXXXXXXXXXXXXXXXXXXX'

It's the Mail Reports (Daily) instance. It worked before upgrading to 4.3 and I have an Identical report working on another site running 4.2. In the cron logs I get "error (grandchild #27974 failed with exit status 8)" If I run wget directly from command line with degbug on I get "HTTP/1.0 403 Forbidden" in the response.
-justin

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: Cron Mail Report using wget permissions error
May 15, 2013, 01:43:26 pm

both the errors dont seem to be related to civicrm, but some other system issues

we'll test this locally and check

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

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Cron Mail Report using wget permissions error
May 15, 2013, 01:44:36 pm
Agreed, it doesn't even seem to be making it to civi at all. Thank you for checking.
-justin

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Cron Mail Report using wget permissions error
May 16, 2013, 07:43:57 am
Could you paste that link in your browser and see if that triggers the mail.

Make sure you have settings_location.php configured. Possible that during upgrade this file got removed ?

I tried on my local machine and it works.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Cron Mail Report using wget permissions error
May 16, 2013, 07:57:29 am
In my browser I get a 403 error. I don't have that file. However, that file doesn't exist on my 4.2 installation either, and that one works just fine.
-justin

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Cron Mail Report using wget permissions error
May 16, 2013, 09:27:02 am
Sounds like a apache / web-server configuration issue than civicrm. If you can get that url working (start triggering mail) would solve your problem.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Cron Mail Report using wget permissions error
May 16, 2013, 01:10:50 pm
Bah, I was wrong in my browser the URL works just fine. Only wget is having a problem. I found some reference to other people having a similar issue with using wget, but their solution to pass in the user agent hasn't worked for me here.
-justin

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Cron Mail Report using wget permissions error
May 16, 2013, 01:32:08 pm
Well, I got this to kind of work. I had to give Anonymous access to "CiviReport: access CiviReport" in the Drupal permissions section. I don't know why this works now. I don't have this access on my 4.2 site or on my other 4.3 site that works just fine without it. My guess at this point is some other module is getting in the way.
-justin

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: Cron Mail Report using wget permissions error
May 16, 2013, 06:15:58 pm

This might be related to:

http://issues.civicrm.org/jira/browse/CRM-12648

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

unclejustin

  • I post occasionally
  • **
  • Posts: 38
  • Karma: 2
  • CiviCRM version: 4.3.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Cron Mail Report using wget permissions error
May 17, 2013, 05:52:34 am
That sounds like it would do it. Thanks for the update.
-justin
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Cron Mail Report using wget permissions error

This forum was archived on 2017-11-26.