Using ipset to ban bad IP addresses from Project Honey Pot, Spamhaus, Tor, OpenBL and more

ipset in combination with iptables are the perfect tools to ban thousands of blacklisted IP addresses from IP blacklist providers like Project Honey Pot, Spamhaus, OpenBL and virtually anyone providing a list of “bad” IP addresses from a Linux server. I’ve created a very simple Bash shell script which can be used to auto-update blacklisted …

Where to buy Bitcoins in Switzerland using SEPA

With so many Bitcoin exchanges around it’s kind of difficult to determine which one to use. Since I’m based in Switzerland, I wanted to send my money using SEPA because this type of international money transfer usually involves the least amount of fees in Europe. There are a few Bitcoin exchanges which accept SEPA transfers. …

When is the next Apple keynote website update

I’m about to roll out an update for the wheniskeynote.com website, just in time for the WWDC 13 keynote. The changes include: Replaced the countdown with one that supports reflection Replaced Google Analytics with Piwik, which is awesome Removed support for the RSS feed and Google +1 Dropped financial results calls from the list of …

Speed up MySQL with a RAM disk in Ubuntu Server

If you have some RAM to spare and want to speed up MySQL a little, you can create a RAM disk for MySQL’s temporary disk tables. In Ubuntu Server, the MySQL process is being watched by AppArmor which prevents us from using a custom tmpdir unless the AppArmor configuration is changed accordingly. This post shows how …

PhpMyAdmin behind HAProxy

Here’s a quick one. If HAProxy is used to SSL-offload the PhpMyAdmin web application, the following line has to be added to PhpMyAdmin’s config.inc.php: $cfg[‘PmaAbsoluteUri’] = ‘https://www.mydomain.net/phpmyadmin’;