[Dovecot] dovecot 2.0.8 LDA with MYSQL issues

[PA]

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

 

 

[root at 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'

 

[root at 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