just for fun, I changed the configuration to the the one below, and the result seem to support my earlier statement

headers_remove = ${if or { { <{$spam_score_int}{1} } \
������������������������������ { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������������������������������ }{$value}fail}} } \
������������������������������ { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������������������������������ }{$value}fail}} } \
������������������������������ } {X-Spam-Score::X-Spam-Report} }



16:16:03 58090 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains }{$value}fa


On 25 September 2014 16:14, Shamim Shahriar <shamim.shahriar@gmail.com> wrote:
setup: FreeBSD 9 Stable
Exim version : 4.84
Vexim latest, with local modification that does not interfere with Exim itself

I have run a few tests (both configuration part and result part is given below), and it appears that for some reason the headers_remove -- or more precisely the lookup mysql inside headers_remove -- is not taking more than a certain number of characters as condition.

snippets:
15:45:32 53510 failed to expand: select users.sa_tag * 10 from users,domains where local
15:54:32 54370 failed to expand: select users.sa_tag * 10 from users,domains where local
15:59:39 55092 failed to expand: select users.sa_tag * 10 from users,domains where local
16:04:55 55934 failed to expand: select users.sa_tag * 10 from users,domains where `loca


Please note the last line, where it stopped at the same length.

Thoughts? anyone capable of looking through the code to see if that is the case (I am, by no means, even remotely qualified to do it, otherwise I would have looked it up myself).

Thanks
Shah


Test 01 :: double colons
-------------------------

headers_remove = ${if or { { <{$spam_score_int}{1} } \
������ ������ { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where localpart = '${quote_mysql::$local_part}' \
������ ������ and domain = '${quote_mysql::$domain}' \
������ ������ and users.on_spamassassin = 1 \
������ ������ and users.domain_id=domains.domain_id}{$value}fail}} } \
������ ������ { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where localpart = '${quote_mysql::$local_part}' \
������ ������ and domain = '${quote_mysql::$domain}' \
������ ������ and users.on_spamassassin = 0 \
������ ������ and users.domain_id=domains.domain_id}{$value}fail}}} \
������ ������ } {X-Spam-Score::X-Spam-Report} }



Result:
-------
15:45:32 53510 expanding: ${if >{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id }{$value}fail}} {X-Spam-Flag: YES\n}{} }
15:45:32 53510������ result: X-Spam-Flag: YES
15:45:32 53510
15:45:32 53510 expanding: $spam_score_int
15:45:32 53510������ result: 27
15:45:32 53510 expanding: 1
15:45:32 53510������ result: 1
15:45:32 53510 expanding: $spam_score_int
15:45:32 53510������ result: 27
15:45:32 53510 failed to expand: select users.sa_tag * 10 from users,domains where local
15:45:32 53510������ error message: missing } at end of string
15:45:32 53510 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where local
15:45:32 53510������ error message: missing } at end of string
15:45:32 53510 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where local
15:45:32 53510������ error message: missing } at end of string inside "or{...}" condition
15:45:32 53510 virtual_domains router: defer for postmaster@diagnosis.lan.cps-intl.org
15:45:32 53510���� message: virtual_domains router failed to expand "${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domai
ns where localpart = '${quote_mysql::$local_part}' and domain = '${quote_mysql::$domain}' and users.on_spamassassin = 1 and users.domain_id=domains.domain_id}{$value}fail}} } { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql::$local_part}' and domain = '${quote_mysql::$domain}' and users.on_spamassassin = 0 and users.domain_id=domains.domain_id}{$value}fail}}} } {X-Spam-Score::X-Spam-Report} }": missing } at end of string inside "or{...}" condition



============================
Test 02 :: remove mysql_quote
-----------------------------

headers_remove = ${if or { { <{$spam_score_int}{1} } \
������ ������ { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where localpart = '{$local_part}' \
������ ������ and domain = '{$domain}' \
������ ������ and users.on_spamassassin = 1 \
������ ������ and users.domain_id=domains.domain_id}{$value}fail}} } \
������ ������ { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where localpart = '{$local_part}' \
������ ������ and domain = '{$domain}' \
������ ������ and users.on_spamassassin = 0 \
������ ������ and users.domain_id=domains.domain_id}{$value}fail}}} \
������ ������ } {X-Spam-Score::X-Spam-Report} }



Result:
-------
15:54:32 54370 expanding: $spam_score_int
15:54:32 54370������ result: 27
15:54:32 54370 expanding: 1
15:54:32 54370������ result: 1
15:54:32 54370 expanding: $spam_score_int
15:54:32 54370������ result: 27
15:54:32 54370 failed to expand: select users.sa_tag * 10 from users,domains where local
15:54:32 54370������ error message: missing } at end of string
15:54:32 54370 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where local
15:54:32 54370������ error message: missing } at end of string
15:54:32 54370 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where local
15:54:32 54370������ error message: missing } at end of string inside "or{...}" condition
15:54:32 54370 virtual_domains router: defer for postmaster@diagnosis.lan.cps-intl.org
15:54:32 54370���� message: virtual_domains router failed to expand "${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '{$local_part}' and domain = '{$domain}' and users.on_spamassassin = 1 and users.domain_id=domains.domain_id}{$value}fail}} } { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '{$local_part}' and domain = '{$domain}' and users.on_spamassassin = 0 and users.domain_id=domains.domain_id}{$value}fail}}} } {X-Spam-Score::X-Spam-Report} }": missing } at end of string inside "or{...}" condition



============================
Test 03 :: put the variables properly
-------------------------------------

headers_remove = ${if or { { <{$spam_score_int}{1} } \
������ ������ { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where localpart = '${local_part}' \
������ ������ and domain = '${domain}' \
������ ������ and users.on_spamassassin = 1 \
������ ������ and users.domain_id=domains.domain_id}{$value}fail}} } \
������ ������ { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where localpart = '${local_part}' \
������ ������ and domain = '${domain}' \
������ ������ and users.on_spamassassin = 0 \
������ ������ and users.domain_id=domains.domain_id}{$value}fail}}} \
������ ������ } {X-Spam-Score::X-Spam-Report} }



Result:
-------

15:59:39 55092 expanding: $spam_score_int
15:59:39 55092������ result: 27
15:59:39 55092 expanding: 1
15:59:39 55092������ result: 1
15:59:39 55092 expanding: $spam_score_int
15:59:39 55092������ result: 27
15:59:39 55092 failed to expand: select users.sa_tag * 10 from users,domains where local
15:59:39 55092������ error message: missing } at end of string
15:59:39 55092 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where local
15:59:39 55092������ error message: missing } at end of string
15:59:39 55092 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where local
15:59:39 55092������ error message: missing } at end of string inside "or{...}" condition
15:59:39 55092 virtual_domains router: defer for postmaster@diagnosis.lan.cps-intl.org
15:59:39 55092���� message: virtual_domains router failed to expand "${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${local_part}' and domain = '${domain}' and users.on_spamassassin = 1 and users.domain_id=domains.domain_id}{$value}fail}} } { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${local_part}' and domain = '${domain}' and users.on_spamassassin = 0 and users.domain_id=domains.domain_id}{$value}fail}}} } {X-Spam-Score::X-Spam-Report} }": missing } at end of string inside "or{...}" condition



============================
Test 04 :: tick all the mysql query
-------------------------------------

headers_remove = ${if or { { <{$spam_score_int}{1} } \
������ ������ { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where `localpart` = '${quote_mysql::$local_part}' \
������ ������ and `domain` = '${quote_mysql::$domain}' \
������ ������ and `users.on_spamassassin` = 1 \
������ ������ and `users.domain_id`='domains.domain_id'}{$value}fail}} } \
������ ������ { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains \
������ ������ where `localpart` = '${quote_mysql::$local_part}' \
������ ������ and `domain` = '${quote_mysql::$domain}' \
������ ������ and `users.on_spamassassin` = 0 \
������ ������ and `users.domain_id`='domains.domain_id'}{$value}fail}}} \
������ ������ } {X-Spam-Score::X-Spam-Report} }


Result:
-------
16:04:55 55934 expanding: $spam_score_int
16:04:55 55934������ result: 27
16:04:55 55934 expanding: 1
16:04:55 55934������ result: 1
16:04:55 55934 expanding: $spam_score_int
16:04:55 55934������ result: 27
16:04:55 55934 failed to expand: select users.sa_tag * 10 from users,domains where `loca
16:04:55 55934������ error message: missing } at end of string
16:04:55 55934 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where `loca
16:04:55 55934������ error message: missing } at end of string
16:04:55 55934 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where `loca
16:04:55 55934������ error message: missing } at end of string inside "or{...}" condition
16:04:55 55934 virtual_domains router: defer for postmaster@diagnosis.lan.cps-intl.org
16:04:55 55934���� message: virtual_domains router failed to expand "${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users,domains where `localpart` = '${quote_mysql::$local_part}' and `domain` = '${quote_mysql::$domain}' and `users.on_spamassassin` = 1 and `users.domain_id`='domains.domain_id'}{$value}fail}} } { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,domains where `localpart` = '${quote_mysql::$local_part}' and `domain` = '${quote_mysql::$domain}' and `users.on_spamassassin` = 0 and `users.domain_id`='domains.domain_id'}{$value}fail}}} } {X-Spam-Score::X-Spam-Report} }": missing } at end of string inside "or{...}" condition
16:04:55 55934 added retry item for R:postmaster@diagnosis.lan.cps-intl.org: errno=-1 more_errno=0 flags=0


