- dovecot - dovecot.org

Trigger for using an sqlite dictionary for quota
by David Anderson 09 Jul '14

09 Jul '14

Hi, I'm using Dovecot 2.0.9, and was trying to set up a dictionary process to use an sqlite database for quota management. The wiki page has examples for MySQL and PostgreSQL: http://wiki2.dovecot.org/Quota/Dict For sqlite, a trigger needs to be created to get it to work. But I was not sufficiently skilled in sqlite to adapt the PostgreSQL trigger (given on the above URL) for use. Nor did Googling find any example of anyone else who had done it. Does anyone here have an example, or the ability? (Through Googling I found an example trigger for using sqlite with expiries - but I was looking at quotas). Best wishes, David -- UpdraftPlus - best WordPress backups - http://updraftplus.com WordShell - WordPress fast from the CLI - http://wordshell.net

2 1

HIGHESTMODSEQ tracking
by Kostya Vasilyev 09 Jul '14

09 Jul '14

Hello, I'd like to follow up on someone else's old thread: http://dovecot.org/list/dovecot/2012-April/082624.html I understand that Dovecot (that 2012 discussion was about version 2.0.18) can return "HIGHESTMODSEQ 1" upon SELECT if persistent modseq tracking was never enabled for a mailbox. I'd like to get a clarification on how to enable proper persistent modseq tracking. Per RFC 4551, "A client supporting CONDSTORE.... indicates its willingness to receive mod-sequence updates... by issuing:" SELECT mailbox (CONDSTORE) STATUS (... HIGHESTMODSEQ ...) ... others ... It seems that Dovecot 2.1.7 (Debian 7.5) enables persistent modseq tracking after one of the above two commands (and maybe others). So far so good. So my questions are: 1 - Is this (enabling persistent modseq) also the case for all Dovecot versions prior to 2.1.7 that advertise CONDSTORE? There must be people running older versions out there, older than 2.1.7. If not, how can I branch my logic to not use HIGHESTMODSEQ, given that Dovecot doesn't appear to return any version info via its greeting or via the ID command? 2 - Is persistent modseq tracking (assuming it's been enabled) available for all types of backend mailbox formats that Dovecot might be using? To be more specific, can it ever be the case that Dovecot appears to enable modseq tracking, returning nice looking HIGHESTMODSEQ values from SELECT / STATUS, but the actual values get reset or not get updated because they're not properly persistent? I'm excluding changes to UIDVALIDITY here, obviously when that changes, the entire mailbox state must be assumed to have changed completely. 3 - I guess the change to return NOMOSEQ instead of "1" for mailboxes with modseq tracking disabled, as mentioned in that discussion from 2012, never happened? At least on the 2.1 branch? Thanks, -- K

2 1

Multiple email clients not in sync
by Marc Perkel 09 Jul '14

09 Jul '14

Hello everyone, I'm not sure if this is an issue with dovecot or my various email clients, or my settings. I'm running 2.2.13 and I have Thunderbird on my desktop and K@mail on my android phone. In theory if I delete email on one it should delete it on the other. It does delete it on the server - but the other client isn't always "aware" of it. Same thing sometimes with read messages. I read on one device but the other didn't know it's read unless I shut down and restart the app. Not knowing the details of how this all works I'm assuming there is some form of notification that goes on in the background so as to let other clients know what other clients do so they can sync up. And that where my setup isn't working consistently. Maybe my expectations are just too high? Maybe I don't have things set up correctly? What am I missing? Thanks in advance.

2 4

Problem with virtual mailbox when using K9 mail (android)
by Henrik Kjölhede 08 Jul '14

08 Jul '14

Hi! I've managed to setup a virtual mailbox that shows all unread or flagged mail from a selection of IMAP folders. This works great with Roundcube, which I use as webmail client. However, using K9 mail on my android phone, a mail that is opened seems to be immediately marked as read, and any flagging I do doesn't take. Presumably this is because it can't be reached any longer in the virtual folder. I tried adding the recent flag to the virtual search line, but that doesn't make any difference. I haven't been able to locate any information about anyone else experiencing this problem, so I was hoping that someone here could help. I realise that this is not exactly a "dovecot problem", but perhaps someone here has found a solution that they are willing to share. The search line in dovecot-virtual is currently "OR RECENT (OR UNSEEN FLAGGED). Regards

1 0

Limit confusion
by Micah Anderson 08 Jul '14

08 Jul '14

