v2.3.17 quota-dict related sql errors
Hi there,
I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b). Right after the update, dovecot begun flooding the mail.log and PostgreSQL's log.
My dict sql configuration: ,--[ .../dovecot/dovecot-dict-sql.conf.ext ]-- | map { | pattern = priv/quota/storage | table = userquota | username_field = uid | value_field = bytes | } | map { | pattern = priv/quota/messages | table = userquota | username_field = uid | value_field = messages | } `--
This worked for decades. Since the update dovecot is passing the user's
email address, instead the user's UID to the query. And therefor I have
lots of errors in the log files: see attached mail.log' and postgresql-14-main.log' excerpts.
The `userquota' table looks like this:
Table "public.userquota"Column | Type | Collation | Nullable | Default ----------+---------+-----------+----------+--------- uid | bigint | | not null | bytes | bigint | | not null | 0 messages | integer | | not null | 0 ... Foreign-key constraints: "fkey_userquota_uid_users" FOREIGN KEY (uid) REFERENCES users(uid) ON DELETE CASCADE
(full database structure: https://bitbucket.org/pvo/vmm/src/vmm-0.7.0/pgsql/create_tables.pgsql)
Regards, Pascal
Ubuntu is an ancient African word meaning “I can’t install Debian.” -- unknown
On 2021-12-04 22.18, I wrote:
Hi there,
I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b). Right after the update, dovecot begun flooding the mail.log and PostgreSQL's log. ... just in case someone has missed
doveconf -noutput and SQL related configuration files, they are attached now.
Let me know if you have any questions.
Regards, Pascal
The trapper recommends today: face1e55.2135221@localdomain.org
On 18/12/2021 20.56, Pascal Volk wrote:
On 2021-12-04 22.18, I wrote:
Hi there,
I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b). Right after the update, dovecot begun flooding the mail.log and PostgreSQL's log. ...
Hi there,
I've upgraded Dovecot to v2.3.18 (9dd8408c18). The problem still exists:
ERROR: invalid input syntax for type bigint:"user@localhost.localdomain.org"
An excerpt from the journal is attached.
Regards, Pascal
The trapper recommends today: beeffeed.2203619@localdomain.org
On 05/02/2022 21:01 Pascal Volk <user+dovecot@localhost.localdomain.org> wrote:
On 18/12/2021 20.56, Pascal Volk wrote:
On 2021-12-04 22.18, I wrote:
Hi there,
I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b). Right after the update, dovecot begun flooding the mail.log and PostgreSQL's log. ...
Hi there,
I've upgraded Dovecot to v2.3.18 (9dd8408c18). The problem still exists:
ERROR: invalid input syntax for type bigint: "user@localhost.localdomain.org"
An excerpt from the journal is attached.
Regards, Pascal
The trapper recommends today: beeffeed.2203619@localdomain.org
Can you provide your quota-dict config file (dovecot-dict-sql.conf.ext), please?
Aki
On 05/02/2022 20.20, Aki Tuomi wrote:
On 05/02/2022 21:01 Pascal Volk <user+dovecot@localhost.localdomain.org> wrote:
Hi there,
I've upgraded Dovecot to v2.3.18 (9dd8408c18). The problem still exists:
ERROR: invalid input syntax for type bigint: "user@localhost.localdomain.org"
An excerpt from the journal is attached.
Can you provide your quota-dict config file (dovecot-dict-sql.conf.ext), please?
Aki
Hi Aki,
the content of the dovecot-dict-sql.conf.ext file:
connect = host=host dbname=mailsys user=dovecot password=TRUE map { pattern = priv/quota/storage table = userquota username_field = uid value_field = bytes } map { pattern = priv/quota/messages table = userquota username_field = uid value_field = messages }
Regards, Pascal
The trapper recommends today: cafefeed.2203720@localdomain.org
participants (3)
-
Aki Tuomi
-
Pascal Volk
-
Pascal Volk