dovecot - Jul 2008 - "select NULL as password..." failing after upgrade to dovecot-1.1

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?
-- 
  Sergey Ivanov.

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, ...

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 194 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20080702/1cd24e45/attachment-0002.bin>

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.