Re: amavisd-new & broken mysql

2019-08-18 Thread Tom Sommer
On 2019-06-13 10:17, p...@cpan.org wrote: Hello! For more then 2 years people complain about semi-broken support when amavisd-new use MySQL database as a storage via DBD::mysql driver. See e.g. this ticket: https://github.com/perl5-dbi/DBD-mysql/issues/78 In past I tried to fix this

Re: amavisd-new & broken mysql

2019-06-13 Thread Tom Sommer
On 2019-06-13 11:38, p...@cpan.org wrote: As far as I can see untaint() forces a string value, which fucks up the DBD::mysql driver. I'm not sure that this is the problem. What we debugged two years ago was problem with magical scalars which are on output -- not input. You are correct

Re: amavisd-new & broken mysql

2019-06-13 Thread Tom Sommer
On 2019-06-13 10:17, p...@cpan.org wrote: For more then 2 years people complain about semi-broken support when amavisd-new use MySQL database as a storage via DBD::mysql driver. See e.g. this ticket: https://github.com/perl5-dbi/DBD-mysql/issues/78 In past I tried to fix this problem in

Re: amavis behind haproxy

2018-10-09 Thread Tom Sommer
On 2018-09-19 14:15, Vitali Quiering wrote: I thought about the setup like this: Postfix receives the mail and sends it (content-filter) to the haproxy on port 10024 which passes the tcp connection to one of the amavis servers on port 10024. After scanning amavis sends it back to postfix on

Re: ANNOUNCE: Amavis project handed over to new project leaders

2018-10-09 Thread Tom Sommer
On 2018-10-09 19:46, Mark Martinec wrote: I'll skip my apologies for being unresponsive for the past two years, there's not enough room in this mail message :) My interests, duties and priorities have shifted, and amavisd was running smoothly at our site (still is), so there was less

Re: Is amavisd-new still being maintained?

2018-10-08 Thread Tom Sommer
On 2018-10-08 09:37, Boris Gulay wrote: Benny Pedersen писал 2018-10-08 00:18: Boris Gulay skrev den 2018-10-07 21:24: Benny Pedersen писал 2018-10-07 17:34: Ralph Seichter skrev den 2018-10-07 14:48: On 07.10.18 12:12, Alexander Dalloz wrote: That's too a one man show? See

Re: Is amavisd-new still being maintained?

2018-10-08 Thread Tom Sommer
On 2018-10-08 01:39, Ralph Seichter wrote: On 08.10.18 01:09, Dave McGuire wrote: are there any bugs in amavisd-new that anyone cares about at this point? Yes, DKIM-related, see my original message. From what I can tell the available patch does not fix everything. Because of this issue I

Re: amavis behind haproxy

2018-09-19 Thread Tom Sommer
On 2018-09-19 14:15, Vitali Quiering wrote: I already got the forward_method, socket_bind and inet_acl setup correctly. The problem I’m facing now is the ip that amavis sees and wants to send the result to. This is the haproxy ip address which of course doesn’t work. The problem is, IIRC,

Re: Bug in amavisd-new, or p5-DBD-mysql?

2018-09-18 Thread Tom Sommer
On 2018-09-17 19:00, David Newman wrote: On 9/17/18 2:58 AM, Tom Sommer wrote: I'm frankly not qualified to answer: Is this an amavisd problem, or a p5-DBD-mysql problem? As it is, amavisd-new is getting bad data. FYI: I just hit this issue when updating DBD::mysql to 4.048, reverting

Re: Bug in amavisd-new, or p5-DBD-mysql?

2018-09-17 Thread Tom Sommer
On 2018-08-29 17:35, David Newman wrote: On 8/27/18 12:40 PM, David Newman wrote: Again answering my own post: After a lot of searching, I found reports of a previously known type-conversion bug in the Perl DBD-MySQL module (aka p5-DBD-mysql on FreeBSD):

Redis log data in IDN

2016-06-10 Thread Tom Sommer
Would it be possible to change so Redis/logstash data is always using IDN? rcpt_to, to_addr is not in IDN format, while rcpt_to_orig is. The mix of it is very confusing. Thanks -- Tom

Disable antispam/antivirus by default

2015-01-10 Thread Tom Sommer
What is the best-practice way to disable antispam and antivirus checks by default, and only enable it for the users in $sql_select_policy ? Thanks. -- Tom Sommer

Re: Disable antispam/antivirus by default

2015-01-10 Thread Tom Sommer
On 2015-01-10 15:06, A. Schulze wrote: Tom Sommer: What is the best-practice way to disable antispam and antivirus checks by default, and only enable it for the users in $sql_select_policy ? look at the first lines in amavisd.conf: # COMMONLY ADJUSTED SETTINGS

Re: Proxy protocol support

2014-11-17 Thread Tom Sommer
On 2014-10-30 20:10, Michael Schwartzkopff wrote: Am Donnerstag, 30. Oktober 2014, 20:07:07 schrieb Tom Sommer: So how do you make sure the postfix and amavis instances see the IP of the mailserver and not of the haproxy server? --- Tom Sommer Use a loadbalancer and not a proxy. Any

RE: Proxy protocol support

2014-11-17 Thread Tom Sommer
On 2014-10-31 06:15, Benny Pedersen wrote: On October 30, 2014 8:12:15 PM Tom Sommer m...@tomsommer.dk wrote: -- postfix (in, port 25) -- haproxy -- amavisd -- postfix (in, port 10025) Imho amavisd have hidded featuere to use client-ip to send back to if you replace postfix server ip

Re: White/Blacklist affects ip_repuation

2014-10-31 Thread Tom Sommer
On 2014-10-31 10:36, Benny Pedersen wrote: On October 31, 2014 10:13:52 AM Tom Sommer m...@tomsommer.dk wrote: When a user white/blacklists a sender, the IP reputation done by amavis is affected. Where is this reputation ? The new Redis IP reputation feature. --- Tom Sommer

RE: Proxy protocol support

2014-10-30 Thread Tom Sommer
is: -- postfix (in, port 25) -- haproxy -- amavisd -- postfix (in, port 10025) But amavisd doesnt know what postfix server to return the mail to (I have multiple, but want central amavis cluster), because it only sees the haproxy IP. Does that make sense? :) Thanks --- Tom Sommer