I'll have a dig thought the logs and find who is sending 16GB emails
send them a snotty email then cap our max accept to 250Mb ... I see no
need in south africa to waist resources on sending emails larger ..
Thanks
W B Hacker wrote:
> Gregory Machin wrote:
>
>> Hi, how do I fix this the error below .. I'm getting it occasionally and
>> would like to resolve it .. is it exim that is complaining about
>> the "absolute value of integer "16777215K" is too large (overflow)" or
>> mysql ?
>>
>>
>> 2008-03-28 07:18:11 [18245] failed to expand condition "${if
>> >{$message_size}{${lookup mysql{select users.maxmsgsize from
>> users,domains where localpart = '${quote_mysql:$local_part}' and domain
>> = '${quote_mysql:$domain}' and users.maxmsgsize > 0 and
>> users.domain_id=domains.domain_id }{${value}K}fail}} {yes}{no}}" for
>> ditch_maxmsgsize router: absolute value of integer "16777215K" is too
>> large (overflow)
>> 2008-03-28 07:18:23 [18262] 1Jf6yi-0004kH-EP failed to expand condition
>> "${if >{$message_size}{${lookup mysql{select users.maxmsgsize from
>> users,domains where localpart = '${quote_mysql:$local_part}' and domain
>> = '${quote_mysql:$domain}' and users.maxmsgsize > 0 and
>> users.domain_id=domains.domain_id }{${value}K}fail}} {yes}{no}}" for
>> ditch_maxmsgsize router: absolute value of integer "16777215K" is too
>> large (overflow)
>>
>> thanks
>>
>>
>
> Not sure it matters (which is complaining).
>
> Seems *daft* to allow 16GB max message sizes.... they'll time-out unless
> you have GigE end-to-end AND a fast server & fs.
>
> Why not set a more realistic limit? Our largest - custom commercial
> installations only - is 800 MB - just over one CD's worth.
>
> Anything larger needs an scp/sftp account.
>
> Or FedEx/DHL/TNT et al...
>
> YMMV,
>
> Bill
>
>
--
Gregory Machin
CT-Net
www.ct-net.org
greg@???
phone : +27 12 379 3497
fax : +27 12 379 4113
Cell : +27 72 524 8096
humans do not use the address
below its for trapping spam.
spamtrap -imasucker@???
