Dovecot – auth:致命:未知数据库驱动程序'pgsql'

我正在尝试使用postgresql支持configurationDovecot + Postfix + PostfixAdmin。 我成功地configuration了postfix来发送电子邮件给我的域的别名,现在我想在我的服务器上configuration实际的邮箱支持。 我遵循dovecot 2维基( http://wiki.dovecot.org/AuthDatabase/SQL )上数据库支持的configuration选项,dovecot无错地启动,但在第一次尝试通过IMAP连接时,dovecot抱怨maillog:

auth: Fatal: Unknown database driver 'pgsql' 

我确定dovecot有postgres的支持,这里是dovecot的输出–build-options:

 Build options: ioloop=epoll notify=inotify ipv6 openssl io_block_size=8192 Mail storages: cydir dbox maildir mbox mdbox raw shared SQL driver plugins: mysql postgresql sqlite Passdb: checkpassword ldap pam passwd passwd-file shadow sql Userdb: checkpassword ldap(plugin) nss passwd prefetch passwd-file sql 

附加信息:

/etc/dovecot/conf.d/auth-sql.conf.ext

 passdb { driver = pgsql # Path for SQL configuration file, see example-config/dovecot-sql.conf.ext args = /etc/dovecot/conf.d/dovecot-sql.conf.ext } 

对于驱动程序节我试过:'pgsql,'postgresql'和'sql',我总是得到错误。

/etc/dovecot/conf.d/dovecot-sql.conf.ext

 connect = host=localhost dbname=postfix user=postfix password=secret default_pass_scheme = CRYPT password_query = SELECT userid as user, password FROM users WHERE userid = '%u' user_query = SELECT '/home/'||home AS home, uid, gid FROM users WHERE userid = '%u' 

任何想法,我失踪的东西? 谢谢。

在CentOS 6上,不仅需要安装dovecot软件包,还需要安装额外的模块,在这种情况下,dovecot-pgsql也是postgresql支持所必需的。

/etc/dovecot/conf.d/auth-sql.conf.ext中驱动程序行的正确语法是:

 driver = sql 

然后在/etc/dovecot/conf.d/dovecot-sql.conf.ext中指定正确的驱动程序

 driver = pgsql