<html>Hello Sami, yes, see below.<br /><br />We run Dovecot at a different versions, mainly 2.2.10 (CentOS), 2.2.22 (Ubuntu) and now 2.2.36 (CentOS). The issue is weird, because it only happened after the update from 2.2.10->36. Just to understand it would be great.<br /><br />I'm actually checking out the configs now ... Our SQL userdb does not specify port. So I'm guessing this may be to blame?<br /><br />(This was by design, though -- we don't want to specify one port for different client protocols. Though, I do recall seeing some hack online using CASE in SQL query ...)<br /><br />These servers run LMTP as a unix socket as well as a TCP port 24 serving all IP sources. The internal servers are running LMTP on TCP port 24 (as well as unix socket, but that's irrelevant), but no LMTP comm happens between directors and backend mail servers after the 2.2.10->36 update on the directors with our config. I do apologize that I can't get more specific than those versions ...<br /><br />The backend mail servers function the same in our environment on both versions 2.2.10 and 2.2.36.<br /><br />We are good now, as we changed the config to go to the TCP port instead of unix socket. But we had a good jolt of fun this morning. :-)<br /><br />Would love to understand what we have done wrong, or how we misunderstood the configuration directives -- in either version.<br /><br />Thank you Sami.<br /><br />Here is the SQL:<br /><br />driver = mysql<br />connect = host=10.1.1.110 dbname=someoneelsesmail user=notouruser password=chicken<br />default_pass_scheme = PLAIN<br />password_query = SELECT CONCAT(a.username,'@',d.domain) AS user,a.password,'captainmaster' AS master,'kentuckyfriedchicken' AS pass,'Y' AS proxy FROM accounts a INNER JOIN domains d ON a.domain_id=d.id WHERE a.username='%n' AND d.domain='%d' AND a.active=1 AND d.active=1<br /><br />Here is the doveconf:<br /><br /># 2.2.36 (1f10bfa63): /etc/dovecot/dovecot.conf<br /># Pigeonhole version 0.4.24 (124e06aa)<br />doveconf: Warning: service auth { client_limit=5200 } is lower than required under max. load (6144)<br /># OS: Linux 3.10.0-693.17.1.el7.centos.plus.x86_64 x86_64 CentOS Linux release 7.6.1810 (Core) <br /># Hostname: imapdir1.randomdomain.net<br />auth_master_user_separator = *<br />auth_mechanisms = plain login cram-md5<br />default_client_limit = 5200<br />default_process_limit = 1024<br />director_mail_servers = 10.9.5.131 10.9.5.132<br />director_servers = 10.9.5.151 10.9.5.152<br />disable_plaintext_auth = no<br />doveadm_port = 24245<br />first_valid_uid = 1000<br />lmtp_proxy = yes<br />managesieve_notify_capability = mailto<br />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 index ihave duplicate mime foreverypart extracttext<br />mbox_write_locks = fcntl<br />namespace inbox {<br /> inbox = yes<br /> location = <br /> mailbox Drafts {<br /> special_use = \Drafts<br /> }<br /> mailbox Junk {<br /> special_use = \Junk<br /> }<br /> mailbox Sent {<br /> special_use = \Sent<br /> }<br /> mailbox "Sent Messages" {<br /> special_use = \Sent<br /> }<br /> mailbox Trash {<br /> special_use = \Trash<br /> }<br /> prefix = <br />}<br />passdb {<br /> args = /etc/dovecot/dovecot-sql.conf.ext<br /> driver = sql<br />}<br />plugin {<br /> quota = maildir:User quota<br /> quota_grace = 10%%<br /> quota_status_nouser = DUNNO<br /> quota_status_overquota = 522 5.2.2 Mailbox is full<br /> quota_status_success = DUNNO<br /> quota_warning = storage=95%% quota-warning 95 %u<br /> quota_warning2 = storage=80%% quota-warning 80 %u<br /> sieve = file:~/sieve;active=~/.dovecot.sieve<br />}<br />protocols = imap pop3 lmtp sieve<br />service auth {<br /> unix_listener auth-client {<br /> mode = 0660<br /> user = exim<br /> }<br />}<br />service director {<br /> fifo_listener login/proxy-notify {<br /> mode = 0600<br /> user = $default_login_user<br /> }<br /> inet_listener {<br /> port = 9090<br /> }<br /> unix_listener director-userdb {<br /> mode = 0600<br /> }<br /> unix_listener login/director {<br /> mode = 0666<br /> }<br />}<br />service doveadm {<br /> inet_listener {<br /> port = 24245<br /> }<br />}<br />service imap-login {<br /> executable = imap-login director<br />}<br />service ipc {<br /> unix_listener ipc {<br /> user = dovecot<br /> }<br />}<br />service lmtp {<br /> inet_listener lmtp {<br /> port = 24<br /> }<br /> process_min_avail = 5<br />}<br />service managesieve-login {<br /> executable = managesieve-login director<br />}<br />service pop3-login {<br /> executable = pop3-login director<br />}<br />service quota-warning {<br /> executable = script /etc/dovecot/quota-warning.sh<br /> user = dovecot<br />}<br />ssl_cert = </etc/ssl/randomdomain.net/randomdomain.net-bundle.crt<br />ssl_key = # hidden, use -P to show it<br />protocol lmtp {<br /> auth_socket_path = director-userdb<br /> mail_plugins = " quota sieve"<br /> passdb {<br /> args = proxy=y port=24<br /> driver = static<br /> name = <br /> }<br /> postmaster_address = postmaster@randomdomain.net<br />}<br />protocol doveadm {<br /> auth_socket_path = director-userdb<br />}<br />protocol imap {<br /> mail_max_userip_connections = 50<br /> mail_plugins = " imap_quota"<br />}<br />protocol pop3 {<br /> mail_max_userip_connections = 50<br />}<br />local 10.9.0.0/18 {<br /> doveadm_password = # hidden, use -P to show it<br />}<br /><br /><br /><br /><br />On Sunday, December 30, 2018 03:08 PM PST, Sami Ketola <sami.ketola@dovecot.fi> wrote:<br /> <blockquote type="cite" cite="9D4D2A03-814E-48CE-85C4-D8D769B33838@dovecot.fi"> </blockquote><meta http-equiv="Content-Type" content="text/html; "><div><blockquote type="cite"><div>On 31 Dec 2018, at 0.43, Laz C. Peterson <<a href="mailto:laz@paravis.net">laz@paravis.net</a>> wrote:</div> <div><meta http-equiv="Content-Type" content="text/html; " class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Hello there,<div> </div><div>Everything was working fine on Dovecot 2.2.10 (on CentOS 7), but after updating to version 2.2.36, our director servers are not able to proxy LMTP.</div><div> </div><div>We are sending mail from exim to the local Dovecot LMTP socket, which then used to send it to our internal mail servers on port 24.</div><div> </div><div>Besides the update, nothing has changed in the config files. The configuration has been working great for months … Then we had a great idea of doing holiday maintenance.</div><div> </div><div>(Currently, we are working around this issue by having exim send mail to the IP and port, instead of the socket.)</div><div> </div><div>Doing a tcpdump capture shows no TCP traffic either. The logs seem to say that it is trying to go to port 0, so my guess is that it’s not getting the port directive from either static or sql — since the docs state that if these settings aren't specified, it will always use the same connection type for the proxy that it received the connection on.</div><div> </div><div>Any thoughts? I can share config if necessary.</div><div> </div><div><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;">~ Laz Peterson</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" /><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;">Paravis, LLC</span></div><div> </div></div></div></div></blockquote></div> <div> </div><div>can you please post doveconf -n and your sql userdb setup?</div><div> </div><div>Sami</div><br /> </html>