We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
2 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Shell or Perl script to search for a list of text / string & return 1st string of the preceding line
Posted on 2011-03-03
' mailq ' often returns various problem mails : such mails would hog genuine
mails from going thru
I need to search for a list of text / string that's found from "mailq" output
& then the script would return the first value of the line just preceding the
line these text were found.
List of search text / string are (which may be added in future ):
a) "Connection timed out"
b) "lowest numbered MX record"
c) "Connection refused"
d) "Mailbox size limit exceeded"
e) "Undeliverable address"
f) "Network is unreachable"
g) "exceed mailbox quota"
..... this list of search text may grow .....
& based on the sample mailq output below, the script would return the values
DD063290F38
D8E42291DBE
D440F291197
D3E14291D93
. . .
These values are the problem mails' ids & will be passed to postsuper to
be withheld in 'hold' queue :
mailq | script_needed | postsuper -h -
Sample problems mails returned by mailq :
. . . . . .
DD063290F38 2924 Tue Mar 1 10:17:13 sssspc@xx.sg
(host mail.phins.com.sg[119.73.2
jason@phins.com.sg
D8E42291DBE 2919 Tue Mar 1 10:20:43 sssspc@xx.sg
(connect to ritzmail.RITZ-CARLTON.COM.
JOSEPHINE@RITZ-CARLTON.COM
D440F291197 2185 Fri Feb 25 15:15:24 sssspc@xx.sg
(Host or domain name not found. Name service error for name=GMAIL.COM.SG type=MX: Host not found, try again)
DR.JOSEPH.ANG@GMAIL.COM.SG
D3E14291D93 3051 Tue Mar 1 10:19:51 sssspc@xx.sg
(host mailserv.skylightgroup.com
florencet@meland.com.sg
9B90CA58AE 1278 Sun Feb 27 15:28:08 contact_autoreply@xx.sg
(connect to park.goldenname.com[75.125
Manue@3nan.com
E7EEBA579E 1272 Sun Feb 27 19:48:56 contact_autoreply@xx.sg
(host alt1.aspmx.l.google.com[74
mails from going thru
I need to search for a list of text / string that's found from "mailq" output
& then the script would return the first value of the line just preceding the
line these text were found.
List of search text / string are (which may be added in future ):
a) "Connection timed out"
b) "lowest numbered MX record"
c) "Connection refused"
d) "Mailbox size limit exceeded"
e) "Undeliverable address"
f) "Network is unreachable"
g) "exceed mailbox quota"
..... this list of search text may grow .....
& based on the sample mailq output below, the script would return the values
DD063290F38
D8E42291DBE
D440F291197
D3E14291D93
. . .
These values are the problem mails' ids & will be passed to postsuper to
be withheld in 'hold' queue :
mailq | script_needed | postsuper -h -
Sample problems mails returned by mailq :
. . . . . .
DD063290F38 2924 Tue Mar 1 10:17:13 sssspc@xx.sg
(host mail.phins.com.sg[119.73.2
jason@phins.com.sg
D8E42291DBE 2919 Tue Mar 1 10:20:43 sssspc@xx.sg
(connect to ritzmail.RITZ-CARLTON.COM.
JOSEPHINE@RITZ-CARLTON.COM
D440F291197 2185 Fri Feb 25 15:15:24 sssspc@xx.sg
(Host or domain name not found. Name service error for name=GMAIL.COM.SG type=MX: Host not found, try again)
DR.JOSEPH.ANG@GMAIL.COM.SG
D3E14291D93 3051 Tue Mar 1 10:19:51 sssspc@xx.sg
(host mailserv.skylightgroup.com
florencet@meland.com.sg
9B90CA58AE 1278 Sun Feb 27 15:28:08 contact_autoreply@xx.sg
(connect to park.goldenname.com[75.125
Manue@3nan.com
E7EEBA579E 1272 Sun Feb 27 19:48:56 contact_autoreply@xx.sg
(host alt1.aspmx.l.google.com[74
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4
3-
3
- +2
12 Comments
You could do something like that:
---
#!/bin/bash
grep your_text_string your_file_name | head -1
---
This will search into your file a certain string, and just show the first coincidence.
Regards
---
#!/bin/bash
grep your_text_string your_file_name | head -1
---
This will search into your file a certain string, and just show the first coincidence.
Regards
Active today
mailq | grep -B1 -f pattern_file |grep -v -f pattern_file |grep -v -e "--" | cut -f1 -d " "
pattern_file should just contain the search strings, without surrounding qotes:
Connection timed out
lowest numbered MX record
Connection refused
Mailbox size limit exceeded
Undeliverable address
exceed mailbox quota
wmp
pattern_file should just contain the search strings, without surrounding qotes:
Connection timed out
lowest numbered MX record
Connection refused
Mailbox size limit exceeded
Undeliverable address
exceed mailbox quota
wmp
mailq | egrep -B1 '(Connection timed out|Undeliverable address|Mailbox size limit exceeded)' | awk '/^[0-9A-F]+/ {print $1}'
you get the idea
you get the idea
Active today
Forgot the remainder of your script:
mailq | grep -B1 -f pattern_file |grep -v -f pattern_file |grep -v -e "--" | cut -f1 -d " " | postsuper -h -
mailq | grep -B1 -f pattern_file |grep -v -f pattern_file |grep -v -e "--" | cut -f1 -d " " | postsuper -h -
And, for those of us on systems like AIX, where -B is not an option for grep, here's a work around
for RECNUM in $(mailq|grep -n -f LookUpList |cut -f1 -d:)
do
(( T = $RECNUM - 1 ))
mailq|sed -n "${T},${T}P" |awk '{print $1}'
done | postsuper -h -
for RECNUM in $(mailq|grep -n -f LookUpList |cut -f1 -d:)
do
(( T = $RECNUM - 1 ))
mailq|sed -n "${T},${T}P" |awk '{print $1}'
done | postsuper -h -
Reviewing this... if you have a very busy mail system... the results of the multiple mailq commands may be inconsistent.. so here's a more stable option
#!/usr/bin/ksh
TMPFILE=/tmp/mq_scan.$$
mailq > $TMPFILE
if [ -s $TMPFILE ]
then
for RECNUM in $(grep -n -f LookUpList $TMPFILE |cut -f1 -d:)
do
(( T = $RECNUM - 1 ))
sed -n "${T},${T}P" $TMPFILE |awk '{print $1}'
done | postsuper -h -
fi
rm $TMPFILE
#!/usr/bin/ksh
TMPFILE=/tmp/mq_scan.$$
mailq > $TMPFILE
if [ -s $TMPFILE ]
then
for RECNUM in $(grep -n -f LookUpList $TMPFILE |cut -f1 -d:)
do
(( T = $RECNUM - 1 ))
sed -n "${T},${T}P" $TMPFILE |awk '{print $1}'
done | postsuper -h -
fi
rm $TMPFILE
Active 1 day ago
I think Mario's solution is not what I wanted :
> " just show the first coincidence"
What I need is one 1 line above the line that contains the search string.
For solution of the others, I can only test out on Monday as my Linux VM
at home is crashed, so can only test in the ofc
Featured Post
Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Background
Still having to process all these year-end "csv" files received from all these sources (including Government entities), sometimes we have the need to examine the contents due to data error, etc...
As a "Unix" shop, our only readily …
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc.
This document explains the different types of consol…
In a previous video, we went over how to export a DynamoDB table into Amazon S3. In this video, we show how to load the export from S3 into a DynamoDB table.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
- Shell Scripting
- Programming Languages-Other
- Scripting Languages
- Programming
- Notepad
- *AutoHotkey, *Scripts
Suggested Courses
Course of the Month2 days, 17 hours left to enroll
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.