Solved

Stuck with small batch script

Posted on 2013-11-17
5
316 Views
Last Modified: 2013-11-19
Hi,

I am trying to do a small script but are stuck because of my limited knowledge.
What I try to do is relative simple. I like to read the last line of the mailq command and than write it in a file. I plan to do this into the hourly cron and than after 24 hours have 24 numbers in the file and send them to me via email and then erase the content for another 24 hour.

I have the command

mailq | tail -n 1 | awk '{ print($5); }'

that shows me the number.

next thing I tryed was:
mailq | tail -n 1 | awk '{ print($5); }' /etc/mailq_log.txt

but this does not write the number into the file.

So the bottom line is that I simply want to write into a file the amount of messages in the postfix queue and then send this file every day to my email and then clean the file for the next day. My next phase would then be that if this number is over x amount at any hour it sends a "check mail queue" email to me as alert.

I would be very happy if any of you would be able to help me out to make this happen. It would be greatly appreciated.

Best wishes,
Thomas
0
Comment
Question by:Thomanji
  • 2
  • 2
5 Comments
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 300 total points
ID: 39655539
For the awk command you need:
mailq | tail -n 1 | awk '{ print $5 >> "/etc/mailq_log.txt" }'

Here's an article for redirection with awk: http://www.chemie.fu-berlin.de/chemnet/use/info/gawk/gawk_7.html#SEC65

HTH,
Dan
0
 
LVL 34

Assisted Solution

by:Dan Craciun
Dan Craciun earned 300 total points
ID: 39655549
You can run your hourly cron with the ">>" redirection (which appends) and have a daily cron with the ">" redirection, which empties the file prior to writing in it.

HTH,
Dan
0
 
LVL 84

Assisted Solution

by:ozo
ozo earned 200 total points
ID: 39655553
mailq | tail -n 1 | awk '{ print($5); }' > /etc/mailq_log.txt
0
 

Author Comment

by:Thomanji
ID: 39655647
Hi,

Thank you for the answers, I do appreciate it. However, I try to get the batch working the way I described.

Here is what I have by now:

(this would be in the hourly cron)

#!/bin/sh

MAX_SIZE=${1:-10}
CUR_SIZE=`mailq | tail -n 1`

if [ $CUR_SIZE -gt $MAX_SIZE ]; then
     mailq | tail -n 1 | awk '{ print $5 >> "/var/log/mailq.alert" }'
     mail -s Postfix Queue Alert email@email.com < /var/log/mailq.alert
fi
else
     echo $CUR_SIZE > /var/log/mailq.size
fi

exit 0

then I plan to put in the daily cron another script simply containing:

mail -s Postfix Queue Daily email@email.com < /var/log/mailq.size

so that once a day I get the mailq.size file that theoretically contains 24 numbers.
I also try to get a date and time stamp in front of each mailq count.
Anyway, all this does not work as expected.
Any assistance is welcome

Best wishes,
Thom
0
 

Author Closing Comment

by:Thomanji
ID: 39661429
Thanks for the input, I did now write a script that monitors the mail and sends a daily report or a alert if the queue goes over xx messages. Works great
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now