On 07 Oct 2015, at 01:34, Simon <sem...@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@localhost on postfix
> 134 Query SELECT bytes FROM quota2 WHERE username =
> 'u...@mydomain.lan'
> 135 Query SELECT bytes FROM quota2 WHERE username =
> 'u...@mydomain.lan'
> 135 Query BEGIN
> 135 Query UPDATE quota2 SET
> bytes=bytes+2570,messages=messages+1 WHERE username = 'u...@mydomain.lan'
Here's it's updating quota with u...@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?
