Cronjob not execute sql script

Question

I have a script called install.sh. This script execute some others script. All work fine just he call a *.sql script. In this case call the script but exit without give an error but don't execute the sql script. Manually, if I call install.sh with an user, all script work correctly.

I create the cronjob with the same user as used to test manually.

Script:

#! /bin/bash
echo "start"
cd /path/to/script/install.sh
./install.sh
echo "End"

Cronjob:

01 01 * * * /full/path/to/start_script.sh

Check if all the environment variables are set correctly in your cron job. Usually cron jobs do not call the user's profile. — Hellmar Becker
– Hellmar Becker, Commented Feb 3, 2016 at 13:59
I know, I try to add the path into the script but nothing change. How I set the variables in my cronjob?? — andy89ch
– andy89ch, Commented Feb 3, 2016 at 14:02

Jay jargot · Accepted Answer · 2016-04-05 12:13:54Z

1

More trace are needed.

Could you modify your script to generate output in a log file?

#! /bin/bash
exec 1>>/tmp/debug.log
exec 2>>/tmp/debug.log
date "+%Y/%m/%d %H:%M:%S ====== S T A R T"
cd /path/to/script/install.sh
bash -x ./install.sh
date "+%Y/%m/%d %H:%M:%S ====== E N D"

Wait the next execution and use debug.log file to debug

edited Apr 5, 2016 at 12:13

answered Mar 9, 2016 at 17:29

Jay jargot

2,8881 gold badge13 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cronjob not execute sql script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related