cronjob does not execute a script that works fine standalone

Question

I have my php script file in /var/www/html/dbsync/index.php. When cd /var/www/html/dbsync/ and run php index.php it works perfectly. I want to call PHP file through sh file, the location of SH file is as below This is the content of the dbsync.sh file is: When I cd /var/www/html/dbsync/ and run ./dbsync.sh it works perfectly as well. Now if I set

Accepted Answer

As seen in comments, the problem is that you are not defining what program should be used to execute the script. Take into account that a cronjob is executed in a tiny environment; there, not much can be assumed. This is why we define full paths, etc.So you need to say something like:1 * * * * /bin/sh /var/www/html/dbsync/dbsync.sh /var/www/html/dbsync#         ^^^^^^^/bin/sh being the binary you want to use to execute the script.Otherwise, you can set execution permissions to the script and add a shell-script header telling it what interpreter to use:#!/bin/shIf you do this, adding the path of the binary is not necessary.From Troubleshooting common issues with cron jobs:  Using relative paths. If your cron job is executing a script of some  kind, you must be sure to use only absolute paths inside that script.  For example, if your script is located at /path/to/script.phpand  you&#8217;re trying to open a file called file.php in the same directory,  you cannot use a relative path such as fopen(file.php). The file must  be called from its absolute path, like this: fopen(/path/to/file.php).  This is because cron jobs do not necessarily run from the directory in  which the script is located, so all paths must be called specifically.Also, I understand you want to run this every minute. If so, 1 * * * * won&#8217;t do. Intead, it will run at every 1st minute past every hour. So if you want to run it every minute, say * * * * *.

Advertisement

Answer