v2.3.17 quota-dict related sql errors

[Pascal Volk]

On 05/02/2022 20.20, Aki Tuomi wrote:
> 
>> On 05/02/2022 21:01 Pascal Volk <user+dovecot at 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 at 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 at localdomain.org