Mailing List Archive

SysAdmin EM via Exim-users <exim-users@exim.org> (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 -

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/

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/

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/

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/

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/

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/

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/