- dovecot - dovecot.org

20 Dec '10

Hi I seem to be getting an error when quotas are enabled. Also I noticed that the quota_ rule settings don't actually get used, the only settings that are used are on the sql.conf file. Maybe I'm not understanding what the quota_rule does but should I be specifying the storage/messages values on there even though they are being read/used are on the sql.conf file only. dict { quotadict = mysql:/usr/local/etc/dovecot/dovecot-dict-quota-sql.conf } plugin { quota = dict:::proxy::quotadict quota_rule = *:storage=1M:messages=5 quota_exceeded_message = Quota exceed, please email support for further assistance. trash = /usr/local/etc/dovecot/trash.conf.ext driver = sql } Sql.conf user_query = SELECT concat('/var/vmail/%d/', maildir) as home, concat('maildir:/var/vmail/%d/', maildir) as mail, 101 AS uid, 502 AS gid, concat('*:messages=5:storage=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' Below are the errors I'm seeing in the log. If I'm overquota I get the following error Dec 20 08:32:32 testip5 dovecot: dict: mysql: Connected to localhost (dovecotquota) Dec 20 08:32:32 testip5 dovecot: lda(user1(a)virttest2.meganet.net): Panic: stream doesn't support seeking backwards Dec 20 08:32:32 testip5 dovecot: lda(user1(a)virttest2.meganet.net): Error: Raw backtrace: /usr/local/lib/dovecot/libdovecot.so.0 [0x7850c0] -> /usr/local/lib/dovecot/libdovecot.so.0(i_syslog_fatal_handler+0x34) [0x785164] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x784704] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x78e600] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_seek+0x68) [0x78bb68] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x78eda8] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read+0x7a) [0x78bc3a] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read_data+0x2b) [0x78beab] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parse_header_next+0x87) [0x76f4a7] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x770d5e] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_next_block+0x43) [0x770543] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_header+0x2f) [0x77075f] -> /usr/local/lib/dovecot/libdovecot-storage.so.0(index_mail_parse_headers+0x10 1) [0x598b51] -> /usr/local Dec 20 08:32:32 testip5 postfix/pipe[7995]: E0FA4958156: to=<user1(a)virttest2.meganet.net>, relay=dovecot, delay=3900, delays=3900/0/0/0.06, dsn=4.3.0, status=deferred (Command died with signal 6: "/usr/local/libexec/dovecot/deliver") Or error message if I'm not over quota on certain messages. Dec 20 08:12:12 testip5 dovecot: auth: Debug: master out: USER 1 user2(a)virttest1.meganet.net home=/var/vmail/virttest1.meganet.net/user2@virttest1.meganet.net/ mail=maildir:/var/vmail/virttest1.meganet.net/user2@virttest1.meganet.net/ uid=101 gid=502quota_rule=*:messages=5:storage=0 Dec 20 08:12:12 testip5 dovecot: lda(user2(a)virttest1.meganet.net): Panic: stream doesn't support seeking backwards Dec 20 08:12:12 testip5 dovecot: lda(user2(a)virttest1.meganet.net): Error: Raw backtrace: /usr/local/lib/dovecot/libdovecot.so.0 [0x63d0c0] -> /usr/local/lib/dovecot/libdovecot.so.0(i_syslog_fatal_handler+0x34) [0x63d164] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x63c704] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x646600] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_seek+0x68) [0x643b68] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x646da8] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read+0x7a) [0x643c3a] -> /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read_data+0x2b) [0x643eab] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parse_header_next+0x87) [0x6274a7] -> /usr/local/lib/dovecot/libdovecot.so.0 [0x628d5e] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_next_block+0x43) [0x628543] -> /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_header+0x2f) [0x62875f] -> /usr/local/lib/dovecot/libdovecot-storage.so.0(index_mail_parse_headers+0x10 1) [0xb17b51] -> /usr/local Dec 20 08:12:12 testip5 postfix/pipe[7557]: 2982A958151: to=<user2(a)virttest1.meganet.net>, relay=dovecot, delay=0.03, delays=0.01/0/0/0.02, dsn=4.3.0, status=deferred (Command died with signal 6: "/usr/local/libexec/dovecot/deliver") I look at http://www.mail-archive.com/dovecot@dovecot.org/msg35048.html and it looks like the issue I'm having, if so what file to I apply the path to? Dovecot -n # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 auth_debug = yes auth_mechanisms = plain login auth_verbose = yes base_dir = /usr/local/var/run/dovecot/ dict { quotadict = mysql:/usr/local/etc/dovecot/dovecot-dict-quota-sql.conf } disable_plaintext_auth = no first_valid_uid = 101 last_valid_uid = 101 login_greeting = Mail Server Ready. mail_location = maildir:/var/vmail/%d/%u passdb { args = /usr/local/etc/dovecot/sql.conf.ext driver = sql } plugin { acl = vfile:/usr/local/etc/dovecot/acls driver = sql quota = dict:::proxy::quotadict quota_exceeded_message = Quota exceed, please email support for further assistance. quota_rule = *:storage=0:messages=5 trash = /usr/local/etc/dovecot/trash.conf.ext } protocols = imap pop3 service auth { unix_listener /var/spool/postfix/private/auth { group = vmail mode = 0660 user = postfix } unix_listener auth-master { group = vmail mode = 0660 user = vmail } unix_listener auth-userdb { group = vmail mode = 0660 user = vmail } } service dict { unix_listener dict { group = vmail mode = 0660 user = vmail } } ssl = no userdb { args = /usr/local/etc/dovecot/sql.conf.ext driver = sql } userdb { driver = prefetch } protocol imap { mail_plugins = quota imap_quota trash } protocol pop3 { mail_plugins = quota trash pop3_client_workarounds = outlook-no-nuls oe-ns-eoh } protocol lda { mail_plugins = quota trash postmaster_address = xx(a)xx.com }

2 4

[Dovecot] stat(/..../Maildir/cur) failed: No such file or directory
by Lystopad Olexandr 19 Dec '10

19 Dec '10

Hi! I use dovecot 1 without any problems for years. Thanks for it! Now I try to migrate to dovecot2. I have small problem. # dovecot --version 2.0.7 # dovecot -n # 2.0.7: /usr/local/etc/dovecot/dovecot.conf # OS: FreeBSD 8.1-RELEASE i386 auth_verbose = yes disable_plaintext_auth = no first_valid_gid = 26 first_valid_uid = 26 lda_mailbox_autocreate = yes login_greeting = imap/pop mailserver ready mail_debug = yes mail_location = maildir:~/Maildir mail_max_userip_connections = 50 mail_privileged_group = mail passdb { args = /usr/local/etc/dovecot/dovecot-sql.conf driver = sql } protocols = pop3 imap service auth { unix_listener auth-userdb { group = mailnull mode = 0600 user = mailnull } user = root } service imap-login { inet_listener imap { address = * port = 143 } inet_listener imaps { address = * port = 993 } } service imap { process_limit = 512 } service pop3-login { inet_listener pop3 { address = * port = 110 } inet_listener pop3s { address = * port = 995 } } service pop3 { process_limit = 512 } ssl_cert = </usr/local/etc/exim/mail.crt ssl_key = </usr/local/etc/exim/mail.key userdb { args = /usr/local/etc/dovecot/dovecot-sql.conf driver = sql } verbose_proctitle = yes verbose_ssl = yes protocol pop3 { pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_uidl_format = %08Xu%08Xv } protocol imap { imap_client_workarounds = delay-newmail tb-extra-mailbox-sep } # dovecot-sql.conf: driver = mysql connect = host=localhost user=exim_user password=xxx dbname=exim default_pass_scheme = MD5-CRYPT password_query = SELECT login as user, crypt as password FROM accounts WHERE login = '%u' user_query = SELECT homedir as home, uid, gid, maildir as mail FROM accounts WHERE login = '%u'; exim router: mysql_account: driver = accept condition = ${lookup mysql{MYSQL_Q_MAILDIR}{$value}fail} transport = dovecot_delivery cannot_route_message = Unknown account $local_part@$domain exim transport: dovecot_delivery: driver = pipe command = /usr/local/libexec/dovecot/dovecot-lda -e -k -d $local_part@$domain \ -f $sender_address -a $original_local_part@$original_domain -m INBOX #use_shell user = mailnull message_prefix = "" message_suffix = "" return_path_add = true envelope_to_add = true delivery_date_add = true temp_errors = 64 : 69 : 70: 71 : 72 : 73 : 74 : 75 : 78 log_output And my problem: Dec 19 08:50:05 server dovecot: auth: Error: mysql: Query failed, retrying: MySQL server has gone away Dec 19 08:50:05 server dovecot: auth: mysql: Connected to localhost (exim) Dec 19 08:50:05 server dovecot: lda: Debug: auth input: 3mail(a)somedomain.priv home=/d/mail/somedomain.priv/3mail uid=26 gid=26 mail=/d/mail/somedomain.priv/3mail/Maildir Dec 19 08:50:05 server dovecot: lda: Debug: Added userdb setting: mail=/d/mail/somedomain.priv/3mail/Maildir Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Debug: Effective uid=26, gid=26, home=/d/mail/somedomain.priv/3mail Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Debug: maildir autodetect: stat(/d/mail/somedomain.priv/3mail/Maildir/cur) failed: No such file or directory Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Debug: mbox autodetect: INBOX file: is a directory (/d/mail/somedomain.priv/3mail/Maildir) Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Debug: mbox autodetect: has .imap/: stat(/d/mail/somedomain.priv/3mail/Maildir/.imap) failed: No such file or directory Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Debug: mbox autodetect: has inbox: stat(/d/mail/somedomain.priv/3mail/Maildir/inbox) failed: No such file or directory Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Debug: mbox autodetect: has mbox: stat(/d/mail/somedomain.priv/3mail/Maildir/mbox) failed: No such file or directory Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Error: user 3mail(a)somedomain.priv: Initialization failed: Initializing mail storage from mail_location setting failed: Ambiguous mail location setting, don't know what to do with it: /d/mail/somedomain.priv/3mail/Maildir (try prefixing it with mbox: or maildir:) Dec 19 08:50:05 server dovecot: lda(3mail(a)somedomain.priv): Fatal: Invalid user settings. Refer to server log for more information. If I manually mkdir /d/mail/somedomain.priv/3mail/Maildir/cur and chown it to 26:26 mail succesfully delieveried. Why lda_mailbox_autocreate=yes does not create this dir? Thanks. -- Lystopad Olexandr

2 2

[Dovecot] Sieve create non-existent folder
by Jeff Mitchell 19 Dec '10

19 Dec '10

Hello, Is there a way to have a Sieve script create a non-existent folder rather than have it deliver messages to INBOX instead? I'm using Dovecot 2.0.8 with Postfix, via LMTP. Thanks!

3 4

[Dovecot] Best way to move mail to an archive
by Richard C. Cox 19 Dec '10

19 Dec '10

Hello all...new to dovecot and this list. I have a question that may have been answered before, but I can't find anything yet that addresses it directly. I installed dovecot 2.0.8 (+postfix, fetchmail) on a small server to manage several e-mail accounts. I love this software! So, to back to the question: I'd like to archive e-mail as it ages into a single IMAP archive directory. Ideally, I would like to set up a cron job to search for e-mail in all of my imap directories that older that 'X' days and move it to the archive directory. I know that dovecot wants to manage e-mail movement thru the IMAP interface, so I'm leery of just using ordinary Linux commands to move mail around and bypass the IMAP protocol. Does anybody have any recommendations about dovecot/IMAP safe commands I could use to accomplish this task? Thanks in advance and I apologize for not being more knowledgeable about this subject. Regards, Richard

2 2

[Dovecot] Authentication issue.
by dmitri tchernov 18 Dec '10

18 Dec '10

Hi list, I try to run imaptest, but I get the following errors (as root): # ./imaptest copybox=Trash # or any other command in http://www.imapwiki.org/ImapTest/Examples Logi List Stat Sele Fetc Fet2 Copy Stor Dele Expu Appe Logo 100% 50% 50% 100% 100% 100% 33% 50% 100% 100% 100% 100% 30% 5% 5% 0 0 0 0 0 0 0 0 0 0 0 0 10/ 10 0 0 0 0 0 0 0 0 0 0 0 0 10/ 10 0 0 0 0 0 0 0 0 0 0 0 0 10/ 10 0 0 0 0 0 0 0 0 0 0 0 0 10/ 10 Error: root[4]: LOGIN failed: 4.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[3]: LOGIN failed: 3.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[5]: LOGIN failed: 5.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[2]: LOGIN failed: 2.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[6]: LOGIN failed: 6.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[10]: LOGIN failed: 10.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[7]: LOGIN failed: 7.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[1]: LOGIN failed: 1.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[8]: LOGIN failed: 8.1 NO [AUTHENTICATIONFAILED] Authentication failed. Error: root[9]: LOGIN failed: 9.1 NO [AUTHENTICATIONFAILED] Authentication failed. ^C # tail /var/log/mail.log: Dec 17 18:07:28 dovecot: imap-login: Disconnected (auth failed, 1 attempts): user=<root>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=0, secured Dec 17 18:08:01 dovecot: last message repeated 19 times # tail /var/log/auth.log: Dec 17 18:07:24 auth: pam_unix(dovecot:auth): authentication failure; logname= uid=0 euid=0 tty=dovecot ruser=root rhost=127.0.0.1 user=root Dec 17 18:08:01 auth: last message repeated 19 times Dec 17 18:08:01 CRON[13916]: pam_unix(cron:session): session opened for user root by (uid=0) Dec 17 18:08:02 CRON[13916]: pam_unix(cron:session): session closed for user root # dovecot --version 2.0.2 # /usr/bin/doveconf -n -c /etc/dovecot/dovecot.conf # 2.0.2: /etc/dovecot/dovecot.conf # OS: Linux 2.6.34.6-ipv6-64 x86_64 Ubuntu 10.10 ext4 auth_mechanisms = plain login digest-md5 cram-md5 disable_plaintext_auth = no log_timestamp = "%Y-%m-%d %H:%M:%S " mail_debug = yes mail_location = dbox:/mnt/dovecot/users/%n mail_privileged_group = mail mbox_read_locks = fcntl dotlock mbox_write_locks = fcntl dotlock mmap_disable = yes passdb { args = /mnt/dovecot/userlist.passwd driver = passwd-file } passdb { driver = pam } protocols = imap pop3 service auth { unix_listener auth-master { mode = 0600 user = doveusers } user = root } ssl = no userdb { args = /mnt/dovecot/userlist.passwd driver = passwd-file } protocol pop3 { pop3_uidl_format = %08Xu%08Xv } protocol lda { auth_socket_path = /var/run/dovecot/auth-master postmaster_address = my-email(a)gmail.com } I do not understand where the problem is. Do you have any idea? /dimitri

2 12

[Dovecot] Problem with expunge
by Jeff Mitchell 18 Dec '10

18 Dec '10

I'm running Dovecot 2.0.8. The other day I tested doveadm expunge on a test Inbox with a few messages received over the course of a day, and using savedbefore <a few hours>, and it seemed to work. However, today I was testing converting some maildirs over to sdbox, and noticed odd behavior: it's deleting all messages in the specified folder instead of just the ones matching the condition I'm using ("savedbefore 4w"). The command I'm using is "doveadm -Dv expunge -A mailbox Trash savedbefore 4w" Because of the conversion, all of the ctimes for all of the files are actually the same (basically, a few minutes ago), due to the converstion to sdbox from maildir, so I would expect that either it doesn't delete any of them or looks inside at some header of the mail (half of which was received/placed into Trash before 4w ago and half of which wasn't). I definitely don't expect full-on deletion... Any idea what's going on? Thanks, Jeff

