exim 4.84

classic Classic list List threaded Threaded
48 messages Options
123
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Odhiambo Washington
Hi Guys,

It would appear that I haven't hit this problem because I have "SpamRejectScore: 100" on several servers that I run Exim4u+Exim-4.82.

The moment I enabled that, I started seeing the errors mentioned here.

So, my question would be: Why would headers_remove directive cause these internal errors? Something must have changed significantly between 4.82 and 4.83 ( I am not talking about 4.84 because it was a minor fix for 4.83). I upgraded from 4.82 to 4.84 in the machines I manage. Unfortunately, I have had SpamRejectScore at 100 on all of them for quite some time because I use other spam filtering options.


I suppose and maybe someone has time to take a keen look at::

I have looked briefly at it and I *suspect* the following changes might give a clue:

--------------------------
JH/12  Expand items in router/transport headers_add or headers_remove lists
90       individually rather than the list as a whole.  Bug 1452.
92       Required for reasonable handling of multiple headers_ options when
93       they may be empty; requires that headers_remove items with embedded
94       colons must have them doubled (or the list-separator changed).
-----------------

I decided to run Exim in debug mode briefly on my very busy server and here is where the errors surface on the virtual_domains router:


16:25:07 67108 expanding: ${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}
16:25:07 67108    result: 50
16:25:07 67108 condition: >={$acl_m_spamscore}{${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 sers.domain_id=domains.domain_id }{$value}fail}}
16:25:07 67108    result: false
16:25:07 67108 expanding: SpamTagText
16:25:07 67108    result: SpamTagText
16:25:07 67108 skipping: result is not used
16:25:07 67108 expanding: /etc/exim/exim4u_global_spam_virus
16:25:07 67108    result: /etc/exim/exim4u_global_spam_virus
16:25:07 67108 skipping: result is not used
16:25:07 67108 expanding: X-Spam-Flag: YES\nSubject: [${lookup{SpamTagText}lsearch{/etc/exim/exim4u_global_spam_virus}}] $h_Subject:\n
16:25:07 67108    result: X-Spam-Flag: YES
16:25:07 67108 Subject: []
16:25:07 67108
16:25:07 67108 skipping: result is not used
16:25:07 67108 expanding: X-Spam-Flag: NO\n
16:25:07 67108    result: X-Spam-Flag: NO
16:25:07 67108
16:25:07 67108 expanding: ${if >={$acl_m_spamscore}{${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\nSubject: [${lookup{SpamTagText}lsearch{/etc/exim/exim4u_global_spam_virus}}] $h_Subject:\n}{X-Spam-Flag: NO\n}}
16:25:07 67108    result: X-Spam-Flag: NO
16:25:07 67108
16:25:07 67108 expanding: $acl_m_spamscore
16:25:07 67108    result:
16:25:07 67108 empty string cast to zero for numerical comparison
16:25:07 67108 failed to expand: select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql
16:25:07 67108    error message: "${quote_mysql" is not a known operator (or a } is missing in a variable reference)
16:25:07 67108 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql
16:25:07 67108    error message: "${quote_mysql" is not a known operator (or a } is missing in a variable reference)
16:25:07 67108 failed to expand: ${if >={$acl_m_spamscore}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_
mysql
16:25:07 67108    error message: "${quote_mysql" is not a known operator (or a } is missing in a variable reference)
16:25:07 67108 virtual_domains router: defer for [hidden email]
16:25:07 67108   message: virtual_domains router failed to expand "${if >={$acl_m_spamscore}{${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=d
omains.domain_id }{$value}fail}} {Subject}{${if eq{SPAMHEADERTYPE}{0}{X-Spam-Report}}}  }": "${quote_mysql" is not a known operator (or a } is missing in a variable reference)



This is an issue directly from virtual_domains router and exactly from the headers_remove part:

# exim4u: This router routes to virtual domains with spamassassin filtering
virtual_domains:
  condition =  ${if < {SPAMREJECT}{1000}}
  driver = redirect
  allow_fail
  data = ${lookup mysql{select smtp from users,domains \
                where localpart = '${quote_mysql:$local_part}' \
                and domain = '${quote_mysql:$domain}' \
                and domains.enabled = '1' \
                and users.enabled = '1' \
                and users.domain_id = domains.domain_id}}

# exim4u header_remove to remove subject if spam or X-Spam-Report if not spam and SPAMHEADERTYPE=0.
  headers_remove = ${if >={$acl_m_spamscore}{${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}} \
                {Subject}{${if eq{SPAMHEADERTYPE}{0}{X-Spam-Report}}}  \
                }

# exim4u header_add to add X-Spam-Flag for all mail and rewrite Subject if spam.
  headers_add = ${if >={$acl_m_spamscore}{${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\nSubject: [SPAMTAGTEXT] $h_Subject:\n}{X-Spam-Flag: NO\n}\
                }
# local_part_suffix = -*
# local_part_suffix_optional
  retry_use_local_part
# file_transport = virtual_delivery
  file_transport = dovecot_virtual_delivery
  reply_transport = address_reply
  pipe_transport = address_pipe



So, Gordon, can you possibly take a look at the query again to see where you can introduce improvements.

Given that Jeremy Harris did some work around this portion, I have taken the liberty to request for his input on the same. He is not subscribed to this list and might get really pissed off, or this mail might end up as spam, but let me try:)

PS: Jeremy, I hope I don't piss you off with this. Please advise us on what's wrong with our headers_remove query since Exim-4.8{3|4} and thank you in advance.



On 23 September 2014 15:46, Shamim Shahriar <[hidden email]> wrote:


On 23 Sep 2014 08:52, "Gordon Dickens" <[hidden email]> wrote:
>
> Hi Shah,
>
> You mentioned Vexim in the attached post and, in a post on the  [hidden email] 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?
>
> Thanks,
>
>
> Gordon
>
>

Hi Gordon

I am using vexim, on FreeBSD 9 release, currently with exim 4.82. We made some customisation for the configure in Exim, and plenty of "improvements" for the gui in vexim. Once i noticed the problems after updating Exim in one of the test servers, Google brought me to Exim4u list as the problems were similar. And as it seems, solution to one will eventually bring solution to all. Hence i put the discussion both to exim4u and Exim-user list.

Hope this clears up any confusion.

Thanks
Shah


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Rimas Kudelis
In reply to this post by gldickens3
Hi Gordon,

2014.09.23 10:52, Gordon Dickens wrote:
> You mentioned Vexim in the attached post and, in a post on the
> [hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

gldickens3
Administrator
In reply to this post by Shamim Shahriar
Hi Shah,  That's fine. No problem. Nevertheless, when you post about a problem you need to let us know that you are using Vexim.  I made alot of changes to exim.conf going from Vexim to Exim4U so it is important to note.

Gordon



On 09/23/2014 08:46 AM, Shamim Shahriar wrote:


On 23 Sep 2014 08:52, "Gordon Dickens" <[hidden email]> wrote:
>
> Hi Shah,
>
> You mentioned Vexim in the attached post and, in a post on the  [hidden email] 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?
>
> Thanks,
>
>
> Gordon
>
>

Hi Gordon

I am using vexim, on FreeBSD 9 release, currently with exim 4.82. We made some customisation for the configure in Exim, and plenty of "improvements" for the gui in vexim. Once i noticed the problems after updating Exim in one of the test servers, Google brought me to Exim4u list as the problems were similar. And as it seems, solution to one will eventually bring solution to all. Hence i put the discussion both to exim4u and Exim-user list.

Hope this clears up any confusion.

Thanks
Shah



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

gldickens3
Administrator
In reply to this post by Odhiambo Washington
Hi Odhiambo,

Thanks for the research and also for seeking Jeremy's help.  Please let us know what he says.

I am busy on other things but will be able to start working on this within a couple of weeks.  I will first have to configure a server with FreeBSD or some other OS that has Exim 4.83 or 4.84 but that is not a problem except for the time to get it configured. If anybody else achieves a resolution on this issue beforehand then please let me know.

Thanks again!

Gordon



On 09/23/2014 10:10 AM, Odhiambo Washington wrote:
Hi Guys,

It would appear that I haven't hit this problem because I have "SpamRejectScore: 100" on several servers that I run Exim4u+Exim-4.82.

The moment I enabled that, I started seeing the errors mentioned here.

So, my question would be: Why would headers_remove directive cause these internal errors? Something must have changed significantly between 4.82 and 4.83 ( I am not talking about 4.84 because it was a minor fix for 4.83). I upgraded from 4.82 to 4.84 in the machines I manage. Unfortunately, I have had SpamRejectScore at 100 on all of them for quite some time because I use other spam filtering options.


I suppose and maybe someone has time to take a keen look at::

I have looked briefly at it and I *suspect* the following changes might give a clue:

--------------------------
JH/12  Expand items in router/transport headers_add or headers_remove lists
90       individually rather than the list as a whole.  Bug 1452.
92       Required for reasonable handling of multiple headers_ options when
93       they may be empty; requires that headers_remove items with embedded
94       colons must have them doubled (or the list-separator changed).
-----------------

I decided to run Exim in debug mode briefly on my very busy server and here is where the errors surface on the virtual_domains router:


16:25:07 67108 expanding: ${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}
16:25:07 67108    result: 50
16:25:07 67108 condition: >={$acl_m_spamscore}{${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 sers.domain_id=domains.domain_id }{$value}fail}}
16:25:07 67108    result: false
16:25:07 67108 expanding: SpamTagText
16:25:07 67108    result: SpamTagText
16:25:07 67108 skipping: result is not used
16:25:07 67108 expanding: /etc/exim/exim4u_global_spam_virus
16:25:07 67108    result: /etc/exim/exim4u_global_spam_virus
16:25:07 67108 skipping: result is not used
16:25:07 67108 expanding: X-Spam-Flag: YES\nSubject: [${lookup{SpamTagText}lsearch{/etc/exim/exim4u_global_spam_virus}}] $h_Subject:\n
16:25:07 67108    result: X-Spam-Flag: YES
16:25:07 67108 Subject: []
16:25:07 67108
16:25:07 67108 skipping: result is not used
16:25:07 67108 expanding: X-Spam-Flag: NO\n
16:25:07 67108    result: X-Spam-Flag: NO
16:25:07 67108
16:25:07 67108 expanding: ${if >={$acl_m_spamscore}{${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\nSubject: [${lookup{SpamTagText}lsearch{/etc/exim/exim4u_global_spam_virus}}] $h_Subject:\n}{X-Spam-Flag: NO\n}}
16:25:07 67108    result: X-Spam-Flag: NO
16:25:07 67108
16:25:07 67108 expanding: $acl_m_spamscore
16:25:07 67108    result:
16:25:07 67108 empty string cast to zero for numerical comparison
16:25:07 67108 failed to expand: select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql
16:25:07 67108    error message: "${quote_mysql" is not a known operator (or a } is missing in a variable reference)
16:25:07 67108 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_mysql
16:25:07 67108    error message: "${quote_mysql" is not a known operator (or a } is missing in a variable reference)
16:25:07 67108 failed to expand: ${if >={$acl_m_spamscore}{${lookup mysql{select users.sa_tag * 10 from users,domains where localpart = '${quote_
mysql
16:25:07 67108    error message: "${quote_mysql" is not a known operator (or a } is missing in a variable reference)
16:25:07 67108 virtual_domains router: defer for [hidden email]
16:25:07 67108   message: virtual_domains router failed to expand "${if >={$acl_m_spamscore}{${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=d
omains.domain_id }{$value}fail}} {Subject}{${if eq{SPAMHEADERTYPE}{0}{X-Spam-Report}}}  }": "${quote_mysql" is not a known operator (or a } is missing in a variable reference)



This is an issue directly from virtual_domains router and exactly from the headers_remove part:

# exim4u: This router routes to virtual domains with spamassassin filtering
virtual_domains:
  condition =  ${if < {SPAMREJECT}{1000}}
  driver = redirect
  allow_fail
  data = ${lookup mysql{select smtp from users,domains \
                where localpart = '${quote_mysql:$local_part}' \
                and domain = '${quote_mysql:$domain}' \
                and domains.enabled = '1' \
                and users.enabled = '1' \
                and users.domain_id = domains.domain_id}}

# exim4u header_remove to remove subject if spam or X-Spam-Report if not spam and SPAMHEADERTYPE=0.
  headers_remove = ${if >={$acl_m_spamscore}{${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}} \
                {Subject}{${if eq{SPAMHEADERTYPE}{0}{X-Spam-Report}}}  \
                }

# exim4u header_add to add X-Spam-Flag for all mail and rewrite Subject if spam.
  headers_add = ${if >={$acl_m_spamscore}{${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\nSubject: [SPAMTAGTEXT] $h_Subject:\n}{X-Spam-Flag: NO\n}\
                }
# local_part_suffix = -*
# local_part_suffix_optional
  retry_use_local_part
# file_transport = virtual_delivery
  file_transport = dovecot_virtual_delivery
  reply_transport = address_reply
  pipe_transport = address_pipe



So, Gordon, can you possibly take a look at the query again to see where you can introduce improvements.

Given that Jeremy Harris did some work around this portion, I have taken the liberty to request for his input on the same. He is not subscribed to this list and might get really pissed off, or this mail might end up as spam, but let me try:)

PS: Jeremy, I hope I don't piss you off with this. Please advise us on what's wrong with our headers_remove query since Exim-4.8{3|4} and thank you in advance.



On 23 September 2014 15:46, Shamim Shahriar <[hidden email]> wrote:


On 23 Sep 2014 08:52, "Gordon Dickens" <[hidden email]> wrote:
>
> Hi Shah,
>
> You mentioned Vexim in the attached post and, in a post on the  [hidden email] 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?
>
> Thanks,
>
>
> Gordon
>
>

Hi Gordon

I am using vexim, on FreeBSD 9 release, currently with exim 4.82. We made some customisation for the configure in Exim, and plenty of "improvements" for the gui in vexim. Once i noticed the problems after updating Exim in one of the test servers, Google brought me to Exim4u list as the problems were similar. And as it seems, solution to one will eventually bring solution to all. Hence i put the discussion both to exim4u and Exim-user list.

Hope this clears up any confusion.

Thanks
Shah


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

gldickens3
Administrator
In reply to this post by Rimas Kudelis
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
>> [hidden email] 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
> [hidden email]
> https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Odhiambo Washington
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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

gldickens3
Administrator
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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Odhiambo Washington
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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

gldickens3
Administrator
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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Odhiambo Washington
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

gldickens3
Administrator
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Shamim Shahriar
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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]: errno=-1 more_errno=0 flags=0


