|
Mar
03
2009
DSPAM: Converting from the hash driver to MySQL driverPosted by fli in Tech, tags: DSPAM, hash, MySQL, SQL…or annoyances with the DSPAM hash driverI’ve been running DSPAM for a long time and the spam classification is great, unfortunately the maintenance tools are not as it turns out. This is the tale of why and more especially HOW I moved from the hash driver to the mysql driver as a backend for my DSPAM installation.
The “Authenticated sender” is added when a user has been authenticated by the MTA through SASL and the directive smtpd_sasl_authenticated_header have been set to yes. The header_checks directive takes a file containing a regular expression which rewrites the header data and removes sensitive information. This all works well – with IPv4. The regular expression posted on the pages mentioned above does not take IPv6 addresses into account, I modified it slightly to accept both IPv4 and IPv6 addresses. /^Received: from (.* \(\[?[-._[:alnum:]]+\]? \[([\.0-9]{7,15}|IPv6[\:a-fA-F0-9]+)\]\))(.*) \(Authenticated sender: ([^)]+)\)(.*)(by mx1\.example\.com) \(([^)]+)\) with (E?SMTPS?A?) id ([A-F[:digit:]]+)(.*)/ REPLACE Received: from smtp-auth.example.com (smtp-auth.example.com [127.0.0.1]) (Authenticated sender: hidden)$5$6 ($7) with $8 id $9 $10 Note that this should be one single line. Put this in a file, for example /usr/local/etc/postfix/obscure_smtp_auth and add the following to your Postfix configuration (assuming you have SASL working). header_checks = pcre:/usr/local/etc/postfix/obscure_smtp_auth smtpd_sasl_authenticated_header = yes The first header will now be rewritten, for both IPv4 and IPv6 clients and will look something like this. Received: from smtp-auth.example.com (smtp-auth.example.com [127.0.0.1]) 127.0.0.1 (Authenticated sender: hidden) by mx1.example.com (Postfix) with ESMTPSA id 3677033C6F for <hostmaster@example.se>; Wed, 10 Dec 2008 16:31:51 +0100 (CET) instead of Received: from [IPv6:2001:xxxx:xxxx:xxxx:xxxx:xxxx:fedd:7914] (unknown [IPv6:2001:xxxx:xxxx:xxxx:xxxx:xxxx::fedd:7914]) (Authenticated sender: someuser@example.com) by mx1.example.com (Postfix) with ESMTPSA id 3677033C6F for <hostmaster@example.se>; Wed, 10 Dec 2008 16:31:51 +0100 (CET) Note: This is about “intra-AS” IPv6 routing and networking as I haven’t had the opportunity to play with IPv6 BGP stuff. Granted it’s still poor-mans-ipv6 (aka ipv6 over a ipv4 tunnel), but still. If you’re IPv6 capable you’re most likely reading this over IPv6 already. The IP address for www.shapeshifter.se is 2001:16d8:ffe5:1:1::1 (from 2001:16d8:ffe5:1::/64) It has got some shiny AAAA/PTR records too.
I played with IPv6 several years ago (back during the 6BONE days) and recently decided to give it another shot. Most of my services are now available through IPv6 and my local LAN has IPv6 connectivity. I’ll write more about that in another post. New release of hso(4), FreeBSD driver for Option iCON branded 3G/HSDPA devices. Changes to hso(4)
Changes to hsoctl(1)
The code can be obtained from the hso page, the update should hit the ports tree soon (comms/hso-kmod). Speed test from a rural location. Values are in bits/s, so that’s almost 300 kB/s downstream and around 40 kB/s upstream. Hopefully downstream is slightly better from a more urban location. |

Entries (RSS)