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

# mysqmail-dovecot-logger(8)

logs dovecot-imapd and dovecot-pop3d traffic to a mysql database

## NAME

mysqmail-dovecot-logger - logs dovecot-imapd and dovecot-pop3d traffic to a mysql database

## SYNOPSIS

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

## DESCRIPTION

**mysqmail-dovecot-logger** reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysqmail-dovecot-logger writes the total used bandwidth corresponding to the username. Configuration is read from /etc/mysqmail.conf.

**mysqmail-dovecot-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

## VERSION

This documentation describes **mysqmail-dovecot-logger** version 0.4.4 or superior. See **http://gplhost.com/softwares-mysqmail.html** for updates.

## SEE ALSO

qmail-send(3), [syslog(3)](/syslog/3.md), logger(8)