Hi, after deciding to use Dovecot 2.0.8 as a postfix LDA using mysql DB I'm running into some issues. I started to follow, http://wiki.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL but noticed that the auth settings on the config changed, after looking through the dovecot wiki I think I have that issue fixed. However I still can't get the SQL part to work right, below is what I have on the conf.d/sql.conf and the error I get.
service dovecot status doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/conf.d/sql.conf line 1: Unknown setting: password_query Where do I put the sql connect string, in the URL above that along with the driver type went on the sql.conf file but that is no longer the case. If anyone has a better reference/suggestions for what im trying to do I would appreciated it. Thanks, Paul [r...@testip5 conf.d]# cat sql.conf password_query = SELECT userid as user, password FROM users WHERE userid = '%u' user_query = SELECT uid, gid, '/var/vmail/%d/%n' as home FROM users WHERE userid = '%u' [r...@testip5 conf.d]# dovecot -n # 2.0.8: /usr/local/etc/dovecot/dovecot.conf # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 auth_mechanisms = plain login cram-md5 first_valid_uid = 101 last_valid_uid = 101 login_greeting = MegaNet Mail Server Ready. mail_gid = vmail mail_location = maildir:/var/vmail/%d/%u mail_uid = vmail passdb { args = /usr/local/etc/dovecot/conf.d/sql.conf driver = sql } plugin { acl = vfile:/usr/local/etc/dovecot/acls quota = maildir:storage=10240:messages=1000 trash = /usr/local/etc/dovecot/conf.d/trash.conf } protocols = imap pop3 userdb { driver = prefetch } userdb { args = /usr/local/etc/dovecot/conf.d/sql.conf driver = sql } doveconf: Error: ssl enabled, but ssl_cert not set doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf: ssl enabled, but ssl_cert not set