Hi, On one of my dovecot servers, i've got a limit problem... and I'm a little confused about which knobs I should adjust to solve it. I've been getting both of these: Error: net_connect_unix(imap) failed: Resource temporarily unavailable - http://wiki2.dovecot.org/SocketUnavailableess This one caused me to go read that wiki page, but none of those seem to apply to me: . i'm running 2.2.9 . i dont have service imap { client_limit }, although I do have service auth ( client_limit = 1024 } . my dovecot/auth process shows: dovecot/auth [91 wait, 0 passdb, 0 userdb] . it doesn't appear the master process is using very much cpu (in fact the system is mostly low load in general) . I have service_count = 0 set for imap-login for the 'high performance mode' dovecot: master: Warning: service(imap): process_limit (2560) reached, client connections are being dropped The second is because I have process_limit of 2560 for the imap service... I can raise that to 4096, but I suspect there are other limits I need to juggle? Thanks a lot for any suggestions! I have ulimit -n 2048 set for the dovecot processes (in /etc/default/dovecot) and the following is my dovecot -n: # 2.2.9: /etc/dovecot/dovecot.conf auth_verbose = yes default_process_limit = 256 default_vsz_limit = 512 M dict { expire = mysql:/etc/dovecot/dovecot-dict-sql.conf quota = mysql:/etc/dovecot/dovecot-dict-sql.conf } disable_plaintext_auth = no first_valid_gid = 8 first_valid_uid = 8 last_valid_gid = 8 last_valid_uid = 8 listen = * login_greeting = howdy, ready. mail_location = mdbox:~/mdbox:INDEX=/srv/dovecot_indexes/%d/%1n/%n mail_plugins = expire quota zlib maildir_very_dirty_syncs = yes namespace { inbox = yes location = prefix = separator = . } namespace { alias_for = hidden = yes inbox = no list = no location = prefix = INBOX. separator = . } passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } plugin { antispam_allow_append_to_spam = yes antispam_backend = pipe antispam_debug_target = syslog antispam_pipe_program = /usr/local/bin/train_spam antispam_pipe_program_args = -d;10.0.1.109 antispam_pipe_program_notspam_arg = ham antispam_pipe_program_spam_arg = spam antispam_pipe_tmpdir = /var/tmp antispam_signature = X-Spam-Flag antispam_signature_missing = error antispam_spam_pattern_ignorecase = SPAM antispam_trash_pattern = trash;Trash;Deleted * expire = Trash expire2 = Trash/* expire3 = Spam expire_dict = proxy::expire quota = dict:Your mail quota::proxy::quota quota_rule = *:bytes=100663296 quota_rule2 = Trash:bytes=+20%% quota_rule3 = Spam:bytes=+10%% quota_rule4 = INBOX.Trash:bytes=+20%% quota_rule5 = INBOX.Spam:bytes=+10%% sieve = ~/.dovecot.sieve sieve_after = /var/lib/dovecot/sieve/after.sieve sieve_before = /var/lib/dovecot/sieve/default.sieve sieve_dir = ~/sieve zlib_save = gz zlib_save_level = 6 } protocols = " imap pop3" service anvil { unix_listener anvil { group = dovecot mode = 0660 user = root } } service auth { client_limit = 1024 unix_listener auth-userdb { group = mail mode = 0600 user = mail } } service dict { unix_listener dict { group = mail mode = 0600 user = mail } } service imap-login { process_min_avail = 10 service_count = 0 vsz_limit = 512 M } service imap-postlogin { executable = script-login /usr/local/sbin/postlogin_imap } service imap { executable = imap imap-postlogin process_limit = 4096 } service pop3-login { process_min_avail = 10 service_count = 0 vsz_limit = 512 M } service pop3-postlogin { executable = script-login /usr/local/sbin/postlogin_pop } service pop3 { executable = pop3 pop3-postlogin } service stats { fifo_listener stats-mail { mode = 0600 user = mail } } ssl_cert = </etc/certs/wildcard/cert.pem ssl_cipher_list = HIGH:-ADH:-aNULL ssl_key = </etc/certs/wildcard/key.pem userdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } verbose_proctitle = yes protocol lda { mail_plugins = expire quota zlib sieve plugin { quota_exceeded_message = Sorry, your message cannot be delivered to that person because their mailbox is full. If you can contact them another way, you may wish to tell them of this problem. quota_rule7 = INBOX:bytes=+10%% } } protocol imap { imap_client_workarounds = delay-newmail tb-extra-mailbox-sep mail_max_userip_connections = 10 mail_plugins = expire quota zlib imap_quota imap_zlib antispam plugin { quota_exceeded_message = You are over quota. To avoid losing mail, immediately empty your Trash and Sent folders and delete emails with large attachments. } } protocol pop3 { mail_plugins = expire quota zlib pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_uidl_format = %g }

1 0

Dovecot ignores existing mailboxes and creates its own
by Martin Vegter 08 Jul '14

08 Jul '14

