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@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@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!
paul
-----Original Message----- From: dovecot-bounces+razor=meganet.net@dovecot.org [mailto:dovecot-bounces+razor=meganet.net@dovecot.org] On Behalf Of Timo Sirainen Sent: Friday, December 17, 2010 8:52 AM To: PA Cc: dovecot@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?