[Dovecot] Complex MySQL query in dovecot-sql.conf

Timo Sirainen tss at iki.fi
Thu Aug 10 23:11:13 EEST 2006


On Sun, 2006-07-23 at 13:13 +0300, Timo Neuvonen wrote:
> Is there some limit for the maximum length of the line in dovecot-sql.conf?

Maximum is 2048 bytes, which includes the LF. You can change this from
src/lib-settings/settings.c

> And further, can a long line be somehow split to several pieces? I tried the
> common unix-style way of putting backslash as the last character of the
> first line, but it results in an error immediatedly while restarting
> Dovecot (while parsing the conf, ie. not a MySQL error):
> 
> (in conf:)
> password_query = SELECT user, password FROM users\
>  WHERE user='%u' AND active='Y'

Unfortunately this doesn't work. I'll add it sometimes after v1.0.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20060810/62d8afc0/attachment.pgp 


More information about the dovecot mailing list