spam

Da es in letzter Zeit wieder vermehrt SPAM Kommentare gab, habe ich jetzt das Captcha System gewechselt. Captchas sind diese verzerrten Zahlen, die nicht angemeldete Gäste der Seite ausfüllen müssen, wenn sie einen Kommentar erstellen wollen.

Das neue System sendet den Text zunächst zur Überprüfung. Erst wenn die Textüberprüfung verdächtige Worte bemerkt, wird das Captcha eingeblendet. Es hat den Vorteil, das man sich die Buchstaben auch vorlesen lassen kann (Barrierefreiheit).

So sieht es aus.

Das Spam-Aufkommen ist seit August um 67 Prozent angestiegen, der sogenannte Image-Spam konnte gar eine Zunahme um 500 Prozent verzeichnen. Das hat [url=http://www.barracudanetworks.com/ns/news_and_events/news.php?nid=245]Barracuda Networks[/url] nach Auswertung der E-Mail-Eingänge bei 35.000 Kunden festgestellt.

4 Tage war ich nun weg, 93 Mails im Postkasten.
Das meiste davon war Schrott.
Zeit was zu unternehmen!

Spamfilter werden zwar von den meisten ISP's und Freemail-Anbietern eingesetzt, landen dann dennoch im Outlook.

Das folgende Tutorial bezieht sich auf T-Online mit verbund von Outlook 2007.

Rational betrachtet mag es falsch sein, subjektiv aber fühlt es sich an, als sei verlässliches Wohlwollen nur da zu finden, wo vorher Geld gesät wurde. Anders gesagt, das Verhältnis zwischen weihnachtlichen Grußkarten von Geschäftspartnern und privaten Bekanntschaften beträgt in diesem Jahr etwa 10 : 2. Misslicher wird dieses Verhältnis nur dadurch, dass ich in grenzenloser Faul- und Trägheit nicht eine verschickt habe (auch keine viel weniger aufwendige, vorformulierte Gruß-E-Mail). Wenn es welche gäbe, würde ich an dieser Stelle moralische Gründe heranziehen. Auffallend ist der konsequent-einheitlich-einfallslose Aufbau der Karten / Briefe. Begonnen wird stets mit einer dünnen allgemeinplatzartigen Binsenweißheit á la:

Oh Mann! Als ich heute die Trackbacks freischalten wollte, habe ich im bloghouse.org admin interface 65.134 eingegangene Trackbacks gezählt (in 3 Tagen).
Ich habe das Trackback modul so konfiguriert, das jemand die Trackbacks freischalten muß. Aber der Menge an SPAM haben wir ein Problem und noch keine wirkliche Lösung.
Ich habe mir jetzt ein kleines sql script gebaut. Es filterte schonmal 65.000 raus :

<!--pagebreak-->

DELETE FROM trackback_received WHERE excerpt LIKE "%http://%";
DELETE FROM trackback_received WHERE name LIKE "%viagra%";
DELETE FROM trackback_received WHERE name LIKE "%tramadol%";
DELETE FROM trackback_received WHERE name LIKE "%sex%";
DELETE FROM trackback_received WHERE name LIKE "%blow job%";
DELETE FROM trackback_received WHERE name LIKE "%cheap%";
DELETE FROM trackback_received WHERE name LIKE "%levitra%";
DELETE FROM trackback_received WHERE name LIKE "%discount%";
DELETE FROM trackback_received WHERE name LIKE "%phentermine%";
DELETE FROM trackback_received WHERE name LIKE "%payday%";
DELETE FROM trackback_received WHERE name LIKE "%diazepam%";
DELETE FROM trackback_received WHERE name LIKE "%poker%";
DELETE FROM trackback_received WHERE name LIKE "%casino%";
DELETE FROM trackback_received WHERE name LIKE "%money%";
DELETE FROM trackback_received WHERE name LIKE "%car insurance%";
DELETE FROM trackback_received WHERE name LIKE "%hydrocone%";
DELETE FROM trackback_received WHERE name LIKE "%drug%";
DELETE FROM trackback_received WHERE name LIKE "%zolof%";
DELETE FROM trackback_received WHERE name LIKE "%buy%";
DELETE FROM trackback_received WHERE name LIKE "%anal%";
DELETE FROM trackback_received WHERE name LIKE "%xanax%";
DELETE FROM trackback_received WHERE name LIKE "%gasi %";
DELETE FROM trackback_received WHERE name LIKE "%roulette%";
DELETE FROM trackback_received WHERE name LIKE "%table dance%";
DELETE FROM trackback_received WHERE name LIKE "%lipidor%";
DELETE FROM trackback_received WHERE name LIKE "%codeine%";
DELETE FROM trackback_received WHERE name LIKE "%mortgage%";
DELETE FROM trackback_received WHERE name LIKE "%Informativity%";
DELETE FROM trackback_received WHERE name LIKE "%viocidin%";
DELETE FROM trackback_received WHERE name LIKE "%divorce%";
DELETE FROM trackback_received WHERE name LIKE "%Vasectomy%";
DELETE FROM trackback_received WHERE name LIKE "%Valium%";
DELETE FROM trackback_received WHERE name LIKE "%gambling%";
DELETE FROM trackback_received WHERE name LIKE "%adipex%";
DELETE FROM trackback_received WHERE name LIKE "%carisoprodol%";
DELETE FROM trackback_received WHERE name LIKE "%fioricet%";
DELETE FROM trackback_received WHERE name LIKE "%meridia%";
DELETE FROM trackback_received WHERE name LIKE "%ativan%";
DELETE FROM trackback_received WHERE name LIKE "%forklift%";
DELETE FROM trackback_received WHERE name LIKE "%codone%";
DELETE FROM trackback_received WHERE name LIKE "%presciption%";
DELETE FROM trackback_received WHERE name LIKE "%order%";
DELETE FROM trackback_received WHERE name LIKE "%1031 %";
DELETE FROM trackback_received WHERE name LIKE "%xenical%";
DELETE FROM trackback_received WHERE name LIKE "%soma %";
DELETE FROM trackback_received WHERE name LIKE "%blow%";
DELETE FROM trackback_received WHERE name LIKE "%latin%";
DELETE FROM trackback_received WHERE subject LIKE "%ultram%";
DELETE FROM trackback_received WHERE subject LIKE "%nurse%";
DELETE FROM trackback_received WHERE subject LIKE "%ambien%";
DELETE FROM trackback_received WHERE subject LIKE "%cialis%";
DELETE FROM trackback_received WHERE subject LIKE "%ultram%";
DELETE FROM trackback_received WHERE subject LIKE "%nurse%";
DELETE FROM trackback_received WHERE subject LIKE "%ambien%";
DELETE FROM trackback_received WHERE subject LIKE "%vicodin%";
DELETE FROM trackback_received WHERE url LIKE "%http://www.onlineflower%";
DELETE FROM trackback_received WHERE url LIKE "%http://aves%";
DELETE FROM trackback_received WHERE url LIKE "%http://lab2ipo%";
DELETE FROM trackback_received WHERE url LIKE "%http://thais%";
DELETE FROM trackback_received WHERE url LIKE "%http://roulette%";
DELETE FROM trackback_received WHERE url LIKE "%http://blackjack%";
DELETE FROM trackback_received WHERE url LIKE "%http://apress%";
DELETE FROM trackback_received WHERE url LIKE "%http://xoomer%";

In den letzten zwei Tagen sind 140 Spam Trackbacks hier eingeschlagen.
Ich habe daraufhin die Moderation der Trackbacks eingeschaltet. Alle Trackbacks müssen jetzt von einem Admin (momentan [url=http://www.bloghouse.org/user/22]Olaf[/url] und ich) explizit veröffentlicht werden.