Re: a cron problem

the new script

-------------------------
#!/bin/sh






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






PATH=/usr/dbms/ingres/lib:/sbin/loader:/usr/users/dms/bin:/sbin:/usr/sbin:/usr/opt/jre142/bin:/usr/bin:/usr/bin/X11:/usr/ucb:/usr/local/bin:/usr/local/install/bin:/usr/dbms/ingres/bin:/usr/dbms/ingres/utility:/usr/users/dms/tools:.
II_SYSTEM=/usr/dbms
LD_LIBRARY_PATH=/lib:/usr/dbms/ingres/lib
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
---------------------------------------

the new error

# mail
From root Thu Jun 1 12:56:01 2006
Received: by vfedms id k51Cu1715875; Thu, 1 Jun 2006 12:56:01 GMT
Date: Thu, 1 Jun 2006 12:56:01 GMT
From: system PRIVILEGED account <root@vfedms>
Message-Id: <200606011256.k51Cu1715875@vfedms>



Warning: no access to tty; thus no job control in this shell...
stty: tcgetattr: Not a typewriter
stty: tcgetattr: Not a typewriter
Not a terminal
PATH=/usr/dbms/ingres/lib:/sbin/loader:/usr/users/dms/bin:/sbin:/usr/sbin:/usr/opt/jre142/bin:/usr/bin:/usr/bin/X11:/usr/ucb:/usr/local/bin:/usr/local/install/bin:/usr/dbms/ingres/bin:/usr/dbms/ingres/utility:/usr/users/dms/tools:.:
Command not found.
II_SYSTEM=/usr/dbms: Command not found.
LD_LIBRARY_PATH=/lib:/usr/dbms/ingres/lib: Command not found.
for: Command not found.
do: Command not found.
db: Undefined variable.
logout






*************************************************
Cron: The previous message is the standard output
and standard error of the following crontab command:



su - dms /usr/users/dms/bin/2_secure_script



? d

i would like to cry ....

.

Relevant Pages

  • Re: a cron problem
    ... for db in `cat liste` ... tar -cf $tar * ... for: Command not found. ... The previous message is the standard output ...
    (comp.unix.shell)
  • Re: a cron problem
    ... for db in `cat liste` ... tar -cf $tar * ... for: Command not found. ... Regarding the script above: ...
    (comp.unix.shell)
  • Re: a cron problem
    ... for db in `cat liste` ... tar -cf $tar * ... for: Command not found. ... and standard error of the following crontab command: ...
    (comp.unix.programmer)
  • Re: a cron problem
    ... for db in `cat liste` ... tar -cf $tar * ... stty: tcgetattr: Not a typewriter ... for: Command not found. ...
    (comp.unix.shell)
  • Re: ksh help: redirect standard error
    ... I try to capture all the errors from tar command, NOT standard output. ...
    (comp.unix.shell)