UPC/Magenta Fritzbox and IPv6 Prefix Delegation

I have started with the network migration today. There is now a fritzbox between the UPC ConnectBox and my router. For IPv4 this now means triple NAT \o/.

One of the most important task was to make my FreeBSD routers SSH port accessible from the internet.

What I have tried:

  • Wireguard: The FreeBSD go package uses SSE2 which results in an illegal hardware instruction. :-S
  • Reverse SSH: Yes it works. But I want something better.
  • IPv6: Following steps were necessary to get it working:
    • Disable the IPv6 Firewall on the ConnectBox
    • Enable IPv6 support on the Fritzbox
    • Disable “DHCPv6 Rapid Commit” on the Fritzbox.
    • Enable IA_PD and IA_NA on the LAN side of the Fritzbox
    • Configure my router as “Ipv6 Exposed Host” on the Fritzbox

Now what I have to think about: Do I trust the Fritzbox enough as a firewall?

Formatting Dates in JExcel

Jexcel has an annoying Feature: It exports Dates always as UTC.
They have published some kind of workaround for reading Excelfiles, but it does not work for Writing Excel files.
My workaround:

TimeZone tz = TimeZone.getDefault();
int offset = tz.getOffset(date.getTime());
Calendar cal = new GregorianCalendar();
cal.setTime(date);
cal.add(Calendar.MILLISECOND, offset);
DateTime datetime = new DateTime(j,i, cal.getTime());
WritableCellFormat cf = new WritableCellFormat(df);
datetime.setCellFormat(cf);

Guten Rutsch ins Jahr 1984 – 24C3 Day Four

I am back home and by now have recovered from 24C3.
On the last day I attended the following talks:
– GPLv3 – Praktische Auswirkungen
– Smartcard protocol sniffing:
– Ruby on Rails Security
After that i spend some time in the lobby recharging my laptop, and preparing for the way home. For the first time in several years i have taken the night train and arrived in Vienna on 31 at around 9ish.
I liked this congress better than the last time i was in Berlin 6 years ago. So i plan to attend the next one in December 2008.
30-12-07_1844.jpg
Today i updated my last 6.x system to 7.0, the remote server. Recompiling the ports in all 4 jails is still in progress, so the system will be a bit slow on the weekend.

24C3 – Day Three

30-12-07_1100.jpg
I attended the following talks:
– Grundlagen der sicheren Programmierung: okish, but lacked something cool to show off
– Hacking ideologies part 2: most blabla talk of the congress
– Wahlchaos – Paradoxien des deutschen Wahlsystems: nothing really new for me.
– Die Wahrheit und was wirklich passierte: quite interesting insights. The second time this week someone recommends “Freakonomics”
– From Ring Zero to Uid 0: I only attended the first part about Solaris/Sparc and not the part about Windows. quite interesting
– Reverse Engineering Embedded Systems: mentioned some interesting tools, but i missed some more details about toolchain/cross compiling issues.
– Sex 2.0: This was the first talk i attended, that went just totally wrong. The speaker wanted to talk about gay dating communities, but because this is a really special interest topic, he did not mention this in the talk description of the program, but instead just promised insights on “a satisfying sex life”. Of course now the Saal 1 was filled to the last seat. And 99% of the people (all heteros and women) were disappointed when he only talked about gays. Some loudly complained, but the speaker only showed his ignorance. Someone from the audience tried to jump in, but this got even more embarassing. In the end the audience started to clap until the speaker left the stage.
– The day finished with the Hacker Jeopardy. At my last congress 6 years ago, i was very impressed by the mad hacker skillz, but this time it was quite embarassing, when the candidates confused the 8088 with the 80286 and haven’t heard about ~. or “Gödel Escher Bach”. Even fefe seems to be getting old.

24C3 – Day 2

I haven’t written anything about yesterday yet. The reason is, the congress sleep deficit is getting larger. Trying to fight it with Club Mate gets harder and harder.
So here my summary about the talks i attended yesterday:
– Elektronische Dokumente und die Zukunft des Lesens: A summary about the current state of ebook readers. The speaker was quite convinced that they are now really start taking off. But i think i will continue reading books for some more years.
– Konzeptionelle Einführung in Erlang: Most confused talk so far. Unfortunately i did not gain much new insights
– After C: D, libd and the Slate project: A perfect example what you will get, when violating the KISS principle.
– Linguistic Hacking: I expected a bit more. Yeah, you can use Google and Wikipedia to learn more about Languages.
– Just in Time compilers – breaking a VM: Peter and Roland presented their talk well.
– Toying with barcodes: As usual great talk by FX
– Spiel, Freude, Eierkuchen?: I only attended the last minutes of the discussion, but it was quite funny watching the heated discussion between the speaker and the audience incl. MdB Tauss.
– Inside the Mac OS X Kernel: Cute girl talking about a cute OS. A bit too much Apple-Fangirlness but still a nice overview.
– DIY Survival: The audience liked the jokes, but i didn’t.
– Rule 34 Contest: They started late because of technical problems, so unfortunately i missed the end, because i thought that i needed to catch last S-Bahn. But actually on weekends there is no last S-Bahn in Berlin. It was the party highlight so far, it will be hard for hackerjeopardy tomorrow to top this. Funny 70s pr0n-Musicals and lots of strange fetishes.