On 25 September 2014 12:09, Gordon Dickens <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Shamim Shahriar
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 <[hidden email]> 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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]: errno=-1 more_errno=0 flags=0


On 25 September 2014 12:09, Gordon Dickens <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

valki
Hi sham!  I can second that! As soon as the condition is too complex/long -> the expand fails.

Shamim Shahriar <[hidden email]> schrieb am 25.09.2014:
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 <[hidden email]> 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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]: errno=-1 more_errno=0 flags=0


On 25 September 2014 12:09, Gordon Dickens <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a shape="rect" href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a shape="rect" href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a shape="rect" href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a shape="rect" href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a shape="rect" href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a shape="rect" href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users





users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users

-- Diese Nachricht wurde mit K-@ Mail gesendet.
_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Shamim Shahriar
Hi Valki, thanks for the confirmation. Much appreciated.

I think this is more about length rather than the complexity -- which I think are different issues. But let us not quibble over semantics.

Do we have anyone from the Exim team in this list who can find some time to check and verify this? Or even if not from the Exim team, anyone with enough knowledge of the code to check and confirm if this is the correct diagnosis?

Thanks
Shah

On 25 September 2014 16:28, Harald Valkanover <[hidden email]> wrote:
Hi sham!  I can second that! As soon as the condition is too complex/long -> the expand fails.

