Unix and Linux Discussions Tagged with default |
|
Thread / Thread Starter |
Last Post |
Replies |
Views |
Forum |
|
|
|
27 |
26,854 |
Linux |
|
|
|
4 |
5,278 |
UNIX for Beginners Questions & Answers |
|
|
|
6 |
5,913 |
Solaris |
|
|
|
0 |
2,079 |
Shell Programming and Scripting |
|
|
|
4 |
3,494 |
Solaris |
|
|
|
4 |
19,365 |
Shell Programming and Scripting |
|
|
|
2 |
11,186 |
Shell Programming and Scripting |
|
|
|
7 |
35,248 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
1,830 |
Software Releases - RSS News |
|
|
|
1 |
1,554 |
Software Releases - RSS News |
|
|
|
1 |
2,745 |
Software Releases - RSS News |
|
|
|
1 |
1,606 |
Software Releases - RSS News |
|
|
|
0 |
1,391 |
Software Releases - RSS News |
|
|
|
0 |
1,131 |
Software Releases - RSS News |
|
|
|
0 |
3,328 |
Infrastructure Monitoring |
|
|
|
0 |
1,574 |
Software Releases - RSS News |
|
|
|
0 |
1,622 |
Software Releases - RSS News |
|
|
|
0 |
1,157 |
Software Releases - RSS News |
|
|
|
0 |
1,383 |
Software Releases - RSS News |
|
|
|
0 |
1,221 |
Software Releases - RSS News |
|
|
|
0 |
1,270 |
Software Releases - RSS News |
|
|
|
0 |
1,246 |
Software Releases - RSS News |
|
|
|
0 |
1,222 |
Software Releases - RSS News |
|
|
|
0 |
1,988 |
Software Releases - RSS News |
|
|
|
0 |
1,487 |
Software Releases - RSS News |
|
|
|
0 |
1,242 |
Software Releases - RSS News |
|
|
|
0 |
1,264 |
Software Releases - RSS News |
|
|
|
0 |
1,201 |
Software Releases - RSS News |
|
|
|
0 |
1,225 |
Software Releases - RSS News |
|
|
|
0 |
1,159 |
Software Releases - RSS News |
|
|
|
0 |
1,294 |
Software Releases - RSS News |
|
|
|
0 |
1,650 |
Software Releases - RSS News |
|
|
|
0 |
1,315 |
Software Releases - RSS News |
|
|
|
0 |
1,112 |
Software Releases - RSS News |
|
|
|
0 |
1,353 |
Software Releases - RSS News |
|
|
|
0 |
1,323 |
Software Releases - RSS News |
|
|
|
0 |
1,187 |
Software Releases - RSS News |
|
|
|
0 |
1,095 |
Software Releases - RSS News |
|
|
|
0 |
1,269 |
Software Releases - RSS News |
|
|
|
0 |
1,100 |
Software Releases - RSS News |
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)