mysqmail-postfix-logger(8)

💖 NAME 💖

okay bestie, so mysqmail-postfix-logger — it logs smtp traffic to a mysql database. that's the whole vibe. periodt. 🦋

✨ SYNOPSIS ✨

mysqmail-postfix-logger subprogram [ args ...  ]

🌸 DESCRIPTION 🌸

so here's the tea ☕: mysqmail-postfix-logger reads the syslog using tail -F, and for each line, it does an action in a selected table in the selected mysql server (and yes, all that configuration is done using /etc/mysqmail.conf, iykyk 💅).

every single message that has been delivered gets marked as so in the from field and in the to field of the smtp traffic table. not one of them escapes the vibe check 🔥.

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. for updates, go look at http://gplhost.com/softwares-mysqmail.html — go get your updates bestie, we love a glow-up 🎀

🫶 SEE ALSO 🫶

• syslog(3)
• logger(8)

and that's the page, bestie!! 💜 this lil writeup is from the System Manager's Manual era of mysqmail-postfix-logger(8), and it's lowkey iconic that it's still serving version 0.1.4 realness. go forth and log those smtp lines. slay. 💅✨