"Ken" == Ken Wright via dovecot <dovecot@dovecot.org> writes:
Ken> On 11/8/19 1:05 PM, @lbutlr via dovecot wrote:
On 07 Nov 2019, at 23:00, Ken Wright <wizard@bnnorth.net> wrote:
I'm getting an error message saying "user unknown" when I send test emails to my server. You need to look at the logs.
Ken> Here's what I see:
Ken> ***
Ken> root@grace:/etc/postfix# tail /var/log/mail.log Ken> Nov 8 13:28:09 grace postfix/smtpd[5382]: connect from Ken> grace.koalatyworks.com[127.0.0.1] Ken> Nov 8 13:28:09 grace postfix/smtpd[5382]: disconnect from Ken> grace.koalatyworks.com[127.0.0.1] ehlo=1 quit=1 commands=2 Ken> Nov 8 13:28:09 grace dovecot: imap-login: Disconnected (disconnected Ken> before auth was ready, waited 0 secs): user=<>, rip=127.0.0.1, Ken> lip=127.0.0.1, TLS handshaking: SSL_accept() syscall failed: Success, Ken> session=<PE2g8dmWyr1/AAAB> Ken> Nov 8 13:28:53 grace dovecot: auth: Fatal: Unknown passdb driver 'mysql'
This line right here looks to be the problem. Do you have mysql support compiled into your Dovecot instance? I run my own domain and I thought I'd do SQL (mysql or sqllite) for my stuff, but the compilications were so much that it was simpler to drop to plain text files.
IMHO, if you have less than 500 users, just got flat files to start.
But back to your case, did you install the 'dovecot-mysql' package with your distribution? For debian, I search with:
apt-cache search dovecot | grep mysFor redhat you could do:
yum search dovecotand see if you need to install it.
Ken> And here's the output from dovecot -n:
Ken> ***
Ken> # 2.2.33.2 (d6601f4ec): /etc/dovecot/dovecot.conf Ken> # Pigeonhole version 0.4.21 (92477967) Ken> # OS: Linux 4.15.0-66-generic x86_64 Ubuntu 18.04.3 LTS ext4 Ken> auth_mechanisms = plain login Ken> auth_verbose = yes Ken> mail_home = /var/mail/vhosts/%d/%n Ken> mail_location = maildir:/var/mail/vhosts/%d/%n/ Ken> mail_privileged_group = mail Ken> managesieve_notify_capability = mailto Ken> managesieve_sieve_capability = fileinto reject envelope Ken> encoded-character vacation subaddress comparator-i;ascii-numeric Ken> relational regex imap4flags copy include variables body enotify Ken> environment mailbox date index ihave duplicate mime foreverypart extracttext Ken> namespace inbox { Ken> inbox = yes Ken> location = Ken> mailbox Drafts { Ken> special_use = \Drafts Ken> } Ken> mailbox Junk { Ken> special_use = \Junk Ken> } Ken> mailbox Sent { Ken> special_use = \Sent Ken> } Ken> mailbox Trash { Ken> special_use = \Trash Ken> } Ken> prefix = Ken> } Ken> passdb { Ken> args = username_format=%u scheme=SSHA512 Ken> driver = mysql Ken> } Ken> passdb { Ken> args = /etc/dovecot/dovecot-sql.conf.ext Ken> driver = sql Ken> } Ken> passdb { Ken> args = /etc/dovecot/dovecot-sql.conf.ext Ken> driver = sql Ken> } Ken> plugin { Ken> sieve = file:~/sieve;active=~/.dovecot.sieve Ken> sieve_after = /var/mail/vmail/sieve-after Ken> sieve_before = /var/mail/vmail/sieve-before Ken> sieve_dir = ~/sieve Ken> } Ken> postmaster_address = postbot@koalatyworks.com Ken> protocols = imap lmtp sieve Ken> service auth-worker { Ken> user = vmail Ken> } Ken> service auth { Ken> unix_listener /var/spool/postfix/private/auth { Ken> group = postfix Ken> mode = 0660 Ken> user = postfix Ken> } Ken> unix_listener /var/spool/postfix/private/dovecot-auth { Ken> group = postfix Ken> mode = 0660 Ken> user = postfix Ken> } Ken> unix_listener auth-userdb { Ken> mode = 0600 Ken> user = vmail Ken> } Ken> user = dovecot Ken> } Ken> service dict { Ken> unix_listener dict { Ken> group = vmail Ken> mode = 0600 Ken> user = vmail Ken> } Ken> } Ken> service imap-login { Ken> inet_listener imap { Ken> port = 143 Ken> } Ken> inet_listener imaps { Ken> port = 993 Ken> ssl = yes Ken> } Ken> } Ken> service lmtp { Ken> unix_listener /var/spool/postfix/private/dovecot-lmtp { Ken> group = postfix Ken> mode = 0600 Ken> user = postfix Ken> } Ken> } Ken> ssl = required Ken> ssl_cert = </etc/letsencrypt/live/koalatyworks.com/fullchain.pem Ken> ssl_cipher_list = Ken> ECDH+AESGCM:DH+AESGCM:ECDH+AES256:DH+AES256:ECDH+AES128:DH+AES:ECDH+3DES:DH+3DES:RSA+AES:RSA+3DES:ADH:!AECDH:!MD5:!DSS Ken> ssl_client_ca_dir = /etc/ssl/certs Ken> ssl_key = # hidden, use -P to show it Ken> userdb { Ken> args = uid=5000 gid=5000 home=/var/mail/vhosts/%d/%n Ken> driver = mysql Ken> } Ken> userdb { Ken> args = uid=5000 gid=5000 home=/var/mail/vhosts/%d/%n Ken> driver = static Ken> } Ken> protocol imap { Ken> imap_client_workarounds = delay-newmail tb-extra-mailbox-sep Ken> mail_max_userip_connections = 10 Ken> } Ken> protocol lda { Ken> deliver_log_format = msgid=%m: %$ Ken> mail_plugins = sieve Ken> quota_full_tempfail = yes Ken> rejection_reason = Your message to <%t> was automatically rejected:%n%r Ken> } Ken> protocol lmtp { Ken> mail_plugins = sieve Ken> postmaster_address = postbot@koalatyworks.com Ken> } Ken> ***
Ken> I hope someone can explain to me just what protocol I should be using to Ken> access a MariaDB database.
Ken> Ken
Ken> -- Ken> Registered Linux user #483005
Ken> If you ever think international relations make sense, remember this:
Ken> because a Serb shot an Austrian in Bosnia, Germany invaded Belgium.