On 4. May 2025, at 14.24, Odhiambo Washington via dovecot <dovecot@dovecot.org>
wrote:
>
> passdb sql {
> default_password_scheme = SHA512
> query = SELECT crypt AS password FROM users,domains WHERE users.username =
> '%
> {user}' AND users.enabled = '1' AND users.type='local' and domains.enabled='1'
> and domains.domain_id = users.domain_id
> }
>
> userdb sql {
> query = SELECT pop as home, uid, gid FROM users WHERE username = '%{user}'
> iterate_query = SELECT username AS user FROM users
Not a reason for your troubles, but should you be checking the enabled=1 here
also? So LMTP deliveries won't succeed for disabled users/domains.
> May 04 13:09:12 auth-worker(9138): Debug: mysql(/var/run/mysqld/mysqld.sock):
> Finished query 'SELECT crypt AS password FROM users,domains WHERE
> users.username = 'j...@doe.com' AND users.enabled = '1' AND users.type='local'
> and domains.enabled='1' and domains.domain_id = users.domain_id' in 0 msecs
> May 04 13:09:12 auth-worker(j...@doe.com,127.0.0.1)<9138><0sexkUw07I1/AAAB>:
> request [1]: Debug: sql: Finished passdb lookup
Okay..
> May 04 13:09:12 auth-worker(9138): Debug: conn unix:auth-worker
> (pid=9063,uid=116): auth-worker<1>: Finished: internal_failure
There's an internal failure, but no reason for it in these logs. I'd have
expected an error to be logged. Are the errors logged to a different file that
you're not looking at? Check with "doveadm log find" and/or "doveadm log
errors" if there's a reason for the internal failure.
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
