dovecot - Oct 2006 - MySQL stored proc authorization

On my Gentoo box until today I had dovecot-1.0_rc7
 and used following entry in /etc/dovecot/dovecot-sql.conf

password_query = call Authorize('%u', '%n', '%d')

Simply put dovecot is calling my mysql stored routine which handles
authorization. Until today, when I updated dovecot to dovecot-1.0_rc8 it
worked flawlessly. With this version executing stored proc dies with:

Password query failed: PROCEDURE mailsql.Authorize can't return a result set
in the given context

Replacing stored proc call with select .... statement does the thing, but
it's stored procedures are ... generally better to do things on DB imvho :-)
Downgrading to dovetot-1.0_rc7 fixes the problem immediately. Of course
/etc/dovecot/dovecot.conf remains the same in either case.
Is this a bug or change made on purpose?

-- 
Chaos greets U
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20061013/0f24cf6d/attachment-0001.html>

On Fri, 2006-10-13 at 22:42 +0200, Chaos Engine wrote:
> On my Gentoo box until today I
> had dovecot-1.0_rc7 and used following entry in
/etc/dovecot/dovecot-sql.conf
> 
> password_query = call Authorize('%u', '%n', '%d')
> 
> Simply put dovecot is calling my mysql stored routine which handles
> authorization. Until today, when I updated dovecot to  dovecot-1.0_rc8
> it worked flawlessly. With this version executing stored proc dies
> with:
> 
> Password query failed: PROCEDURE mailsql.Authorize can't return a
> result set in the given context
> 
> Replacing stored proc call with select .... statement does the thing,
> but it's stored procedures are ... generally better to do things on DB
> imvho :-) 
> Downgrading to dovetot-1.0_rc7 fixes the problem immediately. Of
> course /etc/dovecot/dovecot.conf remains the same in either case.
> Is this a bug or change made on purpose?
Are you sure the difference is between the changes in Dovecot and not in
some gentoo compile/link flags? Such as a different mysql library.

I don't think I've changed anything related to that between rc7 and rc8.

-------------- 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/20061014/82627adb/attachment.bin>