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)
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)
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)
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)
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)
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)
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)
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)
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)
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)