So I have this rsync script I wrote to grab some sql files and import them to a database. I left in the mysql stuff just give context to the situation. The real problem is with my rsync code.
script.sh (chmod 744)
Code:
#!/bin/sh
rsync -av --rsh="sshpass -p'PASSWORD' ssh -l'USERNAME'" WEBSITE.com:/PATH/TO/RSYNC/REMOTE /PATH/TO/RSYNC/LOCAL
tables=(TABLE1 TABLE2)
for name in ${tables[@]}
do
mysql -u'USER' -p'PASSWORD' DBNAME < PATH/TO/SQLFILES/$name.sql
done
My cron looks like this ...
Code:
0 * * * * /PATH/TO/SCRIPT/script.sh
Here's the problem. When I execute the script in bash, it works fine. But my cron job returns these errors
Code:
rsync: Failed to exec sshpass: No such file or directory (2)
rsync error: error in IPC code (code 14) at pipe.c(84) [receiver=3.0.6]
rsync: connection unexpectedly closed (0 bytes received so far) [receiver]
rsync error: error in rsync protocol data stream (code 12) at io.c(600) [receiver=3.0.6]
I don't get it, why would the script work in bash but not in cron ? What am I doing wrong ?
Hi there:
I run rsync very well by typing:
rsync -avz /source /destination
Then I want to run it by cron. So I had a crontab file like this:
* * * * * rm file
* * * * * rsync -avz /source /destination > cron_result
(The first line is used to test whether cron is working.)
When I check... (0 Replies)
I've got a ksh script that works like a charm when I run it manually. When I set it up in a cron, I keep getting this error in my log:
syntax error at line 90: `$' unexpected
Here's my snippet of code starting at line 90:
while ]
do
sleep 900
done
What's the... (5 Replies)
Hi,
I am running a rsync via cron job.
Its running fine and is scheduled to 9:00 AM everyday.
Sometimes it runs for more than 24 hours, such that the next days cron also fires.
Now how will the sync happen as the <sync file> that both crons have created might conflict.
Thanks (5 Replies)
I set up a cron job to FTP to another machine. If I have not logged in before the time the cron is set to run, then the ftp program won't connect. I have run this cron on other boxes (diff networks) and it works fine...it is just this one. If anyone has any suggestions as to what would be... (5 Replies)
Hi,
I've created a cron job for a script with a rsync command in it. The script is named pull.sh and contains the following line :
What it is supposed to do is pull backup files from the production server of my company to my local server. It should also generate the log file (output.log)... (1 Reply)
Good morning,
The script below without the hilited text successfully FTPs the files in question to the other server when it is called from the crontab. I don't want to establish an FTP connection when there are no files so I tried including the hilited lines to only establish an FTP connection... (6 Replies)
/usr/bin/find $SEARCH_DIR -daystart \( \( -name 'KI*' -a -name '*.csv' \) -o -name '*_xyz_*' \) -mtime $DAYS_AGO -printf %f -printf "\n" | sort -r > $FILES
The above command gives different results when run on a cron job. When run manually the result is accurate. (2 Replies)
Ubuntu 9.10 is my linux distro
Based on forums they say that the problem is with environment .
here is my case:
login as user, then sudo -s
using this command: s3cmd put file s3://bucket >>worked!
now here is the simple script intended for testing:
#! /bin/bash
env >/tmp/cronjob.log... (1 Reply)
Hi All,
I have a many cron jobs scheduled in my AIX server.
Only one cron not getting executed in the same server but that job is good on all other servers.
Here is my cron , which will keep last 30 files and remove others.,
00 00 * * * /usr/bin/find /tmp/reports/nmon -name *.nmon -mtime... (9 Replies)
Hello gurus,
I am making what I think is a simple db2 call from within a shell script but I am having difficulty producing the desired
report when I run the script shown below from a shell script in cron. For example, my script and the crontab file setup
is shown below:
#!/bin/ksh
db2... (3 Replies)
Discussion started by: okonita
3 Replies
LEARN ABOUT DEBIAN
dtc-xen_migrate
dtc-xen_migrate(8) System Manager's Manual dtc-xen_migrate(8)NAME
dtc-xen_migrate - migrate a VPS to another Xen server
SYNOPSIS
LOCAL_VPS_ID DESTINATION_HOSTNAME [ DEST_VPS_ID ]
DESCRIPTION
dtc-xen_migrate This shell script is a part of the dtc-xen package that is to be used by the dtc panel to manage a Xen VPS server. Note
that you need rsync in both the source and the destination dom0.
This script is used to move the content of a Xen virtual machine (VM) managed with dtc-xen to another Xen server of the same type. The VM
destination will first be prepared, then the local VM will be shut down, then it's content will be transfered over using rsync.
Note that this is NOT a live migration, and down time of approximatively the time needed for the rsync will occure.
PARAMETERS
LOCAL_VPS_ID The DTC-Xen id of the VM, from 00 to 99.
DESTINATION_HOSTNAME Destination Xen server hostname to migrate to.
DEST_VPS_ID Destination DTC-Xen id of the VM, from 00 to 99.
EXAMPLE
dtc-xen_migrate 19 alpha.example.com 21
This will migrate the content of xen19 on the local machine to the destination server alpha.example.com using xen21 as VM name.
SEE ALSO dtc_reinstall_os(8), dtc_kill_vps_disk(8)dtc-xen_migrate(8)
11-23-2011
