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