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

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.