0

With Debian GNU/Linux 10 (buster), I'm using a simple script to save a PostgreSQL database and upload it to my Dropbox account with Dropbox-Uploader tool. I schedule this task with a crontab.

When I directly execute my script from the prompt everything is ok and well executed, but when it run from the crontab the upload action isn't execute (./dropbox_uploader.sh -d upload).

Am I missing something in execute permissions ?

The script (my_script.sh)

#!/bin/bash

# Database dump
pg_dump -U postgres -d my_database > /home/my_user/`date +%Y%m%d`_my_database.sql

# Upload to Dropbox
./dropbox_uploader.sh -d upload /home/my_user/`date +%Y%m%d`_my_database.sql `date +%Y%m%d`_my_database.sql

Permissions

 ls -l my_script.sh
-rwxr-xr-x 1 my_user my_user 732 Apr  7 09:19 my_script.sh

getfacl  my_script.sh
# file:  my_script.sh
# owner: my_user
# group: my_user
user::rwx
group::r-x
other::r-x

ls -l dropbox_uploader.sh
-rwxr-xr-x 1 root root 52481 Apr  6 16:01 dropbox_uploader.sh

getfacl dropbox_uploader.sh
# file: dropbox_uploader.sh
# owner: root
# group: root
user::rwx
group::r-x
other::r-x

Cron

0 9 * * * /bin/sh /home/my_user/my_script.sh

I have read this post and this post, but I think I'm missing something with dropbox_uploader.sh execution permissions.

Improve this question
3
  • 1
    Replace relative paths (./filename) with absolute paths (/path/to/filename) Commented Apr 7, 2021 at 8:00
  • If you've written a bash script (as suggested by your #!/bin/bash) don't call it with sh; either use bash or better still make it executable and just treat it as any other program Commented Apr 7, 2021 at 8:48
  • When I call it in the crontab ? What difference it makes ? I ask it for my own knowledge and to acquire good practices. Commented Apr 7, 2021 at 8:58

1 Answer 1

Reset to default
1

Modify your script and write the full path of the script dropbox_uploader.sh

#!/bin/bash
# Database dump
pg_dump -U postgres -d my_database > /home/my_user/`date +%Y%m%d`_my_database.sql

# Upload to Dropbox
/home/my_user/dropbox_uploader.sh -d upload /home/my_user/`date +%Y%m%d`_my_database.sql `date +%Y%m%d`_my_database.sql
Improve this answer
1
  • So obvious, how can I miss this ? Thanks. Commented Apr 7, 2021 at 8:07

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.