Shamim Shahriar <[hidden email]> schrieb am 25.09.2014:
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 <[hidden email]> 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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]: errno=-1 more_errno=0 flags=0


On 25 September 2014 12:09, Gordon Dickens <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a shape="rect" href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a shape="rect" href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a shape="rect" href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a shape="rect" href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a shape="rect" href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a shape="rect" href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users





users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users

-- Diese Nachricht wurde mit K-@ Mail gesendet.

_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Rimas Kudelis
In reply to this post by Shamim Shahriar
Hi folks,
this would make sense. It would explain why regardless of the number of closing braces you'd add, the condition fails.
Just to make sure that it's not just logs where the cropping occurs, could you find a working condition and break it by introducing some random whitespace or other useless chars in it?

On 2014 m. rugsėjis 25 d. 18:20:26 EEST, Shamim Shahriar <[hidden email]> wrote:
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 <[hidden email]> 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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]
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 [hidden email]: errno=-1 more_errno=0 flags=0


On 25 September 2014 12:09, Gordon Dickens <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email] 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
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users




--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
<a href="tel:%2B254733744121" value="+254733744121" target="_blank">+254733744121/<a href="tel:%2B254722743223" value="+254722743223" target="_blank">+254722743223
"I can't hear you -- I'm using the scrambler."


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users





users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users

--
Išsiųsta iš mano Android įrenginio naudojant „K-9 Mail“.
_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Shamim Shahriar
On 25/09/2014 19:14, Rimas Kudelis wrote:
> Hi folks,
> this would make sense. It would explain why regardless of the number
> of closing braces you'd add, the condition fails.
> Just to make sure that it's not just logs where the cropping occurs,
> could you find a working condition and break it by introducing some
> random whitespace or other useless chars in it?
>
Tried a few more things, most importantly tried to change this into a
macro as per example from here
http://www.exim.org/exim-html-current/doc/html/spec_html/ch-the_exim_run_time_configuration_file.html
point 8

Thus, created a Macro like below (above router definition)

SA_Query = 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;

both with double and single colon, and got the same error as before.

Then changed the Macro to below
SA_Query = select users.sa_tag * 10 from users,domains ;

And lo! the error changed to below

22:48:49 16989 failed to expand: ${lookup mysql{select users.sa_tag * 10
from users,domains ;}{$value}f
22:48:49 16989    error message: syntax error in "lookup" item - "fail"
expected
22:48:49 16989 failed to expand: ${if or { { <{$spam_score_int}{1} } {
<{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from
users,domains ;}{$value}f
22:48:49 16989    error message: syntax error in "lookup" item - "fail"
expected inside "or{...}" condition
22:48:49 16989 virtual_domains router: defer for

Which looks like the same length issue to me (but to be quite honest,
had a very very long day and I am not that confident on my findings --
brain is not functioning at optimum level now :P).

I do recall in one of the emails I read someone suggested using Macros
instead of long query, and thought it would work. But apparently it will
not -- given that all macro is blown to full within the headers_remove
section, which in turn is exhibiting that length limit issue which got
us to this situation on the first place. So, what other things can/shall
we try? Ideas?

All the best
Shah

_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Shamim Shahriar
On 25/09/2014 23:17, Shamim Shahriar wrote:
On 25/09/2014 19:14, Rimas Kudelis wrote:
Hi folks,
this would make sense. It would explain why regardless of the number
of closing braces you'd add, the condition fails.
Just to make sure that it's not just logs where the cropping occurs,
could you find a working condition and break it by introducing some
random whitespace or other useless chars in it?


Rimas, you wanted to see a length change factor, sorry I forgot to add this bit.

With
SA_Query = select users.sa_tag * 10 from users,domains ;

the error is
22:48:49 16989 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains ;}{$value}f


and with
SA_Query = select users.sa_tag * 10 from users,domains
(the line literally ends at the last s)

the error is
23:06:44 19963 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains}{$value}fai


putting them together, I'd say they do exhibit the symptoms of length issues

23:06:44 19963 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains}{$value}fai
22:48:49 16989 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains ;}{$value}f


