[Dovecot] dovecot 2.0.8 LDA with MYSQL issues not solved

PA razor at meganet.net
Fri Dec 17 16:52:25 EET 2010

Timo, thanks for the reply, the problem is that with dovecot 1.x the wiki recommends the connect string and password_query/user_query be in the sql.conf include file. According to wiki2 I should also be able to put these settings on the sql.conf include file but I get an error no matter what I put on there.

[root at testip5 conf.d]# cat sql.conf
password_query = SELECT user, password FROM users WHERE user = '%u'
user_query = SELECT 101 AS uid, 504 AS gid, home FROM users WHERE userid = '%n'

[root at testip5 conf.d]# dovecot -n
# 2.0.8: /usr/local/etc/dovecot/dovecot.conf
doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/conf.d/sql.conf line 1: Unknown setting: password_query

any idea what im doing wrong?

Thanks for the reply!


-----Original Message-----
From: dovecot-bounces+razor=meganet.net at dovecot.org [mailto:dovecot-bounces+razor=meganet.net at dovecot.org] On Behalf Of Timo Sirainen
Sent: Friday, December 17, 2010 8:52 AM
To: PA
Cc: dovecot at dovecot.org
Subject: Re: [Dovecot] dovecot 2.0.8 LDA with MYSQL issues not solved

On Thu, 2010-12-16 at 16:32 -0500, PA wrote:
> Apparently that's not it, the include is configured as !include
> conf.d/*.conf - when I changed the conf.d/ files to .conf.ext it simple
> didn't read the file and it gave me no error. Back to square one.

The sql config isn't supposed to be !included, it gets used by:

passdb {
  driver = sql
  args = /path/to/sql.conf

And looks like you already had it like that. So what's the problem?

More information about the dovecot mailing list