- dovecot - dovecot.org

[Dovecot] core in lazy_expunge plugin
by Anton Zakatov 24 Nov '08

24 Nov '08

Hello all! dovecot 1.1.6 Use lazy_expunge plugin call core on connect. Core: bt full #0 lazy_expunge_mail_expunge (_mail=0x2ac06e9b89e8) at lazy-expunge-plugin.c:103 lt = (struct lazy_expunge_transaction *) 0x2ac06e9b86e0 deststorage = <value optimized out> #1 0x000000000041cefc in imap_expunge (box=0x2ac06e988de8, next_search_arg=0x0) at imap-expunge.c:31 ctx = (struct mail_search_context *) 0x2ac06e9b87d0 t = (struct mailbox_transaction_context *) 0x2ac06e9aed10 mail = (struct mail *) 0x2ac06e9b89e8 search_arg = {next = 0x0, type = SEARCH_FLAGS, value = {subargs = 0x0, seqset = 0x0, str = 0x0, time = 0, size = 0, flags = MAIL_DELETED, keywords = 0x0}, context = 0x0, hdr_field_name = 0x0, not = 0, match_always = 0, result = -1} failed = <value optimized out> #2 0x00000000004171da in cmd_expunge (cmd=0x2ac06e982378) at cmd-expunge.c:62 client = (struct client *) 0x2ac06e982000 #3 0x000000000041b53c in client_command_input (cmd=0x2ac06e982378) at client.c:580 client = (struct client *) 0x2ac06e982000 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #4 0x000000000041b5f2 in client_command_input (cmd=0x2ac06e982378) at client.c:629 client = (struct client *) 0x2ac06e982000 command = (struct command *) 0x0 __PRETTY_FUNCTION__ = "client_command_input" #5 0x000000000041bdaf in client_handle_input (client=0x2ac06e982000) at client.c:670 _data_stack_cur_id = 3 ret = <value optimized out> remove_io = <value optimized out> handled_commands = false #6 0x000000000041bfd3 in client_input (client=0x2ac06e982000) at client.c:725 cmd = <value optimized out> output = (struct ostream *) 0x2ac06e982298 bytes = 11 __PRETTY_FUNCTION__ = "client_input" #7 0x000000000048c568 in io_loop_handler_run (ioloop=<value optimized out>) at ioloop-epoll.c:203 ctx = <value optimized out> event = (const struct epoll_event *) 0x2ac06e93edc0 list = (struct io_list *) 0x2ac06e981cb0 io = (struct io_file *) 0x2ac06e981c50 tv = {tv_sec = 1799, tv_usec = 999456} events_count = <value optimized out> t_id = 2 msecs = <value optimized out> ret = 1 i = 0 call = <value optimized out> #8 0x000000000048b6ad in io_loop_run (ioloop=0x2ac06e93eb60) at ioloop.c:320 No locals. #9 0x0000000000423471 in main (argc=<value optimized out>, argv=0x0, envp=0x49a7f7) at main.c:293 Config: dovecot -n # 1.1.6: /etc/dovecot.conf # OS: Linux 2.6.18-92.1.13.el5 x86_64 CentOS release 5.2 (Final) base_dir: /var/run/dovecot/ log_path: /var/log/dovecot/dovecot.log info_log_path: /var/log/dovecot/dovecot.info.log protocols: imap imaps pop3 pop3s managesieve listen: * ssl_listen: * ssl_cipher_list: ALL:!LOW:!SSLv2 disable_plaintext_auth: yes verbose_ssl: yes login_dir: /var/run/dovecot//login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login login_executable(managesieve): /usr/libexec/dovecot/managesieve-login login_greeting_capability(default): yes login_greeting_capability(imap): yes login_greeting_capability(pop3): no login_greeting_capability(managesieve): no verbose_proctitle: yes mail_access_groups: vmail mail_uid: vmail mail_gid: vmail mail_location: maildir:~/:INBOX=~/.INBOX:INDEX=/data/maildata/dovecot/INDEX/%Lu/mail-indexes maildir_stat_dirs: yes maildir_copy_preserve_filename: yes mail_drop_priv_before_exec: yes mail_executable(default): /usr/local/bin/dovecot-imap-proxy mail_executable(imap): /usr/local/bin/dovecot-imap-proxy mail_executable(pop3): /usr/local/bin/dovecot-pop3-proxy mail_executable(managesieve): /usr/local/bin/dovecot-managesieve-proxy mail_plugins(default): quota imap_quota expire fts fts_squat listescape acl antispam zlib autocreate trash mail_plugins(imap): quota imap_quota expire fts fts_squat listescape acl antispam zlib autocreate trash lazy_expunge mail_plugins(pop3): quota expire mail_plugins(managesieve): mail_plugin_dir(default): /usr/lib64/dovecot/imap mail_plugin_dir(imap): /usr/lib64/dovecot/imap mail_plugin_dir(pop3): /usr/lib64/dovecot/pop3 mail_plugin_dir(managesieve): /usr/lib64/dovecot/managesieve imap_client_workarounds(default): outlook-idle delay-newmail imap_client_workarounds(imap): outlook-idle delay-newmail imap_client_workarounds(pop3): imap_client_workarounds(managesieve): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh pop3_client_workarounds(managesieve): dict_db_config: /etc/dovecot/dovecot-db.conf sieve_storage(default): sieve_storage(imap): sieve_storage(pop3): sieve_storage(managesieve): /data/maildata/dovecot/sieve/%u sieve(default): sieve(imap): sieve(pop3): sieve(managesieve): ~/.dovecot.sieve namespace: type: private separator: / inbox: yes list: yes subscriptions: yes namespace: type: private separator: / prefix: Archive/ location: maildir:~/archive:INDEX=/data/maildata/dovecot/INDEX/%Lu/archive-indexes:CONTROL=/data/maildata/dovecot/CONTROL/%Lu/archive-control list: yes subscriptions: yes namespace: type: private separator: / prefix: EXPUNGED/ location: maildir:~/expunged list: yes subscriptions: yes namespace: type: private separator: / prefix: DELETED/ location: maildir:~/deleted list: yes subscriptions: yes namespace: type: private separator: / prefix: DELETED/EXPUNGED/ location: maildir:~/deleted/expunged list: yes subscriptions: yes namespace: type: public separator: / prefix: Public/ location: maildir:/data/maildata/mailboxes/%d/public/:INDEX=/data/maildata/dovecot/INDEX/%Lu/public list: yes namespace: type: public separator: / prefix: Public/info/ location: maildir:/data/maildata/mailboxes/%Ld/info:INDEX=/data/maildata/dovecot/INDEX/%Lu/public-info list: yes namespace: type: public separator: / prefix: Public/fax/ location: maildir:/data/maildata/mailboxes/abn.ru/fax:INDEX=/data/maildata/dovecot/INDEX/%Lu/public-fax list: yes namespace: type: public separator: / prefix: Public/info/Archive/ location: maildir:/data/maildata/mailboxes/%Ld/info/archive:INDEX=/data/maildata/dovecot/INDEX/%Lu/public-info-archive list: yes namespace: type: public separator: / prefix: Admins/ location: maildir:/data/maildata/mailboxes/abn.ru/root/:INDEX=/data/maildata/dovecot/INDEX/%Lu/root-indexes list: yes namespace: type: public separator: / prefix: Users/ location: maildir:/data/maildata/mailboxes/%d/shared_users/:INDEX=/data/maildata/dovecot/INDEX/%Lu/shared_users list: yes subscriptions: yes auth default: mechanisms: plain login realms: abn.ru default_realm: abn.ru cache_size: 1000 cache_negative_ttl: 0 username_format: %Lu master_user_separator: * worker_max_request_count: 500 passdb: driver: passwd-file args: /etc/dovecot/passwd.masterusers pass: yes master: yes passdb: driver: passwd-file args: username_format=%Ln /etc/dovecot/passwd.static passdb: driver: pam args: cache_key=%u%r username=%Ln nochangeuser=yes dovecot userdb: driver: static args: allow_all_users=yes uid=501 gid=501 username=%Ln domain=%Ld home=/data/maildata/mailboxes/%Ld/%Ln socket: type: listen client: path: /var/spool/postfix/private/dovecot-smtp-auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 438 user: vmail group: vmail plugin: quota: dict:user:%u:proxy::quotadict quota_rule: *:storage=5G quota_rule2: Trash:storage=500M quota_rule3: spam:ignore quota_rule4: Spam:ignore quota_warning: storage=95%% /usr/local/bin/quota-warn.sh 95 quota_warning2: storage=80%% /usr/local/bin/quota-warn.sh 80 acl: vfile:/data/maildata/dovecot/dovecot-acls:cache_secs=300 trash: /etc/dovecot/trash.conf expire: Trash 7 Trash/* 7 Spam 14 spam 14 spam/* 14 expire_dict: proxy::expiredict lazy_expunge: EXPUNGED/ DELETED/ DELETED/EXPUNGED/ autocreate: spam autosubscribe: spam fts: squat fts_squat: partial=4 full=10 antispam_trash: trash;Trash;Deleted Items; antispam_spam: SPAM;spam;Spam;Junk;&BB0ENQQ2BDUEOwQwBE~E8- &BD8EPgRHBEIEMA-;junk antispam_mail_sendmail: /usr/local/bin/spam-train antispam_mail_sendmail_args: --for;%u antispam_mail_spam: spam antispam_mail_notspam: ham antispam_mail_tmpdir: /tmp dict: quotadict: mysql:/etc/dovecot/dovecot-dict-quota.conf expiredict: mysql:/etc/dovecot/dovecot-dict-expire.conf

