April 2019 - dovecot - dovecot.org

sql table definitions
by Richard Hector 02 Apr '19

02 Apr '19

Hi all, Trivial question ... I'm using PostgreSQL for my auth db. I used the example CREATE TABLE statement in the config file, but now I find the fields are too short. I assume dovecot will be fine with 'text' type columns replacing the varchars? Or failing that, I can change the length of the varchar fields? Cheers, Richard

2 1

Issue with dovecot/director
by Nico Stöckigt 01 Apr '19

01 Apr '19

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi, are there any known issues with dovecot/director (2.2.13) when receiving e-an mail with multiple receivers? In the given scenario the e-mail contains 3 recipients and is redirected by the director to 3 different mail servers (ox/dovecot @ UCS/univention). In this process the first 2 e-mails are just fine but the third e-mail is truncated somewhere in or after the header. Kind Regards Nico Stöckigt - -- Nico Stöckigt <stoeckigt(a)univention.de> Support Univention -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEoGjDpba412f0rm1CjVdPG/rdoykFAlyiPGoACgkQjVdPG/rd oyl+IRAAp11JHenIkDeonGV+tbj3nFF4RigPp85TiJmD2l/kddP5mMR/Bw+vMAc6 taHjfS4Myf6v+jCrn+FS+C2isZaassnqZF1JcyllT5RSvxzrSKl6ojf9vVl3jyfu gZ7RlVOqBqskSHkVsT4fmzFuGMRaTQBN7CtgQH3MXPcN477060WDiZ11x+w+2+be eI0hQID3X3CBRmhaYyXMsgwUCHF36dVYlzEnUy6yge2FuwgwonZASC9xueVQGN5b KYf66LmubJTERGo3XK7454s3jM6oEiz731Os7g/zHyd8X6fgpCaR1nre8x0xfe1I bz86GJzm3b+1Fme8++yxlGhTEERtNkw0znQG7LOw8fqY5ctD12kdxBgXQOgcLkjh 98zJD44wC8y9lRKfZ3Lydfq768U3D47AjmPY0u9Zp1YKdNS8PEsNk0iHaRn5ZpT0 0V+wfTTkh3jFFuaqqd0hgamwRuwkNfFNyGvNAd5x4nMUIGUZ1pI3ikGP8oGaLDMs iSo1YxXkUojZ9A2xMQ8bDbWLjpyj/YYw+Cs6t1QcP0h2HDATc7QrHMO02ajKXDW+ ZxsI4VvEplv4GhbMuhavRYhZk01fI1hdeV1+PvkcAsqxaljoJDSyqZP78A81f7F4 DWComweyk/k+BzLjiQPKhv7AjaXnjDVeJfVxLl8VYoW4jD/4aFc= =MGL8 -----END PGP SIGNATURE-----

2 3

mail_crypt not working on incoming messages?
by Dave 01 Apr '19

01 Apr '19

[Dovecot v2.2.33.2] I'm testing out mail_crypt on a fresh Dovecot install to get a feel for how it works, but I'm running into something unexpected. The mail_crypt plugin does seem to be working, but NOT on incoming email. What I mean is, if I send a test email to the server that has Dovecot installed, the message correctly arrives in the user's Maildir folder (I'm using Maildir format, not mbox), as I can see the mail message file appear. However, the message file is in plaintext and is not encrypted. But, if, using my Thunderbird email client connected to that account via IMAP, I move that message out of the inbox of that account to a folder on another account, and then move it back in to the original inbox, the file that appears in the Maildir folder structure IS encrypted. I have confirmed that mail_crypt is active in 10-mail.conf, 20-imap.conf, and 20-pop3.conf. The global public and private keys are working because (a) there are no errors and (b) it DOES encrypt -- just not on incoming email. mail_crypt_save_version is set 2, as per the docs for Dovecot 2 instruct. What am I missing? Does anyone have any thoughts as to why JUST incoming messages aren't encrypted, but that messages moved into the IMAP account DO get encrypted? Did I set up something incorrectly? I'm using sendmail as the MTA, if that matters, and messages are routed to the user's Maildir folder structure using a .procmailrc in that user's home folder. -Dave

2 3

dovecot ssl error message from my own connections
by Esteban L 01 Apr '19

01 Apr '19

Hello all, Just a minor thing. Not a big deal, because everything works fine, and I feel secure with my setup. But, I get this error message pretty much throughout the day/night, which appears to come from my own mail clients (desktop or mobile). I would like to resolve it, because it must me something (that is not good--that I may not understand), that may have other ramifications. So, here it is. date time myserver dovecot: imap-login: Debug: SSL error: SSL_read() syscall failed: Connection reset by peer Anyone have a suggestion of what this might hint to, other than obvious SSL. I tried parsing through various logs, but the most I find is just this single line. I can produce it, whenever I close my email client. Thanks in advance.

4 5

Possible bug with last_login plugin and PostgreSQL
by Zhang Huangbin 01 Apr '19

