Hello,
I'm trying to setup multimple auth. databases with Dovecot 1.0 alpha2.
I wrote in dovecot.conf next lines
(as was described at http://wiki.dovecot.org/moin.cgi/MultipleAuth)
auth_debug = yes
auth_verbose = yes
auth default {
mechanisms = plain
user = root
passdb sql {
args = /usr/local/dovecot/etc/dovecot-mysql.conf
}
passdb pam {
args = pop3
}
userdb sql {
args = /usr/local/dovecot/etc/dovecot-mysql.conf
}
userdb passwd {
}
}
If user is virtual and placed in SQL database all works perfectly.
But system users can not login:
Sep 23 12:27:58 orion dovecot: auth(default): client in: AUTH 1 PLAIN
service=POP3 lip=192.168.5.23 rip=192.168.3.2
resp=AGRtaXRyeQBtb240bHVjY2tpdDQSep 23 12:27:58 orion dovecot:
auth-worker(default): sql(user,192.168.3.2): query: SELECT `password` FROM
`users` WHERE login = 'user'
Sep 23 12:27:58 orion dovecot: auth-worker(default): sql(user,192.168.3.2):
unknown user
Sep 23 12:27:58 orion dovecot: auth(default): client out: OK 1
user=user
Sep 23 12:27:58 orion dovecot: auth(default): master in: REQUEST 19
50448 1
Sep 23 12:27:58 orion dovecot: auth-worker(default): sql(user,192.168.3.2):
SELECT
"mbox:/var/mail/virtual//user:INBOX=/var/mail/virtual//user:INDEX=MEMORY"
AS `mail`, 101 AS `uid`, 101 AS `gid` FROM users WHERE login = 'user'
Sep 23 12:27:58 orion dovecot: auth-worker(default): sql(user,192.168.3.2): User
not found
Sep 23 12:27:58 orion dovecot: pop3-login: Internal login failure:
user=<user>, method=PLAIN, rip=192.168.3.2, lip=192.168.5.23
Sep 23 12:27:58 orion dovecot: child 50447 (auth) killed with signal 11
Sep 23 12:27:58 orion dovecot: auth-worker(default): mysql: Connected to
127.0.0.1 (exim)
How can I setup multiple auth. databases correctly? Please, help!
Thanks in advance,
Alexander
--
Kind Regards, Alexander Shikoff
minotaur at crete.org.ua
Mob.: +380 67 946 31 49
> (as was described at http://wiki.dovecot.org/moin.cgi/MultipleAuth) > auth_debug = yes > auth_verbose = yes > auth default { > mechanisms = plain > user = root > passdb sql { > args = /usr/local/dovecot/etc/dovecot-mysql.conf > } > passdb pam { > args = pop3 > } > userdb sql { > args = /usr/local/dovecot/etc/dovecot-mysql.conf > } > userdb passwd { > } > } > > If user is virtual and placed in SQL database all works perfectly. > But system users can not login: > Sep 23 12:27:58 orion dovecot: auth(default): client in: AUTH 1 PLAIN service=POP3 lip=192.168.5.23 rip=192.168.3.2 resp=AGRtaXRyeQBtb240bHVjY2tpdDQ> Sep 23 12:27:58 orion dovecot: auth-worker(default): sql(user,192.168.3.2): query: SELECT `password` FROM `users` WHERE login = 'user' > Sep 23 12:27:58 orion dovecot: auth-worker(default): sql(user,192.168.3.2): unknown user > Sep 23 12:27:58 orion dovecot: auth(default): client out: OK 1 user=user > Sep 23 12:27:58 orion dovecot: auth(default): master in: REQUEST 19 50448 1 > Sep 23 12:27:58 orion dovecot: auth-worker(default): sql(user,192.168.3.2): SELECT "mbox:/var/mail/virtual//user:INBOX=/var/mail/virtual//user:INDEX=MEMORY" AS `mail`, 101 AS `uid`, 101 AS `gid` FROM users WHERE login = 'user' > Sep 23 12:27:58 orion dovecot: auth-worker(default): sql(user,192.168.3.2): User not found > Sep 23 12:27:58 orion dovecot: pop3-login: Internal login failure: user=<user>, method=PLAIN, rip=192.168.3.2, lip=192.168.5.23 > Sep 23 12:27:58 orion dovecot: child 50447 (auth) killed with signal 11 > Sep 23 12:27:58 orion dovecot: auth-worker(default): mysql: Connected to 127.0.0.1 (exim)It seems to be a bug. This issue dissapears if change the order of auth. databases in dovecot.conf: auth default { mechanisms = plain user = root passdb pam { args = pop3 } passdb sql { args = /usr/local/dovecot/etc/dovecot-mysql.conf } userdb passwd { } userdb sql { args = /usr/local/dovecot/etc/dovecot-mysql.conf } } -- Kind Regards, Alexander Shikoff minotaur at crete.org.ua Mob.: +380 67 946 31 49
On Fri, 2005-09-23 at 12:33 +0300, Alexander Shikoff wrote:> Sep 23 12:27:58 orion dovecot: child 50447 (auth) killed with signal 11This is the problem. It crashes if MySQL userdb lookup fails. Fixed now in CVS. -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20050924/4ea81207/attachment.bin>