11-19-2009
Quote:
Originally Posted by
kolesunil
Very close, only thing that it has not deleted following lines in middle:
number|GGS_LOG_SEQ|NULL
number|GGS_LOG_POS|NULL
number|GGS_ORACREC_SCN|NULL
Hmm... does grep -v works on your system ? .. check man grep ...
I have two things done in the loop.
1. get all the GGS_.. in to files starting with same name
2. have another file called final.txt and remove whatever we found
After loop:
3. Now append all the GGS_ files and last final.txt
4. Just put all in result file.
Can you let me know your OS and grep version ... else we have use sed
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I need help in doing this scenario. I have two files with multiple lines. I want to compare these two files but ignoring the lines which have words like Tran, Loc, Addr, Charge. Also if i have a word Credit in line, i want to tokenize (i.e string after character "
... (2 Replies)
Discussion started by: jakSun8
2 Replies
2. Shell Programming and Scripting
Hi,
Would anyone know how to compare two strings, and only throw an error if there were different words, not that the same words were in a different order?
e.g
"A B C" vs "B C A" ->OK
"A B C" vs "A D C" -> BAD
Thanks! (2 Replies)
Discussion started by: rebelbuttmunch
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I need to sort it by column or need it in a specific order...
input is
=====
uid=shashi country= india region =0 ph=0
uid= jon region= asia ph= 12345 country=0
uid = man country= india ph=2222 region=0
uid= neera region= asia ph= 125 country=0
output should be
uid=shashi ... (1 Reply)
Discussion started by: hegdeshashi
1 Replies
4. Shell Programming and Scripting
Hi all,
I need a big help. I've a requirment which should be done in awk scripting only..
My requirment is:
In below file, there are some lines started with 'master replica:'.
i want to get the exact word in that line which should be before '@', and i've to create a file with these names... (5 Replies)
Discussion started by: raghu.iv85
5 Replies
5. UNIX for Dummies Questions & Answers
Hi again
I have figured out how to be able to sort through lines in a file with multiple words in any order and display them using this command:
cat file | grep -i $OPTION1 | grep -i $OPTION2 | grep -i $OPTION3 OPTION1 is 2008, OPTION2 is Mar, OPTION 3 is Tue
Result:
Tue Mar 25... (4 Replies)
Discussion started by: semaj
4 Replies
6. UNIX Desktop Questions & Answers
well, i am so not familiar with this kind of things but i am gonna explain extactly what i am looking for so hopfully someone can figure it out :)
i have a command that shows memory usage besides the process name, for example(the command output):
500 kb process_1
600 kb process_2
700 kb... (4 Replies)
Discussion started by: Portabello
4 Replies
7. UNIX for Dummies Questions & Answers
Dear all,
Greetings.
I would like to ask for your help to extract lines with specific words in addition 2 lines before and after these lines by using awk or sed.
For example, the input file is:
1 ak1 abc1.0
1 ak2 abc1.0
1 ak3 abc1.0
1 ak4 abc1.0
1 ak5 abc1.1
1 ak6 abc1.1
1 ak7... (7 Replies)
Discussion started by: Amanda Low
7 Replies
8. Shell Programming and Scripting
Hi,
Please have a look on below records.
STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: The value of the row is: EMPLID = 220677 COMPANY = 919 BALANCE_ID = 0 BALANCE_YEAR = 2012
STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: ORA-00001: unique constraint (SYSADM.PS_TAX_BALANCE) violated
... (4 Replies)
Discussion started by: Sachin Lakka
4 Replies
9. Shell Programming and Scripting
Hello all
I was wondering if someone has an idea how to sort by a specific order, let's say by a specific alphabet containing only 4 letters like (d,s,a,p) instead of (a,b,c....z) ??
Cheers! (6 Replies)
Discussion started by: cabrao
6 Replies
10. Shell Programming and Scripting
Hi
I have a file like that contains infomation about genes exons introns made as a single string. i am just planning to get the gene name alone with out any extra information.
intergenic_Nedd4_exon_0_F
Gapvd1_intron_24_R
Gapvd1_exon_25_Rmy output file should be
intergenic_Nedd4
Gapvd1... (13 Replies)
Discussion started by: raj_k
13 Replies
LEARN ABOUT DEBIAN
mysqmail-courier-logger
mysqmail-logger(8) System Manager's Manual mysqmail-logger(8)
NAME
mysqmail-courier-logger - logs courier-imap traffic to a mysql database
SYNOPSIS
mysqmail-courier-logger subprogram [ args ... ]
DESCRIPTION
mysqmail-courier-logger reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysq-
mail-courier-logger writes the total used bandwidth corresponding to the username. Configuration is read from /etc/mysqmail.conf.
mysqmail-courier-logger uses a table corresponding to this one:
CREATE TABLE IF NOT EXISTS pop_access (
id varchar(32) NOT NULL default '',
uid int(11) NOT NULL default '65534',
gid int(11) NOT NULL default '65534',
home varchar(255) NOT NULL default '',
shell varchar(255) NOT NULL default '',
mbox_host varchar(120) NOT NULL default '',
crypt varchar(50) NOT NULL default '',
passwd varchar(50) NOT NULL default '',
active int(11) NOT NULL default '1',
start_date date NOT NULL default '0000-00-00',
expire_date date NOT NULL default '0000-00-00',
quota_size int(11) NOT NULL default '0',
type varchar(20) NOT NULL default 'default',
memo text,du bigint(20) NOT NULL default '0',
another_perso varchar(5) NOT NULL default 'no',
redirect1 varchar(255) default NULL,
redirect2 varchar(255) default NULL,
localdeliver varchar(10) NOT NULL default 'yes',
pop3_login_count int(9) NOT NULL default '0',
pop3_transfered_bytes int(14) NOT NULL default '0',
imap_login_count int(9) NOT NULL default '0',
imap_transfered_bytes int(14) NOT NULL default '0',
last_login int(14) NOT NULL default '0',
PRIMARY KEY (id,mbox_host) ) TYPE=MyISAM
To have mysqmail-courier-logger working, you should have issued mkfifo /var/log/courier.fifo to create the fifo and use nohup cat
/var/log/courier.fifo | /usr/bin/mysqmail-courier-logger > /dev/null 2>&1 & to launch it.
VERSION
This documentation describes mysqmail-courier-logger version 0.1.4. See http://gplhost.com/softwares-mysqmail.html for updates.
SEE ALSO
qmail-send(3), syslog(3), logger(8)
mysqmail-logger(8)