dovecot sql connection file parse error?
when attempting to connect to a postgresql database using dovecot-pgsql, i notice the following wierd error:
If my dovecot-sql.conf file is as follows:
driver = pgsql
connect = host=localhost dbname=postfix user=postfix password=********
default_pass_scheme = CRYPT
password_query = SELECT username, password FROM mailbox WHERE username = 'u%'
user_query = SELECT maildir AS home FROM mailbox WHERE username = 'u%'
Then when starting dovecot, i get:
Dec 11 22:56:38 auth(default): Error: Error in configuration file /etc/dovecot/dovecot-sql.conf line 6: Expecting '='
Dec 11 22:56:38 dovecot: Error: child 2162 (auth) returned error 89 (Fatal failure)
Dec 11 22:56:38 dovecot: Fatal: Auth process died too early - shutting down
There is no line 6 in the file.
however, if i adjust the config file to be as follows:
driver = pgsql
connect = host=localhost dbname=postfix user=postfix password=********
default_pass_scheme = CRYPT
password_query = SELECT username, password FROM mailbox WHERE username = 'u%'
user_query = SELECT maildir AS home FROM mailbox WHERE username = 'u%'
Then dovecot starts with no problem.
Possibly some sort of file parsing bug? From doing research, i think the syntax within my conf file is correct.
Thanks for looking into this!
(from redmine: issue id 216, created on 2009-12-11, closed on 2010-12-17)