Re: [exim] string_sprintf expansion was longer than 32768

2021-03-22 Thread Jeremy Harris via Exim-users

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

2021-03-22 Thread SysAdmin EM via Exim-users
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

2021-03-22 Thread SysAdmin EM via Exim-users
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

2021-03-19 Thread SysAdmin EM via Exim-users
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

2021-03-19 Thread Jeremy Harris via Exim-users

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

2021-03-19 Thread SysAdmin EM via Exim-users
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

2021-03-19 Thread Evgeniy Berdnikov via Exim-users
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

2021-03-19 Thread Heiko Schlittermann via Exim-users
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/