Hello, I have Postfix with Maildir format. User's emails are being delivered into $HOME/mail/inbox Apart from ~/mail/inbox, there are the usual folders: $HOME/mail/archive $HOME/mail/drafts $HOME/mail/inbox $HOME/mail/trash Now I have installed dovecot, and set mail_location = maildir:~/mail:LAYOUT=fs additionally, I have defined mailboxes as follows: namespace inbox { mailbox drafts { special_use = \Drafts } mailbox sent { special_use = \Sent } mailbox trash { special_use = \Trash } } The problem I am having is following: 1) dovecot ignores the folders (drafts, sent, trash) and creates its own folders begining with capiotal letter: Drafts Sent Trash 2) dovecot ignores ~/mail/inbox and instead creates ~/mail/cur ~/mail/new ~/mail/tmp can somebody please advise how to tell dovecot, to use my existing folder structure, ie: ~/mail/inbox/{cur,new,tmp} ~/mail/drafts/{cur,new,tmp} ~/mail/sent/{cur,new,tmp} ~/mail/trash/{cur,new,tmp} any advice would be much appreciated thanks, Martin

1 0

Dovecot not changing SSL key and certificate as in config file
by Mitchell McMillan 08 Jul '14

08 Jul '14

I am trying to use my (decrypted) SSL key and certificate in Dovecot. I have changed /etc/dovecot/conf.d/10-ssl.conf like so: ssl_cert = </etc/ssl/private/ssl-chain-mail-mydomain.com.pem ssl_key = </etc/ssl/private/ssl-key-decrypted-mail-mydomain.com.key However, after running service dovecot restart, dovecot -n still says that the files /etc/dovecot/dovecot.pem and /etc/dovecot/private/dovecot.pem are being used. I am using dovecot 2.2.9, any help would be greatly appreciated.

3 2

Dovecot Auth Tries Spam
by Silvio Siefke 08 Jul '14

08 Jul '14

Hello, i more and more become this messages in logs: Jul 6 20:43:56 ks3374456 dovecot: auth: Error: passwd-file(jean(a)proxy.silviosiefke.com,213.130.118.102): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory Jul 6 21:35:32 ks3374456 dovecot: auth: Error: passwd-file(jennifer(a)proxy.silviosiefke.com,41.160.109.28): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory Jul 6 21:35:38 ks3374456 dovecot: auth: Error: passwd-file(jennifer(a)proxy.silviosiefke.com,41.160.109.28): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory Jul 6 21:35:44 ks3374456 dovecot: auth: Error: passwd-file(jennifer(a)proxy.silviosiefke.com,41.160.109.28): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory Jul 6 22:27:13 ks3374456 dovecot: auth: Error: passwd-file(jack(a)proxy.silviosiefke.com,203.113.206.105): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory Jul 6 22:27:20 ks3374456 dovecot: auth: Error: passwd-file(jack(a)proxy.silviosiefke.com,203.113.206.105): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory Jul 6 22:27:26 ks3374456 dovecot: auth: Error: passwd-file(jack(a)proxy.silviosiefke.com,203.113.206.105): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory Jul 6 22:36:49 ks3374456 dovecot: auth: Error: passwd-file(eric(a)proxy.silviosiefke.com,41.21.178.38): stat(/var/vmail/auth.d/proxy.silviosiefke.com/passwd) failed: No such file or directory I understand not, because i have set dovecot so it launched only on my vpn ips. Give there a way to underbind this tries? I have installed fail2ban. Maybe im stupid, because this help not or i has set wrong entrys. <dovecot> service imap-login { inet_listener imap { address = 10.8.0.1 port = 12520 } inet_listener imaps { address = 10.8.0.1 port = 12550 } } </dovecot> <fail2ban> [dovecot] enabled = true filter = dovecot action = iptables-multiport[name=dovecot, port="pop3,pop3s,imap,imaps,submission,465,sieve", protocol=tcp] logpath = /var/log/mail.log [dovecot-auth] enabled = true filter = dovecot action = iptables-multiport[name=dovecot-auth, port="12520,12550,submission,465,sieve", protocol=tcp] logpath = /var/log/mail.log </fail2ban> Thanks for help & Nice day Silvio

3 2

doveadm quota recalc -A
by ML mail 08 Jul '14

08 Jul '14

Hello, It looks like my iteration SQL query (iterate_query) does not work as when I try to run "doveadm quota recalc -A" I get the following error: $ sudo -u vmail doveadm quota recalc -A doveadm(nobody): Error: user nobody: Mail access for users with UID 65534 not permitted (see first_valid_uid in config file, uid from userdb lookup). doveadm(nobody): Error: User init failed My iterate_query is quite simple: iterate_query = SELECT username FROM mailbox So from the output I really don't understand why it looks up the user "nobody". I don't have any user "nobody" in my mailbox SQL table. Anyone has an idea? Regards ML

1 0

Redis sentinel support in dict
by Lazy 08 Jul '14

08 Jul '14

Redis sentinel ( http://redis.io/topics/sentinel ) is a service that monitors and manages redis master slave replication. Using sentinel you can easily create a redis ha cluster. You can connect to a sentiniel and subscribe to certain events then in case of an failover update the redis address to new master etc. I think this is better suited to be used with dict proxy. Do You think it can be implemented without changes to dovecot core ? -- Michal Grzedzicki

1 0