[Dovecot] dovecot 1.2.alpha1 quota dict driver mysql broken
Hi Timo, quota dict seems to be broken with 1.2.alpha1
MAP(robert@schetterer.com): read(/var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 18:43:16 Error: dict: Error in configuration file /etc/dovecot/dovecot-dict-quota.conf line 1: Unknown setting: driver dovecot: Sep 24 18:43:16 Error: dict: Failed to initialize dictionary 'quotadict'
etc/dovecot/dovecot-dict-quota.conf driver = mysql connect = host=localhost dbname=postfix user=postfix password=... default_pass_scheme = PLAIN table = quota select_field = current where_field = path username_field = username
worked with 1.1.3
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
On Sep 24, 2008, at 7:50 PM, Robert Schetterer wrote:
etc/dovecot/dovecot-dict-quota.conf driver = mysql .. worked with 1.1.3
Really? I don't think there was such a setting in v1.1 either, since
the driver is taken from the dict line in dovecot.conf.
Anyway, besides the problem with this setting the dict configuration
was rewritten in v1.2. See doc/dovecot-dict-sql-example.conf
Timo Sirainen schrieb:
On Sep 24, 2008, at 7:50 PM, Robert Schetterer wrote:
etc/dovecot/dovecot-dict-quota.conf driver = mysql .. worked with 1.1.3
Really? I don't think there was such a setting in v1.1 either, since the driver is taken from the dict line in dovecot.conf.
Anyway, besides the problem with this setting the dict configuration was rewritten in v1.2. See doc/dovecot-dict-sql-example.conf
hm, it did worked, but perhaps it was my fault during upgrading or it was ignored before
the wikis says
Example dovecot-dict-quota.conf:
connect = host=localhost dbname=mails user=sqluser password=sqlpass table = quota select_field = current where_field = path username_field = username
now i am having
connect = host=localhost dbname=postfix user=postfix password=..... table = quota select_field = current where_field = path username_field = username
with new log failure
Sep 24 21:40:58 Error: dict: Error in configuration file /etc/dovecot/dovecot-dict-quota.conf line 2: Unknown setting: table dovecot: Sep 24 21:40:58 Error: dict: Failed to initialize dictionary 'quotadict' dovecot: Sep 24 21:40:58 Error: IMAP(robert@schetterer.com): read(/var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 21:41:06 Warning: Killed with signal 15
seems strange > Unknown setting: table ???
dovecot.conf
dict { quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf }
quota = dict:::proxy::quotadict
-- Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
On Sep 24, 2008, at 10:53 PM, Robert Schetterer wrote:
Anyway, besides the problem with this setting the dict
configuration was rewritten in v1.2. See doc/dovecot-dict-sql- example.conf ..now i am having
connect = host=localhost dbname=postfix user=postfix password=..... table = quota select_field = current where_field = path username_field = username
Like I said, see doc/dovecot-dict-sql-example.conf. The old style
configuration doesn't work anymore in v1.2. The new style allows more
logical and efficient SQL tables.
Timo Sirainen schrieb:
On Sep 24, 2008, at 10:53 PM, Robert Schetterer wrote:
Anyway, besides the problem with this setting the dict configuration was rewritten in v1.2. See doc/dovecot-dict-sql-example.conf ..
now i am having
connect = host=localhost dbname=postfix user=postfix password=..... table = quota select_field = current where_field = path username_field = username
Like I said, see doc/dovecot-dict-sql-example.conf. The old style configuration doesn't work anymore in v1.2. The new style allows more logical and efficient SQL tables.
jep but whats this
Sep 24 21:40:58 Error: dict: Error in configuration file /etc/dovecot/dovecot-dict-quota.conf line 2: Unknown setting: table dovecot: Sep 24 21:40:58 Error: dict: Failed to initialize dictionary 'quotadict' dovecot: Sep 24 21:40:58 Error: IMAP(robert@schetterer.com): read(/var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 21:41:06 Warning: Killed with signal 15
seems strange > Unknown setting: table ???
-- Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
On Sep 24, 2008, at 11:12 PM, Robert Schetterer wrote:
Like I said, see doc/dovecot-dict-sql-example.conf. The old style
configuration doesn't work anymore in v1.2. The new style allows
more logical and efficient SQL tables.jep but whats this
Sep 24 21:40:58 Error: dict: Error in configuration file /etc/ dovecot/dovecot-dict-quota.conf line 2: Unknown setting: table dovecot: Sep 24 21:40:58 Error: dict: Failed to initialize
dictionary 'quotadict' dovecot: Sep 24 21:40:58 Error: IMAP(robert@schetterer.com): read(/ var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 21:41:06 Warning: Killed with signal 15seems strange > Unknown setting: table ???
Because there is no such setting anymore.
Timo Sirainen schrieb:
On Sep 24, 2008, at 11:12 PM, Robert Schetterer wrote:
Like I said, see doc/dovecot-dict-sql-example.conf. The old style configuration doesn't work anymore in v1.2. The new style allows more logical and efficient SQL tables.
jep but whats this
Sep 24 21:40:58 Error: dict: Error in configuration file /etc/dovecot/dovecot-dict-quota.conf line 2: Unknown setting: table dovecot: Sep 24 21:40:58 Error: dict: Failed to initialize dictionary 'quotadict' dovecot: Sep 24 21:40:58 Error: IMAP(robert@schetterer.com): read(/var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 21:41:06 Warning: Killed with signal 15
seems strange > Unknown setting: table ???
Because there is no such setting anymore.
jep , i see *g
but there is no
doc/dovecot-dict-sql-example.conf
in 1.2
there is doc/wiki/doc/wiki/Quota.Dict.txt
which has only old descriptions
Example 'dovecot-dict-quota.conf':
---%<------------------------------------------------------------------------- connect = host=localhost dbname=mails user=sqluser password=sqlpass table = quota select_field = current where_field = path username_field = username
so you might have to upgrade the doc/wiki for the new syntax
-- Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
On Sep 24, 2008, at 11:32 PM, Robert Schetterer wrote:
Sep 24 21:40:58 Error: dict: Error in configuration file /etc/ dovecot/dovecot-dict-quota.conf line 2: Unknown setting: table dovecot: Sep 24 21:40:58 Error: dict: Failed to initialize
dictionary 'quotadict' dovecot: Sep 24 21:40:58 Error: IMAP(robert@schetterer.com): read(/ var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 21:41:06 Warning: Killed with signal 15seems strange > Unknown setting: table ??? Because there is no such setting anymore.
jep , i see *g
but there is no
doc/dovecot-dict-sql-example.conf
Well that's a different problem then. :) Looks like I forgot to
include it in Makefile. See this instead: http://hg.dovecot.org/dovecot-1.2/file/tip/doc/dovecot-dict-sql-example.conf
so you might have to upgrade the doc/wiki for the new syntax
Yes, once I get around to it :)
Timo Sirainen schrieb:
On Sep 24, 2008, at 11:32 PM, Robert Schetterer wrote:
Sep 24 21:40:58 Error: dict: Error in configuration file /etc/dovecot/dovecot-dict-quota.conf line 2: Unknown setting: table dovecot: Sep 24 21:40:58 Error: dict: Failed to initialize dictionary 'quotadict' dovecot: Sep 24 21:40:58 Error: IMAP(robert@schetterer.com): read(/var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 21:41:06 Warning: Killed with signal 15
seems strange > Unknown setting: table ??? Because there is no such setting anymore.
jep , i see *g
but there is no
doc/dovecot-dict-sql-example.conf
Well that's a different problem then. :) Looks like I forgot to include it in Makefile. See this instead: http://hg.dovecot.org/dovecot-1.2/file/tip/doc/dovecot-dict-sql-example.conf
so you might have to upgrade the doc/wiki for the new syntax
Yes, once I get around to it :)
Hi Timo, after repopulating tables to mysql and using your example conf if have
-----------dovecot: Sep 29 22:09:02 Fatal: dict: Socket already exists: /var/run/dovecot//dict-server dovecot: Sep 29 22:09:02 Error: IMAP(robert@schetterer.com): read(/var/run/dovecot/dict-server) failed: Connection reset by peer
any idea how to fix or what might be the failure
-- Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
participants (2)
-
Robert Schetterer
-
Timo Sirainen