- dovecot - dovecot.org

[Dovecot] maildri++ quota
by Ralf Hildebrandt 10 Oct '08

10 Oct '08

When is the maildir quota usages recalculated and written to the second line of the "maildirsize" file? I'm using 1.1.4, and I reset the quotas for my users by just taking the first line of their maildirsize file and deleting the rest. -- Ralf Hildebrandt (Ralf.Hildebrandt(a)charite.de) snickebo(a)charite.de Postfix - Einrichtung, Betrieb und Wartung Tel. +49 (0)30-450 570-155 http://www.arschkrebs.de I'm looking for a job "A man who won't die for something is not fit to live." -Martin Luther King, Jr.

3 12

[Dovecot] Test environment question
by Stewart Dean 09 Oct '08

09 Oct '08

My production DC machine owns the mail filesystems and is running DC V1.0.15 and mbox folder format. I am looking to test V1.1.3 on another machine, which NFS mounts the mail filesystems, but has its own local index FS. I have made this test environment my default connection in TBird, and it seems to work just fine. Also, I have made sure that my TBird client isn't connecting to the production server (it has multiple accounts but I have turned off the cehck for mail when starting and check for new mail every N minutes functions, and then check the ps table to make sure there are no imap connections) However, I'm seeing two errmsgs in the maillog on the test machine: > Sep 22 11:54:13 egg mail:err|error dovecot: IMAP(sdean): posix_fallocate() faile > d: Protocol not available > Sep 22 11:54:13 egg mail:err|error dovecot: IMAP(sdean): file_set_size() failed > with mbox file /var/spool/mail/sdean: Protocol not available which appear to happen AFTER mail arrives at the production server....it seems to happen on my test server the next time my client goes to access mail AFTER mail has arrived at the production server. Subsequent client requests of the test server execute without error until AFTER the next time mail arrives at and my inbox is updated with it. Again, if I hadn't looked at the logs, I wouldn't know there was a problem...I can see my new mail just fine from the test server. The questions: Is this anything I should be concerned about? Is this a bug or a legit problem coming from my improper use of two servers against the same data. FWIW, I am using fcntl for both mbox read and write locks. procmail in the MDA on the production server, and its locking hierarchy <dotlock,fcntl>, which Timo previously approved. Thanks! Production dovecot -n output: > # 1.0.15: /usr/local/etc/dovecot.conf > listen: *:143 > ssl_listen: *:993 > disable_plaintext_auth: no > verbose_ssl: yes > login_dir: /var/run/dovecot/login > login_executable: /usr/local/libexec/dovecot/imap-login > login_processes_count: 12 > login_max_processes_count: 774 > verbose_proctitle: yes > first_valid_uid: 200 > mail_location: mbox:~/mail:INBOX=/var/spool/mail/%u:INDEX=/var/dcindx/%u > mbox_write_locks: fcntl > mbox_dirty_syncs: no > auth default: > passdb: > driver: pam > userdb: > driver: passwd Test dovecot -n output: > # 1.1.3: /usr/local/etc/dovecot.conf > listen: *:143 > ssl_listen: *:993 > disable_plaintext_auth: no > verbose_ssl: yes > login_dir: /var/run/dovecot/login > login_executable: /usr/local/libexec/dovecot/imap-login > login_processes_count: 12 > login_max_processes_count: 774 > max_mail_processes: 1024 > verbose_proctitle: yes > first_valid_uid: 200 > mail_location: mbox:~/mail:INBOX=/var/spool/mail/%u:INDEX=/var/dcindx/%u > mbox_write_locks: fcntl > mbox_dirty_syncs: no > auth default: > passdb: > driver: pam > userdb: > driver: passwd

2 6

[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