- dovecot - dovecot.org

[Dovecot] Changing password for users
by Mike John 26 Oct '12

26 Oct '12

Hello, I am using dovecot (2.0.9) and using virtual users using passdb { args = /etc/dovecot/dovecotpasswd driver = passwd-file } How can i make my virtual users change their passwords using web interface ? My users already uses squirrelmail to access their mail. is there a program to add to squirrelmail to add this function to the clients ? or should i user different separate website for password changing ? and what program/tool can help me with this ? Any ideas is greatly appreciated. Mike.

2 1

[Dovecot] Snarf plugin
by Jeffrey Ross 26 Oct '12

26 Oct '12

I've now upgraded dovecot from 2.0.21 to 2.1.10 and the good news is I no longer see dovecot crashing when loading the snarf plugin however snarf still does not do anything except make the inbox disappear. I've come to the conclusion that either snarf does not actually work, possible, but I doubt it, or more likely I have a configuration issue preventing it from working. The system is simple, all email is stored in /var/spool/mail/{username} and I want all the mail moved to ~/mbox when the user logs in via imap, similar to uw-imap. Any guidance would really be appreciated. Thanks, Jeff dovecot -n # 2.1.10: //etc/dovecot/dovecot.conf # OS: Linux 3.6.2-1.fc16.x86_64 x86_64 Fedora release 16 (Verne) mail_debug = yes mail_location = mbox:~/mail:INBOX=~/mbox mail_plugins = snarf zlib mbox_write_locks = fcntl namespace default { inbox = yes location = prefix = separator = / } namespace snarf { hidden = yes list = no location = mbox:/run/dovecot/empty:INBOX=/var/spool/mail/%u:INDEX=MEMORY prefix = /snarf separator = / } passdb { driver = pam } plugin { mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename mbox_snarf = ~/mbox snarf = /snarf/INBOX } service imap-login { inet_listener imap { address = localhost } } service pop3-login { inet_listener pop3 { address = localhost } } ssl_cert = </etc/pki/tls/certs/XYZZY.pem ssl_key = </etc/pki/tls/certs/XYZZY.pem userdb { driver = passwd } protocol imap { mail_plugins = snarf zlib imap_zlib } syslog: Oct 24 13:33:27 xyzzy dovecot: master: Warning: SIGHUP received - reloading configuration Oct 24 13:33:27 xyzzy dovecot: imap: Server shutting down. in=277 out=106519 Oct 24 13:33:27 xyzzy dovecot: imap: Server shutting down. in=422 out=2893 Oct 24 13:33:29 xyzzy dovecot: imap-login: Login: user=<jeff>, method=PLAIN, rip=::1, lip=::1, mpid=28089, secured, session=<L6okfNHM2AAAAAAAAAAAAAAAAAAAAAAB> Oct 24 13:33:29 xyzzy dovecot: imap: Debug: Loading modules from directory: /usr/lib64/dovecot Oct 24 13:33:29 xyzzy dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib05_snarf_plugin.so Oct 24 13:33:29 xyzzy dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib20_zlib_plugin.so Oct 24 13:33:29 xyzzy dovecot: imap: Debug: Module loaded: /usr/lib64/dovecot/lib30_imap_zlib_plugin.so Oct 24 13:33:29 xyzzy dovecot: imap(jeff): Debug: Effective uid=500, gid=500, home=/home/jeff Oct 24 13:33:29 xyzzy dovecot: imap(jeff): Debug: Namespace default: type=private, prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes location=mbox:~/mail:INBOX=~/mbox Oct 24 13:33:29 xyzzy dovecot: imap(jeff): Debug: fs: root=/home/jeff/mail, index=, control=, inbox=/home/jeff/mbox, alt= Oct 24 13:33:29 xyzzy dovecot: imap(jeff): Debug: Namespace snarf: type=private, prefix=/snarf, sep=/, inbox=no, hidden=yes, list=no, subscriptions=yes location=mbox:/run/dovecot/empty:INBOX=/var/spool/mail/jeff:INDEX=MEMORY Oct 24 13:33:29 xyzzy dovecot: imap(jeff): Debug: fs: root=/run/dovecot/empty, index=, control=, inbox=/var/spool/mail/jeff, alt= Oct 24 13:33:29 xyzzy dovecot: imap(jeff): Disconnected: Logged out in=117 out=1504

1 1

[Dovecot] Creating Maildir and populating with emails via external Python process
by Bradley Rintoul 26 Oct '12

26 Oct '12

Hello: I'm using Dovecot to provide IMAP services for Thunderbird clients. The user's mail is stored in Maildir format and the individual emails which the user "receives" are actually downloaded and put into the Maildir "repository" using a Python email client (POP3 client). I am trying to create the dovecot-uidlist file and maintain the "next UID" value within it, but I am having trouble with the UIDVALIDITY and the 128 bit mailbox global UID among other things. How can I "seed" a dovecot-uidlist file with these values..? Sorry if the information is not much to go on, please let me know what more information you might need to help point me in the right direction. Thanks, B. RIntoul

7 13

[Dovecot] spamc can't seem to call /usr/lib/dovecot/deliver
by Troy Vitullo 25 Oct '12

25 Oct '12

Hi, My server uses a system comprised of postfix, dovecot and dspam to filter and deliver mail. Postfix used the following flags in calling spamc and dovecot: flags=DRhu user=dovecot:secmail argv=/usr/bin/spamc -u ${recipient} -e /usr/lib/dovecot/deliver -d ${recipient} after an upgrade from Debian lenny to squeeze we were able to get everything working except spam filtering. Spamassassin is able to judge whether the mail coming in is spam but everything stops there. In mail.err I see: pamc[3608]: exec failed: Permission denied spamc shows the same thing in syslog: exec failed: Permission denied postfix delays the email: postfix/pipe[3607]: 50DEFF180EE: to=<[mail]>, relay=dovecot, delay=1.7, delays=0.07/0.01/0/1.6, dsn=4.3.0, status=deferred (system resource problem) Here are the permissions for deliver: -rwsr-x--- 1 root dovecot 865084 May 25 2011 /usr/lib/dovecot/deliver Here are the relevant groups: s1:~# grep dovecot /etc/group secmail:x:119:postfix,spamd,dovecot dovecot:x:111: here's the dovecot user: s1:~# grep dovecot /etc/passwd dovecot:x:108:111:Dovecot mail server,,,:/usr/lib/dovecot:/bin/false here's dovecot -n: # 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.26-2-686 i686 Debian 6.0.6 base_dir: /var/run/dovecot/ protocols: imap imaps pop3s pop3 ssl_cert_file: /etc/ssl/certs/s1.troyvit.com.cert ssl_key_file: /etc/ssl/private/s1.troyvit.com.key ssl_cipher_list: ALL:!LOW disable_plaintext_auth: no verbose_ssl: yes login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login mail_location: maildir:%h/Maildir/ mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 pop3_enable_last(default): no pop3_enable_last(imap): no pop3_enable_last(pop3): yes pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls, oe-ns-eoh pop3_logout_format(default): top=%t/%p, retr=%r/%b, del=%d/%m, size=%s pop3_logout_format(imap): top=%t/%p, retr=%r/%b, del=%d/%m, size=%s pop3_logout_format(pop3): top=%t/%T, retr=%r/%R, del=%d/%m, size=%s namespace: type: private separator: / inbox: yes list: yes subscriptions: yes lda: postmaster_address: postmaster(a)sphere.local auth_socket_path: /var/run/dovecot/auth-master mail_plugin_dir: /usr/lib/dovecot/modules/lda/ mail_plugins: sieve auth default: mechanisms: plain login verbose: yes debug: yes debug_passwords: yes passdb: driver: pam args: dovecot passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: passwd userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 438 user: dovecot plugin: sieve_global_path: /etc/dovecot/default.sieve sieve: /srv/%d/mail/%n/%n.sieve Many thanks in advance for any advice you can give. Troy

4 25

[Dovecot] Dovecot: pipe() failed: Too many open files
by Fasil 25 Oct '12

25 Oct '12

Dear all, Thank you all for such a wonderful support. Hats off to all :) Few times I came across imap login issues where new users will not be allowed to login. /var/log/mail.err shows the error below Aug 12 07:57:46 mail dovecot: dovecot: pipe() failed: Too many open files Aug 12 07:57:46 mail dovecot: dovecot: Temporary failure in creating login processes, slowing down for now Aug 12 07:58:46 mail dovecot: dovecot: pipe() failed: Too many open files Aug 12 07:59:46 mail dovecot: dovecot: pipe() failed: Too many open files Aug 12 08:00:46 mail dovecot: dovecot: pipe() failed: Too many open files I have a dovecot (V 1.2.9) +postfix (V 2.7.0) setup on ubuntu 10.04 # ulimit -Hn 1024 # ulimit -Sn 1024 # cat /proc/sys/fs/file-max 1238548 # cat /proc/`pidof dovecot`/limits | grep 'Max open' Max open files 1024 1024 files Please advice how to get rid off this. Fasil.

3 4

[Dovecot] dovecot auth against AD on samba4
by Carsten Laun-De Lellis 24 Oct '12

24 Oct '12

Hi group I am currently running a mail server on ubuntu 11.04 with postfix 2.8.5, dovecot dovecot 2.0.13 and openldap 2.4.23. I have now read about sogo and I am thinking about installing it because of it's native outlook support capabilities. The ZEG appliance wouldn't be an option for me because I use a virtual server from a provider where I can't install my own vm or even an iso. When I go thru the documentation there is a part with installing OpenChange based on samba4. As far as I understood the OpenChange authentication is against the samba4 AD. Actually there is no support in syncing the AD against an OpenLdap Server and I would have to change the OpenLdap port because the AD is listening on port 389. To change the port wouldn't be a big deal, but what i was thinking about to run the dovecot auth also against the samba 4 AD. I searched around on the internet but didn't find a doc yet how to do that. Does anyone here could provide me with a link or a how-to ? Thanks very much in advance. Regards, Carsten Laun-De Lellis Hauptstrasse 13 D-67705 Trippstadt Phone: +49 6306 992140 Fax: +49 6306 992142 Mobile: +49 151 27530865 email: carsten.delellis(a)delellis.net

2 2

[Dovecot] Clarifications on Pigeonhole and MySQL lookups
by Sandro Tosi 24 Oct '12

24 Oct '12

Hello, we're scouting if it's possible to use Pigeonhole (currently v0.3.1, as this will be provided with an upcoming Debian package) with MySQL dict lookups with the mail setup we're designing. Our (main) goals are: 1. store the filters on the database 2. allow each user to enable/disable any of the filters set we provide (it's a static set of some general filters, available to all the users; we're currently not providing the possibility to users to write their own filters) For point 1) we already see[1] that's possible, but it uses the map construct that might not fit with our current database structure: we have a domain table (storing the domain info) and a mailbox table (storing the mailbox info, but the username is composed by the local part, stored in this table, and the domain part is a FK to the domain table, using an id). Do you think it's possible to run a join query on domain+mailbox to retrieve the mailbox_id needed to query the table for the filters? Or do we have to create the filter table and store the local(a)domain.ext info there ("relaxing" the integrity relationships between tables)? How do we specify which filters are enabled for any given user? We originally thought of an "Enabled" field on the filter table, but in the example in the doc[1] I hadn't seen a way to do that: it seems like the filter list is specified in the proxy definition - am I wrong? How can we do that? [1] http://hg.rename-it.nl/dovecot-2.1-pigeonhole/file/e9ed5d5cef4b/doc/script-… I think it's enough for now, maybe additional questions will arise going deeper in details :) Thanks in advance, -- Sandro Tosi Product Engineer Shared Hosting Products R&D | Dada.pro eml sandro.tosi(a)register.it

2 4

