October 2014 - dovecot

Re: Unable to get virtual users set up with database auth
by Gedalya 16 Oct '14

16 Oct '14

On 10/16/2014 12:19 PM, Cliff Hayes wrote: > well i don't want to use system users. but how do I assign a UID and > GID to virtual users to eliminate the permissions errors? > For dovecot, it is like this: http://wiki2.dovecot.org/AuthDatabase/SQL#User_database_lookups I don't know if this would be OK with your sendmail side. You should really post your complete dovecot config (dovecot -n output + any ".ext" files) so that we can get a better picture.

1 0

Unable to get virtual users set up with database auth
by Cliff Hayes 16 Oct '14

16 Oct '14

I can't seem to get imap virtual users to work with database authentication on new Scientific Linux 6.5 server with Sendmail 8.14.4 & Dovecot 2.0.9 Apparently I have to also create system users because sendmail/procmail/dovecot want to check directory ownership. So I created a database, made entry for the user, created the user chayes on the system. But %u always contains just chayes instead of chayes(a)domain.tld even though I tried different select statements to put the entire username in the username field. This causes the following errors: Oct 16 00:10:26 avalon sendmail[2536]: s9G5APo9002535: forward /var/spool/mail/chayes(a)domain.tld/chayes/.forward.avalon: Group writable directory Oct 16 00:10:26 avalon sendmail[2536]: s9G5APo9002535: forward /var/spool/mail/chayes(a)domain.tld/chayes/.forward: Group writable directory Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Effective uid=497, gid=497, home=/var/spool/mail/chayes(a)domain.tld/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Home dir not found: /var/spool/mail/chayes(a)domain.tld/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Namespace : type=private, prefix=, sep=., inbox=yes, hidden=no, list=yes, subscriptions=yes location=mbox:/var/spool/mail/chayes:INBOX=/var/spool/mail/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: fs: root=/var/spool/mail/chayes, index=, control=, inbox=/var/spool/mail/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Error: user chayes: Initialization failed: Namespace '': mbox: mbox root directory can't be a file: /var/spool/mail/chayes (http://wiki.dovecot.org/MailLocation/Mbox) Oct 16 00:10:26 avalon dovecot: lda(chayes): Fatal: Invalid user settings. Refer to server log for more information. protocols = imap mail_location = mbox:/var/spool/mail/%u:INBOX=/var/spool/mail/%u password_query = SELECT uNameDomain as username, uDomain as domain, uPass as password FROM users WHERE uName = '%n' AND uDomain = '%d' also tried password_query = SELECT uName as username, uDomain as domain, uPass as password FROM users WHERE uName = '%n' AND uDomain = '%d' # file: /etc/procmailrc # system-wide settings for procmail SHELL="/bin/bash" SENDMAIL="/usr/sbin/sendmail -oi -t" LOGFILE="/var/log/procmail.log" DROPPRIVS=yes DELIVER="/usr/libexec/dovecot/deliver" #MAILDIR=$HOME/ #DEFAULT=$HOME/ :0 w * ^X-Spam-Status: Yes | $DELIVER -m spam :0 w | $DELIVER Thanks in advance

3 4

Unable to get virtual users set up with database auth
by Cliff Hayes 16 Oct '14

16 Oct '14

I can't seem to get imap virtual users to work with database authentication on new Scientific Linux 6.5 server with Sendmail 8.14.4 & Dovecot 2.0.9 Apparently I have to also create system users because sendmail/procmail/dovecot want to check directory ownership. So I created a database, made entry for the user, created the user chayes on the system. But %u always contains just chayes instead of chayes(a)domain.tld even though I tried different select statements to put the entire username in the username field. This causes the following errors: Oct 16 00:10:26 avalon sendmail[2536]: s9G5APo9002535: forward /var/spool/mail/chayes(a)domain.tld/chayes/.forward.avalon: Group writable directory Oct 16 00:10:26 avalon sendmail[2536]: s9G5APo9002535: forward /var/spool/mail/chayes(a)domain.tld/chayes/.forward: Group writable directory Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Effective uid=497, gid=497, home=/var/spool/mail/chayes(a)domain.tld/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Home dir not found: /var/spool/mail/chayes(a)domain.tld/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: Namespace : type=private, prefix=, sep=., inbox=yes, hidden=no, list=yes, subscriptions=yes location=mbox:/var/spool/mail/chayes:INBOX=/var/spool/mail/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Debug: fs: root=/var/spool/mail/chayes, index=, control=, inbox=/var/spool/mail/chayes Oct 16 00:10:26 avalon dovecot: lda(chayes): Error: user chayes: Initialization failed: Namespace '': mbox: mbox root directory can't be a file: /var/spool/mail/chayes (http://wiki.dovecot.org/MailLocation/Mbox) Oct 16 00:10:26 avalon dovecot: lda(chayes): Fatal: Invalid user settings. Refer to server log for more information. protocols = imap mail_location = mbox:/var/spool/mail/%u:INBOX=/var/spool/mail/%u password_query = SELECT uNameDomain as username, uDomain as domain, uPass as password FROM users WHERE uName = '%n' AND uDomain = '%d' also tried password_query = SELECT uName as username, uDomain as domain, uPass as password FROM users WHERE uName = '%n' AND uDomain = '%d' # file: /etc/procmailrc # system-wide settings for procmail SHELL="/bin/bash" SENDMAIL="/usr/sbin/sendmail -oi -t" LOGFILE="/var/log/procmail.log" DROPPRIVS=yes DELIVER="/usr/libexec/dovecot/deliver" #MAILDIR=$HOME/ #DEFAULT=$HOME/ :0 w * ^X-Spam-Status: Yes | $DELIVER -m spam :0 w | $DELIVER Thanks in advance

1 0

[Dovecot/VirtualUsers/VirtualMailBoxes] No mails into mua
by aleskandro 16 Oct '14

16 Oct '14

Hi all, I've configured postfix with multiple host and virtual mailboxes (main.cf is here: http://pastebin.com/798VVxbv) So I can receive email to vuser(a)mydomain.tld into /var/mail/vhosts/mydomain.tld/vuser file. Now I'm configuring dovecot 2.2.13-r1; this is my dovecot -n and /etc/dovecot/passwddir/mydomain.tld/passwd: http://pastebin.com/b4xcjj7t - The auth and server subscribe from a mua is ok and in the vuser file there are some mails but I can't see them in my mua. mail.log doesn't report any error. Where I'm wrong? Aleskandro

2 1

Strange quota warning behavior
by Gordon Grubert 16 Oct '14

16 Oct '14

Hi, we are using dovecot 2.2.14. So far, we used the following quota warning configuration quota_rule = *:storage=10G quota_warning = storage=90%% quota-warning 90 %n quota_warning2 = storage=80%% quota-warning 80 %n quota_warning3 = storage=70%% quota-warning 70 %n This works fine. Now, we wanted to add the all clear feature for the quota warning by adding this line: quota_warning4 = -storage=70%% quota-warning 70 %n below The result is really strange. Test 1: 70% exceeded: warning3 executed => OK fall below 70%: quota_warning2 executed => NOT OK quota_warning4 executed => OK Test 2: 70% exceeded: warning3 executed => OK 80% exceeded: warning2 executed => OK fall below 80% (but still more than 70%): quota_warning executed => NOT OK fall below 70%: quota_warning2 executed => NOT OK quota_warning4 executed => OK At the moment, we are running the minimal configuration quota_warning = storage=70%% quota-warning 70 %n quota_warning2 = -storage=70%% quota-warning 70 %n below working like expected (warning when exceeding 70% and all clear when falling below 70%). Does anybody know if there is an error in our configuration or maybe, could this be a bug in dovecot? Best regards, Gordon -- Technischer Leiter & stellv. Direktor Universitätsrechenzentrum (URZ) E.-M.-Arndt-Universität Greifswald Felix-Hausdorff-Str. 12 17489 Greifswald Germany Tel. +49 3834 86 1456 Fax. +49 3834 86 1401

1 0

index problem with only 1 folder of 1 box
by Guillaume 16 Oct '14

16 Oct '14

Hello, First of all, sorry for my poor english level. I pass to solr indexing. All is OK, except for the inbox of one of the mailboxes. For this inbox (other folders of the same mailbox have no problems), when i do text search, there is always no response. Others mailboxes have no problems. If i do a : "doveadm -Dv fts rescan -u mybox(a)domain.tld", i can do one and only one search with the correct response. It index the folder, take a few seconds and give me the good answer. If i redo the same search, it's extremly quick with no answers. It's like a cache problem but i don't know where and why... Logs are not very verbose... Here is an example of command line search : ---------------------------------------- $ nc 127.0.0.1 143 * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE STARTTLS AUTH=PLAIN AUTH=LOGIN] Bienvenue sur le serveur IMAP de Domain.tld 10 LOGIN "mybox(a)domain.tld" "MyBigSecret" 10 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE SEARCH=FUZZY QUOTA] Logged in 20 SELECT INBOX * FLAGS (\Answered \Flagged \Deleted \Seen \Draft unknown-2 unknown-9 unknown-0 unknown-10 unknown-1 unknown-4 $MDNSent unknown-3 unknown-8 $Forwarded NonJunk) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft unknown-2 unknown-9 unknown-0 unknown-10 unknown-1 unknown-4 $MDNSent unknown-3 unknown-8 $Forwarded NonJunk \*)] Flags permitted. * 8437 EXISTS * 0 RECENT * OK [UIDVALIDITY 1412669180] UIDs valid * OK [UIDNEXT 8439] Predicted next UID * OK [HIGHESTMODSEQ 20] Highest 20 OK [READ-WRITE] Select completed (0.000 secs). 30 SEARCH text "coucou" * OK Indexed 14% of the mailbox, ETA 0:57 * OK Indexed 29% of the mailbox, ETA 0:47 * OK Indexed 72% of the mailbox, ETA 0:11 * OK Mailbox indexing finished * SEARCH 35 108 153 175 176 182 348 357 360 431 472 479 520 574 575 576 577 578 586 949 984 1025 1032 1033 1034 1087 1099 1129 1284 1313 1314 1315 1366 1372 1465 1538 1711 1726 1758 1759 1969 1981 1983 1984 2036 2077 2104 2116 2162 2181 2193 2437 2504 2587 2663 2808 2809 2854 2861 2862 3076 3087 3088 3137 3188 3189 3190 3191 3192 3193 3196 3197 3250 3251 3252 3327 3328 3329 3330 3331 3332 3379 3464 3481 3494 3521 3528 3582 3589 3593 3596 3651 3667 3672 3695 3787 3789 3939 3940 3941 3942 3943 3944 3945 3946 4019 4020 4034 4043 4134 4146 4175 4241 4346 4379 4422 4490 4491 4537 4540 4542 4543 4544 4550 4627 4727 4742 4767 4790 4817 4828 4831 4839 4862 4888 4899 4901 4906 4911 4916 4957 4999 5003 5004 5008 5009 5010 5011 5012 5013 5039 5062 5081 5092 5119 5138 5145 5150 5152 5185 5186 5187 5216 5246 5247 5282 5283 5314 5316 5320 5322 5325 5337 5353 5360 5363 5385 5432 5447 5472 5485 5496 5498 5500 5528 5551 5564 5567 5595 5598 5642 5794 5841 5896 5933 5960 5961 5994 6001 6005 6016 6017 6051 6075 6125 6152 6163 6215 6238 6239 6240 6241 6287 6311 6342 6350 6353 6357 6369 6431 6472 6689 6928 6945 6951 7026 7030 7045 7046 7115 7210 7212 7214 7230 7256 7295 7298 7340 7489 7490 7492 7654 7655 7658 7660 7676 7767 7768 7800 7801 7913 7937 7956 8075 8085 8102 8111 8144 8266 8329 8333 8394 8395 8431 30 OK Search completed (36.029 secs). 40 SEARCH text "coucou" * SEARCH 40 OK Search completed (0.002 secs). 50 SEARCH text "blabla" * SEARCH 50 OK Search completed (0.002 secs). 60 LOGOUT * BYE Logging out 60 OK Logout completed. ---------------------------------------- To close this question, here is dovecot -n: ---------------------------------------- # 2.2.9: /etc/dovecot/dovecot.conf # OS: Linux 3.13.0-36-generic x86_64 Ubuntu 14.04.1 LTS ext4 auth_mechanisms = plain login debug_log_path = /var/log/dovecot-debug.log disable_plaintext_auth = no first_valid_uid = 5000 hostname = mailserver.domain.tld info_log_path = /var/log/dovecot-info.log last_valid_uid = 5000 lda_mailbox_autocreate = yes lda_original_recipient_header = X-Original-To listen = * log_path = /var/log/dovecot-err.log login_greeting = Bienvenue sur le serveur IMAP de Domain.tld mail_debug = yes mail_gid = 5000 mail_location = maildir:/data/mails/%d/%n mail_plugins = " quota fts fts_solr" mail_uid = 5000 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 passdb { driver = pam } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { fts = solr fts_autoindex = yes fts_solr = break-imap-search url=http://localhost:8080/solr/ quota = maildir:User quota sieve = /home/vmail/managesieve/.%n(a)%d.sieve sieve_dir = /home/vmail/managesieve/%d/%n sieve_global_dir = /home/vmail/sieve/ } postmaster_address = postmaster(a)domain.tld protocols = " imap sieve pop3" service auth { unix_listener /var/spool/postfix/private/auth { group = root mode = 0660 user = postfix } unix_listener auth-userdb { group = vmail mode = 0660 user = vmail } } service dict { unix_listener dict { group = vmail mode = 0600 user = vmail } } service managesieve-login { inet_listener sieve { port = 4190 } inet_listener sieve_deprecated { port = 2000 } } ssl_ca = </data/certificats/web/domain.tld/ca.pem ssl_cert = </etc/ssl/certs/dovecot.pem ssl_key = </etc/ssl/private/dovecot.pem userdb { driver = passwd } userdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } verbose_proctitle = yes protocol lmtp { mail_plugins = " sieve" } protocol lda { mail_plugins = " quota fts fts_solr sieve" } protocol imap { mail_plugins = " quota fts fts_solr imap_quota" } ------------------------------- By the way, i try to clean solr cache with an : echo 1 > /proc/sys/vm/drop_caches and a restart of the server, but there is always the same problem... Does anyone have an idea to explore? sincerly yours, Guillaume

2 4

Re: doveadm-move(1)
by Joseph Tam 16 Oct '14

16 Oct '14

Pascal Volk writes: >> EXAMPLE >> Move janes messages - received in September 2011 - from her >> INBOX into her archive. >> >> doveadm move -u jane Archive/2011/09 mailbox >> 2011-10-01 SINCE 01-Sep-2011 >> >> [Is this a typo: "2011-10-01" should be "INBOX"?] >> ? > > Where did you find this example? Cut&pasted off the terminal man page output. Looking into man1/doveadm-move.1, I see .B doveadm move \-u jane Archive/2011/09 mailbox INBOX BEFORE \(rs .B 2011-10-01 SINCE 01-Sep-2011 so it's a problem with my nroff, not dovecot's man pages. (Hmm, it happens with groff too -- it appears to be some sort of line length bug.) > Also http://wiki2.dovecot.org/Tools/Doveadm/Move#section_example > shows the correct example. Yes, this makes much more sense. Joseph Tam <jtam.home(a)gmail.com>

2 1

pop3-login segfaulting
by James Shewey 16 Oct '14

16 Oct '14

I upgraded dovecot from v1 to v2 as part of a CentOS upgrade (5.6->6.5) and am now running on 2.0.9. Any time I connect to the pop or imap ports however I get "master: Error: service(imap-login): child 2860 killed with signal 11 (core not dumped - add -D parameter to service imap-login { executable }" after following the core dump instructions at http://www.dovecot.org/bugreport.html. The problem is that I'm not sure how these processes are spawned in order to add the switch. Can I spawn them directly? If so, I ought to be able to do an strace to track down the issue as well. Regards, James Shewey NOC Systems Administrator I Product Support Engineering [Description: Panasonic Avionics] Panasonic Avionics Corporation Phone: +1 (949) 672-2000 Direct: +1 (949) 595-5187

2 2

Permissions problem on new installation
by Cliff Hayes 15 Oct '14

15 Oct '14

I am setting up a new mail server using imap only on Scientific Linux 6.5 and dovecot 2.0.9. How do I fix this problem? I keep getting these errors regardless of permissions ... even up to 777. Oct 15 13:56:01 avalon dovecot: imap(chayes(a)domain.tld): Error: opendir(/var/email/chayes(a)domain.tld/Maildir) failed: Permission denied (euid=497(chayes) egid=12(mail) missing +r perm: /var/email/chayes(a)domain.tld/Maildir, euid is not dir owner) Oct 15 13:56:01 avalon dovecot: imap(chayes(a)domain.tld): Error: opendir(/var/email/chayes(a)domain.tld/Maildir) failed: Permission denied (euid=497(chayes) egid=12(mail) missing +r perm: /var/email/chayes(a)domain.tld/Maildir, euid is not dir owner) Oct 15 13:56:01 avalon dovecot: imap(chayes(a)domain.tld): Error: opendir(/var/email/chayes(a)domain.tld/Maildir/new) failed: Permission denied (euid=497(chayes) egid=12(mail) missing +r perm: /var/email/chayes(a)domain.tld/Maildir/new, euid is not dir owner) Oct 15 13:56:07 avalon dovecot: imap(chayes(a)domain.tld): Error: opendir(/var/email/chayes(a)domain.tld/Maildir/new) failed: Permission denied (euid=497(chayes) egid=12(mail) missing +r perm: /var/email/chayes(a)domain.tld/Maildir/new, euid is not dir owner) Yet when i check, chayes is directory owner as follows (currently showing 760 but I've tried everything): drwx------. 3 chayes mail 4096 Oct 15 12:56 chayes(a)domain.tld drwxrwx---. 6 chayes mail 4096 Oct 15 13:55 Maildir drwxrw----. 2 chayes mail 4096 Oct 15 12:56 cur -rw-------. 1 chayes mail 104 Oct 15 12:56 dovecot.index.log -rw-------. 1 chayes mail 0 Oct 15 12:56 dovecot.mailbox.log -rw-------. 1 chayes mail 51 Oct 15 12:56 dovecot-uidlist drwxrw----. 2 chayes mail 4096 Oct 15 12:56 new -rw-------. 1 chayes mail 6 Oct 15 12:56 subscriptions drwxrw----. 2 chayes mail 4096 Oct 15 12:56 tmp dovecot config: protocols = imap mail_access_groups=mail mail_location = maildir:~/Maildir Thanks in advance.

1 1

Re: delete/archive old mail
by Joseph Tam 15 Oct '14

15 Oct '14

"F." <sottilette(a)rfx.it> writes: >>> doveadm-altmove seems interesting, but in the man page it is reported >>> only work with dbox (dbox-only), and my inboxes are in mbox format. >>> >>> Any other advice? > > As I originally wrote, my need is script or a command like the old > Expire_mail.pl that parse a local mbox folder and move/copy mail older > than NN days to another local mbox folder. > Probably for a Perl programmer is only matter of modify this script or > something similar. > I searched in docs, wiki, ... but not noticied something that can simply > be inserted in a cron job to do the work. > > Only migration tools or complex (for me), library that can be used to > manipulate folders :-) I don't understand how you could have found doveadm-altmove, but miss doveadm-move -- doesn't this dovecot command do exactly what you want? $ man doveadm-move NAME doveadm-move - Move messages matching the given search query into another mailbox ... EXAMPLE Move janes messages - received in September 2011 - from her INBOX into her archive. doveadm move -u jane Archive/2011/09 mailbox 2011-10-01 SINCE 01-Sep-2011 [Is this a typo: "2011-10-01" should be "INBOX"?] The example is fairly close to what you want. Apart from the obvious change to user and mailbox name, the condition would be "savedbefore ${NN}d". You might have to follow this up with an expunge if this operation does not do that. Joseph Tam <jtam.home(a)gmail.com>

2 1