I am arriving late to begin the migration to 2.4.
The following is my auth-sql.conf.ext:
# MySQL Authentication
sql_driver = mysql
mysql /var/run/mysqld/mysqld.sock {
user = user
password = SECRET
dbname = pass
}
passdb sql {
default_password_scheme = MD5-CRYPT
query = SELECT crypt AS password FROM users,domains WHERE users.username =
'%u' 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 = '%u'
iterate_query = SELECT username AS user FROM users
}
The queries work for Dovecot 2.3, but fail for 2.4:
May 03 20:46:44 auth-worker(j...@doe.com,127.0.0.1)<4758><AAi/1z40rt9/AAAB>:
request [1]: Debug: sql: query: SELECT crypt AS password FROM users,domains
WHERE users.username = '%u' AND users.enabled = '1' AND users.type='local' and
domains.enabled='1' and domains.domain_id = users.domain_id
May 03 20:46:44 auth-worker(4758): Debug: mysql(/var/run/mysqld/mysqld.sock):
Finished query 'SELECT crypt AS password FROM users,domains WHERE
users.username = '%u' AND users.enabled = '1' AND users.type='local' and
domains.enabled='1' and domains.domain_id = users.domain_id' in 1 msecs
May 03 20:46:44 auth-worker(j...@doe.com,127.0.0.1)<4758><AAi/1z40rt9/AAAB>:
request [1]: Info: sql: unknown user
May 03 20:46:44 auth-worker(j...@doe.com,127.0.0.1)<4758><AAi/1z40rt9/AAAB>:
request [1]: Debug: sql: Finished passdb lookup
May 03 20:46:44 auth-worker(4758): Debug: conn unix:auth-worker
(pid=4757,uid=116): auth-worker<1>: Finished: user_unknown
May 03 20:46:44 auth(j...@doe.com,127.0.0.1,sasl:plain)<AAi/1z40rt9/AAAB>:
Debug: sql: Finished passdb lookup
May 03 20:46:44 auth(j...@doe.com,127.0.0.1,sasl:plain)<AAi/1z40rt9/AAAB>:
Debug: Auth request finished
May 03 20:46:44 auth(j...@doe.com,127.0.0.1,sasl:plain)<AAi/1z40rt9/AAAB>:
Debug: delaying auth failure
May 03 20:46:46 auth: Debug: conn unix:login (pid=4755,uid=117) [1]: client
passdb out: FAIL 1 user=j...@doe.com
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions: http://www.catb.org/~esr/faqs/smart-
questions.html]
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
