[Dovecot] SQL config error

[list at airstreamcomm.net]

On Wed, 22 Jun 2011 22:14:10 +0200, Pascal Volk
<user+dovecot at localhost.localdomain.org> wrote:
> On 06/22/2011 07:35 PM list at airstreamcomm.net wrote:
>> Currently using 2.0.12, configured the auth-sql.conf to look like this
>> for
>> password lookups (doing smtp auth with postfix, so I am not actually
>> running pop or imap, just auth):
>> 
>> passdb {
>>   driver = sql
>>   connect = host=server.net dbname=passwd user=sqluser
>>   password='password'
>>   default_pass_scheme = CRYPT
>>   password_query = SELECT CONCAT(username,'@domain.net') as user, pw as
>> password FROM passwd WHERE username = '%n'
>> 
>>   # Path for SQL configuration file, see
>> example-config/dovecot-sql.conf.ext
>>   args = /etc/dovecot/dovecot-sql.conf.ext
>> }
>> 
>> Starting Dovecot I am getting the following error:
>> 
>> # 2.0.12: /etc/dovecot/dovecot.conf
>> doveconf: Fatal: Error in configuration file
>> /etc/dovecot/conf.d/auth-sql.conf.ext line 8: Unknown setting: connect
>> 
>> This is my first time configuring SQL for Dovecot so I am not sure how
>> "connect" is recognized as an unknown setting?
> 
> It's an unknown setting in the passdb {} section.
> 
> ,--[ $sysconfdir/dovecot/dovecot-sql.conf.ext ]--
> | connect = …
> | [default_pass_scheme = …]
> | password_query = …
> | user_query = …
> | iterate_query = …
> `--
> 
> ,--[ $sysconfdir/dovecot/conf.d/auth-sql.conf.ext ]--
> | passdb {
> |   driver = sql
> |   args = $sysconfdir/dovecot/dovecot-sql.conf.ext
> ] }
> | userdb {
> |   driver = sql
> |   args = $sysconfdir/dovecot/dovecot-sql.conf.ext
> | }
> `--
> 
> 
> Re4gards,
> Pascal

Pascal,

I discovered looking at the config file again that the passdb section is
trying to reference the file /etc/dovecot/dovecot-sql.conf.ext for the
information.  I added the config options to that file, and it's working
now.  

Thanks for the reply.

Michael