[Dovecot] MySQL stored proc authorization

[Timo Sirainen]

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: not available
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.pgp