Any ideas on how to resolve the Userdb connect/lookup problem? My users are pinging me on Sieve support.

Thanks, David

On 2020-10-04 14:59, David Morsberger wrote:

I am stuck enabling LMTP so that I can use Sieve rules. I have a postfix -> dovecot setup on Ubuntu. I am using virtual users with a SQL backend for virtual_users, password maps, and maildir.

I have searched for a solution and implemented everything I have read.

I do not understand why lmtp is trying to go to /var/run/dovecot/auth-userdb (file does not exist). Everything works until I uncomment "virtual_transport = lmtp:unix:private/dovecot-lmtp” in postfix/main.cf

Anyone have a solution?

Here is the lmtp error with surrounding messages

Oct 4 00:37:29 mmp-mail dovecot: lmtp(info@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Debug: auth-master: userdb lookup(info@domain.com): Started userdb lookup Oct 4 00:37:29 mmp-mail dovecot: lmtp(info@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Debug: auth-master: conn unix:/var/run/dovecot//auth-userdb: Connecting Oct 4 00:37:29 mmp-mail dovecot: lmtp(info@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Error: auth-master: userdb lookup(info@domain.com): connect(/var/run/dovecot//auth-userdb) failed: No such file or directory Oct 4 00:37:29 mmp-mail dovecot: lmtp(info@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Debug: auth-master: userdb lookup(info@domain.com): Userdb lookup failed Oct 4 00:37:29 mmp-mail dovecot: lmtp(268290): Error: lmtp-server: conn unix:pid=268289,uid=129 [1]: rcpt info@domain.com: Failed to lookup user info@domain.com: Internal error occurred. Refer to server log for more information.

I do see "auth_socket_path = auth-userdb” in doveconf output

In 10-master.conf (-rw-r--r-- 1 root root 3784 Oct 4 00:26 10-master.conf)

service auth { unix_listener auth-userdb { path = /var/spool/postfix/private/auth mode = 0660 user = postfix group = postfix } }

In auth-sql-conf.ext (-rw-r--r-- 1 root root 785 Oct 3 22:39 auth-sql.conf.ext)

userdb { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext }

In dovecot-sql.conf.ext (-rw-r----- 1 root dovecot 6086 Oct 3 22:37 dovecot-sql.conf.ext)

user_query =
SELECT email as user, 150 AS uid, 150 AS gid 'maildir:/home/mail/'||maildir as mail
FROM virtual_mailbox_maps WHERE email = '%u'