Disable WordPress Trackbacks to avoid spam

I’ve intended to disable all comment or trackback functionality to avoid having spam and dealing with it in form of anti-spam plugins like Akismet. While I already had comments disabled, Trackbacks were still active.

Even when you disable Trackbacks in the WordPress settings via „Settings / Discussion“ under „Allow link notifications from other Weblogs (Pingbacks and Trackbacks)“, your existing pages needs manual update to take effect.

Connect to your MySQL database of your blog (e.g. with PHPMyAdmin) and execute these two queries:

 

I’ve found this information on Andreas blog, thank you!

WP-Sweep plugin helps you to clean up your WordPress data

Inspired by this tweet, I’ve decided to give WP-Sweep a try:

https://twitter.com/chemik3r/status/572127624346148864

WP-Sweep is a new WordPress plugin which only uses the official WordPress API to delete and clean up orphaned and unused data.

I’ve given it a try on my personal blog and it worked flawlessly. Unfortunately I’ve forgot to write down the exact percentages on what could be sweeped and saved but I have now a good feeling that at least my > 3000 blocked spam comments are finally gone 🙂

Don’t forget to backup your data, before you try this!

How to use your old Huawei E169 UMTS Stick on Mac OS X Lion

It is time to take care of older Hardware running on Mac OS X Lion. This blog post will be about my old Huawei E169 USB UMTS stick, which I use from time to time when no WLAN is available.

Its software was designed to be used under 10.5, so the upgrade to 10.6 was also problematical.

Lion uses a new 64 bit kernel, therefore the older drivers from Snow Leopard do not work anymore. After searching Google, I found this blog post which links to a new driver package. This package is from the english support page of the provider three, however its mpkg installer package contains the necessary drivers for Lion. So you can go ahead and extract the downloaded zip. You will find a file called „3Connect Installer.app“. You can right click and view its content. In Contents/Resources you will find the wanted „mobilemanager.mpkg“. Right Click again and go into Contents/Packages. If you deciced to just upgrade from Snow Leopard to Lion, then you won’t need the „mobile_manager_application.pkg“. This should be already installed if you used the stick before. However you will need the „huawei_universal_425_05.pkg“. This file contains the necessary drivers for Lion.

After you installed these drivers, you can go check your network settings and devices in your system preferences pane. My Mobile Partner complained about a missing phone number, which needs to be called. This was a crucial part of the installation, because I thought that the Lion Update kept all necessary network interfaces and settings. However it will forget the number that needs to be called. So you need to add „*99#“ to the network adapter.

You should be ready to go by now, press connect and try to establish a connection on Lion. Of course you should at least run once the MobilePartner application so that you can enter your SIM pin number.

Fritzbox 3270, Freetz und OpenVPN

Im Zuge meiner bereits erwähnten Umstellung auf ADSL2+ mit einer 16MBit Leitung habe ich meine AVM Fritzbox 3270 mit einer neuen Version des Freetz Mods bespielt. Ziel dieser ganzen Aktion war eigentlich nur die Möglichkeit von außen auf Geräte hinter meiner Fritzbox zuzugreifen. Früher habe ich das schon relativ bequem mit einem SSH Portforwarding lösen können. Dieses Mal wollte ich jedoch mehr und wollte mir extra OpenVPN auf die Box installieren.

Wenn man Freetz benutzen möchte, so sollte man sich am besten die Virtuelle Maschine Freetz-linux herunterladen und damit experimentieren. Diese VM basiert auf Ubuntu und besitzt bereits alle notwendigen Pakete für die Kompilierung der Firmware. Ich verwende speziell die freetz-trunk Version, welche immer den neuesten SVN Stand der Entwicklung wiedergibt. Diese habe ich speziell deswegen gewählt, weil ich somit die neusten Features (wie z.B. HFS+ Datenträgerunterstützung) aktivieren kann und auch die neueste Firmware 04.86 nutzen kann. Die Stable Version benutzen alle noch die ältere 04.80, in der z.B. das Gäste Wlan und keine IP v6 Unterstützung enthalten sind.

Nach vielen hin und her habe ich dann letztlich eine passende Pakete Auswahl getroffen, die auch nicht zu groß für den internen Speicher meiner Fritzbox ist. Ich musste dann die Firmware flashen und habe mich dann den ziemlich ungenauen Anleitungen des Freetz Wiki entlang gehangelt.

Damit begann das Elend… Fritzbox 3270, Freetz und OpenVPN weiterlesen