Gregory Machin wrote:
> 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
>>
>>
>
>
I don't think anyone is actually sending any 16GB emails. It looks to me
as though the expansion which fails is {${value}K}, where value is the
value returned by your mysql{select users.maxmsgsize} lookup. So, the
16777215 is what is returned by MySQL as the value of the $local_user
users.maxmsgsize. of course, I may be wrong...
--
Nigel Wade, System Administrator, Space Plasma Physics Group,
University of Leicester, Leicester, LE1 7RH, UK
E-mail : nmw@???
Phone : +44 (0)116 2523548, Fax : +44 (0)116 2523555
