mysqmail-logger(8)

💖 mysqmail-logger(8) 💖

okay bestie, welcome to the manual page for mysqmail-courier-logger — it lives in the System Manager's Manual section (8), and honestly? it's a whole vibe. it reads syslog, it counts bytes, it writes to mysql. no cap. 🦋

✨ NAME ✨

mysqmail-courier-logger — logs courier-imap traffic to a mysql database 💅

🌸 SYNOPSIS 🌸

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

like, you give it a subprogram and then optionally some args ... and it just goes. periodt.

🎀 DESCRIPTION 🎀

so here's the tea, bestie: mysqmail-courier-logger reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysqmail-courier-logger writes the total used bandwidth corresponding to the username. literally just vibing in the background, watching people log out, writing down how much they downloaded. main character energy fr fr. 💀✨

configuration is read from /etc/mysqmail.conf. don't forget it, she needs it. 🫶

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

🚨 bestie listen — that memo text,du bigint(20) NOT NULL default '0', line is exactly how it is in the original. don't come for me, don't "fix" it, just copy it character for character. iykyk. 😭

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. that fifo is the whole moment, she will not run without it. 🌈

⭐ VERSION ⭐

this documentation describes mysqmail-courier-logger version 0.1.4. see http://gplhost.com/softwares-mysqmail.html for updates. go check it, bestie, it's giving "i read the changelog" 💜

👑 SEE ALSO 👑

• qmail-send(3)
• syslog(3)
• logger(8)

okay that's the whole page!! tysm for reading, you ate that 🍓 and just so you know, this lil manual is the mysqmail-logger(8) one from the System Manager's Manual — that's the name at the top and the name at the bottom, cute lil matching set. it's describing version 0.1.4, so if future-you is reading this from some glamorous upgraded timeline… slay, but this page is still the 0.1.4 girlie. 💖✨ bye bestie!! 🎀🦋