[Dovecot] dovecot-sql.conf - Unknown setting: driver
Im upgrading my dovecot from 2.1.14 to dovecot 2.2.1 on linux.
Im using the same configuration file against my MySQL db and getting the following error:
doveconf -n
2.2.1: /opt/dovecot221/etc/dovecot/dovecot.conf
doveconf: Fatal: Error in configuration file /opt/dovecot221/etc/dovecot/conf.d/dovecot-sql.conf line 2: Unknown setting: driver
dovecot-sql.conf:
The mysqld.sock socket may be in different locations in different systems
driver = mysql
Use "host= ... pass=foo#bar" if your password has '#' character
connect = host=/var/run/mysqld/mysqld.sock dbname=mydb user=username password=pass
password_query = SELECT userid AS username, domain, password
FROM users WHERE userid = '%n' AND domain = '%d'
user_query = SELECT home, uid, gid FROM users WHERE userid = '%n' AND domain = '%d'
home=/opt/ii/%1n/%n/INBOX
For using doveadm -A:
iterate_query = SELECT userid AS username, domain FROM users
That file worked fine in the last version. Looking at the docs 'driver' is still a valid setting. Can someone help me figure out why its complaining? Ive even
Im lost as to why this error is occuring unless the error itself is actually another problem and the wrong error is popping up. Been working on this for a day and cant figure it out.
Thanks in advance!
/mf/home/jeep/shell/.signature
Am 27.04.2013 19:54, schrieb Jeff Lacki:
doveconf: Fatal: Error in configuration file /opt/dovecot221/etc/dovecot/conf.d/dovecot-sql.conf line 2: Unknown setting: driver
"driver =" doesn't belong to the normal dovecot configuration. It should be located in a seperate file called dovecot-sql.conf.ext which is referred (and not included!) by the passdb and userdb-setting:
passdb { driver = sql
Path for SQL configuration file, see example-config/dovecot-sql.conf.ext
args = /etc/dovecot/dovecot-sql.conf.ext }
dovecot-sql.conf:
Per Default /etc/dovecot/conf.d/*.conf is included into the main config, so this is why those files should be named as "*.conf.ext" and not as "*.conf"
Place it outside conf.d or rename it.
Peer
-- Heinlein Support GmbH Schwedter Str. 8/9b, 10119 Berlin
http://www.heinlein-support.de
Tel: 030 / 405051-42 Fax: 030 / 405051-19
Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin
Am 27.04.2013 20:00, schrieb Peer Heinlein:
Hi,
doveconf: Fatal: Error in configuration file /opt/dovecot221/etc/dovecot/conf.d/dovecot-sql.conf line 2: Unknown setting: driver
"driver =" doesn't belong to the normal dovecot configuration. It should be located in a seperate file called dovecot-sql.conf.ext which is referred (and not included!) by the passdb and userdb-setting:
For clearification:
driver = mysql
doesn't belong to the normal configuration.
"driver = sql" can be part of the passdb/userdb-configuration, as I showed in my own example:
passdb { driver = sql
Path for SQL configuration file, see example-config/dovecot-sql.conf.ext
args = /etc/dovecot/dovecot-sql.conf.ext }
Peer
-- Heinlein Support GmbH Schwedter Str. 8/9b, 10119 Berlin
http://www.heinlein-support.de
Tel: 030 / 405051-42 Fax: 030 / 405051-19
Zwangsangaben lt. §35a GmbHG: HRB 93818 B / Amtsgericht Berlin-Charlottenburg, Geschäftsführer: Peer Heinlein -- Sitz: Berlin
Peer Heinlein <p.heinlein@heinlein-support.de> wrote:
Am 27.04.2013 19:54, schrieb Jeff Lacki:
doveconf: Fatal: Error in configuration file /opt/dovecot221/etc/dovecot/conf.d/dovecot-sql.conf line 2: Unknown setting: driver
"driver =" doesn't belong to the normal dovecot configuration. It should be located in a seperate file called dovecot-sql.conf.ext which is referred (and not included!) by the passdb and userdb-setting:
Turns out that I had 2 files (from my lack of understanding months ago):
- dovecot-sql.conf
- dovecot-sql.conf.ext
I got rid of the dovecot-sql.conf and fixed the path to the dovecot-sql.conf.ext and that fixed it.
Thank you Peer!
/mf/home/jeep/shell/.signature
participants (2)
-
jeep＠rahul.net
-
Peer Heinlein