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.
[r...@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' [r...@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....@dovecot.org [mailto:dovecot-bounces+razor=meganet....@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?
