Avatar of webdesigner_dk
webdesigner_dk

asked on 

Cron Job that runs php script every hour

Hi,

I need help setting up a cron job on a server. The purpose of the cron job is to run a php script every hour. The script deletes the contents of some tables in a mySQL database.

I have tried to use the following (from this tutorial):

curl -s -o /dev/null http://www.domain.com/cleanup.php?clean=log

Even though the script runs nicely if I run it from a browser manually, the cron job doesn't run the script.

I have another cron job that works:

php -f /var/www/domain.com/public_html/shell/indexer.php -- reindexall >/dev/null 2>&1

I don't have access to the cPanel, so I have to tell my web hosting company to set up the job on the server.

Thanks!

Dio
Scripting LanguagesLinuxApache Web Server

Avatar of undefined
Last Comment
webdesigner_dk
Avatar of omarfarid
omarfarid
Flag of United Arab Emirates image

Look into the following when running a crontab job:

1- set the env. variables for the script to run
2- use full pathnames to files and dirrctories
3- redirect output and errors to files that you can check later.
4- specify the shell to use to run the script with.

Do you get any errors while running the crontab job?
Avatar of webdesigner_dk
webdesigner_dk

ASKER

Thanks for the answer. I get this in the log:

Sep 11 18:05:01 prod9 /USR/SBIN/CRON[18161]: (root) CMD (curl -s -o /dev/null http://www.domain.com/cleanup.php?clean=log)

Any ideas?
Avatar of omarfarid
omarfarid
Flag of United Arab Emirates image

I think this means the job was run at that time

but did you try to put the command in a shell script with setting env. variables etc?
ASKER CERTIFIED SOLUTION
Avatar of webdesigner_dk
webdesigner_dk

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of webdesigner_dk
webdesigner_dk

ASKER

My web hosting company managed to solve the problem. They didn't give any details though.
Linux
Linux

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

71K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo