mysqmail-postfix-logger(8) System Manager's Manual mysqmail-postfix-logger(8)NAME
mysqmail-postfix-logger - logs smtp traffic to a mysql database
SYNOPSIS
mysqmail-postfix-logger subprogram [ args ... ]
DESCRIPTION
mysqmail-postfix-logger reads the syslog using tail -F and for each lines, does an action in a selected table in the selected mysql server
(configuration done using /etc/mysqmail.conf). All messages that have been delivered are marqued as so in the from and in the to field of
the smtp traffic table.
mysqmail-postfix-logger uses a table corresponding to this one:
CREATE TABLE IF NOT EXISTS smtp_logs (
id int(11) NOT NULL auto_increment,
newmsg_id bigint(20) default NULL,
bounce_qp int(11) default NULL,
bytes int(11) NOT NULL default '0',
sender_user varchar(128) NOT NULL default '',
sender_domain varchar(128) NOT NULL default '',
delivery_id bigint(20) default NULL,
delivery_user varchar(128) NOT NULL default '',
delivery_domain varchar(128) NOT NULL default '',
delivery_success enum('yes','no') NOT NULL default 'no',
time_stamp timestamp(14) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY bounce_qp (bounce_qp),
UNIQUE KEY newmsg_id (newmsg_id),
KEY sender_domain (sender_domain),
KEY delivery_domain (delivery_domain) ) TYPE=MyISAM;
VERSION
This documentation describes mysqmail-postfix-logger version 0.1.4. See http://gplhost.com/softwares-mysqmail.html for updates.
SEE ALSO syslog(3), logger(8)mysqmail-postfix-logger(8)
Check Out this Related Man Page
logger::appender(n) Object Oriented logging facility logger::appender(n)
__________________________________________________________________________________________________________________________________________________NAME
logger::appender - Collection of predefined appenders for logger
SYNOPSIS
package require Tcl 8.2
package require logger::appender ?1.2?
::logger::appender::console -level level -service service ?options...?
::logger::appender::colorConsole -level level -service service ?options...?
_________________________________________________________________DESCRIPTION
This package provides a predefined set of logger templates.
::logger::appender::console -level level -service service ?options...?
-level level
Name of the level to fill in as "priority" in the log procedure.
-service service
Name of the service to fill in as "category" in the log procedure.
-appenderArgs appenderArgs
Any additional arguments for the log procedure in list form
-conversionPattern conversionPattern
The log pattern to use (see logger::utils::createLogProc for the allowed substitutions).
-procName procName
Explicitly set the name of the created procedure.
-procNameVar procNameVar
Name of the variable to set in the calling context. This variable will contain the name of the procedure.
::logger::appender::colorConsole -level level -service service ?options...?
See ::logger::appender::colorConsole for a description of the applicable options.
BUGS, IDEAS, FEEDBACK
This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category logger
of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may have for
either package and/or documentation.
KEYWORDS
appender, logger
COPYRIGHT
Copyright (c) 2005 Aamer Akhter <aakhter@cisco.com>
log 1.2 logger::appender(n)
Hi have Input in this way
KEY AAAA
BBBB
END1
KEY AAAA
BBBB
END2
KEY AAAA
BBBB
END3
I need to find any thing matching in between KEY And ending with "END1|END2|END3"
This didnot work
awk '/KEY/,/END1|END2|END3/' (3 Replies)
Hi guys,
I'm in trouble to do postfix compilation on a Solaris.
SunOS 5.10 Generic_118833-33 sun4u sparc SUNW, Sun-Fire-V440
I'm trying to compile postfix-2.4.5
which make replay /usr/ccs/bin/make and it's in the profile
When I launch make install clean it replies
make: Fatal... (2 Replies)
Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
hello everyone
i hav LITTLE issue, pending for just last week regarding postfix/sendmail server.
M not able to forward mail to outer domain.
I hav not configured DNS server uptill now, so nvr tried to receive mail from any domain, as i don require that as of now.
Can anybody suggest a... (4 Replies)
I have 2 Servers IP:
1)10.1.1.27
2)10.1.2.27
#more /etc/postfix/transport
Domain.com smtp:ServerIP
Now i want to change the smtp:ServerIP according to user interaction: (2 Replies)
hi,
this is related to this thread https://www.unix.com/shell-programming-scripting/154822-dont-have-clue-program-use-process-flying-bat-data.html
using another type of logger (ipcas ipether232) which produces csv data but not seperated into differnt folders. I need to work out how to get... (2 Replies)
hello all,
If i send mails using postfix,the mails stored in queue,not delivered to required recipient...can anyone please tell me the solution for this problem... (4 Replies)
Howdy, I hope it is ok to post this here.
I would like to do all my POP3 email with fetchmail, postfix and emacs. On Snow Leopard 10.6.8 - this is not urgent and I really want to do it in one of the right ways.
This is fetchmail release 6.3.11+GSS+SSL+KRB5.
postconf mail_version = 2.5.14
GNU... (11 Replies)
Hello there,
First of all I tell you that this is my first postfix installation so please be patient...
I have following scenario:
fetchmail --> postfix --> amavis-new --> postfix --> exchange 2010.
Everything -except exchange ;-)- runs on an opensuse 12.1 box.
Now, I have a list of... (2 Replies)
Hello All,
I have a file like this
Define schema flat_file_schema
(
a varchar(20)
,b varchar(30)
,c varchar(40)
);
(Insert into table (
a
,b
,c
) values
(
1
,2
,3
); (4 Replies)
When inserting a temperature logger into a Centos 7.0 machine, the relevant dmesg lines read:
usb 2-1.4: new full-speed USB device number 4 using ehci-pci
usb 2-1.4: New USB device found, idVendor=10c4, idProduct=82cd
usb 2-1.4: New USB device strings: Mfr=1, Product=2, SerialNumber=0
usb... (5 Replies)
Can someone help me please to write a Python program that support a processing of arithmetic expressions in postfix notation.
Expressions in postfix notation contain the operands on which the operation is performed followed by an operator. For example, 3 4 + is equal to 3 + 4 in the infix... (2 Replies)
Hello list,
I want to be able to send email directly from my linux box. I have both a CentOS and Debian installation. I am by no means an expert when it comes to all of the SMTP servers. I have been testing different configs by installing and uninstalling sendmail, postfix, and exim4.
... (2 Replies)
I am trying to send an email to my gmail using postfix. I am using windows 10 Ubuntu 18.04 bash shell. I have tried the website tutorials and was unsuccessful. (6 Replies)