Re: [exim] string_sprintf expansion was longer than 32768
On 22/03/2021 14:43, SysAdmin EM via Exim-users wrote: 2021-03-22 11:31:49 1lOLYZ-00063I-Rz Failed to expand user string "${lookup mysql{SELECT username FROM eximdomains WHERE active=1 AND domain='${quote_mysql:$domain}' UNION ALL SELECT 'nobody' AS username LIMIT 1} {$value}}" for the central_filter router: lookup of "SELECT username FROM eximdomains WHERE active=1 AND domain='laguadalupe.com.ar' UNION ALL SELECT 'nobody' AS username LIMIT 1" gave DEFER: MYSQL: query failed: Lost connection to MySQL server during query 2021-03-22 11:34:06 1lOLYZ-00063I-Rz string_sprintf expansion was longer than 32768; format string was (%s in "%s"?) 2021-03-22 11:35:40 1lOLYZ-00063I-Rz string_sprintf expansion was longer than 32768; format string was (%s in "%s"?) 2021-03-22 11:37:13 1lOLYZ-00063I-Rz string_sprintf expansion was longer than 32768; format string was (%s in "%s"?) # exim -d+all -bt 1lOLYZ-00063I-Rz https://pastebin.com/dBvMfKfT Your -bt test does not seem to include either "longer" or "username" so we can't use it to diagnose your problem. -- Cheers, Jeremy -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
Re: [exim] string_sprintf expansion was longer than 32768
Today i see this error 2021-03-22 11:31:49 1lOLYZ-00063I-Rz Failed to expand user string "${lookup mysql{SELECT username FROM eximdomains WHERE active=1 AND domain='${quote_mysql:$domain}' UNION ALL SELECT 'nobody' AS username LIMIT 1} {$value}}" for the central_filter router: lookup of "SELECT username FROM eximdomains WHERE active=1 AND domain='laguadalupe.com.ar' UNION ALL SELECT 'nobody' AS username LIMIT 1" gave DEFER: MYSQL: query failed: Lost connection to MySQL server during query 2021-03-22 11:34:06 1lOLYZ-00063I-Rz string_sprintf expansion was longer than 32768; format string was (%s in "%s"?) 2021-03-22 11:35:40 1lOLYZ-00063I-Rz string_sprintf expansion was longer than 32768; format string was (%s in "%s"?) 2021-03-22 11:37:13 1lOLYZ-00063I-Rz string_sprintf expansion was longer than 32768; format string was (%s in "%s"?) # exim -d+all -bt 1lOLYZ-00063I-Rz https://pastebin.com/dBvMfKfT I think the problem is the mysql, the sql query will be wrong? Regards, -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
Re: [exim] string_sprintf expansion was longer than 32768
Any helps for this? -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
Re: [exim] string_sprintf expansion was longer than 32768
Please, tell me how to debug correctly. Thanks. -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
Re: [exim] string_sprintf expansion was longer than 32768
On 19/03/2021 14:34, Heiko Schlittermann via Exim-users wrote: Are you talking about a debug output that doesn't work, becaues the string to be output is too long? That sounds to me, as if I had a similar issue recently. Not sure, if I fixed it. 0cd6e20a16 -- Cheers, Jeremy -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
Re: [exim] string_sprintf expansion was longer than 32768
Thanks for the reply. Run debug with these commands: exim -d+all +bt ID_MESSAGE. This is correct?. Regards, -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
Re: [exim] string_sprintf expansion was longer than 32768
On Fri, Mar 19, 2021 at 11:14:33AM -0300, SysAdmin EM via Exim-users wrote: ... > 2021-03-19 11:09:38 1lNFgK-0007a9-Ab string_sprintf expansion was longer > than 32768; format string was (%s in "%s"?) > called from match_check_list 509 > > 2021-03-19 11:09:39 1lNFgO-0007iO-30 string_sprintf expansion was longer > than 32768; format string was (%s in "%s"?) > called from match_check_list 509 > > Here I leave the logs of a connection in debugging mode. > https://pastebin.pl/view/761fdd5a There are no "match_check_list" or "string_sprintf" in this log. -- Eugene Berdnikov -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
Re: [exim] string_sprintf expansion was longer than 32768
SysAdmin EM via Exim-users (Fr 19 Mär 2021 15:14:33 CET): > > 2021-03-19 11:09:39 1lNFgO-0007iO-30 string_sprintf expansion was longer > than 32768; format string was (%s in "%s"?) > called from match_check_list 509 > > Here I leave the logs of a connection in debugging mode. > https://pastebin.pl/view/761fdd5a I do not see the "sprintf …" message anywhere there. Are you talking about a debug output that doesn't work, becaues the string to be output is too long? That sounds to me, as if I had a similar issue recently. Not sure, if I fixed it. Best regards from Dresden/Germany Viele Grüße aus Dresden Heiko Schlittermann -- SCHLITTERMANN.de internet & unix support - Heiko Schlittermann, Dipl.-Ing. (TU) - {fon,fax}: +49.351.802998{1,3} - gnupg encrypted messages are welcome --- key ID: F69376CE - signature.asc Description: PGP signature -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/