[Dovecot] Maildir hardlinks
by Benedetto Vassallo 23 Oct '12

23 Oct '12

Hello list, Excuse me for my poor english. I have updated on a test server dovecot 2.0.13 to dovecot 2.1.1. All works fine, but with the new version it seems that dovecot don't do hardlinks when deliver a message to multiple users. I have checked my config and the only rule I can see aboout that is maildir_copy_with_hardlinks = yes in /etc/dovecot/conf.d/10-mail.conf My mail location config is mail_location = maildir:~/MailDir:LAYOUT=fs I tryed using lmtp directly issuing 'telnet localhost 24' and sending a test message to 3 recipients. Then issuing a 'ls -il' in the "new" directory of that users, I saw the inode was not the same. I rechecked my config and take a look in the wiki and in the list for someone who had the same problems, but found nothing. Maybe I did something wrong, but I can't understand what. Can you help me? Thank you -- Benedetto Vassallo Sistema Informativo di Ateneo Settore Gestione Reti Hardware e Software U.O.B. Sviluppo e manutenzione dei sistemi Università degli studi di Palermo Phone: +3909123860056 Fax: +390916529124 ------------------------------------------------------------------------- This message was sent using the University of Palermo web mail interface.

3 7

[Dovecot] [2.2-UNSTABLE] compilation error: 'POSIX_FADV_WILLNEED' undeclared
by Michael Grimm 23 Oct '12

23 Oct '12

Hi -- I am trying to compile 2.2 (acd76b5272e9) at FreeBSD 9.0: | libtool: compile: gcc -DHAVE_CONFIG_H -I. -I../.. -I../../src/lib -I/usr/local/include -std=gnu99 -O2 -Wall -W -Wmissing-prototypes \ -Wmissing-declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 \ -Wbad-function-cast -fno-builtin-strftime -Wstrict-aliasing=2 \ -I/usr/local/include -MT fs-posix.lo -MD -MP -MF .deps/fs-posix.Tpo \ -c fs-posix.c -fPIC -DPIC -o .libs/fs-posix.o | fs-posix.c: In function 'fs_posix_prefetch': | fs-posix.c:298: warning: implicit declaration of function 'posix_fadvise' | fs-posix.c:298: error: 'POSIX_FADV_WILLNEED' undeclared (first use in this function) | fs-posix.c:298: error: (Each undeclared identifier is reported only once | fs-posix.c:298: error: for each function it appears in.) | gmake[3]: *** [fs-posix.lo] Error 1 | gmake[3]: Leaving directory `/usr/local/etc/dovecot/SOURCE/dovecot-2.2/src/lib-fs' | gmake[2]: *** [all-recursive] Error 1 | gmake[2]: Leaving directory `/usr/local/etc/dovecot/SOURCE/dovecot-2.2/src' | gmake[1]: *** [all-recursive] Error 1 | gmake[1]: Leaving directory `/usr/local/etc/dovecot/SOURCE/dovecot-2.2' | gmake: *** [all] Error 2 From configure logfile: | checking for posix_fadvise... no After a modification (stolen from src/lib-storage/index/index-mail.c) ... | --- dovecot-2.2-modified/src/lib-fs/fs-posix.c 2012-10-23 20:27:31.348919455 +0200 | +++ dovecot-2.2/src/lib-fs/fs-posix.c 2012-10-23 20:26:39.435300269 +0200 | @@ -295,10 +295,12 @@ | return TRUE; | } | | +#if defined(HAVE_POSIX_FADVISE) && defined(POSIX_FADV_WILLNEED) | if (posix_fadvise(file->fd, 0, length, POSIX_FADV_WILLNEED) < 0) { | i_error("posix_fadvise(%s) failed: %m", _file->path); | return TRUE; | } | +#endif | return FALSE; | } ... the compilations runs to completion, and dovecot-2.2 UNSTABLE is running. But: I do not have the knowledge to judge if that "fix" will be the right one. Just to let you know and with regards, Michael

1 0

[Dovecot] index files created improperly in dovecot 1.2.16
by john roman 23 Oct '12

23 Oct '12

Greetings, It seems to be a problem that ive seen occasionally on the web with few results as to a solution, but im experiencing it as well. Namely, dovecot creates index logs for users with a 600 permission, when it should create with a 700 permission. My indexes are stored in /var/indexes with the directory at 777 permission, the users are identified in MySQL. The error is as follows: Oct 23 09:03:13 mailer01 dovecot: POP3 (johnr(a)testing.com) stat(/var/indexes/j/johnr(a)testing.com/.INBOX) failed: Permission denied (euid=10509305(x10509305) egid=81607(pg199275) missing +x perm: /var/indexes/j) the permissions of /var/indexes/j are 700, owned by the euid and egid effectively. the only file that does not have this permission is in /var/indexes/j/johnr(a)testing.com/.INBOX/dovecot.index.log, at 600.

1 0

[Dovecot] 76Gb to 146Gb [Resolved]
by Spyros Tsiolis 23 Oct '12

23 Oct '12

Hello all, I would like to thank you all for your kind replies and feedback in regards to migrating from a smaller hdd to a bigger one (namely from 72gb to 146gb). I finally found a painless way of doing this. Since I believe that this is still an off-topic post, if anyone is interested in the solution i've adopted for this, let me know by replying to me privately. If, however, you don't mind me posting here, let me know. Many many thanks go to Alexander Hoogerhuis, the "mad Norwegian" :-) who helped me on this too much to describe here. Alex, you are a true sport. Thank you again people. All the Best, spyros ---- "I merely function as a channel that filters music through the chaos of noise" - Vangelis

1 0

[Dovecot] Dovecot LDA message save logging
by Dominic Malolepszy 23 Oct '12

23 Oct '12

Hi, Is there any option in Dovecot that enables logging the full path of where a message is saved in the backend? Dominic

2 1

[Dovecot] Anybody recognize these log lines?
by Knute Johnson 23 Oct '12

23 Oct '12

WARN: Duplicate profile 'Dovecot POP3', using last found WARN: Duplicate profile 'Dovecot Secure POP3', using last found WARN: Duplicate profile 'Dovecot IMAP', using last found WARN: Duplicate profile 'Dovecot Secure IMAP', using last found Anybody know if these are dovecot generated? Thanks, -- Knute Johnson

2 2

[Dovecot] (new) director issues in 2.1.10
by Kelsey Cummings 23 Oct '12

23 Oct '12

Timo - I upgraded to 2.1.10 on our director servers two nights ago and apart from errors associated with the directors processes restarting everything looked great for ~24 hours until I failed our the real servers last night to update the nfs mount options for the spools. I followed the suggested procedure for each backend server, just run on one of the directors, which seemed to work as expected. doveadm director add x.x.x.x 0 doveadm director flush x.x.x.x The following errors on the directors that started after this went unnoticed until this AM. director: User bb host lookup failed: Timeout - queued for 30 secs (Ring synced for 36 secs) director: User cc host lookup failed: Timeout - queued for 48 secs (Ring synced for 66 secs, user refreshed 12 secs ago) director: User dd host lookup failed: Timeout - queued for 124 secs (Ring synced for 119 secs, weak user, user refreshed 155 secs ago) director: User ee host lookup failed: Timeout - queued for 79 secs (Ring synced for 119 secs, weak user, user refreshed 113 secs ago) ... User ff host lookup failed: Timeout - queued for 30 secs (Ring synced for 7427 secs, weak user, user refreshed 620 secs ago) This continued, combined with occasional login timeouts (as reported by some internal imap clients.) The login delays/timeouts got bad enough that our load balancers dropped both the servers while I was investigating. They seem to be okay after being restarted. -K

2 5

[Dovecot] auth timeout state=2, bad?
by Bernhard Schmidt 22 Oct '12

22 Oct '12

Hello, we run Dovecot 2.1.7 as SASL backend for our Postfix SMTP-AUTH farm and see this error message occasionally Oct 22 16:15:32 lxmhs52 dovecot: auth: PLAIN(?,xx.xx.xx.xx): Request 0.21 timeouted after 150 secs, state=2 Since it is mostly the same IP repeating I'm assuming it's a client issue. Is that correct? What could cause this? Can we safely ignore it? Thanks, Bernhard

2 1

[Dovecot] Marking all mail in one folder of public mailbox as read
by Frerich Raabe 22 Oct '12

22 Oct '12

Hi, I'm running Dovecot 1.2.17 on FreeBSD 9 to serve an archive of a few internal mailinglists. The archive is implemented using a public namespace: namespace private { separator = / prefix = inbox = yes } namespace public { separator = / prefix = Lists/ location = maildir:/home/vmail/lists/Maildir:CONTROL=~/Maildir/lists:INDEX=~/Maildir/lists subscriptions = no } As you can see, the CONTROL/INDEX files are stored per-user to allow private \Seen flags. The different mailinglists are all sent to the 'lists' user which has a Sieve script to file them into different folders, so I have directories on my harddisk like /home/vmail/lists/Maildir/.somelist /home/vmail/lists/Maildir/.anotherlist Now, I'd like to mark the mail in *one* of those folders as \Seen by default. If the INDEX files weren't per-user, it would simply be a matter of using 'addflag "\Seen";' in the Sieve script of the lists user. Alas, this has no effect. Hence my question - how can I have the mail of just one mailinglist get marked as "read" for all users? So far, the only option I see is to add a second public namespace, with a different prefix - and this namespace doesn't use private CONTROL/INDEX files. However, I'd like to keep using the "Lists" prefix if possible to avoid too many changes to the clients. -- Frerich Raabe - raabe(a)froglogic.com www.froglogic.com - Multi-Platform GUI Testing

2 2

[Dovecot] Segmentation fault in doveadm with lib01_acl_plugin.so
by Alessio Cecchi 22 Oct '12

22 Oct '12

