When I've needed to do something like this I've usually dome something like:
Code:
#get DB user password
stty -echo
trap "stty echo ; echo 'Interrupted' ; exit 1" 1 2 3 15
/usr/bin/echo "Enter password for userfoo account on barbar DB: "
read password
stty echo
#grab output and dump to temp file
isql -S Blah -U foo -P${password} -w 200 <<EOF > /tmp/tmp.$$ 2>&1
random sql query
and so on..
go
EOF
#check for errors/valid output and parse nicely or give error.
grep affected /tmp/tmp.$$ > /dev/null
if [ $? -eq 0 ]
then
Do whatever I'm going to do with my output
else
cat /tmp/tmp.$$
fi
rm /tmp/tmp.$$
I have the following line in my script:
$sftpcmd $rmthost <<COMMANDS>> $sftplog 2>&1
For some reason this is not capturing the errors from sftp, they go to the file attached to the cron entry
ie
mm hh dd MM * /myscript > cron.out
any idea why?
digital unix 4.0d (6 Replies)
I am trying to check to see if a file exists on a ftp server, well, I know that cant be done, atleast directly, So I came up with this small script
ftp -n $HOST <<END_SCRIPT
quote USER $USER
quote PASS $PASSWD
cd public_html/crap
dir $FILE
quit
END_SCRIPT
Where the $ variable... (2 Replies)
Hi all,
I did some searching in this forum but can't find anything that matches the issue I'm bumping heads with.
On a CentOS4/Postfix (and bash everywhere) mail gateway box I run a command periodically to purge the Postfix queue of messages "From:MAILER-DAEMON".
This is the one line'r... (6 Replies)
Hi All,
I was able to connect to sybase in shell script and also able to run few sql queries, something like this,
#!/usr/bin/ksh -x
temp=`echo "select name from sysobjects where type = 'U'"`
results=`isql -SDS_SERVER-UAdhocUser -Pha12 <<EOF
set rowcount 6
$temp
go
EOF`
line_count=0... (1 Reply)
I have a TCL script that logs into a switch using expect.I send a command "show port-security address" and it returns a table having a large number of rows.I need to capture this output(the table) and store it in a .txt file.
I have done this:
match_max 5000
set expect_out(buffer) {}
set... (0 Replies)
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Hi guys
I am calling one DB2 stored proc through unix. It is giving me below output. I want to capture the value 150 in one UNIX variable in shell script. Please let me know how I can achieve this. Thanks in advance
Value of output parameters
--------------------------
Parameter Name :... (5 Replies)
match_max 500000
set timeout 30
set outcome1 {}
set outcome2 {}
set inputfile C:\\Users\\Administrator\\Desktop\\inputfile.txt
send -i $con "\r";
expect -i $con "Desktop>" {
exp_send "type $inputfile \r"
}
set timeout 30
expect {
"Desktop>" { set outcome $expect_out(0,string);}... (3 Replies)
Discussion started by: cityprince143
3 Replies
LEARN ABOUT DEBIAN
apache::session::lock::sybase
Apache::Session::Lock::Sybase(3pm) User Contributed Perl Documentation Apache::Session::Lock::Sybase(3pm)NAME
Apache::Session::Lock::Sybase - Provides mutual exclusion using Sybase
SYNOPSIS
use Apache::Session::Lock::Sybase;
my $locker = new Apache::Session::Lock::Sybase;
$locker->acquire_read_lock($ref);
$locker->acquire_write_lock($ref);
$locker->release_read_lock($ref);
$locker->release_write_lock($ref);
$locker->release_all_locks($ref);
DESCRIPTION
Apache::Session::Lock::Sybase fulfills the locking interface of Apache::Session. Mutual exclusion is achieved through the use of Sybase's
sp_getapplock and sp_releaseapplock functions. Sybase does not support the notion of read and write locks, so this module only supports
exclusive locks. When you request a shared read lock, it is instead promoted to an exclusive write lock.
CONFIGURATION
The module must know how to connect to your MySQL database to acquire locks. You must provide a datasource name, a user name, and a
password. These options are passed in the usual Apache::Session style, and are very similar to the options for
Apache::Session::Store::Sybase. Example:
tie %hash, 'Apache::Session::Sybase', $id, {
LockDataSource => 'dbi:sybase:database',
LockUserName => 'database_user',
LockPassword => 'K00l'
};
Instead, you may pass in an already opened DBI handle to your database.
tie %hash, 'Apache::Session::Sybase', $id, {
LockHandle => $dbh
};
AUTHOR
This module was written by Oliver Maul <oli@42.nu>.
SEE ALSO
Apache::Session
perl v5.10.1 2010-10-18 Apache::Session::Lock::Sybase(3pm)