And then, I changed it to something even shorter
SA_Query = select users.sa_tag from users,domains

and that expanded to
23:30:13 23669 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag from users,domains}{$value}fail}} }
23:30:13 23669    error message: invalid integer "2

which indicates that the query part of it did work out (even though the result did not have any meaning, but the 'select' part worked) when it was shortened to an impractical (IMHO) length. I cannot think of any practical/functional query that I can fit in this short length -- but then again, I am not a sql expert, maybe someone with a better knowledge can fit that long query into this smaller space -- but I surely cannot.

Does is help in what you are looking for?

I need to turn in now. All the best
Shah


_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Shamim Shahriar
Hello All

now I am even more convinced that it is not just the "lookup mysql", but the entire headers_remove is suffering. Please find below the changes I made and the results I received.

Thanks
Shah

----

change:
SA_Query = select sa_tag from users limit 1

result:
09:30:08 17194 expanding: ${lookup mysql{select sa_tag from users limit 1}{$value}fail}
09:30:08 17194    result: 2
09:30:08 17194 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1}{$value}fail}} } { eq
09:30:08 17194    error message: missing { after "eq" inside "or{...}" condition



change:
SA_Query = select sa_tag from users limit 1;

result:
09:35:35 17922 expanding: ${lookup mysql{select sa_tag from users limit 1;}{$value}fail}
09:35:35 17922    result: 2
09:35:35 17922 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}} } { eq
09:35:35 17922    error message: missing { after "eq" inside "or{...}" condition



changed headers_remove to as below keep the SA_Query as above:
headers_remove = ${if or { { <{$spam_score_int}{1} } \
                { <{$spam_score_int}{${lookup mysql{SA_Query}{$value}fail}} } \
                } {X-Spam-Score:X-Spam-Report} }

result:
09:43:51 18778 expanding: ${lookup mysql{select sa_tag from users limit 1;}{$value}fail}
09:43:51 18778    result: 2
09:43:51 18778 condition: or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}} } }
09:43:51 18778    result: false
09:43:51 18778 failed to expand: X
09:43:51 18778    error message: missing } at end of string
09:43:51 18778 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}} } } {X
09:43:51 18778    error message: missing } at end of string



