[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-18 Thread Wietse Venema via Postfix-users
Gerald Galster via Postfix-users: > > > Wietse Venema via Postfix-users : > > > > And here is a more conservative patch for MySQL client retries. > > > > It closes the server connection after every error, and it delays > > making a new server connection only after specific errors. > > > >

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-18 Thread Gerald Galster via Postfix-users
> Wietse Venema via Postfix-users : > > And here is a more conservative patch for MySQL client retries. > > It closes the server connection after every error, and it delays > making a new server connection only after specific errors. > > Closing the connection eliminates the possibility that

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-17 Thread Wietse Venema via Postfix-users
And here is a more conservative patch for MySQL client retries. It closes the server connection after every error, and it delays making a new server connection only after specific errors. Closing the connection eliminates the possibility that the client becomes stuck. Wietse 20230417

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-17 Thread Gerald Galster via Postfix-users
>>> I've patched postfix 3.7.4 on a low volume server. >> >> Thank you! >> >>> "charset" has to be present and defined in all mysql configs, otherwise >>> startup fails: >>> (no backwards compatibility) >>> >>> postfix/proxymap[3996]: fatal: /etc/postfix/test.mysql.cf: bad string >>> length 0

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-17 Thread Wietse Venema via Postfix-users
Wietse Venema via Postfix-users: > Gerald Galster via Postfix-users: > > > > > Wietse Venema via Postfix-users : > > > > > >>> My conclusion to hard-solve this issue on my system is transform all > > >>> tables to utf8mb4. > > >>> > > >>> But: > > > > > >>> - I don't see any option to change

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-17 Thread Wietse Venema via Postfix-users
Gerald Galster via Postfix-users: > > > Wietse Venema via Postfix-users : > > > >>> My conclusion to hard-solve this issue on my system is transform all > >>> tables to utf8mb4. > >>> > >>> But: > > > >>> - I don't see any option to change default charset on mysql_table > >>> connector,

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-17 Thread Gerald Galster via Postfix-users
> Wietse Venema via Postfix-users : > >>> My conclusion to hard-solve this issue on my system is transform all >>> tables to utf8mb4. >>> >>> But: > >>> - I don't see any option to change default charset on mysql_table >>> connector, maybe should be interesting add this option on

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-17 Thread Wietse Venema via Postfix-users
Wietse Venema via Postfix-users: > > My conclusion to hard-solve this issue on my system is transform all > > tables to utf8mb4. > > > > But: > > - I don't see any option to change default charset on mysql_table > > connector, maybe should be interesting add this option on configuration > >

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-17 Thread Wietse Venema via Postfix-users
V?ctor Rubiella Monfort via Postfix-users: > Hi, I have more info and I try to explain it better: > > First of all I have smtputf8_enable = no (disabled). > > I have several databases related with several mysql_virtual maps: > > - Some with utf8 + utf8_general_ci collation > > - Another ones

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-14 Thread Wietse Venema via Postfix-users
Viktor Dukhovni via Postfix-users: > On Fri, Apr 14, 2023 at 01:06:16PM -0400, Wietse Venema via Postfix-users > wrote: > > > Wietse Venema via Postfix-users: > > > As for the temp error becoming persistent, the Postfix pgsql: client > > > code returns an error when it gets an error from all of

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-14 Thread Víctor Rubiella Monfort via Postfix-users
Hi, I have more info and I try to explain it better: First of all I have smtp_utf8 = no (disabled). I have several databases related with several mysql_virtual maps: - Some with utf8 + utf8_general_ci collation - Another ones with latin1 + latin1_spanish_ci. I'm using mysql-postfix

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-14 Thread Viktor Dukhovni via Postfix-users
On Fri, Apr 14, 2023 at 01:06:16PM -0400, Wietse Venema via Postfix-users wrote: > Wietse Venema via Postfix-users: > > As for the temp error becoming persistent, the Postfix pgsql: client > > code returns an error when it gets an error from all of the hosts > > configured in the Postfix pgsql:

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-14 Thread Wietse Venema via Postfix-users
Wietse Venema via Postfix-users: > As for the temp error becoming persistent, the Postfix pgsql: client > code returns an error when it gets an error from all of the hosts > configured in the Postfix pgsql: client configuration file, or when > all hosts have been flagged as 'down'. If a host

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-14 Thread Wietse Venema via Postfix-users
V?ctor Rubiella Monfort via Postfix-users: > Hi again, > > I realized than same error is raised when database is in utf8 if email > contains utf8mb4 characters. > > Which is the convenient database collation for postfix? We can force > postfix to accept only utf8 characters?. With

[pfx] Re: temporary lookup error with utf8mb4 characters

2023-04-14 Thread Víctor Rubiella Monfort via Postfix-users
Hi again, I realized than same error is raised when database is in utf8 if email contains utf8mb4 characters. Which is the convenient database collation for postfix? We can force postfix to accept only utf8 characters?. El 13/4/23 a las 18:36, Víctor Rubiella Monfort via Postfix-users