More information about - Dovecot 2.2.x quota mysql and dict

[Timo Sirainen]

On 07 Oct 2015, at 01:34, Simon <semfly at gmail.com> wrote:
> 
> I some add information about bug...
> 
> 
> Dovecot 2.2.19 version on server FreeBSD 10.2 Release.
> Config quota (dict + mysql)
> Database create Postfixadmin 2.3.7
> 
> Old version Dovecot 2.2.13 use method UPDATE in MySQL base + dict
> example mysql.log
> -----------------
> Connect   postfix at localhost on postfix
>            134 Query     SELECT bytes FROM quota2 WHERE username =
> 'user at mydomain.lan'
>            135 Query     SELECT bytes FROM quota2 WHERE username =
> 'user at mydomain.lan'
>            135 Query     BEGIN
>            135 Query     UPDATE quota2 SET
> bytes=bytes+2570,messages=messages+1 WHERE username = 'user at mydomain.lan'

Here's it's updating quota with user at mydomain.lan

>            140 Query     SELECT messages FROM quota2 WHERE username =
> 'mydomain.lan'
>            140 Query     BEGIN
>            140 Query     DELETE FROM domain WHERE domain = 'mydomain.lan'
>            140 Query     DELETE FROM quota2 WHERE username = 'mydomain.lan'
>            140 Query     INSERT INTO domain (quota,domain) VALUES
> ('8581','mydomain.lan') ON DUPLICATE KEY UPDATE quota='8581'
> 151004 15:18:45  140 Quit

Here it's only mydomain.lan. So something's not right.

> Now dic + mysql doesn’t work in Dovecot 2.2.19, because first DELETE
> operator delete information from base about my domain mydomain.lan  

I can't reproduce this. What's your doveconf -n output? And what's in the dovecot-dict-sql.conf.ext?