Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysqmail-dovecot-logger(8) [debian man page]

mysqmail-dovecot-logger(8)				      System Manager's Manual					mysqmail-dovecot-logger(8)

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, mysq- mail-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), logger(8) mysqmail-dovecot-logger(8)

Check Out this Related Man Page

DOVECONF(1)							      Dovecot							       DOVECONF(1)

NAME
doveconf - Dovecot's configuration dumping utility SYNOPSIS
doveconf [-adnNSx] [-c config-file] [-f filter] [-m module] doveconf [-n] [-c config-file] section_name ... doveconf [-h] [-c config-file] [-f filter] setting_name ... DESCRIPTION
doveconf reads and parses Dovecot's configuration files and converts them into a simpler format used by the rest of Dovecot. All standalone programs, such as dovecot(1) and dovecot-lda(1), will first get their settings by executing doveconf. For system administrators, doveconf is mainly useful for dumping the configuration in easy human readable output. OPTIONS
-a Show all settings with their currently configured values. -c config-file read configuration from the given config-file. By default /etc/dovecot/dovecot.conf will be used. -d Show the setting's default value instead of the one currently configured. -f filter Show the matching configuration for the specified filter condition. The filter option string has to be given as name=value pair. For multiple filter conditions the -f option can be supplied multiple times. Possible names for the filter are: lname The local hostname, e.g. mail.example.com. This will only match hostnames which were configured like: local_name mail.example.com { # special settings } local The server's hostname or IP address. This will also match hostnames which were configured like: local imap.example.net { # special settings } protocol, service The protocol, e.g. imap or pop3 remote The client's hostname or IP address. -h Hide the setting's name, show only the setting's value. -m module Show only settings for the given module. e.g. imap, imap-login, lmtp, pop3 or pop3-login -n Show only settings with non-default values. -N Show settings with non-default values and explicitly set default values. -S Dump settings in simplified machine parsable/readable format. -x Expand configuration variables (e.g. $mail_plugins => quota) and show file contents (from e.g. ssl_cert = </etc/ssl/certs/dove- cot.pem). section_name Show only the current configuration of one or more specified sections. setting_name Show only the setting of one or more setting_name(s) with the currently configured value. You can show a setting inside a section using '/' as the section separator, e.g. service/imap/executable. EXAMPLE
When Dovecot was configured to use different settings for some networks/subnets it is possible to show which settings will be applied for a specific connection. doveconf -f local=10.0.0.110 -f remote=10.11.1.2 -f service=pop3 -n doveconf can be also used to convert v1.x configuration files into v2.x format. doveconf -n -c /oldpath/dovecot.conf > /etc/dovecot/dovecot.conf.new This example shows how to ask doveconf for a global setting and a protocol specific setting. The second command uses also the -h option, in order to hide the setting's name. doveconf mail_plugins mail_plugins = quota doveconf -h -f protocol=imap mail_plugins quota imap_quota This example demonstrates how to dump a whole configuration section. doveconf dict dict { quota = pgsql:/etc/dovecot/dovecot-dict-sql.conf.ext } Or how to dump only the quota dict: doveconf dict/quota dict/quota = pgsql:/etc/dovecot/dovecot-dict-sql.conf.ext REPORTING BUGS
Report bugs, including doveconf -n output, to the Dovecot Mailing List <dovecot@dovecot.org>. Information about reporting bugs is avail- able at: http://dovecot.org/bugreport.html SEE ALSO
doveadm(1), dovecot(1), dovecot-lda(1), dsync(1) Dovecot v2.2 2012-01-29 DOVECONF(1)
Man Page