2 1

[Dovecot] OT: Run Sieve On A Mailbox Manually
by Neil 22 Nov '08

22 Nov '08

(Apologies for being offtopic.) The subject basically says it all...does anyone know of a tool to run a sieve script on a mailbox (in particular, Maildirs) manually? Ideally, I'd like to do it without adding a bunch of new headers to the mail. So, could I just do a find (or for-loop, if it was just one maildir) command and pipe all the mails into deliver..? Thanks, Neil.

2 3

[Dovecot] folder deletion response problem
by Amr Shahin 22 Nov '08

22 Nov '08

dovecot version: 1.1.6 dovecot -n output # 1.1.6: /etc/dovecot/dovecot.conf # OS: Linux 2.6.18-53.el5PAE i686 CentOS release 5.2 (Final) ext3 log_path: /usr/local/dovecot/log protocols: imap ssl_disable: yes disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable: /usr/local/dovecot/libexec/dovecot/imap-login last_valid_uid: 510 mail_location: maildir:/var/mails/%n:CONTROL=/var/no-quota/%n mail_executable: /usr/local/dovecot/libexec/dovecot/imap mail_plugins: quota imap_quota mail_plugin_dir: /usr/local/dovecot/lib/dovecot imap_capability: IMAP4rev1 SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ IDLE CHILDREN NAMESPACE LOGIN-REFERRALS UIDPLUS LIST-EXTENDED I18NLEVEL=1 AUTH=PLAIN auth default: executable: /usr/local/dovecot/libexec/dovecot/dovecot-auth debug: yes passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: passwd socket: type: listen client: path: /var/run/dovecot/auth-client mode: 432 master: path: /var/run/dovecot/auth-master mode: 438 plugin: quota: maildir:User quota quota_rule: *:storage=1G quota_rule2: Trash:ignore quota_rule3: Spam:ignore sieve: /var/sieve-scripts/%n.sieve ============================================= grep -v '^ *$#.*$\?$' output: auth_debug=yes protocols = imap disable_plaintext_auth = no log_path = /usr/local/dovecot/log ssl_disable = yes login_user = dovecot mail_location = maildir:/var/mails/%n:CONTROL=/var/no-quota/%n first_valid_uid = 500 last_valid_uid = 510 first_valid_gid = 1 last_valid_gid = 0 protocol imap { login_executable = /usr/local/dovecot/libexec/dovecot/imap-login mail_executable = /usr/local/dovecot/libexec/dovecot/imap imap_capability = IMAP4rev1 SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ IDLE CHILDREN NAMESPACE LOGIN-REFERRALS UIDPLUS LIST-EXTENDED I18NLEVEL=1 AUTH=PLAIN mail_plugins = quota imap_quota mail_plugin_dir = /usr/local/dovecot/lib/dovecot } protocol pop3 { } protocol lda { postmaster_address = amrnablus(a)gmail.com hostname=maktoob.com mail_plugins = quota cmusieve mail_plugin_dir = /usr/local/dovecot/lib/dovecot/lda/ sendmail_path=/usr/sbin/sendmail.postfix auth_socket_path = /var/run/dovecot/auth-master mode = 384 } auth_executable = /usr/local/dovecot/libexec/dovecot/dovecot-auth auth default { mechanisms = plain user = root passdb sql { args = /etc/dovecot/dovecot-sql.conf } userdb sql { args = /etc/dovecot/dovecot-sql.conf } socket listen { master { path = /var/run/dovecot/auth-master mode = 0666 } client { path = /var/run/dovecot/auth-client mode = 0660 } } userdb passwd { } user = root } dict { } plugin { quota = maildir:User quota quota_rule = *:storage=1G quota_rule2 = Trash:ignore quota_rule3 = Spam:ignore sieve = /var/sieve-scripts/%n.sieve } ================================== the problem is that when i try to delete an existing directory in a mailbox, it gets actually deleted, but the response says that the mailbox does not exist, please check this log: 1 login <username> <password> 1 OK Logged in. 1 Create AAA 1 OK Create completed. 1 list "" "*" * LIST (\HasNoChildren) "." "TestDir" * LIST (\HasNoChildren) "." "Contacts" * LIST (\HasNoChildren) "." "Calendar" * LIST (\HasNoChildren) "." "Notes" * LIST (\HasNoChildren) "." "Tasks" * LIST (\HasNoChildren) "." "Spam" * LIST (\HasNoChildren) "." "Draft" * LIST (\HasNoChildren) "." "Trash" * LIST (\HasNoChildren) "." "Journal" * LIST (\HasNoChildren) "." "Sent" * LIST (\HasNoChildren) "." "AAA" * LIST (\HasNoChildren) "." "INBOX" 1 OK List completed. 1 Delete AAA 1 NO Mailbox doesn't exist: AAA 1 list "" "*" * LIST (\HasNoChildren) "." "TestDir" * LIST (\HasNoChildren) "." "Contacts" * LIST (\HasNoChildren) "." "Calendar" * LIST (\HasNoChildren) "." "Notes" * LIST (\HasNoChildren) "." "Tasks" * LIST (\HasNoChildren) "." "Spam" * LIST (\HasNoChildren) "." "Draft" * LIST (\HasNoChildren) "." "Trash" * LIST (\HasNoChildren) "." "Journal" * LIST (\HasNoChildren) "." "Sent" * LIST (\HasNoChildren) "." "INBOX" 1 OK List completed. 1 logout * BYE Logging out 1 OK Logout completed.

