cronjob not working..

vivendi · 08-12-2009, 04:30 PM

Hello, i tried to add a cronjob, but for some reason it isn't working...

I want the cronjob to be executed every minute. So i added this line to my crontab:

* * * * * /usr/bin/php /var/www/em/test.php

I also tried to run the test.php file from the terminal manually. And the php file executed correctly. So there's no error in the php file.

<?php
mysql_connect("localhost", "****", "****");
mysql_select_db("testdb01") or die(mysql_error());

$insert = "INSERT INTO test (msg) VALUES ('blaat')";
mysql_query ( $insert ) or die ( mysql_error() );
?>

But the cron still isn't working... Anyone any idea what the problem might be..???

anomie · 08-12-2009, 04:40 PM

Check mail(1) for the user the cronjob is running as. By default, stdout/stderr from your cronjobs goes there.

vivendi · 08-12-2009, 04:50 PM

Quote:

Originally Posted by anomie

Check mail(1) for the user the cronjob is running as. By default, stdout/stderr from your cronjobs goes there.

I'm sorry, i really new to Linux so i'm not sure what you mean by mail(1)...
I didn't specify any email anywhere for the cronjob, if that's what you need to know.

Tinkster · 08-12-2009, 04:57 PM

Depending on your distro there's most likely a mail-server set-up
for local delivery of mail. If you have mail, mailx, nail, mutt,
pine, ... installed you should be able to read notifications from
cron regarding the output of your script.

Also check the relevant log-files under /var/log (again, it all
depends on your distro ;} ... may want to add that to your profile!
Hint, hint.)

grep -i cron /var/log/* for a first glimpse.

Cheers,
Tink

vivendi · 08-12-2009, 05:18 PM

I don't have any mail server running, so i dont receive any mails with errors.

I checked the logs with the cmd you gave and this is what i got (its not eveything but i think its enough info):

http://pastebin.com/me8ccbdd

It doesn't mean much to me, but maybe you can see any errors or something...

Oh, and i'm running the latest kubuntu (9.04).

Tinkster · 08-12-2009, 05:29 PM

Ok ... so *buntu have disabled local mail delivery; great :D

In that case, make it something like

Code:

* * * * * /usr/bin/php /var/www/em/test.php >> /tmp/cron_out 2>&1

vivendi · 08-12-2009, 05:40 PM

Quote:

Originally Posted by Tinkster

Ok ... so *buntu have disabled local mail delivery; great

In that case, make it something like

Code:

* * * * * /usr/bin/php /var/www/em/test.php >> /tmp/cron_out 2>&1

I feel like such an ass...

I checked the cron_out file and it said it couldn't find the file /var/www/test.php

I had the path wrong all the time cause it should've point to /var/www/em/test.php

But it works perfectly now

Thanks alot for you help!!