CiviCRM Community Forums (archive)

Hi All,

Here's my situation. I'm running CiviCRM v3.2.2 on Drupal on a 1and1 host to which I have ssh access. I have a site_key configured and cronjobs set up for civimail.cronjob.php and CiviMailProcessor.php. Cron was working perfectly for months until I recently updated to v3.2.2 and now I get strange errors when attempting to run either of the php scripts above.

My cron commands are set up to run as follows:
*/10    *       *       *       *       wget -O - -q -t 1 --post-data='name=USER&pass=PASS&key=SITE_KEY' http://www.atyourpalate.com/drupal-6.6/sites/all/modules/civicrm/bin/civimail.cronjob.php
*/15    *       *       *       *       wget -O - -q -t 1 --post-data='name=USER&pass=PASS&key=SITE_KEY' http://www.atyourpalate.com/drupal-6.6/sites/all/modules/civicrm/bin/CiviMailProcessor.php

When attempting to do this from shell or from a browser (http://www.atyourpalate.com/drupal-6.6/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=USER&pass=PASS&key=SITE_KEY) I get the following result:
ERROR: Invalid username and/or password

I've tried creating a new drupal user, synced to a civicrm contact record, and even generated a new site key and resulted in the same error.

I am able to successfully log in to the drupal account with the new username and password. I am at a loss as to how to fix this. PLEASE! ANYONE! HELP!!!

Yes, I pasted the exact content of my crontab. I am indeed using the single-quote (') around the post-data information.

Even if I were to rework the wget command to look like this:

wget -O - -q -t 1 'http://www.atyourpalate.com/drupal-6.6/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=USER&pass=PASS&key=SITE_KEY'
It still results in the following message:
ERROR: Invalid username and/or password

Any ideas?!

Is this a new ACL that needs to be configured from previous versions? Where can I find these settings?

It used to work in CiviCRM 3.1 just fine. The username has access to all the civicrm module items. No special characters in the key or password either. It's all alphanumeric. I even updated my drupal installation and that didn't seem to work either.

Any ideas? At this point, I'm thinking of doing a fresh install and migrating the DB.....

Can you try adding the ‘edit all contacts’ permission? This was just reported: http://forum.civicrm.org/?topic=15472.msg66839#msg66839

The original username and password I was using had ALL permissions, including Access CiviCRM, Access CiviMail and Edit All Contacts. I created a new user with a new role called CiviCron which ONLY has permissions for Access CiviCRM, Access CiviMail and Edit All contacts.

Also, do check whether you can actually login (by hand) with the credentials passed to wget.

I was successfully able to login with the new user credentials manually, however, when running wget on the command-line, I get the same error as before. So...no luck....weird.....

Stab in the dark, as you seem to have shell access with php-cli:
cd civicrm root;
php5 bin/civimail.cronjob.php -u user -p password -s yoursite.org

What does it says?

X+

Ok....this is interesting...this is the error I got:

X-Powered-By: PHP/5.2.14
Content-type: text/html

<br />
<b>Warning</b>:  require_once(bin/cli.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/homepages/29/d100263672/htdocs/wsb3626572001/drupal-6.6/sites/all/modules/civicrm/bin/civimail.cronjob.php</b> on line <b>67</b><br />
<br />
<b>Fatal error</b>:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'bin/cli.php' (include_path='.:/usr/lib/php5') in <b>/homepages/29/d100263672/htdocs/wsb3626572001/drupal-6.6/sites/all/modules/civicrm/bin/civimail.cronjob.php</b> on line <b>67</b><br />

Hoping this means I'm on the road to debugging......

--S

Ok...some more weirdness....I looked at line 67 again in civimail.cronjob.php and noticed that it's looking for bin/cli.php even though cli.php is in the same directory as civimail.cronjob.php. So, I removed the "bin/" prefix so that it just pointed to cli.php and then I got a NEW error on line 97 in cli.php which is in the middle of the following function:
function setEnv() {
// so the configuration works with php-cli
$_SERVER['PHP_SELF' ] ="/index.php";
$_SERVER['HTTP_HOST']= $this->site;
require_once ("./civicrm.config.php");
          $this->key= CIVICRM_SITE_KEY;
$_REQUEST['key']= $this->key;
    }Line 97 is where it says require_once ("./civicrm.config.php"); However, I don't think there IS a civicrm.config.php. I do have a civicrm.settings.php in my ../sites/default directory though which includes the site key.....

Any ideas?

Just upgraded to CiviCRM v3.2.3 from v3.2.2 and it still gives me the same "ERROR: Invalid Username and/or password"

*sigh*

--S