Script runs manually but not from cron

Question

As per the monitoring of my mysql replication status. I wrote a simple shell script with the following code

#!/bin/bash
date > /tmp/mysql_repl_status.txt
cd /usr/bin/
"/usr/bin/mysql" "-e" "SHOW SLAVE STATUS \G" >> /tmp/mysql_repl_status.txt
mail -s "Netspective MySQL replication status" name@abc.com < /tmp/mysql_repl_status.txt

The issue is when i execute this script manually it works fine, but using cron the script not works.

Using cron got the mail with the output of date command only. What is wrong with my side?

In serverfault there is a generic answer to this issue....is there one in this SE for this problem? — mdpc, Jun 19 '14 at 16:57
@mdpc There's a summary in the tag wiki. I can find one answer that mentions shell, environment and percent: http://unix.stackexchange.com/questions/47941/whats-wrong-with-these-two-cron-jobs/48005#48005 — Gilles 'SO- stop being evil', Jun 19 '14 at 22:05

score 4 · Answer 1 · edited Jun 19 '14 at 22:08

4

Several possibilities:

Cron doesn't pass a full user environment to scripts run under cron. So vars like $PATH can be different running under cron than running in a user terminal.
Cron requires a newline at the end of every line, so always keep a blank line at the end of the crontab file.

Maybe specify the full paths in the script, and see if that works to start with.

#!/bin/bash
statfile=/tmp/mysql_repl_status.txt
/bin/date > $statfile
cd /usr/bin
/usr/bin/mysql -e "SHOW SLAVE STATUS \G" >> $statfile
/bin/mail -s "Netspective MySQL Replication Status" name@abc.com < $statfile

edited Jun 19 '14 at 22:08

Gilles 'SO- stop being evil'

829,060

answered Jun 19 '14 at 13:38

Tim Kennedy

19,697

1

Quoting the path to a command (point 3) is not an issue. It's how you run a command with spaces or other special characters (which should never happen in a sensible system, but you know). – l0b0 Jun 19 '14 at 13:53
I would also add 2>&1 to the end of the mysql command line to pick up any error messages. – doneal24 Jun 19 '14 at 18:57
@DougO'Neal It would be better to configure mail properly so that cron's email doesn't get lost. If a cron job emits anything on stdout or stderr, cron sends the output in an email. – Gilles 'SO- stop being evil' Jun 19 '14 at 22:06
The script is executed under bash, not under a “reduced shell”. And anyway cd /usr/bin is supported by all shells. – Gilles 'SO- stop being evil' Jun 19 '14 at 22:08
Sorry. I meant to say a reduced environment. Cron often doesn't run script with the same environment a user would get in an interactive shell. – Tim Kennedy Jun 20 '14 at 01:27

score 2 · Answer 2 · answered Jun 19 '14 at 13:55

Cron jobs are run with very little context. If you have a .my.cnf file in your home directory, that could contain the authentication details needed for the mysql command to work. You probably also need the full path to mail - see what which mail prints.

score 1 · Answer 3 · answered Jun 17 '17 at 10:54

Instead of writing full path for every command, it would be helpful to set PATH variable in the script file itself

#!/bin/bash
export PATH=/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
date > /tmp/mysql_repl_status.txt
cd /usr/bin/
"/usr/bin/mysql" "-e" "SHOW SLAVE STATUS \G" >> /tmp/mysql_repl_status.txt
mail -s "Netspective MySQL replication status" name@abc.com < 
/tmp/mysql_repl_status.txt`

score 0 · Answer 4 · edited Feb 12 '20 at 02:12

0

use bash -l -c

eg:

* * * * * bash -l -c '/dsds/fddfd/something.sh' > /tmp/something.log

edited Feb 12 '20 at 02:12

muru

72,889

answered Feb 11 '20 at 20:23

Indukuri Raju

1

Script runs manually but not from cron

4 Answers4

Linked