Looking at whether Zen-listed IPs keep trying to send us email

Here's a question: when an IP address listed in the Spamhaus Zen gets rejected, does it come back later or are most visits a one-time thing? This time I pulled 90 days worth of logs, extracted each day's rejections from Zen-listed IPs, and checked to see how many IPs showed up in more than one day's logs.

(Because an IP could be trying to deliver stuff right when the logs roll, the safe question is how many IPs show up in more than two days worth of logs.)

The first answer is that we have some persistent IPs but not anything that is really hammering on us. Well, at least if you look at the data this way. Here, have a table:

212.174.85.13024 days SBL107558
89.204.63.22820 days SBL168886 and the PBL
189.112.34.21518 days SBL153384
82.165.159.3415 daysweb.de; SBL175032
82.165.159.3513 daysweb.de and SBL175032 again
82.165.159.310 daysweb.de but now SBL175030 , which is basically the same as SBL175032 ; web.de is clearly good at getting SBL-listed.
217.133.203.3410 days SBL157999
115.93.88.5010 daysIn the PBL
82.165.159.29 daysweb.de yet again, SBL175030
218.38.136.799 days SBL146938
216.104.35.85
216.104.35.86
216.104.35.90
9 daysNo longer listed.
200.68.99.1969 days SBL CSS
186.1.192.239 days SBL172432

(This table probably doesn't look that nice in the syndication feed.)

Now things get interesting, because I noticed a pattern and went digging. All of the IPs from 216.104.35.83 through 216.104.35.94 got rejected by us at various times in the 90 days, and all of them were rejected on multiple days. Even more interesting, the rejections stretch from day 11 through day 90 (although not continuously).

(The gaps in rejections could be either because they stopped sending to email addresses that were rejecting them, because they dropped out of Zen temporarily, or both of the above.)

This prompted me to look at /24-based reoccurrence, and there things get more interesting:

173.242.121.0/2446 daysOne IP still in the SBL CSS
198.64.159.0/2445 days13 of 23 IPs still in the SBL CSS
216.104.35.0/2443 daysNothing still listed out of the 12 IPs we rejected from this
82.165.159.0/2430 daysweb.de, mentioned above; all four IPs still in their SBL listings
177.47.102.0/2427 days SBL136747 , a /24 listing dating from August 14, 2012
212.174.85.0/2426 days SBL107558 ; one of the single IPs made it into the single-IP list
178.210.168.0/2425 daysMultiple IPs still in the SBL CSS
216.229.59.0/2422 daysMultiple IPs still in the SBL CSS

I'm going to stop here because the next '/24' is actually due to a single IP (89.204.63.228) so we're reaching the crossover point (besides, I'm doing this all more or less by hand).

What really surprises me from looking at the by-/24 breakdown is how active the SBL CSS clearly is. If someone told me that the SBL CSS was now the largest single contributor for spam rejections, I wouldn't be surprised.

(I can't verify that without changing our mail configuration to add more logging (since SBL CSS listings expire, we'd have to capture the Zen results at the time of the actual rejection). Sadly my curiosity is not worth that.)

(This is kind of a followup to looking to see if IP addresses persist in Zen .)

Sidebar: a way in which these results may not be representative

We do Zen-based rejections only for some email addresses (only those that have opted in to it). So a Zen-listed sending IP wouldn't necessarily see continuous rejections if they kept sending to us. It depends on what email addresses they are sending to that day and they could have a day with no rejections.

I haven't tried to dig into the raw logs to see if this is happening for some of these IPs, or in general if these IPs saw a mix of successful deliveries and rejections or if they saw uniform rejections. I don't know if I'll ever do this level of analysis, since it's going past what I can easily bash together with shell scripts and awk . Past the land of shell scripts lies the land of real work.