Hello,
We currently have a BASH script that runs and moves image files from a remote server to the local db server. A snippet of the code shows that we are picking up all Images that are 'mtime -1'
It's simple and it works.
Now, due to development requirements we need a way of picking up those images from different directories within the base directory of /u01/bea/madeup/Images. The plan is to have an 'index' table that will hold the location (path and filename) of the image file and it is this that I would like to read from the table and somehow use in place of the hard coded file path above.
Can I Just do something like this example: (This may work with some tweaking, but it gives you an idea of what i am trying to achieve).
Dear Friends,
Please help me to achieve the following:
I want to pass one parameter from Shell-script to Sql-script.
Example:
My ShellScript.sh is calling report.sql like this:
/bin/sqlplus /reports.sql
And
My report.sql is calling many Stored-Procedures like this:
exec... (0 Replies)
hi I all ,
I have sql statment in my shell script , I pass two argument to the script I need to pass the this two arguments to the sql statment
example :
runsql.sh "1" "2"
sql :
updat tables_x set y=0
where
A=:x should subsituted by "1"
and
B=:y shuold subsituted bt "2"... (1 Reply)
Hi guyz,
Posting a thread after a long time.
I want to pass two variables to unix shell script from sql script.
Note: I am calling sql script from unix script. sql script has 2 variables one is the return code for status of program run and second one email flag. I don't know how to capture... (3 Replies)
Hi All,
I need to pass a variable to perl script from bash script, where in perl i am using if condition. Here is the cmd what i am using in perl
FROM_DATE="06/05/2008"
TO_DATE="07/05/2008"
"perl -ne ' print if ( $_ >="$FROM_DATE" && $_ <= "$TO_DATE" ) ' filename"
filename has... (10 Replies)
Unix prompt
=========
echo "Enter the query"
read q
==========
User has entered :
SELECT * FROM employee
=====================
Now the problem starts..
echo $q
Output: SELECT "all files names in the PWD" FROM employee
================================================
... (5 Replies)
Hi Gurus,
i have one requirement in unix script, i have a file called abc.txt in that few lines are there with the empid, i need to read each line and pass to .sql script.
ex:
abc.txt
2345
2346
1243
1234
i need to pass these arguments to .sql script rom unix
ex:
select * from... (1 Reply)
Hi Guys,
I am trying to pass a string variable from Unix shell script to sqlplus as a parameter.
I have tried using single quotes with the variable name but it does not work. Please help me with it.
I am using BASH.
My code:
Your help is much appreciated.
Thanks,
shil (2 Replies)
I'm trying to write a basic bash script that takes input you give (what directory, if any, what name, if any ....) and passes the information to find.
I'm trying to just create a string with all variables and then pass it to find. So far I have this extremely simple:
#!/bin/bash -f
... (2 Replies)
Hi Friend,
I have one file in which some number are mentioned and number of lines are vary every time
And i need to pass that number to my sql command from script.
Suppose i have file acc.txt
45456546456
45464564565
67854353454
67657612132
Number of records are vary every time.... (20 Replies)
Hello,
I have file (PARFILE) with string on first line:
INCLUDE=SCHEMA:"IN\( 'SCHEMA1','SCHEMA2','SCHEMA3' \)"In .sh script I use:
....
IMPORT_SCHEMA=`awk 'NR==1{print $2}' ${PARFILE}`
...print $2 is because 'SCHEMA1','SCHEMA2','SCHEMA3' is 2nd column in file
echo "$IMPORT_SCHEMA"... (5 Replies)
Discussion started by: DjukaZg
5 Replies
LEARN ABOUT DEBIAN
bld
BLD(8) System Manager's Manual BLD(8)NAME
bld - A black list daemon
SYNOPSIS
bld -h | [option]
OPTIONS -v Output version information and exit
-n Do not fork to become a daemon
-a address
Address to bind to
-p port
Port to listen to
-l number
Log verbosity (between 0 and 3)
-t number
Minimum time interval before blacklisting
-m number
Maximum submissions in time interval
-i number
IP list size
-b number
Blacklist size
-e number
Blacklist expiration
-P filename
Filename where to save PID
-T number
Timeout for client connections
-u user
User to run as
-g group
Group to run as
-f filename
Use a specific configuration file
-A filename
Filename where to find ACLs
-W filename
Filename where to find whitelist
-B filename
Filename where to store blacklist
-I filename
Filename where to store whole IP list
DESCRIPTION
By default, the bld daemon listens to requests on port 2905. Requests are either IP addresses submissions or checks against the black
list.
bld uses a very simple algorithm to decide whether to add IP addresses to the blacklist or not. The first time an IP address is submitted,
it is added to an internal list with a timestamp and all further requests increment a counter for this IP. As soon as the minimum time
interval is elapsed (default: 30 seconds), and if a maximum requests ratio is reached (default: 10 submissions in the 30 seconds interval),
the IP is put in the blacklist. It is then blacklisted for a configurable time (default: 900 seconds).
PROTOCOL
Requests sent to bld are rather simple. Each request or reply is followed by a linefeed and a carriage return. A client may only send one
request per TCP session. As of now, two commands may be used: ip (address submission) and ip? (ask if address is blacklisted).
ip=a.b.c.d submits an IP address. The server acknowledges either with a 200 code if the address is not blacklisted or a 421 if it is.
ipdecr=a.b.c.d decrements the internal counter for an IP address. The lowest value for the counter is zero. The server always acknowl-
edges with a 200 code.
ip?=a.b.c.d asks if address is blacklisted. The server reply may be 421 if it is or 200 if it's not.
ipbl=a.b.c.d forces the insertion in the blacklist. The server acknowledges with a 200 code.
If using IP based restrictions, the server reply may be 600 if the client is not in the correct ACL to perform a request. Any other error
will generate a reply with a 500 error code.
NOTES
bld binds to localhost by default and accepts any local request, so please make sure that only trusted users can establish a connection to
the daemon. Please check that all authorized hosts meet the minimal security requirements before changing this parameter even if using an
access control list (see bld_acl.conf(5)).
bld will log some statistics if it receives the SIGUSR1 signal. SIGUSR2 is used to force a dump of both lists in bld working directory.
FILES
/etc/bld/bld.conf /etc/bld/bld_acl.conf /etc/bld/bld_whitelist.conf /var/run/bld/bld.pid /var/run/bld/bld_iplist.dump
/var/run/bld/bld_blacklist.dump
SEE ALSO bld.conf(5)bld_acl.conf(5)bld_whitelist.conf(5)bldread(8)bldquery(8)bldsubmit(8)blddecr(8)AUTHOR
Olivier Beyssac <obld@r14.freenix.org>
August 2004 BLD(8)