Hi,
I've had this problem as well. I brought it up about a month ago but
nobody responded to my message.
There seems to be a problem in the SQL INSERT query in the source code.
The ?path? value is being inserted into the ?current? column and via
versa. I swapped them around in the source and recompiled it. That
seemed to solve the insert problem, however there seems to be another
issue I couldn?t solve when using multiple domains. Have a look at the
message I posted last on this:
http://www.dovecot.org/list/dovecot/2006-September/015970.html
This was all done on Dovecot version 1.0.rc6-1 from the Debian Testing
package on a x86 machine. Does anyone know if this was fixed in rc7 or
if anyone is working on it?
I?m afraid I'm not a C(++) coder so can?t really offer much more of an
explanation on this.
Thanks
Neil
Peter Veerman wrote:> Hi,
>
> I have dovecot configured to make use of the dict (mysql) plugin in
> order to keep track of the used quota.
> First, as you can see in the mysql table output below it seems that
> values aren't stored correctly.
> Secondly I get all kinds of database related errors in my mail logs.
> The (relevant) sections of the configuration files are also included below.
> My question is, what am I doing wrong?
>
> Peter
>
>
>
> mysql> select * from quota;
> +------------------+-------+---------+
> | username | path | current |
> +------------------+-------+---------+
> | userc at domain1 | 0 | 0 |
> | usera at domain1 | 0 | 0 |
> | userb at domain1 | 0 | 0 |
> | userb at domain1 | 5417 | 0 |
> | userb at domain1 | 937 | 0 |
> | userb at domain1 | 3724 | 0 |
> | userb at domain1 | -9141 | 0 |
> | userb at domain1 | 4887 | 0 |
> | userb at domain1 | -4887 | 0 |
> | usera at domain2 | 0 | 0 |
> | usera at domain1 | 3134 | 0 |
> | usera at domain1 | 2177 | 0 |
> | usera at domain1 | 5137 | 0 |
> | usera at domain1 | 4953 | 0 |
> +------------------+-------+---------+
> 14 rows in set (0.03 sec)
>
>
>
>
> dovecot.conf:
>
> dict {
> quotadict = mysql:/usr/local/etc/dovecot/dovecot-dict-quota.conf
> }
>
> plugin {
> quota = dict:storage=10240 proxy::quotadict
> }
>
>
>
>
> dovecot-dict-quota.conf:
>
> connect = host=localhost dbname=postfix user=postfix password=*******
> table = quota
> select_field = current
> where_field = path
> username_field = username
>
>
>
>
>
> dovecot.log gives:
> Oct 02 23:25:49 Info: imap-login: Login: user=<user at domain.net>,
> method=plain, rip=88.211.149.123, lip=10.0.0.4, TLS
> Oct 02 23:25:49 Info: IMAP(user at domain.net): Effective uid=125, gid=125
> Oct 02 23:25:49 Info: IMAP(user at domain.net): Loading modules from
> directory: /usr/local/lib/dovecot/imap
> Oct 02 23:25:49 Info: IMAP(user at domain.net): Module loaded:
> /usr/local/lib/dovecot/imap/lib01_quota_plugin.so
> Oct 02 23:25:49 Info: IMAP(user at domain.net): Module loaded:
> /usr/local/lib/dovecot/imap/lib02_imap_quota_plugin.so
> Oct 02 23:25:49 Info: IMAP(user at domain.net): Namespace: type=private,
> prefix=INBOX., sep=., inbox=yes, hidden=no, subscriptions=no
> Oct 02 23:25:49 Info: IMAP(user at domain.net): maildir:
> data=/data/postfix/virtual/domain.net/user
> Oct 02 23:25:49 Info: IMAP(user at domain.net): maildir:
> root=/data/postfix/virtual/domain.net/user,
> index=/data/postfix/virtual/domain.net/user, control=, inbox> Oct 02
23:25:49 Info: IMAP(user at domain.net): dict quota: uri > proxy::quotadict
> Oct 02 23:25:49 Info: IMAP(user at domain.net): dict quota: byte limit >
524288000
> Oct 02 23:25:49 Info: IMAP(user at domain.net): dict quota: count limit = 0
> Oct 02 23:25:49 Info: dict: mysql: Connected to localhost (postfix)
> Oct 02 23:25:55 Info: dict: mysql: Connected to localhost (postfix)
> Oct 02 23:25:56 Info: dict: mysql: Connected to localhost (postfix)
> Oct 02 23:26:37 Info: dict: mysql: Connected to localhost (postfix)
> Oct 02 23:27:07 Info: imap-login: Aborted login: rip=10.0.0.25,
> lip=10.0.0.22, TLS
> Oct 02 23:27:11 Info: dict: mysql: Connected to localhost (postfix)
>
>
>
>
> mail.debug gives:
> Oct 2 23:26:39 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:39 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:39 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:39 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:40 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:40 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:40 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:40 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:40 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:40 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:40 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:41 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:42 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:42 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:42 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:48 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:48 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
> Oct 2 23:26:48 bubbles dovecot: IMAP(user at domain.net): dict_quota:
> Couldn't update quota
>
>
>