3 2

[Dovecot] mail_privileged_group not working for dotlock files (1.1.6)
by Rob Mangiafico 22 Nov '08

22 Nov '08

Hello, Running dovecot 1.1.6 on centOS 5 and RHEL 5. With the settings: pop3_lock_session = yes mail_privileged_group = mail mail_location = mbox:~/:INBOX=/var/spool/mail/%u mbox_read_locks = fcntl mbox_write_locks = dotlock fcntl and /var/spool/mail permissions: drwxrwx--x 2 root mail 4096 Nov 19 10:16 mail/ Trying to connect via POP3 results in this error: --- Nov 19 09:31:01 lexiconn2 dovecot: child 32127 (pop3) killed with signal 11 Nov 19 09:31:01 lexiconn2 dovecot: POP3(cerberus): file_lock_dotlock() failed with mbox file /var/spool/mail/xxx: Permission denied Nov 19 09:31:01 lexiconn2 dovecot: pop3-login: Login: user=<xxx>, method=PLAIN, rip=1.2.3.4, lip=5.6.7.8, secured --- The docs seem to indicate the above config / settings should work. Is this a bug? The reason we have dotlock as the primary format is due to procmail LDA from sendmail: --- procmail -v 2>&1|grep Locking Locking strategies: dotlocking, fcntl() --- I assume we have to make the "mbox_write_locks" match the procmail locking... Thanks. Rob

