- Monday: Laboe and Augstfelde near Plön
- Tuesday: Büsum
- Wednesday: Rantum and Wenningstedt, Sylt
- Thursday: Rantum and Wenningstedt, Sylt
- Friday: Nørre, Denmark
Archive for June, 2005
Church on Tour Schedule
Tuesday, June 28th, 2005Church on Tour
Sunday, June 26th, 2005
Parking lot at the motorway near Kolding, Denmark. June 23, 13:00 MET.

Tent pitching equipment. Blåvand, Denmark. June 23, 17:30 MET.

All tents are ready for the volunteers. Blåvand, Denmark. June 23, 22:00 MET.
FYI: Last week, I was temporarely lent by Diaconia to Mr. Schmidt from the Northelbian Church. Our task: Pitch the tents for Church On Tour on Amrum and in Blåvand, Denmark. Kirche unterwegs. As I’m lent to Mr. Schmidt for another week, more interesting trips through Nordelbien may follow.
Wieviel Load darf es denn sein?
Friday, June 24th, 2005Offsite Work
Tuesday, June 21st, 2005I’ll be in Amrum tomorrow and eventually in Denmark from Thursday to Friday, so don’t expect any communication til later this week.
Hamburg Food: Lenches Eis im Alstertal
Sunday, June 19th, 2005In the style of Restaur.Antville, where only recently two of my famous places got blogged [1], [2], follows a note about one of the best locations for ice cream in Hamburg.
Lenchens Eis im Alstertal is located at Poppenbüttler Weg and Schulbergredder, just next to Ring 3. I know no other place where you can get so much ice cream for just 0,60 €. I’ve ssen ice cream for 0,70 €, but not half as much as at Lenchens. Be prepared for queueing so, if you’re coming on a hot sunday.
Note to myself: Don’t try to use Autobahn, if it’s closed in both directions due to a Motorradgottesdienst. The organizers of that event even work in the same place as I do. I should have known better. Doh!
[1] Andronaco. We sometimes eat there for lunch, very good!
[2] Pavilion Hotel. Located next to Ruddimans Hotel (or Stylotel). Both very convenient, cheap and – well – original in style.
Domainrobot Status
Saturday, June 18th, 2005One might say Große Ereignisse werfen Ihren Schatten voraus. Indeed M. will be amused to see that we just updated the first one of our web apps to use the backend of our Domainrobot version 2. Shortly, we will revamp our reseller area to be connected directly to our registrars and registry partners worldwide. So stay tuned. In the meantime visit isfree.proterzio.info for a quick look through the window of our development labs and be amazed about the number of top level domains you can register with us in the future.
Vallstedt-Networks
Friday, June 17th, 2005M., I remember that we once planned something like this. Maybe now is the time to do it? Vallstedt-Networks [via Wolf].
Gnome.org/Switch
Friday, June 17th, 2005Today I switched editors for the first time I’m on Linux. I do not mean console editors. I’m still a proud vim user. However, as of today, I’ve purged Bluefish from my system. Belive it or not, I’m now using Gedit as my new editor of choice. It basically supports the same features Bluefish does. At the same time, the interface is much cleaner and the GUI integrates much more nicely with the Gnome desktop. Not a surprise as it is a native Gnome application, but a definitve plus anyway. You probably don’t know that I got a draft called Bluefish Settings pending for quite some time now. I guess I will purge that one, too.
And what made me switch at last, the fellow reader will ask inquiring. A post about new features in Gedit on Planet Gnome [1], I tell you. If you follow the link, you can see screenshots of a searchbar instead of a search dialog and error or notification messages in a yellow bar at the top of the window – again instead dialogs. Although I guess the Gedit developers were inspired by the popular Firefox browser, I got used to the searchbar feature way before Firefox was even called mozilla/browser. Back then I was still a Windows user and used EditPad Lite. Edit Pad used a search- and replace bar docked to the bottom of the page – like Firefox does. Gedit will do something similar with it’s search sidebar. This is a killer feature for programmers and I long hoped it would be implemented in Bluefish. Thank God, it will be supported by Gedit now! In the good ol’ days this great search and replace GUI design saved my life numerous times. After “being stuck” with Bluefish this was the only thing I really missed and that really drove me nuts in some situations.
So thank you Bluefish developers for a great editor and a great time I had with your app. Farewell. Welcome Gedit. May the power be with us!
You tend to use more and more native Gnome apps once you become addicted to reading Planet Gnome by the way…. I even think about switching from Thunderbird to Evolution. ‘Nuff said.
[1] For those of you interested in Gedit development: A follow-up has been posted in between.
University Evaluation
Wednesday, June 15th, 2005It is almost Mid-June now and that means I have to choose a couple of universities now to apply for the desired Computer Science (BA/M) program of study. I assured myself numerous times during the last month, that most universities require to send in your papers not before July 15. Today I did a closer evaluation of possible universities. Of course I’ll try to get a place in Hamburg, which is not so certain anyway. Other interesting universities are – according to ranking from Spiegel and Zeit – Saarbrücken and Karlsruhe. Both of them have a much better ranking (based on Informatik of course) than Hamburg. And – even better – both of them did not establish restriction of entry this year. I zealously cite from the Uni Karlsruhe website:
Alle Bewerber werden zugelassen.
Still, Hamburg has got the home bonus. Funding will not be a problem over here. However, I do now have almost fully proved fall-back scenarios, if so required.
WordPress Tiger
Tuesday, June 14th, 2005Unfortunately, I haven’t upgraded to WordPress 1.5, so I cant try this out. WordPress Administration Design: Tiger [via Dave]
Getting Real: The alone time zone
Tuesday, June 14th, 2005Hetzner: c’t-Werbung seit 1997
Tuesday, June 14th, 2005‘Muslim? Change your name like me’
Saturday, June 11th, 2005‘Muslim? Change your name like me! Sad story [via London Leben].
Ode to a Spell Checker
Saturday, June 11th, 2005This one illustrates quite nicely one of the things I hate spell checkers for: Ode to a Spell Checker [via Planet Debian].
Pay less for your mobile call – with Linux
Saturday, June 11th, 2005If you’ve got a O2 Genion mobile phone, you can save a considerable amount of money for national calls from your mobile to national and international mainlines. You just need a Linux box and an ISDN line with a service provider of your choice. You can save even more money with special billing options from Hansenet, Telekom or Arcor. Try it out and see for yourself: c’t 13/2005, S. 216.
Sunday Morning Transcript
Wednesday, June 8th, 2005-1-
As you may recall from one of my previous posts, I went to Nuremberg to visit the IP-Exchange data center on Saturday, May 28. I started out at 6:30 in the morning, packed my Handelskontor Hamburg branded bag and went to the Altona train station by bike. It was a very nice morning and the sun had already warmed the air quite a bit.
Due to the early hour I had to get a ticket at the Fahrkartenautomat. As I had used the ticket vending machines serveral times before, it was a straight forward approach – despite of the fairly complex and at times irritatig GUI.
I got an unreserved place at a table. Throughout the journey I used the power outlet that was conveniently placed next to the table to finally recharge the battery of my Canon Ixus 40 for the first time since I had bought it. That took serveral hours however and so I was unable to go about some offline work by utilizing my currently battery-less and therefore current-dependent laptop device.
-2-
I spent the time reading through most of The Tristan Betrayal by Robert Ludlum, a book I had bought shortly before departure at the Chicago airport in fall of last year.
When I arrived in Nuremberg we had already reached an outside temperature of approx. 29° C. It was fairly hot. Since I had no idea how to get to the data center I approached the Bahn Service Point and asked for directions.
The IPX data center is located in Gewerbepark Nürnberg-Feucht, which is in the south-east part of Nuremberg. It turns out that the bus station on location (Am Tower) is only served from Monday to Friday. That meant I had to take U1 to Langwasser Mitte and then Bus 57 from there to Streubuck. You have to walk back through the forest to Gleiwitzer Str. and head to your left side towards the Autobahn. You will recognize the old tower, which is situated right next to the data center and presumably left from an American airbase. That’s also why the street, where the data center is located, is called Am Tower, I suppose.
-3-
The data center itsself is built inside a former aircraft hangar. We met with T., C., M. and J. from IPX in the NOC and opted for a tour through the entire data center. Unfortunately, it was strictly prohibited to take photos inside the data center, but it really was impressive. The center currently consists of two colocation facilities, which contain around 7.000 servers. Each month the data center produces more than 500 terra byte of traffic, which is equal to Strato and half that of 1&1, as M. said later on. All of us had the opportunity to see our own server. Of course the air conditioning worked quite hard that day to keep anything at the right temperature level. Air circulation was so high in one colo that the light bulbs hanging from the top moved from one side to the other in the air stream.
Than we initiated phase two of the meeting and went outside the data center to have a nice BBQ sponsored by IPX – including alcoholic and non-alcoholic drinks of course.
Later M. took us on a private tour of the NOC and showed us what steps IPX took to monitor and fight incoming and outgoing DDoS attacks. He also told us a lot interesting things about his work and new features to come.
-4-
At around 8 p.m. I left together with W., who dropped me off at Fulda station around clock 10. Unfortunately, there was only a train to Hannover. I arrived 20 minutes late at 0:30 a.m. on Sunday. Because there was no direct connection from Hannover to Hamburg before 6:45 a.m. I took a Regional Express to Bremen, which had graciously been ordered to wait for our train. I was there at 2 a.m. and am currently waiting (3:45 a.m.) for the first train to Hamburg, that should leave here at 5:13 a.m. from platform 10. This solution is faster than actually waiting in Hannover.
During my lay-over I already had some coffee to cope with results of a 12 hour day without sleep and I took some photos of the station. Next to me in the waiting room most people sleep on the benches. Occassionally some people walk through the main hall. Also since about 2:50 a.m. service personell are working hard cleaning the staition utilizing some machines that make a lot of noise whenever they come by the waiting area. Also since 3:00 a.m. there are people at work behind the desks of two still closed bakery shops. Burger King and the Bahn service point behind me seem to be open 24/7.
I will now try to finish my book.
File Transfer via Jabber
Sunday, June 5th, 2005Yesterday T. invited me to a very delicious gala dinner at his place. I brought my Laptop along. We made use of the opportunity and shared some recent Knoppix and Kanotix Live-CDs. Unfortunately, we were unable to make T.s Windows box talk to my Linux box and instead of wasting endless time we decided to use Jabber instead. When T. launched PSI and I accepted the file in Gaim we were really exited of the connection speed (around 3.5 MBit). Actually, Jabber seemed to notice that we were on the same network and initiated a direct peer-to-peer link between our computers. And the lesson of this post: If you are in a hurry and don’t have time to setup a proper network or simply don’t want to mess with your settings just use Jabber. Both T. and me are impressed again and again of the power this open instant messaging protocol gives to its users.
PowerDNS on Debian Lenny, Sarge or Woody (1) [Update3]
Saturday, June 4th, 2005PowerDNS is an extremly powerful DNS server. It supports a number of relational database backends, loadbalancing and failover algorithms.
Deploying PowerDNS on all our servers has a few major advantages over our current Bind based setup.
- PowerDNS has native MySQL database backend support and is therefore easier to integrate with our customer control panel. Also changes to the MySQL database are discovered automatically, eliminating the need for periodical restarts. All changes are applied almost instantly.
- PowerDNS can act as a so-called supermaster, synchronizing itsself automatically with slave servers. Zone transfers occur even without adding a domain name to all of the slaves beforehand. It is enough if the domain is added to the database of the master server.
I will now describe how to setup PowerDNS on a Linux box running Debian Woody or Debian Sarge or Debian Lenny and utilizing the MySQL database backend.
Initial Setup
Official Debian packages for PowerDNS are availlable since Debian Sarge, but you can download Woody packages from http://www.powerdns.com/downloads/, if you use Woody. There is no apt repository availlable, however.
After downloading the most recent package with wget, you can install it on your system with dpkg.
wget http://downloads.powerdns.com/releases/deb/stable/pdns-static_2.9.17-1_i386.debdpkg -i pdns-static_2.9.17-1*
If you’ve got a Sarge or newer installation of Debian just run apt-get as follows and the necessary packages will be installed automatically.
apt-get install pdns-recursor pdns-backend-mysql
You’ll notice that PowerDNS will not start up directly after installing the package. That’s because the standard configuration file does not come preconfigured for a specific backend; we have to configure PowerDNS for a backend of our choice first. See below for a sample output of a fresh PowerDNS installation.
/etc/init.d/pdns monitorJun 04 10:13:56 Unable to launch, no backends configured for querying.
Gerneal Settings
Before we will begin to configure the database backend, we’ll have a look at some basic settings first. If you use Sarge, you can skip this part. You will be asked for the information below during configuration of the package. If you use Lenny or Woody, you need to specify an IP address and a port, to which PowerDNS should bind. You should specify an alternate port for non-production use. That allows you to run PowerDNS in parallel to an existing nameserver installation during the initial setup period.
On Woddy and Sarge, edit /etc/powerdns/pdns.conf directly. In Lenny, do edit the file /etc/powerdns/pdns.d/pdns.local file instead. This way it will be easier to update the package later.
vi /etc/powerdns/pdns.d/pdns.locallocal-address=192.168.0.2local-port=5300
If you want to bind PowerDNS to multiple IP addresses change the local-address setting as follows.
local-address=192.168.0.2,192.168.0.3
If your server has multiple IP addresses configured, you should also set the IP address, which PowerDNS will use as the source address when sending out answers to queries from clients or remote servers.
query-local-address=192.168.0.2
MySQL
Before we start to configure PowerDNS to use the MySQL backend, we need to setup the required database and tables.
CREATE DATABASE pdns;USE pdns;CREATE TABLE domains (id INT auto_increment,name VARCHAR(255) NOT NULL,master VARCHAR(20) DEFAULT NULL,last_check INT DEFAULT NULL,type VARCHAR(6) NOT NULL,notified_serial INT DEFAULT NULL,account VARCHAR(40) DEFAULT NULL,primary key (id))type=InnoDB;CREATE UNIQUE INDEX name_index ON domains(name);CREATE TABLE records (id INT auto_increment,domain_id INT DEFAULT NULL,name VARCHAR(255) DEFAULT NULL,type VARCHAR(6) DEFAULT NULL,content VARCHAR(255) DEFAULT NULL,ttl INT DEFAULT NULL,prio INT DEFAULT NULL,change_date INT DEFAULT NULL,primary key(id))type=InnoDB;CREATE INDEX rec_name_index ON records(name);CREATE INDEX nametype_index ON records(name,type);CREATE INDEX domain_id ON records(domain_id);CREATE TABLE supermasters (ip VARCHAR(25) NOT NULL,nameserver VARCHAR(255) NOT NULL,account VARCHAR(40) DEFAULT NULL);
We also have to create a new MySQL user account exclusively for PowerDNS and need to set the rights accordingly.
GRANT USAGE ON *.* TO `pdns`@localhost IDENTIFIED BY "********"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0MAX_UPDATES_PER_HOUR 0;GRANT ALL PRIVILEGES ON `pdns`.`domains` TO `pdns`@localhost;GRANT ALL PRIVILEGES ON `pdns`.`records` TO `pdns`@localhost;GRANT SELECT ON `pdns`.`supermasters`TO `pdns`@localhost;
The neccessary database is now setup and the empty tables await our data. Because PowerDNS is unable to connect using sockets, we have to modify the MySQL configuration and make it bind itsself to localhost.
vi /etc/mysql/my.cnf#skip-networkingbind-address = 127.0.0.1
All we need to do now is to make another change to the PowerDNS configuration.
vi /etc/powerdns/pdns.d/pdns.locallaunch=gmysqlgmysql-host=127.0.0.1gmysql-user=pdnsgmysql-password=********gmysql-dbname=pdns
Let's have a little test of the installation.
/etc/init.d/pdns monitorJun 04 16:46:34 gmysql Connection successful
Perfect. PowerDNS is setup successfully. The initial setup is completed. See you later for part two of this workshop, in which we will insert some random domain data into our new database and setup a typical superserver/slave framework.
Update1: Recently Debian 3.1 Sarge was released. I changed this tutorial a bit to accommodate some differences between Woody and Sarge.
Update2: Actually, PowerDNS is perfectly able to use MySQL sockets, if you omit the gmysql-host option. Lesson learned. Post changed.
Update3: Debian Lenny will be released shortly. I changed this tutorial a bit to accommodate some differences between Woody, Sarge and Lenny.