Zoong PHAM
2005-Apr-02 21:40 UTC
[Dovecot] Question about "reply from worker without password scheme"
I have dovecot-1.0-test64 installed on OpenBSD-3.6.
It works fine with local password.
Now I fail to get dovecot to use MySQL to query for user details.
Any help would be very appreciated.
Here are the details:
from /var/log/maillog:
1) with "default_pass_scheme = PLAIN"
Apr 3 07:20:22 www dovecot: Dovecot v1.0-test64 starting up
Apr 3 07:20:23 www dovecot: auth(default): mysql: Connected to (null)
(dovecot)
Apr 3 07:20:23 www dovecot: auth-worker(default): mysql: Connected to
(null) (dovecot)
Apr 3 07:20:50 www dovecot: auth(default): client in: AUTH 1 PLAIN
service=IMAP secured lip=1.2.3.4 rip=5.6.7.8
resp=AGhhemVsQGhhemVscGhhbS5jb20AemhAMTlTQXZl
Apr 3 07:20:50 www dovecot: auth-worker(default): sql(client at
clientdomain.com,5.6.7.8): query: SELECT pass AS password FROM user WHERE user =
'client at clientdomain.com'
Apr 3 07:20:50 www dovecot: auth(default): blocking(client at
clientdomain.com,5.6.7.8): Received reply from worker without password scheme
Apr 3 07:20:51 www dovecot: auth(default): client out: FAIL 1
user=client at clientdomain.com temp
Apr 3 07:21:50 www dovecot: imap-login: Disconnected: Inactivity
[5.6.7.8]
2) with "default_pass_scheme = PLAIN-MD5"
Apr 3 07:07:13 www dovecot: Dovecot v1.0-test64 starting up
Apr 3 07:07:14 www dovecot: auth(default): mysql: Connected to (null)
(dovecot)
Apr 3 07:07:14 www dovecot: auth-worker(default): mysql: Connected to
(null) (dovecot)
Apr 3 07:07:47 www dovecot: auth(default): client in: AUTH 1 PLAIN
service=IMAP se cured lip=1.2.3.4 rip=5.6.7.8
resp=AGhhemVsQGhhemVscGhhbS5jb20AemhAMTlTQXZl
Apr 3 07:07:47 www dovecot: auth-worker(default): sql(client at
clientdomain.com,5.6.7.8): query: SELECT pass AS password FROM user WHERE user =
'client at clientdomain.com'
Apr 3 07:07:48 www dovecot: auth(default): client out: FAIL 1
user=client at clientdomain.com
Command to start dovecot:
/usr/local/dovecot/sbin/dovecot -c /usr/local/dovecot/etc/dovecot.conf
Part of /usr/local/dovecot/etc/dovecot.conf:
....
disable_plaintext_auth = no
....
# SQL database
passdb sql {
# Path for SQL configuration file, see doc/dovecot-sql.conf for
# example
args = /usr/local/dovecot/etc/dovecot-mysql.conf
}
....
# SQL database
userdb sql {
# Path for SQL configuration file, see doc/dovecot-sql.conf for
# example
args = /usr/local/dovecot/etc/dovecot-mysql.conf
}
....
I also tried with "disable_plaintext_auth = yes" without any luck.
/usr/local/dovecot-1.0-test64/etc/dovecot-mysql.conf:
driver = mysql
connect = host=/var/www/dovecot/mysql.sock dbname=dovecot user=dovecot
password=secretpwDB
default_pass_scheme = PLAIN
password_query = SELECT pass AS password FROM user WHERE user = '%u'
user_query = SELECT maildir AS mail, sysuid AS uid, sysgid AS gid FROM
user WHERE user = '%n'
Manually query MySQL with username and passwd as specified
in /usr/local/dovecot-1.0-test64/etc/dovecot-mysql.conf:
mysql> SELECT pass AS password FROM user WHERE user ='client at
clientdomain.com';
+-----------+
| password |
+-----------+
| secretpw |
+-----------+
1 row in set (0.00 sec)
mysql>
Thanks,
Zoong
Zoong PHAM
2005-Apr-02 21:53 UTC
[Dovecot] Question about "reply from worker without password scheme"
On Sunday, 3 April 2005 at 7:40:36 +1000, Zoong PHAM wrote:> I have dovecot-1.0-test64 installed on OpenBSD-3.6. > It works fine with local password. > > Now I fail to get dovecot to use MySQL to query for user details.I forgot few more details in my previous post: For mail client I use mutt and for protocol I specify imaps in /usr/local/dovecot/etc/dovecot.conf. Notes: it works OK like that with local /etc/passwd. It just doens't work with MySQL. Thanks, Zoong
Timo Sirainen
2005-Apr-02 22:24 UTC
[Dovecot] Question about "reply from worker without password scheme"
On Sun, 2005-04-03 at 07:40 +1000, Zoong PHAM wrote:> Apr 3 07:20:50 www dovecot: auth(default): blocking(client at clientdomain.com,5.6.7.8): Received reply from worker without password schemeIt's a bug. I think it was fixed in 1.0-test65. Or at least in later nightly snapshots. -------------- 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/20050403/c00866d3/attachment-0001.bin>
Zoong PHAM
2005-Apr-02 22:58 UTC
[Dovecot] Re: Question about "reply from worker without password scheme" - 1.0-test65 fails with mysql-4.0.20
On Sunday, 3 April 2005 at 1:24:38 +0300, Timo Sirainen wrote:> On Sun, 2005-04-03 at 07:40 +1000, Zoong PHAM wrote: > > Apr 3 07:20:50 www dovecot: auth(default): blocking(client at clientdomain.com,5.6.7.8): Received reply from worker without password scheme > > It's a bug. I think it was fixed in 1.0-test65. Or at least in later > nightly snapshots.I just try to compile 1.0-test65 and it fails when I ran "make". The same configure command work for 1.0-test64. I am using OpenBSD-3.4 with pre-compiled package mysql-4.0.20. Here are the details: ./configure --prefix=/usr/local/dovecot --without-pam --without-shadow --without-vpopmail --localstatedir=/var --with-ssldir=/etc/ssl --with-ssl=openssl --with-mysql make And below is the outputs from make: make all-recursive Making all in src Making all in lib Making all in lib-sql Making all in lib-ntlm Making all in lib-settings Making all in lib-charset Making all in lib-mail Making all in lib-imap Making all in lib-index source='mail-index-transaction.c' object='mail-index-transaction.o' libtool=no DEPDIR=.deps depmode=gcc /bin/sh ../../depcomp gcc -DHAVE_CONFIG_H -I. -I. -I../.. -I../../src/lib -I../../src/lib-mail -g -O2 -Wall -W -Wmissing-prototypes -Wmissing-declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 -Wbad-function-cast -c mail-index-transaction.c mail-index-transaction.c: In function `mail_index_buffer_convert_to_uids': mail-index-transaction.c:102: syntax error before `struct' mail-index-transaction.c:111: `count' undeclared (first use in this function) mail-index-transaction.c:111: (Each undeclared identifier is reported only once mail-index-transaction.c:111: for each function it appears in.) mail-index-transaction.c:112: `i' undeclared (first use in this function) mail-index-transaction.c:113: `seq' undeclared (first use in this function) mail-index-transaction.c:115: `j' undeclared (first use in this function) mail-index-transaction.c:115: warning: left-hand operand of comma expression has no effect mail-index-transaction.c:117: `rec' undeclared (first use in this function) mail-index-transaction.c:120: `view' undeclared (first use in this function) mail-index-transaction.c: In function `arrays_convert_to_uids': mail-index-transaction.c:133: syntax error before `*' mail-index-transaction.c:139: `updates' undeclared (first use in this function) mail-index-transaction.c:139: `count' undeclared (first use in this function) mail-index-transaction.c:140: `i' undeclared (first use in this function) mail-index-transaction.c: In function `mail_index_seq_range_array_add': mail-index-transaction.c:265: syntax error before `struct' mail-index-transaction.c:268: `value' undeclared (first use in this function) mail-index-transaction.c:277: `data' undeclared (first use in this function) mail-index-transaction.c:277: `count' undeclared (first use in this function) mail-index-transaction.c:302: `idx' undeclared (first use in this function) mail-index-transaction.c:302: `left_idx' undeclared (first use in this function) mail-index-transaction.c:302: `right_idx' undeclared (first use in this function) mail-index-transaction.c: In function `mail_index_seq_range_array_remove': mail-index-transaction.c:347: syntax error before `struct' mail-index-transaction.c:353: `data' undeclared (first use in this function) mail-index-transaction.c:353: `count' undeclared (first use in this function) mail-index-transaction.c:374: `idx' undeclared (first use in this function) mail-index-transaction.c:374: `left_idx' undeclared (first use in this function) mail-index-transaction.c:374: `right_idx' undeclared (first use in this function) mail-index-transaction.c:398: `value' undeclared (first use in this function) mail-index-transaction.c: In function `mail_index_seq_array_lookup': mail-index-transaction.c:636: syntax error before `unsigned' mail-index-transaction.c:639: `count' undeclared (first use in this function) mail-index-transaction.c:646: `seq_p' undeclared (first use in this function) mail-index-transaction.c:648: `idx' undeclared (first use in this function) mail-index-transaction.c:650: `left_idx' undeclared (first use in this function) mail-index-transaction.c:650: `right_idx' undeclared (first use in this function) mail-index-transaction.c: In function `mail_index_seq_array_add': mail-index-transaction.c:675: syntax error before `void' mail-index-transaction.c:685: `idx' undeclared (first use in this function) mail-index-transaction.c:687: `p' undeclared (first use in this function) mail-index-transaction.c: In function `mail_index_update_header_ext': mail-index-transaction.c:775: warning: unused parameter `t' mail-index-transaction.c:776: warning: unused parameter `ext_id' mail-index-transaction.c:776: warning: unused parameter `offset' mail-index-transaction.c:777: warning: unused parameter `data' mail-index-transaction.c:777: warning: unused parameter `size' *** Error code 1 Stop in /usr/local/zoong/src/dovecot-1.0-test65/src/lib-index. *** Error code 1 Stop in /usr/local/zoong/src/dovecot-1.0-test65/src (line 271 of Makefile). *** Error code 1 Stop in /usr/local/zoong/src/dovecot-1.0-test65 (line 328 of Makefile). *** Error code 1 Stop in /usr/local/zoong/src/dovecot-1.0-test65 (line 214 of Makefile). Thanks, Zoong
Zoong PHAM
2005-Apr-05 11:58 UTC
[Dovecot] Question about "reply from worker without password scheme"
On Sunday, 3 April 2005 at 1:24:38 +0300, Timo Sirainen wrote:> On Sun, 2005-04-03 at 07:40 +1000, Zoong PHAM wrote: > > Apr 3 07:20:50 www dovecot: auth(default): blocking(client at clientdomain.com,5.6.7.8): Received reply from worker without password scheme > > It's a bug. I think it was fixed in 1.0-test65. Or at least in later > nightly snapshots.Timo, The problem still happening with 1.0-test66. Is the bug fixed yet or still outstanding? Thanks, Zoong