---
name: "mysqmail-postfix-logger"
section: "8"
platform: "linux"
package: "mysqmail-postfix-logger"
version: "0.4.9-10.4"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/mysqmail-postfix-logger"
---

# mysqmail-postfix-logger(8)

logs smtp traffic to a mysql database

## 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)](/syslog/3.md), logger(8)