sqlite + IMAP Authentication issues - user unknown

Scott Edwards supadupa at gmail.com
Tue May 25 00:09:31 EEST 2021

I'm not on the maillist, please reply all.

It's been a few years since I've setup a mail server (I feel like a
noob!). The following syslog message is isolating the auth issues. I
have sqlite, and want to keep it this way. I don't see more than a few
mailboxes to setup until sometime later, but if it does grow, I'll
stand up PostgreSQL. FQDN is 'localcar.repair'.

May 24 21:01:45 localcar dovecot: auth: Debug: client in:
May 24 21:01:49 localcar dovecot: auth-worker(20614): Debug:
sql(webmaster-foo at localcar.repair,,<Rb8dshnD/Gwv2Ixo>):
query: SELECT password, userid as user FROM users WHERE userid =
'webmaster-foo' AND domain = 'localcar.repair'
May 24 21:01:49 localcar dovecot: auth-worker(20614):
sql(webmaster-foo at localcar.repair,,<Rb8dshnD/Gwv2Ixo>):
unknown user (given password: topsecret)
May 24 21:01:51 localcar dovecot: auth: Debug: client passdb out:
FAIL#0116#011user=webmaster-l5buyjuxao8 at localcar.repair#011original_user=webmaster-foo at localcar.repair
May 24 21:01:51 localcar dovecot: imap-login: Debug: Ignoring unknown
passdb extra field: original_user

root at localcar:/etc/dovecot# sqlite3 users
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> .schema
  userid VARCHAR(128) NOT NULL,
  domain VARCHAR(128) NOT NULL,
  password VARCHAR(64) NOT NULL,
  home VARCHAR(255) NOT NULL,
sqlite> select * from users;

Thunderbird naturally says "Login to server localcar.repair with
username webmaster-foo at localcar.repair failed.

[ ok ] Restarting dovecot (via systemctl): dovecot.service.
root at localcar:/etc/dovecot# dovecot -n
# (f79e8e7e4): /etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.4 ()
# OS: Linux 4.19.0-16-amd64 x86_64 Debian 10.9
# Hostname: localcar.repair
auth_debug = yes
auth_verbose = yes
auth_verbose_passwords = yes
mail_location = mbox:~/mail:INBOX=/var/mail/%u
mail_privileged_group = mail
namespace inbox {
  inbox = yes
  location =
  mailbox Drafts {
    special_use = \Drafts
  mailbox Junk {
    special_use = \Junk
  mailbox Sent {
    special_use = \Sent
  mailbox "Sent Messages" {
    special_use = \Sent
  mailbox Trash {
    special_use = \Trash
  prefix =
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
protocols = " imap lmtp"
ssl_cert = </etc/dovecot/private/dovecot.pem
ssl_client_ca_dir = /etc/ssl/certs
ssl_dh = # hidden, use -P to show it
ssl_key = # hidden, use -P to show it
userdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql

Thank you,


More information about the dovecot mailing list