Cron job and 1and1

derivativemedia

Followed instructions here to a T:

http://faq.1and1.com/scripting_languages_supported/cron_jobs/3.html

Cron still not working with the provided script/code in my sendy account. Any ideas?

derivativemedia

do I have to wrap my cron command in a php tags?

derivativemedia

or instead of 'php' in both command and job, use 'usr/bin/php' ?

Ben

Please check with your host if your CRON command is correct.

derivativemedia

CRON is running according to my host, but for some reason I keep getting the CRON setup popup in my campaign editor.

Ben

If CRON is running properly, it would execute the script and change the 'cron' column in 'login' table to 1. Thus eliminating the CRON setup popup. If the script is not executed by CRON, you'll keep getting the CRON setup popup.

What is your CRON command? Does it start with php or curl?

derivativemedia

Mine is:

php /path/to/your/sendy/installation/scheduled.php > /dev/null 2>&1

derivativemedia

I've even manually executed the command and there is no change

Ben

@derivativemedia when you visit http://your_sendy_installation/scheduled.php do you still get the cron setup instruction modal window?

derivativemedia

Ben, I just visited my http://your_sendy_installation/scheduled.php and now the cron setup instruction modal disappeared. Am I set? Also, does the cron script get rid of the timeout issue I experience with each send?

Ben

@derivativemedia If visiting the scheduled.php script directly removes the modal window, then cron is not set up correctly.

If cron was set up correctly, cron will execute the scheduled.php script, hence changing the value to '1' in the column, 'cron', in 'login' table. This tells Sendy cron has been set up correctly.

Please access your database and change the value back to '0' in the column, 'cron', in 'login' table. Then consult your host on why cron isn't executing your script.

derivativemedia

Ben, odd -- still listed at 0 in the 'cron' column in the 'login' table in the DB..

Ben

@derivativemedia yeah that's odd, cron is 0 but modal window disappeared?

derivativemedia

yes, unless I'm reading the table wrong in phpmyadmin

derivativemedia

now no emails will send for some reason, stuck in pending

derivativemedia

Used this: ALTER TABLE `login` CHANGE `cron` `cron` INT( 11 ) NULL DEFAULT '0' Still no go.

derivativemedia

found it.. had to edit the cron value under the user ID

derivativemedia

appears to be working. I had to change my local path to PHP to ../../php5 and it worked. Is there any harm in leaving the cron job to 1 min intervals or is 5 fine?

Ben

@derivativemedia Glad you got it working. Please set to 5 mins otherwise scheduled emails may not work correctly.

derivativemedia

Ok. Also I seem to keep having the timeout issue. One camapign just stopped (even with CRON working now) and I had to manually resume. Is there something else going on here?

Ben

@derivativemedia - are you on 1and1 shared server?

derivativemedia

@Ben -- I am on a managed dedicated server