- dovecot - dovecot.org

[Dovecot] shared mailboxes in 1.2 question
by Robert Schetterer 09 Oct '08

09 Oct '08

Hi Timo, i tried a littel bit playing with shared mailboxes namespace shared { separator = / # %%u gets expanded to the remote user. Instead of %%u you can # also use %%n and %%d. prefix = "shared/" location = maildir:/usr/local/virtual/%d:CONTROL=/usr/local/virtual/%d:INDEX=/usr/local/virtual/%d inbox = no list = yes subscriptions = yes hidden = no } should at last show all other users mailboxes when .DEFAULT acl is authenticated lr and dovecot-acl in /usr/local/virtual/%d is authenticated lr too but instead only shared is shown in thunderbird playing with %%u etc in combinations does not lead to working results too (sometimes shared^^ was shown, might be user(a)domain.de isnt working for shared maildirs, @ could be a problem to maildir....?) your example was namespace shared { separator = / # %%u gets expanded to the remote user. Instead of %%u you can # also use %%n and %%d. prefix = shared/%%u/ location = Maildir:/home/%%u/Maildir:INDEX=~/Maildir/shared/%%u } so something with acl might not working in 1.2 and i think i need more explanation ( examples ...) in using %%u %%d ... to test shared mailboxes there were no usefull log entries which would give some more advice during testing...so it might be my fault and it only config stuff i didnt understand -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria

3 19

[Dovecot] Maildir size report for imap?
by Mark Zealey 09 Oct '08

09 Oct '08

Hi guys, It would be really nice if there were an easy way to see how much space an individual imap account used when a user logged out; something like pop3_logout_format = size=%s. I appreciate that this isn't so easy in imap though - I was thinking of using the quota plugin with no limit or something like that. 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

1 0

[Dovecot] 1.1.4 and trouble over NFS
by Igor Colombi 09 Oct '08

09 Oct '08

Hello, I have some trouble with the current setup (it's a testing environment): 2 server with Dovecot 1.1.4 from source (OS Debian testing 2.6.26) (name: "exim" and "exim2") 1 NFS server (OS Debian testing 2.6.26) I use NFS v.4, indexes shared over NFS. The relavant part of Dovecot configuration: dotlock_use_excl = yes mail_nfs_storage = yes mail_nfs_index = yes mmap_disable = yes lock_method = dotlock Maildir format. /etc/exports on NFS server: /mnt 192.168.0.0/24(rw,sync,no_root_squash,no_subtree_check,fsid=0) /mnt/vexim 192.168.0.0/24(rw,sync,no_root_squash,no_subtree_check) /etc/fstab on the clients: 192.168.0.71:/vexim /mnt/nfs1 nfs4 rw 0 0 When I access a mailbox with 2 different clients (for example Outlook Express that uses "exim" and Thunderbird that uses "exim2") and in the same time some message is delivered to the mailbox (the smtp is served by Exim 4.69) Dovecot has some trouble as you can see: *** Log from machine "exim" Oct 7 20:00:20 exim dovecot: IMAP(postmaster(a)minnie.tld): /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot-uidlist: file size changed unexpectedly after write Oct 7 20:00:20 exim dovecot: IMAP(postmaster(a)minnie.tld): Broken file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot-uidlist line 3: Invalid data: Oct 7 20:00:21 exim dovecot: IMAP(postmaster(a)minnie.tld): /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot-uidlist: Duplicate file entry at line 6: 1223402420.H172077P24365.exim.bnscr.it:2, (uid 16919 -> 16922) Oct 7 20:00:23 exim dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=10612 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Append with UID 16925, but next_uid = 16926 Oct 7 20:00:23 exim dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=10724 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Extension record update for invalid uid=16926 Oct 7 20:00:23 exim dovecot: IMAP(postmaster(a)minnie.tld): Synchronization corrupted index header: /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:00:23 exim dovecot: IMAP(postmaster(a)minnie.tld): fscking index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:00:23 exim dovecot: IMAP(postmaster(a)minnie.tld): Fixed index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: first_recent_uid 16927 -> 16926 Oct 7 20:00:24 exim dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=11140 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Extension record update for invalid uid=16928 Oct 7 20:00:24 exim dovecot: IMAP(postmaster(a)minnie.tld): fscking index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:01:00 exim dovecot: imap-login: Login: user=<postmaster(a)minnie.tld>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 7 20:02:00 exim dovecot: imap-login: Login: user=<postmaster(a)minnie.tld>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 7 20:02:26 exim dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=11628 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Append with UID 16929, but next_uid = 16930 Oct 7 20:02:26 exim dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=11756 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Extension record update for invalid uid=16930 Oct 7 20:02:26 exim dovecot: IMAP(postmaster(a)minnie.tld): fscking index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:15:23 exim dovecot: Panic: IMAP(postmaster(a)minnie.tld): Message count decreased Oct 7 20:15:23 exim dovecot: IMAP(postmaster(a)minnie.tld): Raw backtrace: imap [0x80d6781] -> imap [0x80d6802] -> imap [0x80d6199] -> imap [0x8069711] -> imap [0x805e98b] -> imap [0x805ea40] -> imap [0x809c9af] -> imap(io_loop_handle_timeouts+0xe9) [0x80ddb19] -> imap(io_loop_handler_run+0x82) [0x80de3d2] -> imap(io_loop_run+0x20) [0x80dd8c0] -> imap(main+0x46a) [0x806b5aa] -> /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb7df2455] -> imap [0x805c9f1] *** Log from machine "exim" Oct 7 20:00:20 exim2 dovecot: IMAP(postmaster(a)minnie.tld): /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot-uidlist: Duplicate file entry at line 5: 1223402419.H453623P30627.exim2.bnscr.it:2, (uid 16919 -> 16920) Oct 7 20:00:22 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=10496 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Extension record update for invalid uid=16925 Oct 7 20:00:22 exim2 dovecot: IMAP(postmaster(a)minnie.tld): fscking index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:00:25 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=11324 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Append with UID 16928, but next_uid = 16929 Oct 7 20:00:25 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Log synchronization error at seq=3,offset=11528 for /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: Extension record update for invalid uid=16929 Oct 7 20:00:26 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Synchronization corrupted index header: /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:00:26 exim2 dovecot: IMAP(postmaster(a)minnie.tld): fscking index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:00:26 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Fixed index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index: first_recent_uid 16930 -> 16929 Oct 7 20:00:26 exim2 dovecot: IMAP(postmaster(a)minnie.tld): fscking index file /mnt/nfs1/minnie.tld/postmaster/Maildir/dovecot.index Oct 7 20:01:49 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Disconnected: Logged out bytes=80/583 Oct 7 20:01:49 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Disconnected: Logged out bytes=20304/276528 Oct 7 20:03:06 exim2 dovecot: imap-login: Login: user=<postmaster(a)minnie.tld>, method=PLAIN, rip=192.168.0.199, lip=192.168.0.72 Oct 7 20:03:09 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Maildir /mnt/nfs1/minnie.tld/postmaster/Maildir: Expunged message reappeared, giving a new UID (old uid=16930, file=1223402424.H796471P30658.exim2.bnscr.it:2,) Oct 7 20:03:09 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Maildir /mnt/nfs1/minnie.tld/postmaster/Maildir: Expunged message reappeared, giving a new UID (old uid=16931, file=1223402425.H483603P24395.exim.bnscr.it:2,) Oct 7 20:03:09 exim2 dovecot: IMAP(postmaster(a)minnie.tld): Maildir /mnt/nfs1/minnie.tld/postmaster/Maildir: Expunged message reappeared, giving a new UID (old uid=16932, file=1223402425.H824041P30664.exim2.bnscr.it:2,) I know that with Dovecot < 1.1 the use on multiple computer when users are connected randomly was discouraged, but with version 1.1.x this setup is safe. I can try to move indexes on the local disk, the trouble with dovecot.index disappear but I have again problem with dovecot-uidlist. I can reproduce this kind of problem easly: 2 clients on the same mailbox connected to two different imap server and a simple bash script that send 2 email every 1 second to the mailbox. There is some option/configuration that I can try to change?

3 4

[Dovecot] zlib plugin
by Luuk 09 Oct '08

09 Oct '08

hi, Could anyone give some info on this plugin? When i read the wiki (http://wiki.dovecot.org/Plugins/Zlib) i'm still left with some questions... I use Maildir to store my mails, if i enable this zlib-plugin, should i 'manually' compress all messages? or wil the uncompressed messages still be accessible by dovecot? wil new messages be compressed automagically? how should the compressed messages be named? a message now has the name '1223224520.2783_1.opensuse:2,S' how would a compressed message be named? ['1223224520.2783_1.opensuse:2,SZ' or '1223224520.2783_1.opensuse:2,S,Z' or ???] Last but not least, what gain will i have by using this plugin in combination with Maildir, or will it have more impact when mails are stored in mbox. -- Luuk $ dovecot --version dovecot version 1.1.1 $ uname -srpmio Linux 2.6.18.8-0.10-default x86_64 x86_64 x86_64 GNU/Linux

4 6

Re: [Dovecot] v1.1.2 release candidate
by Alessio Cecchi 09 Oct '08

09 Oct '08

Il Thursday 24 July 2008 01:22:28 hai scritto: > On Tue, 2008-07-22 at 11:24 +0200, Alessio Cecchi wrote: > > have you read this thread on vpopmail? > > > > http://www.mail-archive.com/dovecot@dovecot.org/msg11289.html > > This talks about vchkpw instead of the direct vpopmail library support. > Which one do you want to use? > > Anyway implemented this for checkpassword: > http://hg.dovecot.org/dovecot-1.1/rev/5c9057eaac56 Hi Timo, Though very late, I found the time to do further tests on this issue, and I am happy to confirm that after applying patch you introduced the variable TCPLOCALPORT is correctly received by vpopmail if I use the method of authentication "checkpassword" in dovecot.conf with a version >= 1.1.2. So now "Disable non webmail IMAP access" in vpopmail works fine! Thank you Timo! -- Alessio Cecchi is: @ ILS -> http://www.linux.it/~alessice/ Assistenza Sistemi GNU/Linux -> http://www.cecchi.biz/ @ PLUG -> ex-Presidente, adesso senatore a vita, http://www.prato.linux.it @ LOLUG -> neo-Socio http://www.lolug.net

1 0

[Dovecot] Folders within folders?
by ed beers 09 Oct '08

09 Oct '08

I'm trying to migrate my emails from an existing server (University of Washington IMAP toolkit) to dovecot. My clients are all using Thunderbird. I'm moving to a new Ubuntu based server (old one was Centos4) and selected dovecot solely because it was the default option. I'm not committed to it if it isn't the right tool for my application. My existing server allows hierarchical folders and these are used to organize 20 years worth of carefully sorted emails. I can create a new folders on the dovecot server but Thunderbird doesn't allow me to create new sub-folders within them. I think T-bird is configured OK since this works on the old server. Is this a dovecot limitation or have I configured it incorrectly?

3 2

Re: [Dovecot] postfix/dovecot/mysql quotas not working, default dovecot.conf does.
by dovecot＠corwyn.net 09 Oct '08

09 Oct '08

dovecot-sql.conf: driver = mysql connect = host=localhost dbname=postfix user=postfix password=postfix default_pass_scheme = MD5-CRYPT password_query = \ SELECT username, domain, password \ FROM mailbox WHERE username = '%u' AND domain = '%d' AND active = '1' user_query = \ SELECT 1015 as uid, 105 as gid, '/var/spool/mail/%d/%n' as home, \ 'maildir:/var/spool/mail/%d/%n/Maildir' as mail, \ concat('*:storage=', quota, 'B') as quota_rule, \ FROM mailbox WHERE username = '%u' AND domain = '%d' and active = '1' dovecot.conf quota = maildir quota_rule = *:storage=102400 quota_warning = storage=95%% /usr/local/sbin/quota_notify 95 quota_warning2 = storage=80%% /usr/local/sbin/quota_notify 80 Telnet: Connected to 127.0.0.1. Escape character is '^]'. * OK Dovecot ready. . login test111(a)example.com Test111 . OK Logged in. . getquotaroot inbox * QUOTAROOT "inbox" "" * QUOTA "" (STORAGE 67 102400) . OK Getquotaroot completed. Quota still shows what's in dovecot.conf /var/log/maillog Oct 8 17:16:23 webmail dovecot: auth(default): client in: AUTH^I1^IPLAIN^Iservice=imap^Isecured^Ilip=127.0.0.1^Irip=127.0.0.1^Ilport=143^Irport=49601^Iresp=<hidden> Oct 8 17:16:23 webmail dovecot: auth-worker(default): sql(test111(a)example.com,127.0.0.1): query: SELECT username, domain, password FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'example.com' AND active = '1' Oct 8 17:16:23 webmail dovecot: auth(default): client out: OK^I1^Iuser=test111(a)example.com Oct 8 17:16:23 webmail dovecot: auth(default): master in: REQUEST^I11^I23281^I1 Oct 8 17:16:23 webmail dovecot: auth(default): passwd(test111(a)example.com,127.0.0.1): lookup Oct 8 17:16:23 webmail dovecot: auth(default): passwd(test111(a)example.com,127.0.0.1): unknown user Oct 8 17:16:23 webmail dovecot: auth-worker(default): sql(test111(a)example.com,127.0.0.1): SELECT 1015 as uid, 105 as gid, '/var/spool/mail/example.com/test111' as home, 'maildir:/var/spool/mail/example.com/test111/Maildir' as mail, concat('*:storage=', quota, 'B') as quota_rule, FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'example.com' and active = '1' Oct 8 17:16:23 webmail dovecot: auth-worker(default): sql(test111(a)example.com,127.0.0.1): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'example.c' at line 1 Oct 8 17:16:23 webmail dovecot: auth(default): master out: USER^I11^Itest111(a)example.com Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Loading modules from directory: /usr/local/lib/dovecot/imap Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Module loaded: /usr/local/lib/dovecot/imap/lib10_quota_plugin.so Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Module loaded: /usr/local/lib/dovecot/imap/lib11_imap_quota_plugin.so Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Effective uid=1015, gid=105, home= Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Quota root: name= backend=maildir args= Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Quota rule: root= mailbox=* bytes=104857600 (0%) messages=0 (0%) Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Quota warning: bytes=99614720 (95%) messages=0 (0%) command=/usr/local/sbin/quota_notify 95 Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): Quota warning: bytes=83886080 (80%) messages=0 (0%) command=/usr/local/sbin/quota_notify 80 Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): maildir: data=/var/spool/mail/example.com/test111/Maildir Oct 8 17:16:23 webmail dovecot: IMAP(test111(a)example.com): maildir++: root=/var/spool/mail/example.com/test111/Maildir, index=, control=, inbox=/var/spool/mail/example.com/test111/Maildir Oct 8 17:16:23 webmail dovecot: imap-login: Login: user=<test111(a)example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured It looks like the error is in all likelihood here: '/var/spool/mail/example.com/test111' as home, 'maildir:/var/spool/mail/example.com/test111/Maildir' as mail, concat('*:storage=', quota, 'B') as quota_rule, FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'example.com' and active = '1' Oct 8 17:16:23 webmail dovecot: auth-worker(default): sql(test111(a)example.com,127.0.0.1): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'example.c' at line 1 What's interesting is that it's not truncated in the line above it wt? Rick At 04:46 PM 10/8/2008, Timo Sirainen wrote: >On Wed, 2008-10-08 at 16:29 -0400, dovecot(a)corwyn.net wrote: > > >Enable auth_debug=yes and mail_debug=yes and look at the logs. It should > > >show quota_rule being sent as part of "master out" line. > > > > I enabled both of those. in /var/log/maillog I'm don't see a "master" line. > >It should have been before the "Module loaded" etc stuff. Inside the >authentication. But anyway: > > > Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Quota > > root: name=storage=10240 backend=maildir args= > >This looks wrong. Your quota root name is "storage=10240", which really >isn't what you want. > > > Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Quota > > rule: root=storage=10240 mailbox=* bytes=104857600 (0%) messages=0 (0%) > >This is ok. > > > concat('maildir:storage=', quota) as quota, \ > >Remove this entirely. > > > concat('*:storage=', quota, '') as quota_rule, \ > >You also broke this now. :) >

1 0

Re: [Dovecot] postfix/dovecot/mysql quotas not working, default dovecot.conf does.
by dovecot＠corwyn.net 09 Oct '08

09 Oct '08

(and oops forgot to get my last post on the list) Hmm, I pulled a cleaner log file and got this: Oct 8 16:44:51 webmail dovecot: auth(default): new auth connection: pid=14573 Oct 8 16:44:55 webmail dovecot: auth(default): client in: AUTH^I1^IPLAIN^Iservice=imap^Isecured^Ilip=127.0.0.1^Irip=127.0.0.1^Ilport=143^Irport=50346^Iresp=<hidden> Oct 8 16:44:55 webmail dovecot: auth-worker(default): sql(test111(a)example.com,127.0.0.1): query: SELECT username, domain, password FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'example.com' AND active = '1' Oct 8 16:44:55 webmail dovecot: auth(default): client out: OK^I1^Iuser=test111(a)example.com Oct 8 16:44:55 webmail dovecot: auth(default): master in: REQUEST^I28^I14248^I1 Oct 8 16:44:55 webmail dovecot: auth(default): passwd(test111(a)example.com,127.0.0.1): lookup Oct 8 16:44:55 webmail dovecot: auth(default): passwd(test111(a)example.com,127.0.0.1): unknown user Oct 8 16:44:55 webmail dovecot: auth-worker(default): sql(test111(a)example.com,127.0.0.1): SELECT 1015 as uid, 105 as gid, '/var/spool/mail/example.com/test111' as home, 'maildir:/var/spool/mail/example.com/test111/Maildir' as mail, concat('maildir:storage=', quota) as quota, concat('*:storage=', quota, '') as quota_rule, FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'example.com' and active = '1' Oct 8 16:44:55 webmail dovecot: auth-worker(default): sql(test111(a)example.com,127.0.0.1): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mailbox WHERE username = 'test111(a)example.com' AND domain = 'exampl' at line 1 Oct 8 16:44:55 webmail dovecot: auth(default): master out: USER^I28^Itest111(a)example.com Oct 8 16:44:55 webmail dovecot: imap-login: Login: user=<test111(a)example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Loading modules from directory: /usr/local/lib/dovecot/imap Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Module loaded: /usr/local/lib/dovecot/imap/lib10_quota_plugin.so Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Module loaded: /usr/local/lib/dovecot/imap/lib11_imap_quota_plugin.so Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Effective uid=1015, gid=105, home= Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Quota root: name=storage=10240 backend=maildir args= Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Quota rule: root=storage=10240 mailbox=* bytes=104857600 (0%) messages=0 (0%) Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Quota warning: bytes=99614720 (95%) messages=0 (0%) command=/usr/local/sbin/quota_notify 95 Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): Quota warning: bytes=83886080 (80%) messages=0 (0%) command=/usr/local/sbin/quota_notify 80 Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): maildir: data=/var/spool/mail/example.com/test111/Maildir Oct 8 16:44:55 webmail dovecot: IMAP(test111(a)example.com): maildir++: root=/var/spool/mail/example.com/test111/Maildir, index=, control=, inbox=/var/spool/mail/example.com/test111/Maildir I see a sql error in there, but it doesn't make any sense. Why would it hack off the last part of the domain? (domain names have been changed to protect the innocent, it was truncated at 9 characters) rick At 04:29 PM 10/8/2008, Rick Steeves wrote: >At 03:27 PM 10/8/2008, Timo Sirainen wrote: >>Note that dirsize is superslow with maildir. quota=maildir is much >>better. > >Yeah, I knew that, but was trying the simplest option. I've now >switched everything over to maildir. > >> > concat('*:storage=', quota, 'B') as quota_rule, \ >> >>Looks correct. A bit simpler would be concat('*:bytes=',quota) >> >>Enable auth_debug=yes and mail_debug=yes and look at the logs. It should >>show quota_rule being sent as part of "master out" line. > >I enabled both of those. in /var/log/maillog I'm don't see a "master" line. >Here's the log files: > >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Module >loaded: /usr/local/lib/dovecot/imap/lib10_quota_plugin.so >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Module >loaded: /usr/local/lib/dovecot/imap/lib11_imap_quota_plugin.so >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): >Effective uid=1015, gid=105, home= >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Quota >root: name=storage=10240 backend=maildir args= >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Quota >rule: root=storage=10240 mailbox=* bytes=104857600 (0%) messages=0 (0%) >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Quota >warning: bytes=99614720 (95%) messages=0 (0%) >command=/usr/local/sbin/quota_notify 95 >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): Quota >warning: bytes=83886080 (80%) messages=0 (0%) >command=/usr/local/sbin/quota_notify 80 >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): maildir: >data=/var/spool/mail/example.com/test111/Maildir >Oct 8 16:30:32 webmail dovecot: IMAP(test111(a)example.com): >maildir++: root=/var/spool/mail/example.com/test111/Maildir, index=, >control=, inbox=/var/spool/mail/example.com/test111/Maildir > > >I've been tweaking things as I try to figure it out, so I include >the current ones just in case it's critical to what I'm doing wrong > >I DO get dovecot to report quotas, they just don't match the quota >in sql (which for this user currently is 0: >| test111(a)example.com | encryptedpassword | Test TEST | >example.com/test111/ | 0 | example.com | 2008-09-30 17:24:2 > >dovecot.conf: > quota = maildir:storage=10240 > quota_rule = *:storage=102400 > quota_warning = storage=95%% /usr/local/sbin/quota_notify 95 > quota_warning2 = storage=80%% /usr/local/sbin/quota_notify 80 > >dovecot-sql.conf: >driver = mysql >connect = host=localhost dbname=postfix user=postfix password=pfix1723 >default_pass_scheme = MD5-CRYPT >password_query = \ > SELECT username, domain, password \ > FROM mailbox WHERE username = '%u' AND domain = '%d' AND active = '1' >user_query = \ > SELECT 1015 as uid, 105 as gid, '/var/spool/mail/%d/%n' as home, \ > 'maildir:/var/spool/mail/%d/%n/Maildir' as mail, \ > concat('maildir:storage=', quota) as quota, \ > concat('*:storage=', quota, '') as quota_rule, \ > FROM mailbox WHERE username = '%u' AND domain = '%d' and active = '1' > > > >Thanks > >Rick > > >