2 3

[Dovecot] expire-tool fails if mail_location contains %h
by Thorsten Vollmer 21 Nov '08

21 Nov '08

Hi Timo, not long ago you fixed a bug regarding the expansion of ~/ in mail_location that prevented expire-tool from working correctly. A similar problem exists if mail_location contains %h: expire-tool will use the wrong path to access the mailbox. After replacing %h with ~, expire-tool works as expected. Why are there two variables for the home directory? Maybe the use of %h could be discouraged, sparing you some problems. Regards, Thorsten

2 2

[Dovecot] Separate quotas not displayed correctly
by Laurent Blume 21 Nov '08

21 Nov '08

Hello all, My system is set up to have quotas both on /var/mail, where emails are received, and on /export/home, where users' homedirs are. But the client (Thunderbird) shows the same /export/home values both for the Inbox and for the folders in the homedir, so a user cannot know where she stands on her /var/mail use. This is Dovecot 1.1.5. As per the wiki, the dovecot.conf file contains this: quota = fs:INBOX:mount=/var/mail quota2 = fs:Others:mount=/export/home A sample user: # quota -v testimap Disk quotas for testimap (uid 1143): Filesystem usage quota limit timeleft files quota limit timeleft /export/home 6490 10000 15000 0 0 0 /var/mail 0 20000 25000 0 0 0 When Icheck the Quota tab in the Properties of the Inbox, the field contains "Others", and the value are 6490 out of 10000. Any idea why this doesn't display the value of /var/mail? Laurent -- / Leader de Projet & Communauté | I'm working, but not speaking for \ G11N http://fr.opensolaris.org | Bull Services http://www.bull.com / FOSUG http://guses.org |