Hi, I'm running dovecot 2.1.10 on Debian 6. When I run "doveadm expunge -A mailbox Trash savedbefore 30d" it crash with "Segmentation fault" [15022673.496902] doveadm[13072]: segfault at 8 ip 00007f4b7041f551 sp 00007fffdab4f8c0 error 4 in lib01_acl_plugin.so[7f4b70415000+10000] If I add -D to doveadm I can see this: doveadm(myuser(a)mydomain.com): Debug: Added userdb setting: plugin/quota_rule=*:backend=524288000S doveadm(myuser(a)mydomain.com): Debug: Effective uid=89, gid=89, home=/home/vpopmail/domains/2/mydomain.com/myuser doveadm(myuser(a)mydomain.com): Debug: Quota root: name=UserQuota backend=maildir args= doveadm(myuser(a)mydomain.com): Debug: Quota rule: root=UserQuota mailbox=* bytes=524288000 messages=0 doveadm(myuser(a)mydomain.com): Debug: Quota rule: root=UserQuota mailbox=Trash bytes=+104857600 messages=0 doveadm(myuser(a)mydomain.com): Debug: Quota root: name=User quota backend=dict args=:noenforcing:proxy::quota doveadm(myuser(a)mydomain.com): Debug: dict quota: user=myuser(a)mydomain.com, uri=proxy::quota, noenforcing=1 doveadm(myuser(a)mydomain.com): Debug: Namespace inbox: type=private, prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:~/Maildir doveadm(myuser(a)mydomain.com): Debug: maildir++: root=/home/vpopmail/domains/2/mydomain.com/myuser/Maildir, index=, control=, inbox=/home/vpopmail/domains/2/mydomain.com/myuser/Maildir, alt= doveadm(myuser(a)mydomain.com): Debug: acl: initializing backend with data: vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 doveadm(myuser(a)mydomain.com): Debug: acl: acl username = myuser(a)mydomain.com doveadm(myuser(a)mydomain.com): Debug: acl: owner = 1 doveadm(myuser(a)mydomain.com): Debug: acl vfile: Global ACL directory: /usr/local/dovecot-2.1/etc/dovecot/global-acls doveadm(myuser(a)mydomain.com): Debug: Namespace : type=shared, prefix=shared/%n/, sep=/, inbox=no, hidden=no, list=children, subscriptions=no location=maildir:%h/Maildir:INDEX=~/Maildir/shared/%u doveadm(myuser(a)mydomain.com): Debug: shared: root=/usr/local/dovecot-2.1/var/run/dovecot, index=, control=, inbox=, alt= doveadm(myuser(a)mydomain.com): Debug: acl: initializing backend with data: vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 doveadm(myuser(a)mydomain.com): Debug: acl: acl username = myuser(a)mydomain.com doveadm(myuser(a)mydomain.com): Debug: acl: owner = 0 doveadm(myuser(a)mydomain.com): Debug: acl vfile: Global ACL directory: /usr/local/dovecot-2.1/etc/dovecot/global-acls doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=276 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=277 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=278 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=279 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=280 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=281 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=282 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=283 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=284 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=285 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=286 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=287 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=288 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=289 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=290 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=291 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=292 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=293 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=294 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=295 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=296 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=297 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=298 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=299 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=300 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=301 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=302 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=303 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=304 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=305 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=306 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=307 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=308 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=309 doveadm(myuser(a)mydomain.com): Debug: expunge: box=Trash uid=310 doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls//.DEFAULT not found doveadm(myuser(a)mydomain.com): Debug: Namespace : Using permissions from /home/vpopmail/domains/2/mydomain.com/myuser/Maildir: mode=0700 gid=-1 doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Drafts not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /home/vpopmail/domains/2/mydomain.com/myuser/Maildir/.Drafts/dovecot-acl not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Spam not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /home/vpopmail/domains/2/mydomain.com/myuser/Maildir/.Spam/dovecot-acl not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Sent not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /home/vpopmail/domains/2/mydomain.com/myuser/Maildir/.Sent/dovecot-acl not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Trash not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /home/vpopmail/domains/2/mydomain.com/myuser/Maildir/.Trash/dovecot-acl not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/INBOX not found doveadm(myuser(a)mydomain.com): Debug: acl vfile: file /home/vpopmail/domains/2/mydomain.com/myuser/Maildir/dovecot-acl not found Segmentation fault If I disable "acl" plugin in dovecot all works fine. I think that this problem is connected with "Dovecot deliver Segmentation fault when arrive the first message" http://www.dovecot.org/list/dovecot/2012-September/068343.html that I'm still experiencing. How can get core dumps from "doveadm"? This is my dovecot config with acl enabled: # 2.1.10: /usr/local/dovecot-2.1/etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-amd64 x86_64 Debian 6.0.6 auth_cache_size = 512 k auth_worker_max_count = 60 default_login_user = nobody dict { acl = mysql:/usr/local/dovecot-2.1/etc/dovecot/dovecot-share-folder.conf quota = mysql:/usr/local/dovecot-2.1/etc/dovecot/dovecot-dict-sql.conf.ext } disable_plaintext_auth = no dotlock_use_excl = no first_valid_gid = 89 first_valid_uid = 89 last_valid_gid = 89 last_valid_uid = 89 lda_mailbox_autocreate = yes lda_mailbox_autosubscribe = yes log_path = /var/log/dovecot/dovecot.log mail_fsync = always mail_location = maildir:~/Maildir mail_nfs_index = yes mail_nfs_storage = yes mail_plugins = quota acl maildir_very_dirty_syncs = yes managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave mmap_disable = yes namespace { list = children location = maildir:%%h/Maildir:INDEX=~/Maildir/shared/%%u prefix = shared/%%n/ separator = / subscriptions = no type = shared } namespace inbox { inbox = yes location = mailbox Drafts { auto = subscribe special_use = \Drafts } mailbox Sent { auto = subscribe special_use = \Sent } mailbox Spam { auto = subscribe special_use = \Junk } mailbox Trash { auto = subscribe special_use = \Trash } prefix = separator = / } passdb { args = /usr/local/dovecot-2.1/etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { acl = vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 acl_shared_dict = proxy::acl quota = maildir:UserQuota quota2 = dict:User quota::noenforcing:proxy::quota quota_rule2 = Trash:storage=+100M sieve = ~/.dovecot.sieve sieve_default = /usr/local/dovecot-2.1/etc/dovecot/sieve/default.sieve sieve_dir = ~/sieve } protocols = imap pop3 sieve sendmail_path = /var/qmail/bin/sendmail service auth { unix_listener auth-userdb { group = vchkpw mode = 0660 user = vpopmail } } service dict { unix_listener dict { group = vchkpw mode = 0660 user = vpopmail } } service imap-login { service_count = 0 } service managesieve-login { inet_listener sieve { port = 4190 } } service pop3-login { service_count = 0 } ssl_cert = </etc/ssl/certs/wildcard.net.pem ssl_key = </etc/ssl/private/wildcard.net.key userdb { args = /usr/local/dovecot-2.1/etc/dovecot/dovecot-sql.conf.ext driver = sql } protocol lda { log_path = /var/log/dovecot/lda.log mail_plugins = quota acl sieve } protocol imap { imap_client_workarounds = delay-newmail tb-extra-mailbox-sep tb-lsub-flags mail_max_userip_connections = 20 mail_plugins = quota acl imap_quota imap_acl } protocol sieve { mail_max_userip_connections = 10 } protocol pop3 { mail_max_userip_connections = 5 pop3_client_workarounds = outlook-no-nuls oe-ns-eoh } Thanks

4 6

Re: [Dovecot] still having difficulties with per-user quotas
by Daniel Parthey 22 Oct '12

22 Oct '12

David Mehler wrote: > Thanks, so if I understand what your saying the reason I'm getting the > column update issues is Dovecot is reading from and writing to the > quota and quota_messages columns in my virtual_users table? > > My database user I believe only has select permissions on that table. > > So, I either need another table and to adjust my dovecot-dict.sql file > for that table, that's where Dovecot will write to, or two more > columns in the virtual_users table? > > Which way do you recommend? I would recommend to create a new table for dovecot_usage where dovecot is granted write permission. Regards Daniel

2 1

Re: [Dovecot] still having difficulties with per-user quotas
by Daniel Parthey 21 Oct '12

21 Oct '12

Hi Dave, David Mehler wrote: > Thanks for all your help so far. I have per-user quotas now working, I > had to also alter my dict config file as well. I am having two > outstanding issues, actually one outstanding issue and one question. > > Here's the question, given that the userdb sql query returns a default > quota entry for rows of zero in quota and quota_messages is the > default quota section needed in 90-quota.conf? > > plugin { > quota_rule = *:storage=1G > quota_rule2 = Trash:storage=+100M > } You need quota_rule2 to give the user some additional space in the Trash folder if he/she wants to delete messages when over quota. The dict is also needed for quota lookup from the database. The only thing which might be omitted is the global quota_rule since it is returned by the userdb/passwd in any case, but I'm not sure what happens if you only configure a "quota_rule2" without configuring a "quota_rule". > My outstanding issue is whenever I as the root mysql user update a > user's quota the other user also gets an update, I noticed with one > the messages column on the other user went from 0 to 2, another time > the quota value went up from 0 to 3500 it seems random. You should not be accounting the actual mailbox usage in the same virtual_users table as the quota is read from. Use *different* column or table name in your dict file where dovecot may write the current storage/message count. > dovecot-dict-sql.conf.ext > > map { > pattern = priv/quota/storage > table = virtual_users > username_field = user > value_field = quota value_field should be current_quota_storage (writable column) > } > map { > pattern = priv/quota/messages > table = virtual_users > username_field = user > value_field = quota_messages value_field should be current_quota_messages (writable column) > I'd like to know why these columns are updating. Dovecot stores the current storage and mailcount in there. These columns should be different from the columns defining the maximum limit. Regards Daniel

1 0

[Dovecot] fstat() failed with file */dovecot.index.log
by Nicolás 21 Oct '12

21 Oct '12

Hi list! I'm using Dovecot along with Postfix (with MySQL) and I'm having some curious error messages in the mail log. Everything runs normally and suddenly I start viewing messages like these: Oct 12 14:24:23 dovecot: last message repeated 5 times Oct 12 14:25:23 dovecot: last message repeated 6 times Oct 12 14:26:23 dovecot: last message repeated 6 times Oct 12 14:27:23 dovecot: last message repeated 6 times Oct 12 14:29:22 mail dovecot: imap(nicolas(a)devels.es): Error: fstat() failed with file /home/vmail/devels.es/nicolas/Maildir/dovecot.index.log: No such file or directory Oct 12 14:30:23 dovecot: last message repeated 5 times Oct 12 14:31:23 dovecot: last message repeated 6 times Oct 12 14:33:22 mail dovecot: imap(nicolas(a)devels.es): Error: fstat() failed with file /home/vmail/devels.es/nicolas/Maildir/dovecot.index.log: No such file or directory Oct 12 14:34:23 dovecot: last message repeated 5 times Oct 12 14:35:23 dovecot: last message repeated 6 times Oct 12 14:36:01 mail dovecot: imap(nicolas(a)devels.es): Error: fstat() failed with file /home/vmail/devels.es/nicolas/Maildir/dovecot.index.log: No such file or directory This file which Dovecot references to indeed exists, is accesible, etc. Once I get the first of these messages, the user stops receiving e-mails (the mail server keeps receiving them normally, though) until he restarts the mail client. Then the error msg is gone and he receives all their unreceived messages. This error appears in 6-12h. intervals once the user starts their client. Version is 2.0.19, and dovecot -n is: root@mail:~# dovecot -n # 2.0.19: /etc/dovecot/dovecot.conf # OS: Linux 3.2.0-32-generic-pae i686 Ubuntu 12.04.1 LTS ext4 disable_plaintext_auth = no log_timestamp = "%Y-%m-%d %H:%M:%S " mail_location = maildir:/home/vmail/%d/%n/Maildir mailbox_idle_check_interval = 2 mins namespace { inbox = yes location = prefix = INBOX. separator = . type = private } passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } protocols = imap pop3 service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-master { mode = 0600 user = vmail } user = root } ssl_cert = </etc/ssl/certs/dovecot.pem ssl_key = </etc/ssl/private/dovecot.pem userdb { args = uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes driver = static } protocol lda { auth_socket_path = /var/run/dovecot/auth-master log_path = /home/vmail/dovecot-deliver.log postmaster_address = postmaster(a)devels.es } protocol pop3 { pop3_uidl_format = %08Xu%08Xv } Thanks so much for any help! Nicolás

2 5

Re: [Dovecot] still having difficulties with per-user quotas
by Daniel Parthey 20 Oct '12

20 Oct '12

David Mehler wrote: > Thanks for your reply. So with the extending of the query to return a > default quota rule, do you have an example of that by the way, does > that mean I only have to put the overrided users in the quota table? Assuming that quota values are in the dovecot_users table... # passdb with userdb prefetch and default quota of 1024M for quota=0 rows # The userdb_ prefix is for prefetch userdb entries in password_query password_query = SELECT username AS user, \ password AS password, \ home AS userdb_home, \ uid AS userdb_uid, \ gid AS userdb_gid, \ CASE quota \ WHEN 0 \ THEN '*:bytes=1024M:messages=0' \ ELSE \ CONCAT('*:bytes=', CAST(quota AS CHAR), 'M:messages=', CAST(quota_message AS CHAR)) \ END AS `userdb_quota_rule` \ FROM dovecot_users \ WHERE username='%u'; # user_query with default quota of 1024M for quota=0 rows user_query = SELECT username AS user, \ home AS home, \ uid AS uid, \ gid as gid, \ CASE quota \ WHEN 0 \ THEN '*:bytes=1024M:messages=0' \ ELSE \ CONCAT('*:bytes=', CAST(quota AS CHAR), 'M:messages=', CAST(quota_message AS CHAR)) \ END AS `quota_rule` \ FROM dovecot_users \ WHERE username='%u'; Your user_query needs to return a row if the user exists, otherwise dovecot will assume that the user does not exist and the mail or user will be rejected. Regards Daniel -- https://plus.google.com/103021802792276734820

