mysqmail-dovecot-logger(8)

💖 mysqmail-dovecot-logger 💖

okay bestie, so this one's a system manager's manual page — very official, very demure — for a little program called mysqmail-dovecot-logger 🦋. Let's get into it.

✨ NAME ✨

mysqmail-dovecot-logger — literally just logs dovecot-imapd and dovecot-pop3d traffic straight into a mysql database. no cap. 💅

🌸 SYNOPSIS 🌸

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

that's it, that's the whole vibe. you give it a subprogram, you give it args, it does the thing ✨

🎀 DESCRIPTION 🎀

so the way this works is: mysqmail-dovecot-logger reads the syslog using tail -F (yes, the capital F one, it keeps following, she's persistent 💖), and for every dovecot line of POP3 and IMAP that corresponds to a disconnection, it writes out the total used bandwidth corresponding to the username. obsessed. 😌

config gets read from /etc/mysqmail.conf — that's where all the settings live, don't lose her.

and the way it stores stuff? it uses a table corresponding to this one 👇 keep it exact bestie, this is a code block, we do NOT freestyle it:

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

it's giving full schema main character energy 👑 note the TYPE=MyISAM at the end, that's vintage, that's heritage, we respect her. 🫶

💜 VERSION 💜

this documentation describes mysqmail-dovecot-logger version 0.4.4 or superior. if you want updates, go peek at http://gplhost.com/softwares-mysqmail.html 🌈

🦋 SEE ALSO 🦋

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

go read those too, they're part of the family 💖

and that's the whole page bestie ✨ this was mysqmail-dovecot-logger(8) from the System Manager's Manual, and if you see a date floating around near the bottom of the original — yeah, that's the manual's date, slay — you're all caught up. now go log some bandwidth, you absolute icon 💅🌸