changed headers_remove to as below keep the SA_Query as above:
headers_remove = ${if or { { <{$spam_score_int}{1} } \
              { eq {0}{${lookup mysql{SA_Query}{$value}fail}}} \
                } {X-Spam-Score:X-Spam-Report} }

result:
09:49:35 19577 expanding: ${lookup mysql{select sa_tag from users limit 1;}{$value}fail}
09:49:35 19577    result: 2
09:49:35 19577 condition: or { { <{$spam_score_int}{1} } { eq {0}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}}} }
09:49:35 19577    result: false
09:49:35 19577 failed to expand: X-Spam-Score
09:49:35 19577    error message: missing } at end of string
09:49:35 19577 failed to expand: ${if or { { <{$spam_score_int}{1} } { eq {0}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}}} } {X-Spam-Score
09:49:35 19577    error message: missing } at end of string



On 25 September 2014 23:49, Shamim Shahriar <[hidden email]> wrote:
On 25/09/2014 23:17, Shamim Shahriar wrote:
On 25/09/2014 19:14, Rimas Kudelis wrote:
Hi folks,
this would make sense. It would explain why regardless of the number
of closing braces you'd add, the condition fails.
Just to make sure that it's not just logs where the cropping occurs,
could you find a working condition and break it by introducing some
random whitespace or other useless chars in it?


Rimas, you wanted to see a length change factor, sorry I forgot to add this bit.

With
SA_Query = select users.sa_tag * 10 from users,domains ;

the error is
22:48:49 16989 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains ;}{$value}f


and with
SA_Query = select users.sa_tag * 10 from users,domains
(the line literally ends at the last s)

the error is
23:06:44 19963 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains}{$value}fai


putting them together, I'd say they do exhibit the symptoms of length issues

23:06:44 19963 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains}{$value}fai
22:48:49 16989 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains ;}{$value}f


And then, I changed it to something even shorter
SA_Query = select users.sa_tag from users,domains

and that expanded to
23:30:13 23669 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag from users,domains}{$value}fail}} }
23:30:13 23669    error message: invalid integer "2

which indicates that the query part of it did work out (even though the result did not have any meaning, but the 'select' part worked) when it was shortened to an impractical (IMHO) length. I cannot think of any practical/functional query that I can fit in this short length -- but then again, I am not a sql expert, maybe someone with a better knowledge can fit that long query into this smaller space -- but I surely cannot.

Does is help in what you are looking for?

I need to turn in now. All the best
Shah



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: exim 4.84

Shamim Shahriar
my last diagnosis report

SA_Query = select sa_tag from users limit 1;

headers_remove = ${if or{{<{2}{1}} \
                { eq {0}{${lookup mysql{SA_Query}{$value}fail}}} \
                }{X-Spam-Score::X-Spam-Report}}

and it is working. Please note, the changes from the previous non-working one is the removal of spaces between the curly brackets -- i.e., shortening the length of the conditions. i.e., same condition with larger string-length fails.

Could someone please check and let me know if I have missed something very obvious then that will be greatly appreciated.

Thanks all
Shah

On 26 September 2014 09:56, Shamim Shahriar <[hidden email]> wrote:
Hello All