1 0

[Dovecot] still having difficulties with per-user quotas
by David Mehler 20 Oct '12

20 Oct '12

Hello, I am trying to get per-user quotas working. My thanks to all who have helped so far. To recap I am running Dovecot 2.1 and Mysql where I've got my virtual users. All virtual users are under the system user vmail with a UID and GID of 5000. Looking over the wiki docs I've added a quota table and got the dict service working, I am not having problems with permissions or the login username and password, all that is working fine. Here's my current doveconf -n output it is producing the following debug error related to the userdb sql query: # 2.1.10: /etc/dovecot/dovecot.conf # XXX dict { quota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } first_valid_gid = 5000 first_valid_uid = 5000 hostname = XXX last_valid_gid = 5000 last_valid_uid = 5000 mail_location = maildir:/home/vmail/%d/%n:LAYOUT=fs mail_plugins = " quota" namespace inbox { inbox = yes location = prefix = } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { quota = dict:User quota::proxy::quota quota_rule = *:storage=1G quota_rule2 = Trash:storage=+100M quota_warning = storage=95%% quota-warning 95 %u quota_warning2 = storage=80%% quota-warning 80 %u } protocols = imap service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { mode = 0600 user = vmail } } service dict { unix_listener dict { mode = 0600 user = vmail } } service imap-login { inet_listener imap { address = 127.0.0.1 ::1 } inet_listener imaps { address = xxx xxxx ssl = yes } } service quota-warning { executable = script /usr/local/bin/quota-warning.sh user = vmail } ssl_cert = </etc/ssl/certs/server.crt ssl_key = </etc/ssl/private/server.key userdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } protocol imap { mail_plugins = " quota imap_quota" } Oct 19 15:23:52 auth-worker(29279): Info: mysql(/var/run/mysqld/mysqld.sock): Connected to database mail Oct 19 15:23:52 auth-worker(29279): Debug: sql(xxx,::1): query: SELECT user as user, password FROM virtual_users WHERE user='xxx@domain'; Oct 19 15:23:52 auth: Debug: client passdb out: OK 1 user=xxx Oct 19 15:23:52 auth: Debug: master in: REQUEST 3523346433 29276 1 f5cd16e3f5e078c28d850749e42c86cc Oct 19 15:23:52 auth-worker(29279): Debug: sql(xxx,::1): SELECT concat('*:storage=', bytes, 'M') as quota_rule FROM quota WHERE username='xxx'; Oct 19 15:23:52 auth: Debug: master userdb out: USER 3523346433 xxx quota_rule=*:storage=368485M Oct 19 15:23:52 imap-login: Info: Login: user=<xxx>, method=PLAIN, rip=::1, lip=::1, mpid=29282, secured, session=</xKpcW7MFgAAAAAAAAAAAAAAAAAAAAAB> Oct 19 15:23:52 imap(xxx): Error: user xxx: Couldn't drop privileges: User is missing UID (see mail_uid setting) Oct 19 15:23:52 imap(xxx): Error: Internal error occurred. Refer to server log for more information. I am wanting a majority of my users to have the global 1GB quota, but the users in the quota table to have given quotas. Here's what the virtual_users and quota tables look like: mysql> describe virtual_users; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | domain_id | int(11) | NO | MUL | NULL | | | user | varchar(40) | NO | | NULL | | | password | varchar(128) | NO | | NULL | | +-----------+--------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) mysql> describe quota; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | username | varchar(100) | NO | PRI | NULL | | | bytes | bigint(20) | NO | | 0 | | | messages | int(11) | NO | | 0 | | +----------+--------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) I'd appreciate any help. Thanks. Dave.

2 3

[Dovecot] Dovecot 2 and TCP-Keepalive
by Sven Hartge 20 Oct '12

20 Oct '12

Hi! I am about to migrate a perdition-based IMAP/POP3 proxy to Dovecot. Unfortunately some users are behind a firewall/NAT setup which throws away seemingly idle TCP connections sooner than the established default of 24 hours (more likely after 30 minutes ...) resulting in all kinds of weird client behavior. And unfortunately² this firewall/NAT setup is outside of my control and I have no means of correcting this (in my opinion) flawed configuration. Now, with perdition I was able to use the --tcp_keepalive option which totally solved the mentioned weird client behavior. My question is: does Dovecot2 use TCP-Keepalive on its sockets per default or do I need to enable it some way I have not yet discovered? The manual and wiki only talk about "keepalive" in connection with the IMAP protocol and IDLE and my C-fu is too weak to understand the source code. Grüße, Sven. -- Sigmentation fault. Core dumped.

2 2

[Dovecot] Dovecot 2 quota limit and actual size (mysql)
by wamp 20 Oct '12

20 Oct '12

Hello, Can You explain to me how dovecot-lda knows actual size of virtual user directory? I want to keep max size of user directory in mysql - should I also use some kind of script to upgrade actual size information in mysql ? I read docs from wiki but still dont know it. thanks -- View this message in context: http://dovecot.2317879.n4.nabble.com/Dovecot-2-quota-limit-and-actual-size-… Sent from the Dovecot mailing list archive at Nabble.com.

2 1

[Dovecot] Question about salted hashes
by Tobias Maffert 19 Oct '12

19 Oct '12

Hello. I'm switching from b1gmail to my own setup which consists of Postfix+Dovecot+MySQL (and maybe VBoxAdm). There are two problems: - b1gmail is using unsalted MD5 hashes. Is there any good way to make my new setup backward compatible? So I don't have to force all of my 50k users to change their password. - How do I change my setup to salted SHA256 (or an even better algorithm). And how do I make the hashes compatible between Postfix, Dovecot, MySQL (and maybe VBoxAdm)? My system: Debian Squeeze Postfix version: 2.7.1 Dovecot version: 1.2.15 ----------------------------------------------- dovecot -n # 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-686 i686 Debian 6.0.6 protocols: imap pop3 disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login mail_access_groups: vmail mail_debug: yes mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 pop3_uidl_format(default): %08Xu%08Xv pop3_uidl_format(imap): %08Xu%08Xv pop3_uidl_format(pop3): UID%u-%v lda: postmaster_address: <postmaster-address> auth_socket_path: /var/run/dovecot/auth-master mail_plugins: quota sendmail_path: /usr/sbin/sendmail auth default: mechanisms: plain login user: vmail passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: vmail plugin: quota: maildir ----------------------------------------------- driver = mysql connect = host=127.0.0.1 dbname=smail user=smail password=mypw default_pass_scheme = CRYPT password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE (username = '%u' OR email = '%u') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR '%Ls' = 'smtp') user_query = SELECT CONCAT(homedir, maildir) AS home, CONCAT('maildir:', homedir, maildir) AS mail, uid, gid, CONCAT('*:storage=', (quota*1024)) as quota_rule FROM mail_users WHERE (username = '%u' OR email = '%u') ----------------------------------------------- Regards, Tobi M.

2 1

[Dovecot] Add S=<size> to maildirfile
by Alessio Cecchi 19 Oct '12

19 Oct '12

Hi, in some old Maildir/ I have file without the S=<size> in file name. Is possibile to add the size to the file name with some tools like doveadm? Are there other methods to update these file? Thanks -- Alessio Cecchi is: @ ILS -> http://www.linux.it/~alessice/ on LinkedIn -> http://www.linkedin.com/in/alessice Assistenza Sistemi GNU/Linux -> http://www.cecchi.biz/ @ PLUG -> ex-Presidente, adesso senatore a vita, http://www.prato.linux.it

4 4

[Dovecot] Emails from invalid local accounts
by Steven Kiehl 19 Oct '12

19 Oct '12

Hi, I'm using dovecot 1.2.9 in a postfix/dovecot setup and I'm having issues with receiving spam where the "from" header contains an address like accounting(a)mydomain.com. Is there some way I can filter out these emails coming from outside our network with an account associated with our network which doesn't exist? Do I just need to configure some custom process to evaluate these addresses, or is there some way either in dovecot or spamassassin to do this? Thanks, Steve K

3 4

[Dovecot] dovecot-core, dovecot-mysql for Debian squeeze
by Ricardo 18 Oct '12

18 Oct '12

Hello list apologize in advance for my bad English, this is the first time I write to a list if I mistake Excuse me I want to implement mail server with MySQL database, Postfix and Postfixadmin, dovecot-core, dovecot-mysql dovecot-imapd dovecot-pop3d for multiple domains. I have problems installing the daemon dovecot-core, dovecot-mysql dovecot-imapd dovecot-pop3d Debian squeeze, I'm using the repositories: deb http://ftp.ccc.uba.ar/pub/linux/debian/debian/ squeeze main deb-src http://ftp.ccc.uba.ar/pub/linux/debian/debian/ squeeze main deb http://security.debian.org/ squeeze/updates main deb-src http://security.debian.org/ squeeze/updates main # squeeze-updates, previously known as 'volatile' deb http://ftp.ccc.uba.ar/pub/linux/debian/debian/ squeeze-updates main deb-src http://ftp.ccc.uba.ar/pub/linux/debian/debian/ squeeze-updates main deb http://packages.dotdeb.org squeeze all deb-src http://packages.dotdeb.org squeeze all deb http://backports.debian.org/debian-backports squeeze-backports main to install dovecot-core, dovecot-mysql, install it without problems is the version (2.1.7-2 ~ bpo60 +1) of both packages, now wanting to install dovecot-imapd dovecot-pop3d (version 1.2.15-7) breaks the dovecot-core, dovecot-mysql, apparently must be the same version all packages. Debian Wheezy, installs without problems but installs the version (dovecot-core_2.1.7-2 ~ ppa12.04 +1 _i386.deb) all packets are the same version. What is the correct version for Debian squeeze? Look for San Google but eh had success. Can anybody help? Ricardo

3 2

[Dovecot] lmtp proxy logging
by Jack Bates 18 Oct '12

18 Oct '12

The logging on lmtp and lmtp proxy is pretty limited from what I can see. It seems to handle errors, Connect, Disconnect, and in the case of lmtp delivery, it logs where an email is saved to. The lmtp may be enough, "connect, saved user, saved user..., disconnect", but I was curious if it is worth while to add more info logging for the proxy, primarily which recipients are sent to which proxy. I was thinking of local patching it, but I'll generate up something more inline with official code if it is desired. My thought is to show 1 entry for each recipient, and the destination server chosen. If I recall correctly, the proxy code doesn't actually listen in on the conversation, so logging results would probably complicate the code. Jack

4 8

[Dovecot] CAS Authentication
by b m 18 Oct '12

18 Oct '12

