CiviCRM Community Forums (archive)

I believe I finally got the EmailProcessor.php file working.  It now connects successfully to a POP3 email account I have set up (though not one hosted on google apps, which I couldn't get working).  The status responds:

connecting to example.com and authenticating as bounce@example.com got to the end of the mailbox
I think this means I'm in good shape.

Onto problem 2: I can't get civimail.cronjob.php to work.

When I go to the url, http://example.org/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=myuser&pass=mypass&key=mykey, I get the following error:

Warning: require_once(bin/cli.php) [function.require-once]: failed to open stream: No such file or directory in /home/caseyeyr/logicbloc/sites/all/modules/civicrm/bin/civimail.cronjob.php on line 70

Fatal error: require_once() [function.require]: Failed opening required 'bin/cli.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/caseyeyr/logicbloc/sites/all/modules/civicrm/bin/civimail.cronjob.php on line 70

Any help would be appreciated.  I have access to shell, so ideally I'd like to set it up that way, but I'm a noob at this stuff and I've found the documentation to be confusing so far. I just can't get stuff working.

Webserver: Apache 2.2.17 (its on hostgator)

Don't know what you mean by fast cgi version.

This is the shell output from php -v:

$ php -v
PHP 5.2.15 (cli) (built: Dec 15 2010 12:26:49)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
    with the ionCube PHP Loader v3.3.20, Copyright (c) 2002-2010, by ionCube Ltd., and
    with Zend Optimizer v3.3.9, Copyright (c) 1998-2009, by Zend Technologies

Its the damnedest thing, it just started working.  Accessing the script via my browser still does not work (i.e., going to http://example.org/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=myuser&pass=mypass&key=mykey still results in the error I posted earlier), but if I run the following command in my shell it works fine:

php bin/civimail.cronjob.php -sdefault -umyusername -pmypassword
Perhaps I did something (changing file permissions maybe?) that made it work this time and not before.  I've spent like 15 hours trying to get this to work... hopefully now all I have to do is set up cron and it will be good.

Thank you for your help!

I set this up using my google apps email account... the port needed to be opened.  It works now.

?!?

Just to be sure: you do have bin/cli.php under your sites/all/modules/civicrm ?

Doesn't make sense to me. And the bin/civimail.cronjob.php should die with the error message instead of running silently anyway.

What's the log you are displaying ?

X+

I now have a similar issue. The civimail.cronjob.php completes without errors, and the mailing status changes to "Running" with the expected time listed in the "Started" column at http://example.org/civicrm/mailing/browse/scheduled.

However, the mailing doesn't actually get sent -- and the "Completed" column does not get filled in -- until I manually browse to http://example.org/civicrm/mailing/queue&reset=1

One thing to look at if you are still getting require_once(bin/cli.php) errors is the difference between php interpreters. Check my previous thread for more info on that (http://forum.civicrm.org/index.php/topic,18395.0.html).

Not sure if these issues are related or not though 

This is so strange... it is suddenly working again.

I was using my superadmin account (that did not have any privs explicitly checked in Drupal, but because it is a superadmin account it doesn't matter) to initiate civimail.cronjob.php in terminal.  I added the privileges you suggested and then suddenly it worked!  I thought I figured out the problem, so I unchecked all the privileges again and it still worked!  I am completely dumbfounded as to what the problem is.

Its sort-of working now... coming up with a cron error that I think you experienced, but I'm going to take a look at that now.

Thanks for the help!

Hi planigan,

Thanks for the tip.  My host wrote a little script for me that I can call from cron.  At first it wasn't working from cron (yet it was from the terminal).  This was caused by the CGI SAPI thing you were talking about.

Here's the working cron script, in case anyone else finds it useful:

#! /bin/sh

export PATH="/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin"

cd /home/USER/SITE/sites/all/modules/civicrm;

nice -n 19 php \
bin/civimail.cronjob.php \
-sdefault \
-uDRUPAL_USER_NAME \
-pDRUPAL_PASSWORD


cd /home/USER/SITE/sites/all/modules/civicrm; should be the full path to your civicrm directory, and replace DRUPAL_USER_NAME and DRUPAL_PASSWORD with your mailprocess drupal user account.

Thanks for your help!