now I am even more convinced that it is not just the "lookup mysql", but the entire headers_remove is suffering. Please find below the changes I made and the results I received.

Thanks
Shah

----

change:
SA_Query = select sa_tag from users limit 1

result:
09:30:08 17194 expanding: ${lookup mysql{select sa_tag from users limit 1}{$value}fail}
09:30:08 17194    result: 2
09:30:08 17194 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1}{$value}fail}} } { eq
09:30:08 17194    error message: missing { after "eq" inside "or{...}" condition



change:
SA_Query = select sa_tag from users limit 1;

result:
09:35:35 17922 expanding: ${lookup mysql{select sa_tag from users limit 1;}{$value}fail}
09:35:35 17922    result: 2
09:35:35 17922 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}} } { eq
09:35:35 17922    error message: missing { after "eq" inside "or{...}" condition



changed headers_remove to as below keep the SA_Query as above:
headers_remove = ${if or { { <{$spam_score_int}{1} } \
                { <{$spam_score_int}{${lookup mysql{SA_Query}{$value}fail}} } \
                } {X-Spam-Score:X-Spam-Report} }

result:
09:43:51 18778 expanding: ${lookup mysql{select sa_tag from users limit 1;}{$value}fail}
09:43:51 18778    result: 2
09:43:51 18778 condition: or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}} } }
09:43:51 18778    result: false
09:43:51 18778 failed to expand: X
09:43:51 18778    error message: missing } at end of string
09:43:51 18778 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}} } } {X
09:43:51 18778    error message: missing } at end of string



changed headers_remove to as below keep the SA_Query as above:
headers_remove = ${if or { { <{$spam_score_int}{1} } \
              { eq {0}{${lookup mysql{SA_Query}{$value}fail}}} \
                } {X-Spam-Score:X-Spam-Report} }

result:
09:49:35 19577 expanding: ${lookup mysql{select sa_tag from users limit 1;}{$value}fail}
09:49:35 19577    result: 2
09:49:35 19577 condition: or { { <{$spam_score_int}{1} } { eq {0}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}}} }
09:49:35 19577    result: false
09:49:35 19577 failed to expand: X-Spam-Score
09:49:35 19577    error message: missing } at end of string
09:49:35 19577 failed to expand: ${if or { { <{$spam_score_int}{1} } { eq {0}{${lookup mysql{select sa_tag from users limit 1;}{$value}fail}}} } {X-Spam-Score
09:49:35 19577    error message: missing } at end of string



On 25 September 2014 23:49, Shamim Shahriar <[hidden email]> wrote:
On 25/09/2014 23:17, Shamim Shahriar wrote:
On 25/09/2014 19:14, Rimas Kudelis wrote:
Hi folks,
this would make sense. It would explain why regardless of the number
of closing braces you'd add, the condition fails.
Just to make sure that it's not just logs where the cropping occurs,
could you find a working condition and break it by introducing some
random whitespace or other useless chars in it?


Rimas, you wanted to see a length change factor, sorry I forgot to add this bit.

With
SA_Query = select users.sa_tag * 10 from users,domains ;

the error is
22:48:49 16989 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains ;}{$value}f


and with
SA_Query = select users.sa_tag * 10 from users,domains
(the line literally ends at the last s)

the error is
23:06:44 19963 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains}{$value}fai


putting them together, I'd say they do exhibit the symptoms of length issues

23:06:44 19963 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains}{$value}fai
22:48:49 16989 failed to expand: ${lookup mysql{select users.sa_tag * 10 from users,domains ;}{$value}f


And then, I changed it to something even shorter
SA_Query = select users.sa_tag from users,domains

and that expanded to
23:30:13 23669 failed to expand: ${if or { { <{$spam_score_int}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag from users,domains}{$value}fail}} }
23:30:13 23669    error message: invalid integer "2

which indicates that the query part of it did work out (even though the result did not have any meaning, but the 'select' part worked) when it was shortened to an impractical (IMHO) length. I cannot think of any practical/functional query that I can fit in this short length -- but then again, I am not a sql expert, maybe someone with a better knowledge can fit that long query into this smaller space -- but I surely cannot.

Does is help in what you are looking for?

I need to turn in now. All the best
Shah




_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users
123