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(i...@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Debug:
auth-master: userdb lookup(i...@domain.com): Started userdb lookup
Oct 4 00:37:29 mmp-mail dovecot:
lmtp(i...@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Debug:
auth-master: conn unix:/var/run/dovecot//auth-userdb: Connecting
Oct 4 00:37:29 mmp-mail dovecot:
lmtp(i...@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Error:
auth-master: userdb lookup(i...@domain.com):
connect(/var/run/dovecot//auth-userdb) failed: No such file or
directory
Oct 4 00:37:29 mmp-mail dovecot:
lmtp(i...@domain.com)<268290><UpizKIlReV8CGAQA9daSvw>: Debug:
auth-master: userdb lookup(i...@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 i...@domain.com: Failed to
lookup user i...@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'