Hi.I'm very sorry for the repost but I forgot the subject. So, I'm using dovecot 2.0.18 and I'm trying to authenticate through a CAS server (until now authentication was through MS Active Directory). I could not find anywhere some examples, so here is what i have done so far. -install phpcas and pam_cas -edit /etc/pam.d/dovecot auth sufficient /lib/security/pam_cas.so -simap://webmail.mydomain.com -f /etc/pam_cas.conf -edit /etc.pam_cas.conf host mycas.mydomain.com port 443 uriValidate /cas/proxyValidate ssl on proxy ??????????????????????? trusted_ca /etc/cert/certificate.pem debug on - and finally dovecot.conf which I'm sure is complety wrong userdb { args = /etc/dovecot/dovecot-ldap.conf driver = ldap } passdb { driver = pam args = cache_key=%u dovecot } What I get in log is Oct 15 15:39:58 auth-worker: Debug: Loading modules from directory: /usr/lib64/dovecot/auth Oct 15 15:39:58 auth-worker: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so Oct 15 15:39:58 auth-worker: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so Oct 15 15:39:58 auth-worker: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so Oct 15 15:39:58 auth-worker: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so Oct 15 15:39:58 auth-worker: Debug: Module loaded: /usr/lib64/dovecot/auth/libmech_gssapi.so Oct 15 15:39:58 auth-worker: Debug: pam(user,127.0.0.1): lookup service=dovecot Oct 15 15:39:58 auth-worker: Debug: pam(user,127.0.0.1): #1/1 style=1 msg=Password: Oct 15 15:39:58 auth-worker: Info: pam(user,127.0.0.1): pam_authenticate() failed: Permission denied Oct 15 15:40:00 auth: Debug: client out: FAIL 1 user=user Oct 15 15:40:00 imap-login: Info: Aborted login (auth failed, 1 attempts): user=<user>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 15 15:40:00 auth: Debug: auth client connected (pid=9019) Any ideas? Thanks.

3 5

[Dovecot] Problem with process_limit
by FABIO FERRARI 18 Oct '12

18 Oct '12

Hello, i have a problem with the process_limit configuration. Occasionally, it happens that the dovecot.log shows this line: master: Warning: service(imap): process_limit reached, client connections are being dropped So I checked, the process number, with the command: ps auxwww | grep imap | grep -v login | wc -l and it shows 1024. Then, i edited the file /etc/dovecot/conf.d/10-master.conf and set the line process_limit = 1500 I checked if the dovecot had accepted the change with the command doveconf -n | grep process_limit and it shows process_limit = 1500 But it is dropping the connections when they reach 1024 anyway, the configuration parameter is totally ignored. Can anyone help? Am I editing the right parameter? thanks in advance Fabio Ferrari P.S. The version of the dovecot is dovecot-2.0.1-1_118.el5 on Red Hat Enterprise Linux Server release 5.8 (Tikanga).

3 3

[Dovecot] real_rip variable addition for dovecot 2.1.10
by Jack Bates 18 Oct '12

18 Oct '12

Timo, Please check the code. I didn't add it, but a real_lip might be useful for some people as well. Also, I notice that pop3-proxy is doing a different xsession than the imap proxy. Is there an xsession standard that is different between the two, or just an oversight in the code? Both send the remote address/port, but only imap proxy sends the local address/port. This patch declares long variable %{real_rip} so that a backend server can declare a different login_log_format_elements login_log_format_elements = user=<%u> method=%m rip=%r lip=%l pip=%{real_rip} mpid=%e %c This is primarily useful for backend servers to log both the rip, lip, and in case of xsession, the real rip. I haven't done extensive testing yet, but as long as nothing does anything weird elsewhere in the code, it should be good. http://www.brightok.net/jbates/dovecot-2.1.10-real-ip.patch dovecot: pop3-login: Login: user=<test>, method=PLAIN, rip=192.168.1.5, lip=::1, pip=::1, mpid=8665, secured Jack Bates

2 3

[Dovecot] Difference between Indexing and Rescan in FTS
by Fred Kilbourn 18 Oct '12

18 Oct '12

I've had squat running on dovecot 2.0 and have been updating all users mailbox indexes nighty via cron with this command: doveadm -v search -A text xyzzyx I've just updated to 2.1 and I'm migrating to lucene indexes, but reading the documentation I'm having a hard time understanding the semantic differences between indexing and rescanning. If I were to continue to run an all user all mailbox index every night, would that be appropriate? Would running this every night avoid the need to ever rescan? Should I run rescan instead of index? Should I run both rescan and index? In which order? Best Regards, FredK

3 5

[Dovecot] Per user quotas
by David Travers 18 Oct '12

18 Oct '12

Hi All, I keep going round in circles with this. I have quotas up and running but would like to add a couple of per user exceptions but can't figure out how to do it! I am using Open Xchange community edition on top of dovecot and tha tis showing the 200MB limit, if I change it in the dovecot.conf the change is reflected in open xchange, but can't figure out how to change for 1 user. I believe I need to add to a passwd file, but I have added to that and nothing has changed. # dovecot -n # 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-686 i686 Debian 6.0.5 log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3 pop3s ssl_cert_file: /etc/ssl/certs/postfix.pem ssl_key_file: /etc/ssl/private/postfix.key login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login mail_privileged_group: mail mail_location: maildir:~/mail:LAYOUT=fs:INBOX=~/mail/ mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 lda: mail_plugins: quota auth default: mechanisms: plain login passdb: driver: pam userdb: driver: passwd socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix plugin: quota: maildir:user quota quota_rule: *:storage=200M quota_rule2: Trash:storage=10%% quota_rule2: SPAM:ignore quota_warning: storage=95%% /usr/local/bin/quota-warning.sh 95 quota_warning2: storage=80%% /usr/local/bin/quota-warning.sh 80 quota_exceeded_message: Quota exceeded, Please delete some emails Any help gratefully received Dave _________________________________________ This email has been scanned for malicious content. _________________________________________

3 4

[Dovecot] Dsync clustering
by list＠airstreamcomm.net 18 Oct '12

18 Oct '12