2 5

[Dovecot] FW: nfs troubles
by Bas van Oosterum 21 Nov '08

21 Nov '08

Hi all, I upgraded to dovecot 1.1.6 to be able to use NFS. Got a little issue: I can't move mail to another IMAP folder (so I can't delete to: moving to .trash does not work. Error message Oct 31 11:07:45 jozua-mailserver dovecot: IMAP(nicolette(a)kerknet.org): fdatasync_path(/var/mail/kerknet.org/nicolette/Maildir/.Trash/cur) failed: Invalid Argument I tried to use ll sorts of locking: no difference Who can help? Regards, Bas

2 3

[Dovecot] Dovecot and Bogofilter
by Matthias-Christian Ott 21 Nov '08

21 Nov '08

Hi, on my small Xen-virtualised server with 48 MiB RAM I use Postfix and Dovecot, because the Debian administrators dislike qmail [1], which is in my opinion despite some maintainability and code quality issues a quite well designed software, because it mostly follows the UNIX principles. Postfix is not able to sort my E-Mail into different Maildir folders and after I looked at procmail's source code, I decided to use Dovecot's LDA, because it supports sieve via a plugin. All in all it worked after some tweaking and Dovecot is now responsible for authentication and delivery. Furthermore I want to setup a spam filter and due to the memory constraints I decided in favour of bogofilter (I made no real world tests, but the authors claim that it's fast and has a small memory footprint). My first idea was train bogofilter via a cronjob that runs bogofilter for each E-Mail in my spam folder and deletes them afterwards. Then I stumbled upon the dovecot antispam [2] plugin and quickly wrote a backend for bogofilter. During the development I realised that bogofilter has to update the X-Bogosity header of the reclassified E-Mails. Johannes Berg told me that he wasn't sure whether dovecot would be able to do this and recommended to ask this on the mailing list. An other problem is that each mail needs to be initially classified and due to the fact that sieve is not able to execute external programmes, deliver has to do this task. I'm currently thinking of possibilities to implement this, so far I came up with the following: 1. Write a generic pipe plugin which can execute an arbitrary number of programmes. The problem with this is that I'm not sure how to integrate this is in Dovecot's configuration file. I thought of something like this: pipe = prg1 | prg2 2. Write a bogofilter-specific plugin for this. Anyhow I would like to take this opportunity to criticise Dovecot for being a bloated (unnecessary abstractions, verbose, pseudo object-oriented, ...), non-suckless [3] and non-unixish (plugin architecture, monolithic design, ...) software which in return works quite well and stable so far. I appreciate any suggestions, ideas or criticism. I would really like to finish configuring my mail server as soon as possible. Regards, Matthias-Christian [1] http://smarden.org/pape/Debian/1215531259.4854_332.werc [2] http://johannes.sipsolutions.net/Projects/dovecot-antispam [3] http://www.suckless.org/common/

9 16

[Dovecot] nfs_flush_fcntl failed: No locks available
by Mark Zealey 21 Nov '08

21 Nov '08

Hi there, I've been seeing this error in our logs quite frequently on our nfs storage (v3): 2008-11-10T13:24:26+00:00 mail8 dovecot: IMAP(XXX(a)YYY.com): nfs_flush_fcntl: fcntl(/var/spool/mail/XXX/Maildir/dovecot.index.cache, F_RDLCK) failed: No locks available Which is because we don't run lockd on our servers. Why is dovecot trying to use fcntl() ? I explicitly set it to use dotlocks in the dovecot config: # 1.1.6: /etc/dovecot.conf # OS: Linux 2.6.18-92.el5 i686 CentOS release 5.2 (Final) base_dir: /var/run/dovecot/ protocols: imap pop3 mail_location: maildir:~/Maildir mmap_disable: yes mail_nfs_storage: yes mail_nfs_index: yes lock_method: dotlock maildir_copy_preserve_filename: yes mbox_write_locks: dotlock This happens for both pop and imap (however more frequently with imap). Thanks, Mark -- Mark Zealey -- Shared Hosting Team Leader Product Development * Webfusion 123-reg.co.uk, webfusion.co.uk, donhost.co.uk, supanames.co.uk This mail is subject to http://www.gxn.net/disclaimer

2 2

[Dovecot] For Configuration Help: per-user quota for virtual users.
by sales＠100n.org 21 Nov '08

21 Nov '08

Dear dovecot list: Could any experts help me on the configuration of per-user for dovecot on FreeBSD 7.x with postfix-2.5.4,1. I followed the howto of http://workaround.org/articles/ispmail-etch/, it is an excellent file, my mailserver worked very well. When I configured per-user quota plug-in, quota_rule with 20MB limits can not be overrided by the Mysql query statement, Although I followed the document at : http://wiki.dovecot.org/Quota. Below is the output of dovecot --version, dovecot -n and dovecot-sql.conf. Could any experts help me? Thanks in advance ! Best Regards, Forrest --------------------------------- ns1# dovecot --version 1.1.2 ns1# dovecot -n # 1.1.2: /usr/local/etc/dovecot.conf protocols: imap pop3 pop3s imaps login_dir: /var/run/dovecot/login login_executable(default): /usr/local/libexec/dovecot/imap-login login_executable(imap): /usr/local/libexec/dovecot/imap-login login_executable(pop3): /usr/local/libexec/dovecot/pop3-login verbose_proctitle: yes first_valid_gid: 0 mail_privileged_group: mail mail_location: maildir:/home/vmail/%d/%n/Maildir mail_executable(default): /usr/local/libexec/dovecot/imap mail_executable(imap): /usr/local/libexec/dovecot/imap mail_executable(pop3): /usr/local/libexec/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugin_dir(default): /usr/local/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3 imap_client_workarounds(default): delay-newmail netscape-eoh tb-extra-mailbox-sep imap_client_workarounds(imap): delay-newmail netscape-eoh tb-extra-mailbox-sep imap_client_workarounds(pop3): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh auth default: mechanisms: plain login passdb: driver: sql args: /usr/local/etc/dovecot-sql.conf userdb: driver: passwd userdb: driver: static args: uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 384 user: vmail plugin: quota: maildir quota_rule: *:storage=20M quota_rule2: Trash:storage=10M quota_warning: storage=95%% /usr/local/bin/quota-warning.sh 95 quota_warning2: storage=80%% /usr/local/bin/quota-warning.sh 80 ns1# grep -v '^ *$#.*$\?$' dovecot-sql.conf driver = mysql connect = host=127.0.0.1 dbname=****** user=****** password=******** default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u'; user_query = select 5000 as uid, 5000 as gid, '/home/vmail/%d/%n' as home, \ concat('*:bytes=', quota_bytes) as quota_rule \ from email_quota where email = '%u'

2 1