01 Apr '19

Dear all, I'm trying to get last_login plugin working with PostgreSQL, but seems Dovecot doesn't handle duplicate key while updating last login time (note: same setting works fine with MariaDB). I wonder whether it's a bug of Dovecot or i should handle this with PostgreSQL trigger. OS: OpenBSD 6.4 (amd64) Dovecot: 2.2.36 PostgreSQL: 10.5 Error log: ################### Mar 31 11:15:21 ob dovecot: imap-login: Login: user=<postmaster(a)a.io>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=5936, TLS, session=<63/jV2CFhzt/AAAB> Mar 31 11:15:21 ob dovecot: imap(postmaster(a)a.io): Logged out in=300 out=1604 Mar 31 11:15:21 ob dovecot: imap-login: Login: user=<postmaster(a)a.io>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=29797, TLS, session=<lLboV2CFuZ9/AAAB> Mar 31 11:15:21 ob dovecot: dict(9584): Error: sql dict: commit failed: ERROR: duplicate key value violates unique constraint "last_login_pkey" Mar 31 11:15:21 ob dovecot: dict: Error: DETAIL: Key (username)=(postmaster(a)a.io) already exists. Mar 31 11:15:21 ob dovecot: imap(postmaster(a)a.io): Error: dict-client: server returned failure: 1554023721 (reply took 0.012 secs) Mar 31 11:15:21 ob dovecot: imap(postmaster(a)a.io): Error: last_login_dict: Failed to write value for user postmaster(a)a.io Mar 31 11:15:21 ob dovecot: imap(postmaster(a)a.io): Logged out in=70 out=732 ################## My Dovecot config: ################### protocol imap { mail_plugins = ... last_login ... } protocol pop3 { mail_plugins = ... last_login ... } plugin { last_login_dict = proxy::lastlogin #last_login_key = last-login/%u ... } dict { lastlogin = pgsql:/etc/dovecot/dovecot-last-login.conf ... } ################### SQL commands used to create PostgreSQL table: ########### CREATE TABLE last_login ( username VARCHAR(255) NOT NULL, last_login INT DEFAULT NULL, PRIMARY KEY (username) ); ########### File /etc/dovecot/dovecot-last-login.conf: ########### connect = host=127.0.0.1 port=5432 dbname=vmail user=vmailadmin password=<password> map { pattern = shared/last-login/$user table = last_login value_field = last_login value_type = uint fields { username = $user } } ##############

1 1

I have a question.
by 김태용 01 Apr '19

01 Apr '19

Hi. I have a question. Can I limit the maximum number of messages I can sync per mailbox? Even if there are 10000 messages, I want to sync with the specified number of times. Ex)max sync mail count = 5000 (or 1000 or 2000..Outlook view message 5000) Thank you.

2 2

CentOS Repository broken ?
by Günther J. Niederwimmer 01 Apr '19

01 Apr '19

Hello, I have a CentOS 7 server with dovecot Repository enabled. But it is not possible to Update with Yum Update I have this Error? The dovecot package is missing? --> Transaktionsprüfung wird ausgeführt ---> Paket dovecot-imaptest.x86_64 2:2.3.5-1 markiert, um aktualisiert zu werden ---> Paket dovecot-imaptest.x86_64 2:2.3.5.1-1 markiert, um eine Aktualisierung zu werden --> Abhängigkeit dovecot = 2:2.3.5.1-1 wird für Paket 2:dovecot- imaptest-2.3.5.1-1.x86_64 verarbeitet ---> Paket dovecot-lua.x86_64 2:2.3.5-1 markiert, um aktualisiert zu werden ---> Paket dovecot-lua.x86_64 2:2.3.5.1-1 markiert, um eine Aktualisierung zu werden --> Abhängigkeit dovecot = 2:2.3.5.1-1 wird für Paket 2:dovecot- lua-2.3.5.1-1.x86_64 verarbeitet --> Abhängigkeitsauflösung beendet Fehler: Paket: 2:dovecot-imaptest-2.3.5.1-1.x86_64 (dovecot-2.3-latest) Benötigt: dovecot = 2:2.3.5.1-1 Installiert: 2:dovecot-2.3.5-1.x86_64 (installed) dovecot = 2:2.3.5-1 Verfügbar: 1:dovecot-2.2.36-3.el7.i686 (base) dovecot = 1:2.2.36-3.el7 Fehler: Paket: 2:dovecot-lua-2.3.5.1-1.x86_64 (dovecot-2.3-latest) Benötigt: dovecot = 2:2.3.5.1-1 Installiert: 2:dovecot-2.3.5-1.x86_64 (installed) dovecot = 2:2.3.5-1 Verfügbar: 1:dovecot-2.2.36-3.el7.i686 (base) dovecot = 1:2.2.36-3.el7 Thanks for repair. -- mit freundliche Grüßen / best regards, Günther J. Niederwimmer

5 12