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