I have not seen mention of using dsync for clustering Dovecot in some time on the mailing list, but I believe Timo was going to write a wiki page when v2.2 became more mature. Does this documentation exist yet, or are there any resources on what dsync replication is capable of at this point (looking on the wiki and google didn't reveal much)? Thank in advance.

2 1

Re: [Dovecot] Disconnected for inactivity time.
by Joseph Tam 18 Oct '12

18 Oct '12

Robert JR writes: > After 10 mins of unactivity of pop3 , dovecot disconnect the user (-ERR > Disconnected for inactivity.) > > What is the option in the config file which control the unactivity > logout time ? becuase i want to decrease the inactivity time > > To 5 mins instead of 10 mins Looks like it's set in the source code pop3-client.c:#define CLIENT_IDLE_TIMEOUT_MSECS (10*60*1000) but the output of # doveconf -a ... service pop3 { ... idle_kill = 0 ... } maybe points to the config that overrides this. Easy enough to test. It's non-RFC compliant as one poster points out, so unless you got a good reason to do this like lots of zombie pop3 processes, leave it alone. Joseph Tam <jtam.home(a)gmail.com>

1 0

[Dovecot] Dovecot sieve and duplicate email subjects
by Benjamin Thomas 17 Oct '12

17 Oct '12

Hi, I'm running a small email server with the help of iRedMail. I can manage sieve scripts from the Rouncube web interface or manually inside the user's personal sieve folder. I have an email account setup to receive automated tasks. Some of these "alerts" occur too often and they have the same subject line, but different senders. This is the rule I am currently using: ##CODE START## # rule:[AutoAlerts] if anyof ( header :matches "Subject" "AutoAlert Type1*", header :matches "Subject" "AutoAlert Type2*", header :matches "Subject" "AutoAlert Type3*" ) { fileinto "INBOX.AutoAlerts"; stop; } ##CODE END## I was wondering if it's possible to gracefully handle duplicate subjects lines (within a given time frame) with sieve filters ? Ideally, I would like the first email of the day with subject ""AutoAlert Type1..." to get moved to the subfolder given above. Subsequent "duplicate" emails would then go into a "duplicate" subfolder. Is this possible with sieve filters ? I could not find anything striking me as obvious while reading the page http://wiki.dovecot.org/LDA/Sieve. Thanks very much for your input.

2 3

[Dovecot] Disconnected for inactivity time.
by Robert JR 17 Oct '12

17 Oct '12

Hello, After 10 mins of unactivity of pop3 , dovecot disconnect the user (-ERR Disconnected for inactivity.) What is the option in the config file which control the unactivity logout time ? becuase i want to decrease the inactivity time To 5 mins instead of 10 mins Please advise Robert JR

2 1

[Dovecot] dovecot died
by Hendrik 17 Oct '12

17 Oct '12

Hi All I have been trying to get this website running for months now. I get this emails from cpanel and don't know how to fix it. If anyone can help me please contact me at pipefab(a)mweb.co.za. Kind regards Hendrik imap failed @ Fri Oct 12 05:51:18 2012. A restart was attempted automagically. Service Check Method: [check command] Number of Restart Attempts: 1 Cmd Service Check Raw Output: dovecot is not running Startup Log: /etc/init.d/dovecot: line 15: 6043 Alarm clock /usr/sbin/dovecot > /dev/null 2>&1 Syslog Messages: Oct 12 04:01:01 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__lvgws_iymiqndfmflick2pa3yjzc56ukpa2t6x3 yj43fuh...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:01:02 scene dovecot: IMAP(__cpanel__service__auth__imap__lvgws_iymiqndfmflick2pa3yjzc56ukpa2t6x3y j43fuhjgeiqomc3dhlkyjwdq): Disconnected: Logged out bytes=11/340 Oct 12 04:06:06 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__jxy1xcsu0koedgkhexhexpu3_idp4ynukxpaou0 jaovpdr...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:06:06 scene dovecot: IMAP(__cpanel__service__auth__imap__jxy1xcsu0koedgkhexhexpu3_idp4ynukxpaou0j aovpdrgqjnf0_rxyi0wncetn): Disconnected: Logged out bytes=11/313 Oct 12 04:11:01 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__6oxwycgffp_5xkysaitw4eifev2nffi_dqlhj4z k8h05nx...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:11:01 scene dovecot: IMAP(__cpanel__service__auth__imap__6oxwycgffp_5xkysaitw4eifev2nffi_dqlhj4zk 8h05nx2p9n4yfxhrp3a2gjhl): Disconnected: Logged out bytes=11/313 Oct 12 04:16:08 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__7zurxql5qf5whp4rupxen3viduh5kucjqtrzigs c75cnov...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:16:09 scene dovecot: IMAP(__cpanel__service__auth__imap__7zurxql5qf5whp4rupxen3viduh5kucjqtrzigsc 75cnovslbll4702ue2veu2n3): Disconnected: Logged out bytes=11/318 Oct 12 04:21:10 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__cq4wbk6o7svgbljnmw1hx2iiaunvzp3w1cywwsf ou8d5ky...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:21:11 scene dovecot: IMAP(__cpanel__service__auth__imap__cq4wbk6o7svgbljnmw1hx2iiaunvzp3w1cywwsfo u8d5kysrfeaqvlmjgx6afvnb): Disconnected: Logged out bytes=11/340 Oct 12 04:26:35 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__uhyykmmdnf31il4pn_kfci9y2gw2o9skyz7zuoe oga08za...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:26:36 scene dovecot: IMAP(__cpanel__service__auth__imap__uhyykmmdnf31il4pn_kfci9y2gw2o9skyz7zuoeo ga08zaq_nh6yzqsmveqpvnxi): Disconnected: Logged out bytes=11/313 Oct 12 04:31:05 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__hka0onlsdbqugjyirdyygk_d9wtw_xtkl7jgaus tpvzl1q...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:31:05 scene dovecot: IMAP(__cpanel__service__auth__imap__hka0onlsdbqugjyirdyygk_d9wtw_xtkl7jgaust pvzl1qjjei5uuoi1c4g8tpea): Disconnected: Logged out bytes=11/313 Oct 12 04:36:02 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__ouonjmdpliwgyj8ij6gucv6y7fxq6ojdk9hsxjj fzonng9...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:36:03 scene dovecot: IMAP(__cpanel__service__auth__imap__ouonjmdpliwgyj8ij6gucv6y7fxq6ojdk9hsxjjf zonng9eqrsw5l5hg7xoejer2): Disconnected: Logged out bytes=11/340 Oct 12 04:41:03 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__wpwfzoyvnb2rsz2desu10swelok4cdwrqqw70gw eibvov1...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:41:04 scene dovecot: IMAP(__cpanel__service__auth__imap__wpwfzoyvnb2rsz2desu10swelok4cdwrqqw70gwe ibvov1_minfh7j4_4ejaz7v2): Disconnected: Logged out bytes=11/340 Oct 12 04:46:04 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__razxoe9ffiqhzj6rahuftwwqprhj2blovjvsbhd rhafjur...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:46:05 scene dovecot: IMAP(__cpanel__service__auth__imap__razxoe9ffiqhzj6rahuftwwqprhj2blovjvsbhdr hafjureydiuxbtbk2jkpkvlo): Disconnected: Logged out bytes=11/340 Oct 12 04:51:06 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__as64dk7mx4gfxupigti8wwrbqpqhetm9zyhzlrq h1iztqo...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:51:06 scene dovecot: IMAP(__cpanel__service__auth__imap__as64dk7mx4gfxupigti8wwrbqpqhetm9zyhzlrqh 1iztqosnzfwt28kkzv4riyd9): Disconnected: Logged out bytes=11/340 Oct 12 04:56:07 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__x0do00ujo_2w89kbu0kfk6s8evtdz9u3davldan 2pdmdvg...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 04:56:07 scene dovecot: IMAP(__cpanel__service__auth__imap__x0do00ujo_2w89kbu0kfk6s8evtdz9u3davldan2 pdmdvg6jofzylncdb3ytjaaz): Disconnected: Logged out bytes=11/340 Oct 12 05:01:08 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__lkup_seowtz4xhnmf5fkihlw6hpacvnfyeyzvir quwcv1z...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:01:08 scene dovecot: IMAP(__cpanel__service__auth__imap__lkup_seowtz4xhnmf5fkihlw6hpacvnfyeyzvirq uwcv1zhloqt12rqni_o2pqcj): Disconnected: Logged out bytes=11/340 Oct 12 05:06:09 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__yl1ivh4akxdj7vph6nz2w8jdmeuzukqkvezokgr cpi3usb...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:06:09 scene dovecot: IMAP(__cpanel__service__auth__imap__yl1ivh4akxdj7vph6nz2w8jdmeuzukqkvezokgrc pi3usbdjkiy2n8zy2bbvhhny): Disconnected: Logged out bytes=11/340 Oct 12 05:11:10 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__z0jltexjylqusc5j7qrtw5t7m_tqzcjyheljxrg 4vew3df...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:11:10 scene dovecot: IMAP(__cpanel__service__auth__imap__z0jltexjylqusc5j7qrtw5t7m_tqzcjyheljxrg4 vew3dfbyrglsasuldldaspck): Disconnected: Logged out bytes=11/340 Oct 12 05:16:11 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__0ycn3mqrthjv1aqo7w45zy1ndeodd2xxh92y3v0 e2bwtas...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:16:11 scene dovecot: IMAP(__cpanel__service__auth__imap__0ycn3mqrthjv1aqo7w45zy1ndeodd2xxh92y3v0e 2bwtastu0kton3azlhmmuhwi): Disconnected: Logged out bytes=11/340 Oct 12 05:21:12 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__ofmf6ptqgyhrzgrlsx3p33fz52q7j1afid0uszq mf4h8z1...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:21:12 scene dovecot: IMAP(__cpanel__service__auth__imap__ofmf6ptqgyhrzgrlsx3p33fz52q7j1afid0uszqm f4h8z1shjl34q9zpid3g4gsp): Disconnected: Logged out bytes=11/340 Oct 12 05:26:13 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__awz7xewlgj6pjfdz1dogl28vm9ld5fqfwviyaog ha3yc0w...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:26:13 scene dovecot: IMAP(__cpanel__service__auth__imap__awz7xewlgj6pjfdz1dogl28vm9ld5fqfwviyaogh a3yc0w6t7vvgyf1snz8vechf): Disconnected: Logged out bytes=11/340 Oct 12 05:31:14 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__uyfeustvewbyjgjyyrqgrflkxhuxfloywsash62 mucudsm...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:31:15 scene dovecot: IMAP(__cpanel__service__auth__imap__uyfeustvewbyjgjyyrqgrflkxhuxfloywsash62m ucudsmjfmyolzcpm9shakkiw): Disconnected: Logged out bytes=11/340 Oct 12 05:36:15 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__g6g0w1ikkl7h2dx3uw8hdpin8uhjml0lgk08zxc kmn7fkd...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:36:16 scene dovecot: IMAP(__cpanel__service__auth__imap__g6g0w1ikkl7h2dx3uw8hdpin8uhjml0lgk08zxck mn7fkdpsvbrjptqanfuljfv2): Disconnected: Logged out bytes=11/340 Oct 12 05:41:15 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__hucgkkpt7ggbzuudcxecprlhdf_c1qenb56hqun f1neeqb...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:41:16 scene dovecot: IMAP(__cpanel__service__auth__imap__hucgkkpt7ggbzuudcxecprlhdf_c1qenb56hqunf 1neeqbmzas00uqbzmmjsxiab): Disconnected: Logged out bytes=11/340 Oct 12 05:46:17 scene dovecot: imap-login: Login: user=<__cpanel__service__auth__imap__09irfuxyirdwosv6_f9prfvxpxhozr8qfauvfre yewqvxx...>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Oct 12 05:46:17 scene dovecot: IMAP(__cpanel__service__auth__imap__09irfuxyirdwosv6_f9prfvxpxhozr8qfauvfrey ewqvxxeoo7yhyiki7ghukxss): Disconnected: Logged out bytes=11/340 Oct 12 05:47:27 scene dovecot: dovecot: Fatal: Time just moved backwards by 35 seconds. This might cause a lot of problems, so I'll just kill myself now. http://wiki.dovecot.org/TimeMovedBackwards

3 2

[Dovecot] Dovecot failed logins delay all logins
by Dominic Malolepszy 17 Oct '12

17 Oct '12

Hi all, I have observed with my Dovecot setup that unique failed logins cause legitimate correct logins to be slowed. I am running two servers, each with two Dovecot instances, a Proxy with Director, and a backend Dovecot. I suspect that the backend instance is throttling connections from the same IP, and because I am running a Proxy, the backend will only see either of the two server IPs. I confirmed this by directly connecting to the backend, to bypass the proxy and rule it. I initiated dozens of unique failed logins from one IP and separately attempted to login from the same IP, and experienced an extended delay during login. At the same time a login from a different IP suceeded imediately. I see nothing in the logs suggesting some sort of process limits were exceeded, however I do see the following proc title for the backend auth process: "dovecot/auth [7 wait, 0 passdb, 0 userdb]" I have increased the mail_max_userip_connections to a very large value however I believe that setting is a per username/ip limit. Is there any sort of setting in Dovecot that I can configure that stops this authentication throttling per IP? Below is the configuration of the backend Dovecot instance. # 2.1.9: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-279.5.2.el6.x86_64 x86_64 Red Hat Enterprise Linux Server release 6.3 (Santiago) auth_cache_negative_ttl = 3 secs auth_cache_size = 100 M auth_cache_ttl = 10 mins auth_default_realm = example.com auth_failure_delay = 5 secs auth_mechanisms = plain login auth_verbose_passwords = sha1 auth_worker_max_count = 25 base_dir = /var/run/dovecot/ disable_plaintext_auth = no first_valid_gid = 12 first_valid_uid = 8 last_valid_gid = 12 last_valid_uid = 8 login_greeting = Hello there. login_log_format_elements = user=<%u> method=%m rip=%r lip=%l mpid=%e %c mail_fsync = always mail_gid = mail mail_location = maildir:%h/Maildir mail_nfs_index = yes mail_nfs_storage = yes mail_plugins = " stats" mail_uid = mail mmap_disable = yes namespace { inbox = yes location = maildir:%h/Maildir prefix = INBOX. separator = . } passdb { args = /etc/dovecot/dovecot-ldap.conf driver = ldap } protocols = pop3 imap service auth { unix_listener auth-userdb { group = mail mode = 0660 user = mail } } service imap-login { inet_listener imap { address = 0.0.0.0 port = 9143 } process_min_avail = 5 service_count = 0 vsz_limit = 256 M } service imap { process_limit = 1000 vsz_limit = 256 M } service pop3-login { inet_listener pop3 { address = 0.0.0.0 port = 9110 } process_min_avail = 5 service_count = 0 vsz_limit = 256 M } service pop3 { process_limit = 1000 vsz_limit = 256 M } service stats { fifo_listener stats-mail { mode = 0600 user = mail } inet_listener { address = 127.0.0.1 port = 24242 } } ssl = no stats_memory_limit = 64 M userdb { driver = prefetch } userdb { args = /etc/dovecot/dovecot-ldap.conf driver = ldap } verbose_proctitle = yes protocol imap { imap_logout_format = bytes_read=%i bytes_send=%o mail_max_userip_connections = 1000 mail_plugins = " stats " } protocol pop3 { mail_max_userip_connections = 1000 } Dominic

2 2

[Dovecot] LMTP userdb lookup
by list＠airstreamcomm.net 17 Oct '12

17 Oct '12

Is it possible to have separate userdb lookups for LMTP and POP/IMAP?

3 5

[Dovecot] Problem with quota update in dovecot 1.2
by tower 16 Oct '12

16 Oct '12

Hi A have a problem with quota2 table, working under postfixadmin. When I login into imap server with thunderbird client everything works fine, quota is update when i receive a message, but when I move message to trash or any other folder value for messages field in table quota2 increases +1 instead decreases or have still this same value. Only if I close my imap client value descending -2. I wish to table quota2 will be updated immediately after any operation on inbox. Is there any mistake in my configuration? Thanks for any advice. ============================================================== dovecot -n print: # 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-xen-686 i686 Debian 6.0.3 ext3 log_path: /var/log/dovecot/error.log info_log_path: /var/log/dovecot/info.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3 pop3s disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login first_valid_uid: 100 mail_privileged_group: Debian-exim mail_uid: 101 mail_gid: 103 mail_location: maildir:/var/mail/virtual/%d/%n/Maildir mail_cache_min_mail_count: 100 mail_debug: yes mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/rawlog /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/rawlog /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugins(default): autocreate quota imap_quota trash mail_plugins(imap): autocreate quota imap_quota trash mail_plugins(pop3): quota mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 imap_client_workarounds(default): tb-extra-mailbox-sep imap_client_workarounds(imap): tb-extra-mailbox-sep imap_client_workarounds(pop3): imap_id_log(default): * imap_id_log(imap): * imap_id_log(pop3): lda: postmaster_address: postmaster(a)mydomain.com mail_plugins: quota log_path: /var/log/dovecot/lda-errors.log info_log_path: /var/log/dovecot/deliver.log auth default: mechanisms: plain login verbose: yes debug: yes debug_passwords: yes passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen master: path: /var/run/dovecot/auth-master mode: 384 user: Debian-exim plugin: autocreate: INBOX autocreate2: Sent autocreate3: Trash autocreate4: Drafts autocreate5: Junk autocreate6: Spam autosubscribe: INBOX autosubscribe2: Sent autosubscribe3: Trash autosubscribe4: Drafts autosubscribe5: Junk autosubscribe6: Spam quota: dict:user::proxy::quotadict quota_rule: Trash:storage=+20%% quota_rule2: Spam:ignore quota_rule3: Drafts:storage=+5%% quota_rule4: Sent:storage=+15%% quota_rule5: Junk:storage=+10%% quota_warning: storage=100%% quota-exceeded 100 %u quota_warning2: storage=95%% quota-warning 95 %u quota_warning3: storage=90%% quota-warning 90 %u quota_warning4: storage=85%% quota-warning 85 %u quota_warning5: storage=80%% quota-warning 80 %u quota_warning6: storage=75%% quota-warning 75 %u quota_warning7: storage=70%% quota-warning 70 %u quota_warning8: storage=65%% quota-warning 65 %u trash: /etc/dovecot/dovecot-trash.conf mail_log_events: delete undelete expunge copy mailbox_delete mailbox_rename flag_change append mail_log_group_events: no mail_log_fields: uid box msgid size subject from dict: quotadict: mysql:/etc/dovecot/dovecot-dict-quota.conf ============================================= cat /etc/dovecot/dovecot-sql.conf driver = mysql connect = host=localhost dbname=eximdb user=eximdbadm password=************* default_pass_scheme = PLAIN password_query = \ SELECT username as user, domain, password \ FROM mailbox WHERE username= '%u' AND active = 1 user_query = \ SELECT CONCAT('/var/mail/virtual/', maildir) AS home, 101 AS uid, 103 AS gid, concat('dict:storage=', CAST(ROUND(quota / 1024) AS CHAR), '::proxy::quotadict') AS quota, CONCAT('*:storage=', CAST(quota AS CHAR), 'B') AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' ============================================= cat /etc/dovecot/dovecot-dict-quota.conf connect = host=localhost dbname=eximdb user=eximdbadm password=********* map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages } ============================================== cat /etc/dovecot/dovecot-trash.conf 1 Trash 2 Spam 3 Sent 4 Draft

2 3

[Dovecot] Plugin hooks in login process
by Simone Lazzaris 16 Oct '12

16 Oct '12

Hi all; I've setup dovecot (2.1.10) in a cluster configuration. We have two servers acting as frontend which authenticates users and proxy them to other two servers which handles the "real" work. Users credentials are on a mysql cluster; we have one master, in which read/write queries are processed, and many replicated slave, which process read-only queries. The frontend servers reads users credentials from the read-only mysql slaves. I'd like to execute a query once the client is verified to update the last login data. Right now, that query is executed on the backend servers, via a post-login service: protocols = imap service imap-postlogin { executable = script-login /usr/local/etc/dovecot/postlogin.sh unix_listener imap-postlogin { group = vchkpw mode = 0600 user = vpopmail } } service imap { executable = imap imap-postlogin process_limit = 2048 } Problem is, if I execute the update on the backend, I miss the information regarding the original IP, as I only see the IP of the proxies. I haven't been able to launch the postlogin service on the frontend, so I figured that I can try to write a plugin - that also seems to me the cleanest solution. Looking in the dovecot source code, I noticed that there aren't any hooks in the execution path used by the proxies; I am missing something ? I am the only one missing the presence of this hooks in the auth/proxy process ? I've also thought of a workaround for this problem. One way is to monitor the dovecot logs on the frontend and execute the update asyncronously. One other way is to query directly the main mysql server of the cluster and adjust the query making it call a stored procedure that updates the information in case of successful login. But I'd really prefer to create a plugin, that I'd be willing to share. I attach the configuration of the servers (front and back) generated via postfix -n. Thanks in advance for any help. -- Simone Lazzaris | Responsabile aree datacenter e VoIP Interactive Network srl | via Roggia Vignola 9, 24047 Treviglio (BG) Tel. 0363 1970352 | Fax 0363.1971971 | www.interactive.eu

2 2

[Dovecot] Dovecot deliver Segmentation fault when arrive the first message
by Alessio Cecchi 16 Oct '12

16 Oct '12

Hi, I have found this strange problem. I'm working with Debian 6, dovecot 2.1.9 and vpopmail-auth. LDA is configured and works fine but the problem is when the first message arrive "dovecot-lda" return a "Segmentation fault", the message is written to the user's Mailbox but the message remains, also, in the queue of qmail (deferral: Segmentation_fault/) and at the second attempt is delivered fine. If disable ACL (acl and imap_acl from mail_plugins) in dovecot.conf "Segmentation fault" go away. Moreover, without ACL at the first delivery folders like Sent, Drafts, Trash, Spam appear immediately. An example, new user: root@demo-vpop ~ # tree /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/ -a /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/ ├── cur ├── maildirsize ├── new └── tmp root@demo-vpop ~ # cat testmail.txt | /usr/local/dovecot-2.1/libexec/dovecot/deliver -d cecchi2(a)qboxdns.it Segmentation fault root@demo-vpop ~ # echo $? 139 root@demo-vpop ~ # tree /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/ -a /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/ ├── cur ├── dovecot-acl-list ├── dovecot.index.cache ├── dovecot.index.log ├── dovecot-uidlist ├── dovecot-uidvalidity ├── dovecot-uidvalidity.50599a7f ├── maildirsize ├── new │ └── 1348049535.M21758P19264.demo-vpop.cbsolt.net,S=2025,W=2071 └── tmp dovecot log (with ulimit -c unlimited before starting Dovecot): Sep 19 12:06:50 auth: Debug: Loading modules from directory: /usr/local/dovecot-2.1/lib/dovecot/auth Sep 19 12:06:50 auth: Debug: master in: USER 1 cecchi2(a)qboxdns.it service=lda Sep 19 12:06:50 auth-worker(18728): Debug: Loading modules from directory: /usr/local/dovecot-2.1/lib/dovecot/auth Sep 19 12:06:50 auth-worker(18728): Debug: vpopmail(cecchi2(a)qboxdns.it): lookup user=cecchi2 domain=qboxdns.it Sep 19 12:06:50 auth: Debug: master out: USER 1 cecchi2(a)qboxdns.it uid=89 gid=89 home=/home/vpopmail/domains/qboxdns.it/cecchi2 quota_rule=*:backend=10485760S Sep 19 12:06:50 dict: Info: mysql(localhost): Connected to database dovecot lda log: Sep 19 12:06:50 lda: Debug: Loading modules from directory: /usr/local/dovecot-2.1/lib/dovecot Sep 19 12:06:50 lda: Debug: Module loaded: /usr/local/dovecot-2.1/lib/dovecot/lib01_acl_plugin.so Sep 19 12:06:50 lda: Debug: Module loaded: /usr/local/dovecot-2.1/lib/dovecot/lib10_quota_plugin.so Sep 19 12:06:50 lda: Debug: auth input: cecchi2(a)qboxdns.it uid=89 gid=89 home=/home/vpopmail/domains/qboxdns.it/cecchi2 quota_rule=*:backend=10485760S Sep 19 12:06:50 lda: Debug: Added userdb setting: plugin/quota_rule=*:backend=10485760S Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Effective uid=89, gid=89, home=/home/vpopmail/domains/qboxdns.it/cecchi2 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=UserQuota backend=maildir args= Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Quota rule: root=UserQuota mailbox=* bytes=10485760 messages=0 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Quota rule: root=UserQuota mailbox=Trash bytes=+104857600 messages=0 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=User quota backend=dict args=:noenforcing:proxy::quota Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: dict quota: user=cecchi2(a)qboxdns.it, uri=proxy::quota, noenforcing=1 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Namespace inbox: type=private, prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:~/Maildir Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: maildir++: root=/home/vpopmail/domains/qboxdns.it/cecchi2/Maildir, index=, control=, inbox=/home/vpopmail/domains/qboxdns.it/cecchi2/Maildir, alt= Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl: initializing backend with data: vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl: acl username = cecchi2(a)qboxdns.it Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl: owner = 1 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: Global ACL directory: /usr/local/dovecot-2.1/etc/dovecot/global-acls Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Namespace : type=shared, prefix=shared/%n/, sep=/, inbox=no, hidden=no, list=children, subscriptions=no location=maildir:%h/Maildir:INDEX=~/Maildir/shared/%u Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: shared: root=/usr/local/dovecot-2.1/var/run/dovecot, index=, control=, inbox=, alt= Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl: initializing backend with data: vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl: acl username = cecchi2(a)qboxdns.it Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl: owner = 0 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: Global ACL directory: /usr/local/dovecot-2.1/etc/dovecot/global-acls Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=UserQuota backend=maildir args= Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=User quota backend=dict args=:noenforcing:proxy::quota Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: dict quota: user=raw mail user, uri=proxy::quota, noenforcing=1 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: none: root=, index=, control=, inbox=, alt= Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Destination address: cecchi2(a)qboxdns.it (source: user@hostname) Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: Namespace : Using permissions from /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir: mode=0700 gid=-1 Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Info: msgid=<5059979E.3080402(a)cecchi.biz>: saved mail to INBOX Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls//.DEFAULT not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/INBOX not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/dovecot-acl not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Drafts not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Drafts/dovecot-acl not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Spam not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Spam/dovecot-acl not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Trash not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Trash/dovecot-acl not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Sent not found Sep 19 12:06:50 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Sent/dovecot-acl not found now works fine: root@demo-vpop ~ # cat testmail.txt | /usr/local/dovecot-2.1/libexec/dovecot/deliver -d cecchi2(a)qboxdns.it Sep 19 12:08:18 auth: Debug: master in: USER 1 cecchi2(a)qboxdns.it service=lda Sep 19 12:08:18 auth-worker(18763): Debug: Loading modules from directory: /usr/local/dovecot-2.1/lib/dovecot/auth Sep 19 12:08:18 auth-worker(18763): Debug: vpopmail(cecchi2(a)qboxdns.it): lookup user=cecchi2 domain=qboxdns.it Sep 19 12:08:18 auth: Debug: master out: USER 1 cecchi2(a)qboxdns.it uid=89 gid=89 home=/home/vpopmail/domains/qboxdns.it/cecchi2 quota_rule=*:backend=10485760S Sep 19 12:08:18 dict: Info: mysql(localhost): Connected to database dovecot Sep 19 12:08:18 lda: Debug: Loading modules from directory: /usr/local/dovecot-2.1/lib/dovecot Sep 19 12:08:18 lda: Debug: Module loaded: /usr/local/dovecot-2.1/lib/dovecot/lib01_acl_plugin.so Sep 19 12:08:18 lda: Debug: Module loaded: /usr/local/dovecot-2.1/lib/dovecot/lib10_quota_plugin.so Sep 19 12:08:18 lda: Debug: auth input: cecchi2(a)qboxdns.it uid=89 gid=89 home=/home/vpopmail/domains/qboxdns.it/cecchi2 quota_rule=*:backend=10485760S Sep 19 12:08:18 lda: Debug: Added userdb setting: plugin/quota_rule=*:backend=10485760S Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Effective uid=89, gid=89, home=/home/vpopmail/domains/qboxdns.it/cecchi2 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=UserQuota backend=maildir args= Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Quota rule: root=UserQuota mailbox=* bytes=10485760 messages=0 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Quota rule: root=UserQuota mailbox=Trash bytes=+104857600 messages=0 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=User quota backend=dict args=:noenforcing:proxy::quota Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: dict quota: user=cecchi2(a)qboxdns.it, uri=proxy::quota, noenforcing=1 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace inbox: type=private, prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:~/Maildir Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: maildir++: root=/home/vpopmail/domains/qboxdns.it/cecchi2/Maildir, index=, control=, inbox=/home/vpopmail/domains/qboxdns.it/cecchi2/Maildir, alt= Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl: initializing backend with data: vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl: acl username = cecchi2(a)qboxdns.it Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl: owner = 1 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: Global ACL directory: /usr/local/dovecot-2.1/etc/dovecot/global-acls Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : type=shared, prefix=shared/%n/, sep=/, inbox=no, hidden=no, list=children, subscriptions=no location=maildir:%h/Maildir:INDEX=~/Maildir/shared/%u Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: shared: root=/usr/local/dovecot-2.1/var/run/dovecot, index=, control=, inbox=, alt= Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl: initializing backend with data: vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl: acl username = cecchi2(a)qboxdns.it Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl: owner = 0 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: Global ACL directory: /usr/local/dovecot-2.1/etc/dovecot/global-acls Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=UserQuota backend=maildir args= Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Quota root: name=User quota backend=dict args=:noenforcing:proxy::quota Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: dict quota: user=raw mail user, uri=proxy::quota, noenforcing=1 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: none: root=, index=, control=, inbox=, alt= Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Destination address: cecchi2(a)qboxdns.it (source: user@hostname) Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Info: msgid=<5059979E.3080402(a)cecchi.biz>: saved mail to INBOX Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls//.DEFAULT not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/INBOX not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/dovecot-acl not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Drafts not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Drafts/dovecot-acl not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Drafts doesn't exist yet, using default permissions Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : Using permissions from /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir: mode=0700 gid=-1 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls//.DEFAULT not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Spam not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Spam/dovecot-acl not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Spam doesn't exist yet, using default permissions Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : Using permissions from /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir: mode=0700 gid=-1 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls//.DEFAULT not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Trash not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Trash/dovecot-acl not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Trash doesn't exist yet, using default permissions Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : Using permissions from /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir: mode=0700 gid=-1 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls//.DEFAULT not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls/Sent not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Sent/dovecot-acl not found Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir/.Sent doesn't exist yet, using default permissions Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: Namespace : Using permissions from /home/vpopmail/domains/qboxdns.it/cecchi2/Maildir: mode=0700 gid=-1 Sep 19 12:08:18 lda(cecchi2(a)qboxdns.it): Debug: acl vfile: file /usr/local/dovecot-2.1/etc/dovecot/global-acls//.DEFAULT not found # 2.1.9: /usr/local/dovecot-2.1/etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-amd64 x86_64 Debian 6.0.5 auth_cache_size = 512 k auth_debug = yes auth_debug_passwords = yes auth_verbose = yes auth_worker_max_count = 60 default_login_user = nobody dict { acl = mysql:/usr/local/dovecot-2.1/etc/dovecot/dovecot-share-folder.conf quota = mysql:/usr/local/dovecot-2.1/etc/dovecot/dovecot-dict-sql.conf.ext } disable_plaintext_auth = no dotlock_use_excl = no first_valid_gid = 89 first_valid_uid = 89 last_valid_gid = 89 last_valid_uid = 89 lda_mailbox_autocreate = yes lda_mailbox_autosubscribe = yes log_path = /var/log/dovecot/dovecot.log mail_debug = yes mail_fsync = always mail_location = maildir:~/Maildir mail_nfs_index = yes mail_nfs_storage = yes mail_plugins = quota acl maildir_very_dirty_syncs = yes mmap_disable = yes namespace { list = children location = maildir:%%h/Maildir:INDEX=~/Maildir/shared/%%u prefix = shared/%%n/ separator = / subscriptions = no type = shared } namespace inbox { inbox = yes location = mailbox Drafts { auto = subscribe special_use = \Drafts } mailbox Sent { auto = subscribe special_use = \Sent } mailbox Spam { auto = subscribe special_use = \Junk } mailbox Trash { auto = subscribe special_use = \Trash } prefix = separator = / } passdb { args = cache_key=%s%u webmail=192.168.113.215 driver = vpopmail } plugin { acl = vfile:/usr/local/dovecot-2.1/etc/dovecot/global-acls:cache_secs=300 acl_shared_dict = proxy::acl quota = maildir:UserQuota quota2 = dict:User quota::noenforcing:proxy::quota quota_rule2 = Trash:storage=+100M } protocols = imap pop3 sendmail_path = /var/qmail/bin/sendmail service auth { unix_listener auth-userdb { group = vchkpw mode = 0660 user = vpopmail } } service dict { unix_listener dict { group = vchkpw mode = 0660 user = vpopmail } } service imap-login { service_count = 0 } service pop3-login { service_count = 0 } ssl_cert = </etc/ssl/certs/wildcard-cbsolt.pem ssl_key = </etc/ssl/private/wildcard-cbsolt.key userdb { args = quota_template=quota_rule=*:backend=%q driver = vpopmail } protocol lda { log_path = /var/log/dovecot/lda.log } protocol imap { imap_client_workarounds = delay-newmail tb-extra-mailbox-sep tb-lsub-flags mail_max_userip_connections = 20 mail_plugins = quota acl imap_quota imap_acl } protocol pop3 { mail_max_userip_connections = 5 pop3_client_workarounds = outlook-no-nuls oe-ns-eoh } Thanks -- Alessio Cecchi is: @ ILS -> http://www.linux.it/~alessice/ on LinkedIn -> http://www.linkedin.com/in/alessice Assistenza Sistemi GNU/Linux -> http://www.cecchi.biz/ @ PLUG -> ex-Presidente, adesso senatore a vita, http://www.prato.linux.it

2 11

[Dovecot] Search for substring in header?
by Dave Abrahams 16 Oct '12

16 Oct '12

Hi, According to the IMAP spec (http://tools.ietf.org/html/rfc2060#page-37) if I do a search for "TO isocpp.org" it should find all the messages whose To: field contains the string "isocpp.org", but dovecot is returning me an empty list. However, a search for "TO tm(a)isocpp.org" produces a long list of messages. What am I doing wrong? TIA, Dave -- Dave Abrahams BoostPro Computing Software Development Training http://www.boostpro.com Clang/LLVM/EDG Compilers C++ Boost

3 7

[Dovecot] /var/run/dovecot/auth-userdb failed
by thefantaman 16 Oct '12

16 Oct '12

Hi, I work on test server and if I send an email on log i read lda: Error: userdb lookup: connect(/var/run/dovecot/auth-userdb) failed: Permission denied (euid=8135(vmail) egid=8135(vmail) missing +r perm: /var/run/dovecot/auth-userdb, euid is not dir owner) This is my dovecot.conf: auth_mechanisms = plain login info_log_path = /var/log/dovecot listen = 0.0.0.0 log_path = /var/log/dovecot login_greeting = Dovecot IMAP Server ready. mail_location = maildir:/home/vmail/%d/%u mail_privileged_group = vmail passdb { args = /etc/dovecot/dovecot-ldap.conf.ext.fabry driver = ldap } protocols = pop3 sieve imap service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { mode = 0600 user = root group = root } } ssl_cert = </etc/pki/dovecot/certs/dovecot.pem ssl_key = </etc/pki/dovecot/private/dovecot.pem userdb { driver = ldap args = /etc/dovecot/dovecot-ldap.conf.ext.fabry } lda_original_recipient_header = X-Original-To lda_mailbox_autocreate = yes lda_mailbox_autosubscribe = yes protocol lda { mail_plugins = $mail_plugins sieve info_log_path = /var/log/dovecot-lda.log } managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variab les body enotify environment mailbox date plugin { sieve_dir = /home/vmail/%d/%u/sieve sieve = /home/vmail/%d/%u/sieve/.dovecot.sieve } What did I do wrong? -- View this message in context: http://dovecot.2317879.n4.nabble.com/var-run-dovecot-auth-userdb-failed-tp3… Sent from the Dovecot mailing list archive at Nabble.com.

3 2

[Dovecot] [BUG] Lucene plugin breaks header substring search
by Dave Abrahams 16 Oct '12

16 Oct '12

According to the IMAP spec if I do a search for "TO isocpp.org" it should find all the messages whose To: field contains the string "isocpp.org", but dovecot is returning me an empty list. However, a search for "TO tm(a)isocpp.org" produces a long list of messages. This behavior is present if I *even load* the lucene fts plugin. Note that lucene isn't in use (fts = squat); it's merely loaded. This behavior goes away if I don't load fts_lucene. Dovecot configuration with dovecot -n: --8<---------------cut here---------------start------------->8--- # 2.1.6: /usr/local/stow/dovecot-2.1.6/etc/dovecot/dovecot.conf # OS: Darwin 11.4.2 x86_64 hfs default_internal_user = _dovecot default_login_user = _dovenull mail_gid = 20 mail_location = mdbox:/Users/dave/Library/Data/LocalIMAP/mdbox mail_plugin_dir = /usr/local/lib/dovecot mail_plugins = fts fts_squat fts_lucene zlib mail_uid = 501 maildir_very_dirty_syncs = yes namespace { inbox = yes location = prefix = separator = . subscriptions = yes type = private } passdb { args = uid=501 gid=20 home=/Users/dave nopassword=y driver = static } plugin { fts = squat zlib_save = gz zlib_save_level = 6 } protocols = imap ssl = no protocol imap { mail_plugins = fts fts_squat fts_lucene zlib } --8<---------------cut here---------------end--------------->8--- Dovecot version: 2.1.6 Operating system or Linux distribution name: MacOS X 10.7, 10.8 CPU architecture (x86 or something else?): x86_64 Filesystem you used (especially if you use NFS or not): Mac Some kind of description of what you were doing and with what IMAP client.: Searching -- Dave Abrahams BoostPro Computing Software Development Training http://www.boostpro.com Clang/LLVM/EDG Compilers C++ Boost

2 6

Re: [Dovecot] per-user quotas
by David Mehler 16 Oct '12

16 Oct '12

Hello, Thanks for your replies so far. Still having issues with per-user quotas. To my Mysql virtual_users table I've added a column quota_kb and for a test user I've added in a value of 250000 going for a 250 megabyte quota. I've tried various sql queries they're returning empty sets not pulling out the information needed. Thanks. Dave. On 10/12/12, Daniel Parthey <daniel.parthey(a)informatik.tu-chemnitz.de> wrote: > Hi Dave, > > David Mehler wrote: >> Thanks for your reply. I've written you directly as it is sounding >> like at least for now this isn't dovecot it's well a mysql issue with >> design. I don't have anything in my database setup with regards quota >> I've included it below. I've got one virtual mail user called vmail >> with UID/GID of 5000 who owns all the virtual mailboxes. If I'm >> understanding what I've read in the link, the dovecot wiki and your >> message since anything in a user section of Mysql will override the >> global configuration in 90-quota.conf, that being the case I should >> add an extra column to virtual users? Once that's done adjust the >> userdb query for dovecot to return quota information? > > Yes, the quota should be stored in an additional userdb column, > or you need at least an SQL statement which takes a username > and returns a quota rule. > > Quota of 0 is interpreted as "unlimited" by dovecot. > As already said, if the value in the quota column for the > user is 0, your SQL statement could also return a different > value (default quota) instead of 0 (using MySQL CASE/ELSE statement). > > Here is a short documentation on how it is done with Tine 2.0 Groupware: > http://www.tine20.org/wiki/index.php/Admins/Mailserver_integration > (it is a simple example which does not support a default quota fallback, > since Tine 2.0 writes the default quota as a value into the column > when the user is created) > > Regards > Daniel > -- > https://plus.google.com/103021802792276734820 >

1 0

[Dovecot] fts = squat solr
by Dave Abrahams 16 Oct '12

16 Oct '12

I don't know if this was supposed to have changed with dovecot2, but http://wiki.dovecot.org/Plugins/FTS shows fts = squat solr so, since I have the lucene plugin—"fts = lucene" works by itself—I tried fts = squat lucene but: $ doveadm index '*' doveadm(dave): Error: fts: Failed to initialize backend 'squat lucene': Unknown backend So, is that syntax obsolete, is the wiki wrong, or am I doing something wrong? -- Dave Abrahams BoostPro Computing Software Development Training http://www.boostpro.com Clang/LLVM/EDG Compilers C++ Boost

2 1

[Dovecot] POP UIDL
by simon.buongiorno＠gmail.com 16 Oct '12

16 Oct '12

Hi I run a small mail server with Dovecot and postfix. Several of the accounts are popped by an external email provide I use, mostly out habit and also for a bit of redundancy. I have no details on that external server except that it uses exim. Lately, it's been repopping mail from accounts (mail is left on the server so I can use IMAP) at fairly frequent, but undetermined, intervals. Before I take it to them, I want to be sure it's not an error on my side. How can I be sure Dovecot does not have a problem with the UIDL list causing this external server to repop the mail? For the record, I'm not inclined to think it's a Dovecot issue, but since that's the bit I can fix, I'd like to be sure. Cheers Simon

2 1