<br><br><div><span class="gmail_quote">2006/10/14, Timo Sirainen <<a href="mailto:tss@iki.fi">tss@iki.fi</a>>:</span><blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
On Sat, 2006-10-14 at 00:08 +0200, Chaos Engine wrote:<br><br>> db->client_flags |= CLIENT_MULTI_STATEMENTS;<br><br>><br>><br>><br>> Yes, most probably the lack of this CLIENT_MULTI_STATEMENTS flag
<br>> blocks stored procs (acording to MySQL docs).<br>> From my point of view using stored proc is more secure than putting<br>> select user, password from user_sensitive_data_table into<br>> dovecot-sql.conf
, but I'll live with that.<br>> You most probably had your reasons, and ultimately I agree -<br>> security first ;-)<br><br>Now that I think of it, you can actually enable this again. Add to<br>connect string in dovecot-sql.conf
:<br><br>client_flags = 64<br></blockquote></div><br>If all was that simple ... but unfortunatelly that didn't work for me. <br>I wonder did'nt you mean client_flags = 65536 coz that's what I found in /usr/include/mysql/mysql_com.h
<br>...<br>Heh, I've just tried that and it worked :-)<br>Looks like we can call the issue solved then.<br clear="all"><br>-- <br>Chaos greets U