The final phase of migrating this and several other sites and services I host to a new server concludes thus. Zeroing out the volumes on the disks should finish in about an hour from now.
// Oliver
Heute im Buchladen in Kringlan den Titel vom Stern gesehen: “Warum Jesus sterben mußte”. Wow, so reißerisch nach nur knapp 2000 Jahren? Oder hat man sich nach den Hitlertagebüchern jetzt auf Geschichten verlagert bei denen ohnehin keiner mehr etwas verifizieren oder falsifizieren kann? 
// Oliver
There are always reasons not to cache certain data. An antispam measure I have implemented in several forums over the years is one of them. However, now trying to migrate to phpBB3 it appears there is no clever way to exclude particular items from the cache. Brilliant 😕
Current workaround: remove the cache item (one particular item) on each page load.
// Oliver
Mäxchen ist nicht vergessen 😥
Siehe Farewell, little fellow, vor exakt einem halben Jahr – auch an einem Sonntag.
A Ukrainian folk tale told in a cartoon (in Russian). Here with English subtitles. Just lovely.
Vielen Dank, ZDF. Jetzt wissen wir endlich, daß das Internet gefährlich ist. Auweia, und wie gefährlich. Ich bin schon gespannt auf die Fortsetzungen:
Wie lange benutzen Kriminelle eigentlich schon die jeweiligen Werkzeuge ihrer Zeit? Man stelle sich vor, Autos wären verboten worden weil sie als Tötungswerkzeug oder zum Transport im Rahmen eines Tötungsdelikts benutzt wurden. Die Welt sähe heute anders aus.
Kriminelle benutzen – wie übrigens Nichtkriminelle – alles was in der jeweiligen Epoche zur Verfügung steht. Das heißt aber nicht, daß die Technologien irgendwie besonders schlimm wären, wie der Titel suggeriert. Ein ganz spezieller Fall von Qualitätsfernsehen?
Was zeigt uns nun also dieser Beitrag? Vor allem, daß es genügend Leute gibt, die alles von sich preisgeben. Und dann gibt es eben Kriminelle die das ausnutzen. Früher ging es per Brief und heute eben über Email und über irgendwelche Internetportale.
Am schönsten fand ich aber den Packetsniffer der bei dem BKA-Menschen im Beitrag im Hintergrund lief. Mächtig imposant diese lokalen nicht-routbaren IP-Adressen (192.168.0.0/16) … kleiner Tip an die Experten: der gezeigte Sniffer hat auch Filter, mit denen man den ganzen Unsinn ausblenden kann. Mitsniffen läßt sich der Inhalt auch ganz ohne daß die Inhalte komplett angezeigt werden. Ansonsten einfach mal Sniffer wechseln oder bei Wireshark selber den Code ändern. Vermutlich ist das jedoch ohnehin nur um den Matrix-Effekt zu bekommen. Hauptsache da rutscht was auf dem Bildschirm lang
Aber ich kann dem Herrn von vollem Herzen zustimmen, daß die ganzen modernen Mistseiten (Facebook vorne dran) die Leute dazu verleiten – und diese sich verleiten lassen – die intimsten Daten preiszugeben.
// Oliver
We noticed that you are not at the top of the search engines for a number of your key terms. We have helped companies similar to yours to achieve top organic rankings. Please reply to this message and we will prepare a special proposal for you, to show you how we can achieve similar results for you.
What? What company? This is a private website 🙄
Trying to break into my Yoggie Open Firewall Pico via SSH since I forgot the password. Using the current method it will take approximately 41 days and 6 hours to finish around 1.5 million passwords. *gnarf*
Lovely. Hex-Rays released version 6.1 of IDA just today. I already requested my download and I am downloading as I type this.
See the changes here.
// Oliver
PS: sadly it’s the first version where I don’t get a Linux version. I occasionally used the Linux terminal version when no Win32 was nearby, but those days are gone 😥
Auf den heutigen Tag und nach dem Streß der letzten Tage gibt es jetzt …
*trommelwirbel*
… einen Cognac.
Mein Opa meinte: die wärmsten Jacken sind noch immer die Konjacken. Recht hatte er. Auf die Gesundheit und die Erinnerung an die die nicht mehr unter uns weilen.
I’m using MariaDB. Now, I had the idea for smaller DBs to use the SQL dump and store that in a version control system such as Mercurial or Git. However, the ordinary mysqldump creates quite unreadable dumps. Since the version control systems use diffing algorithms I figured it would be best to use something that outputs more readable, less cluttered, output. Someone on the #mysql channel over at FreeNode pointed me to mydumper. Turns out he was the author.
In order to compile it for Debian (Squeeze) I had to install the following prerequisites:
apt-get install bzr cmake build-essential \ libpcre3-dev libglib2.0-dev libmariadbd-dev
… after that was done, the following was used to build:
bzr branch lp:mydumper cd mydumper cmake . make
… and as root:
make
Very easy. Thanks Domas!
// Oliver
PS: On Debian 5 the required packages were bzr cmake build-essential libpcre3-dev libglib2.0-dev libmysqlclient15-dev zlib1g-dev.
Kaum tauen die letzten Schneereste, wird Reykjavík wieder zum Nizza des Nordens: Hundekacke wo man geht und steht
// Oliver
PS: diese etwas eindimensionalen Eindrücke von Nizza rühren sicher daher, daß ich nicht “in der Saison” dort war.
So I’m talking to a veeeeery slow device over serial connection. Meanwhile I have managed to talk to it using kermit from within Linux – from within a GNU screen (actually byobu) session to be more precise. The output that I initiated is a dump of memory contents, more precisely of the flash memory mapped at a particular location. 16 MiB of flash memory. Now consider that every line looks approximately like this:
XXXXXXXX: 00000000 00000000 00000000 00000000 ................
Of course for the Xs it’s an address and the zeros would be actual byte values corresponding to the contents at that address. This runs at 38400 Baud and is slooooow
To my horror I realized before finishing the first MiB, that this would take hours and that I have no means of killing it before it’s finished (e.g. Ctrl+C does not work). However, the plan was anyway to abuse the textual form of it and convert that to the binary form. Fortunately GNU screen offers a logging feature and I knew it was there, although I didn’t remember the shortcut. Well, easy enough. I looked it up and enabled logging. Simply brilliant. It will run for a few more hours, but I have only “lost” less than 1 MiB at the front of the dump that I’m going to rerun tomorrow.
The solution for enabling logging:
I’m not going to forget that one again
// Oliver
I’m using byobu on a daily basis, but occasionally I also use mc (Midnight Commander). Midnight Commander is a terminal-based two-panel file manager as they became well known with Norton Commander. If you look for a similar solution for Windows, I can recommend FAR (console) and SpeedCommander (GUI).
Running mc under byobu windows has a problem. Now, interestingly the Fn-keys F5 through F10 work normally, but F1 through F4 and F11 through F12 don’t. The problem doesn’t seem to be unique. The solution with mc.keymap looks promising, but I have yet to test it.
For now, I found a workaround. It turns out that the four keys at the top of the key pad (Num … -) map exactly to F1 through F4. I’ll post a new entry when I find the proper solution.
// Oliver
I had changed the table storage engine format from MyISAM and InnoDB to PBXT for my blog and some other blogs I host. Little did I know.
Of course WordPress will hide any and all errors from plain sight, so the symptom I got to see was that I couldn’t write any new blog posts, or generally make any modification to the database at all.
When I decided to roll back, I got this:
ERROR 1598 (HY000): Binary logging not possible. Message: Statement-based format required for this statement, but not allowed by this combination of engines
Oops. That’s pretty nasty. I can’t even roll back? Well, turns out I could. First off all let’s check the current log format:
show global variables like 'binlog_%';
It requires MIXED here, but is not properly set. We can set it for the current session, like so:
set session binlog_format = 'MIXED';
… but that is only a temporary workaround and only possible for our currently running session. I imagine it would be possible to use the global keyword instead of session, but I don’t know whether that survives DB server restarts. So, to be sure, I decided to set:
binlog_format = MIXED
… in my.cnf. Ever since, even PBXT is happily running as the storage engine.
// Oliver
I’m running an ejabberd instance and it’s configured to use TLS in S2S (server to server) communications. It works perfectly fine with jabber.ccc.de, but Google’s server does not seem to like TLS.
Very awkward. First I thought it may be because of my certificate, but then I used the same as for the website (same domain, after all) and it still does not work.
No idea why it refuses to talk encrypted with Google.
// Oliver
Watch it over here.
Just uploaded a flowchart that shows the order of packet processing in iptables to my downloads. You can find it here. There is the Visio file from which I created it in the same folder, just in case you want to modify it to your taste.
// Oliver