On 25 September 2014 12:09, Gordon Dickens <gecko@exim4u.org> wrote:
Ah... OK. I thought that there may be more to it than that.�� However, that's fine and I appreciate the tip.

Gordon




On 09/25/2014 07:07 AM, Odhiambo Washington wrote:
Hi Gordon,

I already posted his reply. It was a one liner actually.

All he said was:

"See the changes file.�� The colon in headers-remove now matters."



On 25 September 2014 14:02, Gordon Dickens <gecko@exim4u.org> wrote:
Hi Odhiambo,

This list is setup to reject posters that are not subscribed and so his post unfortunately got rejected....�� So, if you don't mind, please forward his reply.

Thanks!

Gordon




On 09/25/2014 05:59 AM, Odhiambo Washington wrote:
Hi Gordon,

He did a Reply-all and so you perhaps need to release his mail from the moderation of this list.

Anyway, as I suspected, he simply said the following:

<quote>
See the changes file.�� The colon in headers-remove now matters.
</quote>

And I know that makes sense for you:-)



On 25 September 2014 05:48, Gordon Dickens <gecko@exim4u.org> wrote:
That sounds great!�� I look forward to seeing his email. I�� haven't seen it yet so please forward it to me.

Thanks,

Gordon



On 09/24/2014 04:02 PM, Odhiambo Washington wrote:
Hi Gordon,��

He did a reply to all.��

Let me fwd it to you. He actually suggested the solution.��

On Wednesday, 24 September 2014, Gordon Dickens <gecko@exim4u.org> wrote:
Hi Rimas,

Its perfectly fine for you to lurk and post here while using Vexim.�� I just like to know since there are significant differences as I mentioned in my earlier reply to Shah.�� And yes, I would definitely endorse a working cooperation between Vexim and Exim4U.�� Both projects would benefit by sharing one another's work which I am all for. 24 hours just isn't enough time in a day for any of us...

Gordon




On 09/23/2014 02:56 PM, Rimas Kudelis wrote:
Hi Gordon,

2014.09.23 10:52, Gordon Dickens wrote:
You mentioned Vexim in the attached post and, in a post on the
exim-users@exim.org��mailing list, you said that you were using Vexim.
So, please clarify; Are you using Exim4U or Vexim?

Also, others have mentioned Vexim too.�� So, I ask the same question of
Rimas Kudelis, Harald Valkanover and anyone else having this problem;
Are you using Exim4U or Vexim?
to be fair, I use Vexim, but only on one server, which still runs Debian
Squeeze. Hence, I'm not directly suffering from this problem.

The reason why I follow this list and sometimes participate in it is
because I also happen to be the current maintainer/reviewer of Vexim
(although I've been quite passive in that regard recently, and I don't
expect this to change back anytime soon).

This particular problem we're discussing here was registered as Vexim
issue #21 almost four weeks ago (
https://github.com/avleen/vexim2/issues/21 ), and I would like to fix it
on our side, hoping that somebody will find a solution rather sooner
than later.

By the way, do you think it would be possible to have a working
cooperation between Vexim and Exim4U? After all, we do share a lot of
common code, and it doesn't seem very feasible to work on two copies of
it independently.

Rimas

_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
"I can't hear you -- I'm using the scrambler."



_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users