2 2

[Dovecot] undefined reference to fallocate64
by Mike Korizek 18 Dec '10

18 Dec '10

Hi While compiling dovecot 2.0.8 on Ubuntu 9.10 I get the following error at make: ../../src/lib-dovecot/.libs/libdovecot.so: undefined reference to `fallocate64' Any idea how to resolve this? Thanks, Mike

2 1

Re: [Dovecot] Namespace subscription issue
by Eric N. Jones 18 Dec '10

18 Dec '10

The same issue appears to exist with the shipping version of Dovecot on Mac OS X Server 10.6+. I have shared namespaces that cause this same issue (and your subsequent issues with roundcube). -- Eric N. Jones Sr. Engineer TransWare Enterprises Inc.

1 0

[Dovecot] Expire plugin does not work
by Christoph Pleger 17 Dec '10

17 Dec '10

Hello, I followed the instructions on http://wiki2.dovecot.org/Plugins/Expire to configure the expire plugin, but when I move a message to the Trash folder, I get the following error messages in my logfile: dovecot: dict: Error: sqlite: exec(INSERT INTO expires (expire_stamp,username,mailbox) VALUES ('1292525469','christoph','Trash')) failed: unable to open database file (14) dovecot: dict: Error: sql dict: commit failed: I have attached a "dovecot -n"-generated dovecot.conf, the configuration file for the expire dict service, and my sqlite3 database file. In my filesystem, dovecot-dict.sqlite currently has permissions 666. Regards Christoph

2 3

[Dovecot] dovecot 2.0.8 LDA with MYSQL issues
by PA 17 Dec '10

17 Dec '10

Hi, after deciding to use Dovecot 2.0.8 as a postfix LDA using mysql DB I'm running into some issues. I started to follow, http://wiki.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL but noticed that the auth settings on the config changed, after looking through the dovecot wiki I think I have that issue fixed. However I still can't get the SQL part to work right, below is what I have on the conf.d/sql.conf and the error I get. service dovecot status doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/conf.d/sql.conf line 1: Unknown setting: password_query Where do I put the sql connect string, in the URL above that along with the driver type went on the sql.conf file but that is no longer the case. If anyone has a better reference/suggestions for what im trying to do I would appreciated it. Thanks, Paul [root@testip5 conf.d]# cat sql.conf password_query = SELECT userid as user, password FROM users WHERE userid = '%u' user_query = SELECT uid, gid, '/var/vmail/%d/%n' as home FROM users WHERE userid = '%u' [root@testip5 conf.d]# dovecot -n # 2.0.8: /usr/local/etc/dovecot/dovecot.conf # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 auth_mechanisms = plain login cram-md5 first_valid_uid = 101 last_valid_uid = 101 login_greeting = MegaNet Mail Server Ready. mail_gid = vmail mail_location = maildir:/var/vmail/%d/%u mail_uid = vmail passdb { args = /usr/local/etc/dovecot/conf.d/sql.conf driver = sql } plugin { acl = vfile:/usr/local/etc/dovecot/acls quota = maildir:storage=10240:messages=1000 trash = /usr/local/etc/dovecot/conf.d/trash.conf } protocols = imap pop3 userdb { driver = prefetch } userdb { args = /usr/local/etc/dovecot/conf.d/sql.conf driver = sql } doveconf: Error: ssl enabled, but ssl_cert not set doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf: ssl enabled, but ssl_cert not set

2 6