Re: a cron problem

Mehlwurm wrote:
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



Looks like a csh is trying to execute it, despite the #!/bin/sh





*************************************************
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


Haven't followed this thread, sorry.

Is dms the user root should switch to,
and does dms have a csh login shell (passwd entry)?

I think the crontab entry should be

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

or maybe

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

or maybe

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

Assuming that /usr/users/dms/bin/2_secure_script
is the above script, and its very first line is
#!/bin/sh
it should run.

Regarding the script above:

The PATH= and LD_LIBRARY_PATH= lines only have an
effect if you add another line

export PATH LD_LIBRARY_PATH

--
Michael Tosch @ hp : com
.

Relevant Pages

  • tar or dump and restore commands on Compaq Tru64 UNIX or Unix - restore from tape?
    ... They have a script I assume that runs a backup tape every night of just one ... So no idea if they are using tar or dump. ... assuming their either are using a tar or dump command / script. ... a restore from a tar file assuming they are using tar. ...
    (comp.unix.admin)
  • 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.programmer)
  • 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. ... 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)