2 1

[Dovecot] postfix/dovecot/mysql quotas not working, default dovecot.conf does.
by dovecot＠corwyn.net 08 Oct '08

08 Oct '08

I'm having problems getting dovecot to set imap quotas that are defined as individual quotas for virtual users using mysql. I'm using postfix/dovecot 1.1.3, just built from source about a week ago. I've been testing using telnet and getquotaroot. when I define the quota in dovecot.conf quota = dirsize quota_rule = *:storage=102400 I get the following response from Dovecot: # telnet 127.0.0.1 143 Connected to 127.0.0.1. * OK Dovecot ready. . login test222(a)example.com password . OK Logged in. . getquotaroot inbox * QUOTAROOT "inbox" "" * QUOTA "" (STORAGE 276273 102400) All is good (the mailbox IS currently very full as part of my testing). However, when I define that data in the dovecot-sql.conf file, it doesn't appear to pick the data up, either as an override, or, if I delete quota_rule = *:storage=102400 from dovecot.conf, I get no quota at all . getquotaroot inbox . OK No quota. # grep -v '^ *$#.*$\?$' dovecot-sql.conf driver = mysql connect = host=localhost dbname=postfix user=postfix password=password default_pass_scheme = MD5-CRYPT password_query = \ SELECT username, domain, password \ FROM mailbox WHERE username = '%u' AND domain = '%d' AND active = '1' user_query = \ SELECT 1015 as uid, 105 as gid, '/var/spool/mail/%d/%n' as home, \ 'maildir:/var/spool/mail/%d/%n/Maildir' as mail, \ 'dirsize' as quota, \ concat('*:storage=', quota, 'B') as quota_rule, \ FROM mailbox WHERE username = '%u' AND domain = '%d' and active = '1' the results remain the same in telnet. Any assistance would be appreciated. I've done a fair amount of digging, and have no idea why it's not working. ASsociated other configuration below. Thanks! Rick SQL data: mysql> show columns in mailbox; +----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | NO | PRI | | | | password | varchar(255) | NO | | | | | name | varchar(255) | NO | | NULL | | | maildir | varchar(255) | NO | | | | | quota | bigint(20) | NO | | 0 | | | domain | varchar(255) | NO | | | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | | +----------+--------------+------+-----+---------------------+-------+ 9 rows in set (0.00 sec) | test222(a)example.com | hashedpassword | | example.com/test222/ | 153600000 | example.com | 2008-10-01 12:13:54 | 2008-10-06 15:49:51 | 1 | # dovecot -n # 1.1.3: /usr/local/etc/dovecot.conf protocols: imap imaps pop3 pop3s ssl_disable: yes ssl_cert_file: /etc/httpd/host.cert ssl_key_file: /etc/httpd/host.key disable_plaintext_auth: no login_dir: /usr/local/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 mail_uid: 1015 mail_gid: 105 mail_location: maildir:/var/spool/mail/%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 imap_client_workarounds(imap): delay-newmail 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: sql args: /usr/local/etc/dovecot-sql.conf userdb: driver: static socket: type: listen client: path: /var/run/dovecot/auth-client mode: 432 user: vuser group: vuser master: path: /var/run/dovecot/auth-master mode: 384 user: vuser group: vuser plugin: quota: dirsize quota_rule: *:storage=102400 quota_warning: storage=95%% /usr/local/sbin/quota_notify 95 quota_warning2: storage=80%% /usr/local/sbin/quota_notify 80 Rick Steeves http://www.sinister.net "The journey is the destination"

2 1

[Dovecot] Dovecot-sieve processing optimizations
by Roderick A. Anderson 08 Oct '08

08 Oct '08

I'm working at the next part of the virtual domains mail server. I'm moving this account (raanders(a)acm.org is a forwarder) which has a bunch of procmail rules to file into folders. My question is if it is more efficient is use? if { ... } elsif { ... } elsif { ... } else This seems to be the way many of the example scripts do it but I found at least one that used if { ... } if { ... } Which is more procmail like and for me reads easier. If not here where should I ask? Thanks, Rod --

3 3