On Wed, 22 Jun 2011 22:14:10 +0200, Pascal Volk user+dovecot@localhost.localdomain.org wrote:

On 06/22/2011 07:35 PM list@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