On 02/15/2016 03:58 AM, Evgeniy Berdnikov wrote:
> Indeed, in one place your "virtual_delivery" tranport has letter "M"
> appended to the extracted quota value:
>> quota = ${lookup mysql{select users.quota from users,domains \
>> where localpart = '${quote_mysql:$local_part}' \
>> and domain = '${quote_mysql:$domain}' \
>> and users.domain_id = domains.domain_id}{${value}M}}
> -----------------------------------------------------------^^^^^^^^^
>
> In other place extracted users.quota is used without multiplication.
Thanks Evgeniy! You've got it right and this was my mistake. My mysql
statement was converting megabytes to bytes as you pointed out and my
extract statement should have been doing likewise as follows:
quota = ${extract{quota}{$address_data}{${value}M}}
Instead of:
quota = ${extract{quota}{$address_data}}
Now, everything appears to be working properly. Stupid me, I don't know
how I missed that... Sorry for my goof!
Heiko, there is no need for a bug report but thanks for your replies as
well!
Gordon Dickens
