On Wed, 22 Jun 2011 22:14:10 +0200, Pascal Volk
<user+dove...@localhost.localdomain.org> wrote:
> On 06/22/2011 07:35 PM l...@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
