Re: [Dovecot] "select NULL as password..." failing after upgrade to dovecot-1.1

2 Jul 2008


      Timo Sirainen wrote:
...
On Jul 2, 2008, at 12:26 AM, Sergey Ivanov wrote:
...
Hi,
I've upgraded mail server to dovecot-1.1, on solaris-10 with mysql
user database.
I used sql query
"SELECT NULL as password, login as user,
concat('/mail/var/dovecot/',login) AS userdb_home, 501 AS userdb_uid,
501 AS userdb_gid FROM users WHERE login='%n' AND
password=old_password('%w')" with dovecot-1.0.15 and it worked
perfectly.
But since upgrade the server can not authenticate any users,
complaining in info_log: "Empty password returned without no_password".
How to set up such things in dovecot-1.1? Is it possible?
Like it says, return no_password field also. For example:
select 'Y' as no_password, ...
Thank you, Timo, it worked but without underscore, that is, "select 'Y'
as nopassword...".
But after that I have another problem:
dovecot: Jul 01 17:38:50 Error: IMAP(seriv): Corrupted transaction log
file /mail/var/dovecot/seriv/.Trash/dovecot.index.log: hdr.size too
large (67108864)
dovecot: Jul 01 17:38:50 Warning: IMAP(seriv): fscking index file
/mail/var/dovecot/seriv/.Trash/dovecot.index
dovecot: Jul 01 17:38:52 Error: child 29586 (imap) killed with signal 11
...
(imap child killed many many times).
I stopped dovecot, deleted dovecot.index files, and this problem was
gone. But tags also were gone. Is there a way to upgrade preserving tags
and other flags?
WBR,
Sergey Ivanov.

Re: [Dovecot] "select NULL as password..." failing after upgrade to dovecot-1.1

Sergey Ivanov

Thank you, Timo, it worked but without underscore, that is, "select 'Y' as nopassword...". But after that I have another problem:

(imap child killed many many times). I stopped dovecot, deleted dovecot.index files, and this problem was gone. But tags also were gone. Is there a way to upgrade preserving tags and other flags?