cron tab

phpprog

Hi all
I am setting up crontab for a php file to run once every day.
I set up the command in the txt file cronjobs like this

crontab cronjobs

the content of the cronjobs is

0 0 * /path to file

but it still gives the error that the file could not be found, though the file there in the directory. An I doing something wrong.
Please help

Thanks
IM

Chimera

Unless you set up PHP to be able to run scripts from the command line (a new feature in 4.2, and mostly disabled, but will be on by default in 4.3), then you can't do it. What I do is use wget in my cron jobs to execute a PHP script. Say your script is located at http://www.domain.com/test.php, then you just make your cron command "wget http://www.domain.com/test.php" and wget will execute the script, and return any output from the script into a file of the same name (test.php in this case).

phpprog

Thanks very much for the reply.

I have two questions
1. How do i check whether PHP is able to run scripts from command line.

If i use wget(), will there be any security issues, because in ths php script, I am connecting to the database and executing some queries.

Once again thanks
IM

Chimera

Read this article on PHP shell scripts...

http://www.phpbuilder.com/columns/jayesh20021111.php3

as for the wget question, your script has to be accessible from a web browser, since that's essentially what wget is. However, you could secure the script by making it only run when the IP of the user running it is the same as the server IP.