a cron problem

mehlwurm@rocketmail.com · *nix forums beginner Joined: 30 May 2006 Posts: 17

in /var/spool/cron/crontabs/root

00 2 * * * su dms -c /usr/users/dms/bin/2_secure_script

das Script:

#!/bin/sh
cd /usr/users/dms/bin
for db in `cat liste`
do
tar=""$db"_by_cron_`date +%d%h%y_%H%M`.tar"
rm -rf db_tmp_dir
mkdir db_tmp_dir
chmod 777 db_tmp_dir
cd db_tmp_dir
/usr/users/dms/bin/copydb -c $db /usr/dbms/ingres/bin/sql -f8F79.38 $db
< /usr/users/dms/bin/db_tmp_dir/copy.out
sed "s+`pwd`+.+" < /usr/users/dms/bin/db_tmp_dir/copy.in >
/usr/users/dms/bin/db_tmp_dir/new_copy.in
mv /usr/users/dms/bin/db_tmp_dir/new_copy.in
/usr/users/dms/bin/db_tmp_dir/copy.in
tar -cf $tar *
chmod 777 $tar
gzip -9 $tar
mv "$tar".gz /usr/users/dms/backup/BY_CRON
cd ..
rm -rf db_tmp_dir
done
exit

funktioniert

THX an alle !

mehlwurm@rocketmail.com · *nix forums beginner Joined: 30 May 2006 Posts: 17

i have done some changes, but it still doesn´t work :-(

-=start of the new scipt=-

more 2_secure_script
#!/bin/sh

##########################################
## ##
## Scirpt zum Sichern von DB's ##
## ##
##########################################
## ##
## Autor: M. Wilke ##
## Datum: 26.04.2006 ##
## Version: 1.2 ##
## ##
##########################################
#
# In der Datei "liste" sind die zu sichernden DB's anzugeben
#

cd /usr/users/dms/bin

dir=`pwd`
for db in `cat liste`
do
tar=""$db"_by_cron_`date +%d%h%y_%H%M`.tar"
rm -rf db_tmp_dir
mkdir db_tmp_dir
chmod 777 db_tmp_dir
cd db_tmp_dir
touch copy.out
touch copy.in
touch new_copy.in
chmod 777 copy.in
chmod 777 copy.out
chmod 777 new_copy.in
/usr/users/dms/bin/copydb -c $db
chmod 777 copy.in
chmod 777 copy.out
chmod 777 new_copy.in
sql -f8F79.38 $db < /usr/users/dms/bin/db_tmp_dir/copy.out
chmod 777 copy.in
chmod 777 copy.out
chmod 777 new_copy.in
sed "s+`pwd`+.+" < /usr/users/dms/bin/db_tmp_dir/copy.in >
/usr/users/dms/bin/db_tmp_dir/new_copy.in
chmod 777 copy.in
chmod 777 copy.out
chmod 777 new_copy.in
mv /usr/users/dms/bin/db_tmp_dir/new_copy.in
/usr/users/dms/bin/db_tmp_dir/copy.in
chmod 777 copy.in
chmod 777 copy.out
chmod 777 new_copy.in
tar -cvf $tar .
chmod 777 $tar
gzip -9 $tar
mv "$tar".gz /usr/users/dms/backup/BY_CRON
cd ..
rm -rf db_tmp_dir
done
exit

-=end of the new scipt=-

and there is a new error mail ->

mehlwurm@rocketmail.com · *nix forums beginner Joined: 30 May 2006 Posts: 17

Hi,

I have trouble with a cron job, which should save a database.
I wrote a script (attached) and it works, if I start it, but if cron
wants to start it I get the .tar.gz file but it is just 176KB and not
5000KB :-(

I don´t know where the problem can be ... have asked in many forums
and
a lot of people ... i hope you can help me ...

the script:
<<<<
#!/bin/ksh
# In der Datei "liste" sind die zu sichernden DB's anzugeben ### in
liste are the names of the DB
#

set -x

cd /usr/users/dms/bin

dir=`pwd`
for db in `cat liste`
do
tar=""$db"_by_cron_`date +%d%h%y_%H%M`.tar"
rm -rf db_tmp_dir
mkdir db_tmp_dir
cd db_tmp_dir
/usr/users/dms/bin/copydb -c $db
sql -f8F79.38 $db < /usr/users/dms/bin/db_tmp_dir/copy.out
sed "s+`pwd`+.+" < /usr/users/dms/bin/db_tmp_dir/copy.in >
/usr/users/dms/bin/db_tmp_dir/new_copy.in
mv /usr/users/dms/bin/db_tmp_dir/new_copy.in
/usr/users/dms/bin/db_tmp_dir/copy.in
tar -cf $tar *
chmod 777 $tar
gzip -9 $tar
mv "$tar".gz /usr/users/dms/backup/BY_CRON
cd ..
rm -rf db_tmp_dir
done
env
exit

Google