The email will be send only for an successfull return code (which value is 0).
To be sur that your SQL command returns an error status in case of problem, add the following statements at the top of your sql script :
Jean-Pierre.
Hello people,
I am new to shell scripting and hoping to get a quick answer to my query.
I am writing a simple script which needs to call an executale which generates an output file. Once the output file is generated I have to do a couple of more task with that file. The executable ideally... (1 Reply)
Hi,
Can anyone please help me on building the logic for writing a shell script which can delete blank lines from a file and count the number of duplicate lines in a file.
Thanks,
Indra (2 Replies)
Hi,
Can someone help me with this small piece of code.
DIRNAME=$(dirname $0)
BASENAME=$(basename $0)
DATA="${DIRNAME}/${BASENAME}.data"
&& . $DATA
whats is meant by && . $DATA here...
Regards,
Abhishek (2 Replies)
Hello friends,
It will be great if we found some way to check this our:
we have some databases (teradata and oracle).
our applications(in java on weblogic) are using connection pools of these databases.
we have a pair of userID and password for every pool.
If we have any logic to test... (2 Replies)
There are two fields actually one is server name and the other one is Time.
Based on time, there are 8 columns and these will be updated with the flag 1 if at all if there is any server name.
Time
Server name
15 to 18
18 to 21
21 to 24
00 to 03
03 to 06
06 to 09
09 to 12
Server... (3 Replies)
Hello All,
I was wondering if someone can help me to develop restart logic for a Korn Shell program (a master script) that I am developing. The program is design to invoke a series of child processes (Korn Shell Scripts) whose function is to create a series of load files on a specified mount... (0 Replies)
Hi,
My input file as follws
$ cat 1.txt
-------
a aa aaa 11
b bb bbb 22
I am able to extract first and last column of a given line as follows.
$ nawk '{print $1}' FS= RS= 1.txt | awk '{ $NF = ""; print }'
a
$ nawk '{print $1}' FS= RS= 1.txt | awk '{ print $NF}'
11
however, the... (4 Replies)
Hi Unix Experts,
Happy Morning to all !! :)
I am new to UNIX Shell Scripting and at my begineer level. To get acquainted to scripting, I am trying to create a script.
The details/requirements of my script was to create a script with month changing logic in it so that on every 6th Working... (3 Replies)
Hi,
I need shell script for getting the date in format from below text output
IP IS 10.238.52.65
pun-ras-bng-mhs-01#show conf port 2/4
Building configuration...
Current configuration:
!
card ge3-4-port 2
!
port ethernet 2/4
no shutdown
encapsulation dot1q (7 Replies)
Hi I have a requirement where I have to generate a mail/alert to the user if any QA check is failed.
our oracle jobs run in unix environment and log file is created .
Sample is given below .
SELECT *
FROM product.fact_tally
WHERE period_id = '20130401' ;
LIMIT 5;
Ideally the above... (4 Replies)
Discussion started by: systemee
4 Replies
LEARN ABOUT CENTOS
radsqlrelay
RADSQLRELAY(8) FreeRADIUS helper program RADSQLRELAY(8)NAME
radsqlrelay - relay SQL queries to a central database server
SYNOPSIS
radsqlrelay [-?] [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path
DESCRIPTION
radsqlrelay tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) data-
base, even if the database has extended downtime.
The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.
OPTIONS
-? Print usage help information.
-d sql_driver
Driver to use: mysql, pg, oracle.
-b database
Name of the database to use.
-f file
Read password from file, instead of command line.
-h host
Connect to host.
-u user
User for login.
-P port
Port number to use for connection.
-p password
Password to use when connecting to server.
-1 One-shot mode: push the file to database and exit.
-x Turn on debugging.
file_path
The pathname of the SQL logfile to use.
NOTES
Oracle driver
The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:
db.domain.tld =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <DB SID>)
)
)
SEE ALSO rlm_sql_log(5)AUTHOR
Nicolas Baradakis <nicolas.baradakis@cegetel.net>
19 June 2005 RADSQLRELAY(8)