Sponsored Content
Full Discussion: Logfile monitor script
Top Forums Shell Programming and Scripting Logfile monitor script Post 302368104 by elmesy on Wednesday 4th of November 2009 06:33:01 AM
Old 11-04-2009
Cheers for the reply, what i'm looking for is to make sure the the alert i'm sending an email for has just happend which is why I wanted to try use the $DATE1 = Nov 4 11:29 which is the same format as in the logfile. But If I try it doesn't work. Is it possible to grep twice from the output of a tail and direct it to /dev/null?

Code:
DATE=`date`
DATE1="`date +%b` `date +%e` `date +%H`:`date +%M`"
HOST=`hostname`
LOG=/var/adm/sqllog
ERRORLOG=/home/sql/sqlerrlog
 
while true
do
  tail -100 $LOG | grep "$DATE1" | grep "SQL" > /dev/null
if [ $? -eq 0 ];then
  mail -s "SQL errors in $LOG on $HOST $DATE" "me@host.com" 
  exit
fi
done


Last edited by Franklin52; 11-04-2009 at 09:15 AM.. Reason: Please indent your code and use code tags!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

perl script to filter logfile

i was wondering if anyone can help me, how could i write in perl a a script that would look through a log file and print onscreen the contents of the log file excluding lines that contain '192.168.1.' and entries that contain directory paths that arent in the directory /usr/local/httpd/htdocs/ i... (4 Replies)
Discussion started by: norsk hedensk
4 Replies

2. Shell Programming and Scripting

Script to manipulate logfile text

Hi guys, I was wandering if a Shell guru could give me some advice on tackling a problem. I have used a mixture of grep, cut and awk to get data from a log file in the following format: 14/11/08 10:39: Checking currenly : Enabled 14/11/08 10:39: Records allocated : 221... (11 Replies)
Discussion started by: rosspaddock
11 Replies

3. Shell Programming and Scripting

Attaching a logfile to the Script

Hello guys. I've recently written a basic utilities script just for home use. and i want to attach a logfile to it that will record all the commands that where executed in that script. Then just so i can add the d%b%y% and make each logfile unique and i can look back in each logfile to see what i... (9 Replies)
Discussion started by: matt02
9 Replies

4. Shell Programming and Scripting

Logfile rotation script.

I'm trying to find or create a Perl script that: Checks for and creates these files: notes notes.1 notes.2 notes.3 notes.4 The first represents the current log file and the others are older versions. Each time the script runs it would check for the existence of notes.3 and, if it exists,... (3 Replies)
Discussion started by: HardyV2
3 Replies

5. Shell Programming and Scripting

Script to extract line from logfile

Hi , Can someone help me,I am not well versed with scripting,it is very urjent. Need a script in perl or shell for the following task. The logfile contains several entries of which one particular string to be searched and that complete line has to be removed and copied to another file to... (25 Replies)
Discussion started by: garryt21@rediff
25 Replies

6. Shell Programming and Scripting

Script to monitor errors in logfile

Hi, I would like to implements monitoring tool which looks at the logfile and sends me an email with error messages from the logfile. The runtime errors are printed in logfile. The logfile also contains some warning and debugging messages. For errors, the line will start with “Error”., the error... (1 Reply)
Discussion started by: LinuxLearner
1 Replies

7. Shell Programming and Scripting

Script for Logfile Inserting into the Database

Here's the problem. I have a shell script running for every one minute as cronjob that outputs to a log file. I want to be able to take the data from the log file and insert it into a mysql database. The script needs to run at a set period of time and remove the log file data once the insert is... (7 Replies)
Discussion started by: kgrvamsi
7 Replies

8. Shell Programming and Scripting

generate logfile in a shell script

Unix Gurus, I have a shell script which has few "echo" statements. I am trying to create a logfile where all the outputs of the echo statement sare stored. I will have to add this as the final step in the existing script so that everytime the script runs, a logfile is generated with all the... (1 Reply)
Discussion started by: shankar1dada
1 Replies

9. UNIX for Dummies Questions & Answers

Shell script to email logfile

Hi, I am trying to write a shell script to send a log file of a query run in oracle.Pls help me I am very new to shell scripting. echo " Checking Activity Spec " sqlplus / as sysdba <<END_SQL @activity_spec_metadata.sql quit;>>logfile END_SQL mailx -s "Checking Activity Spec schedule... (1 Reply)
Discussion started by: Rossdba
1 Replies

10. Shell Programming and Scripting

Logfile monitoring with logfile replacement

Bonjour, I've wrote a script to monitor a logfile in realtime. It is working almost perfeclty except for two things. The script use the following technique : tail -fn0 $logfile | \ while read line ; do ... some stuff done First one, I'd like a way to end the monitoring script if a... (3 Replies)
Discussion started by: Warluck
3 Replies
ALEVT-DATE(1)							   Teletext time						     ALEVT-DATE(1)

NAME
alevt-date - display/set time received via Teletext SYNOPSIS
alevt-date [options] DESCRIPTION
alevt-date displays the time received from a Teletext source. It can be used to set the system time. The date is not interpreted (not even transmitted on most channels). So it allows only adjustment of +/-12 hours. The default allowed adjustment is limited to +/-2 hours (use -delta to change). Without the -set option it just displays the date in the format of the date(1) command. OPTIONS
A summary of options is included below. -set Set system time from time received via Teletext. -delta seconds Maximum allowed adjustment made to the system time. The default is 7200 seconds (2 hours) and the maximum that may be given is 12 hours. -format string Format string to used to print the time. Look at strftime(3) for possible control sequences. -vbi device Use the given device name. Default: /dev/vbi, /dev/vbi0, /dev/video0, /dev/dvb/adapter0/demux0 tried in this order. -timeout seconds If the time can't be detected in seconds, the program is terminated with a SIGALRM. -progname name Specifies the program name if using the DVB interface. -pid pid Specifies the teletext PID if using the DVB interface. --help Show summary of options. --version Show version of program. Before starting this program, you have to set the TV channel with another program like xawtv of set-tv. Note: This program does not set the battery backed up clock of your computer. clock -w will do this. The -progname or -pid option specifies the program or teletext PID if using the DVB interface. If neither of these two options is used, alevt outputs informations about the currently accessible streams and uses the first of these PIDs as default. This output contains the PIDs and names that can be used as an input for the -progname or -pid option in the context of the currently chosen TV channel. FILES
/dev/vbi* /dev/dvb/adapter*/demux* SEE ALSO
alevt(1x), alevt-cap(1), strftime(3), date(1), clock(8). BUGS
This program is just a toy. The time transmitted by the TV stations is more than inaccurate. Some are within a few seconds of your local time reference but others are more then 15 minutes off. You've been warned. (And don't assume the pkt8/30 time is better. It's even worse.) No bug reports to <froese@gmx.de> *g*. LINUX
1.6.2 ALEVT-DATE(1)
All times are GMT -4. The time now is 03:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy