Oct 17

OK, so you broke your freebsd /var/db/pkg directory and want to recover it from a backup.

backups look like this:
root@websrv:/var/db/pkg # ls -l /var/backups/
total 19190
-rw-r–r– 1 root wheel 1690 Jul 10 2014 aliases.bak
-rw-r–r– 1 root wheel 475 Jul 1 19:30 group.bak
-rw——- 1 root wheel 1937 Sep 7 10:25 master.passwd.bak
-rw——- 1 root wheel 1954 Aug 23 18:34 master.passwd.bak2
-rw-r–r– 1 root wheel 2429640 Oct 16 03:20 pkg.sql.xz
-rw-r–r– 1 root wheel 2429640 Oct 15 03:01 pkg.sql.xz.1
-rw-r–r– 1 root wheel 2429640 Oct 14 03:09 pkg.sql.xz.2
-rw-r–r– 1 root wheel 2429640 Oct 13 03:01 pkg.sql.xz.3
-rw-r–r– 1 root wheel 2429640 Oct 12 03:01 pkg.sql.xz.4
-rw-r–r– 1 root wheel 2429640 Oct 11 04:00 pkg.sql.xz.5
-rw-r–r– 1 root wheel 2429640 Oct 10 03:01 pkg.sql.xz.6
-rw-r–r– 1 root wheel 2429640 Oct 9 03:01 pkg.sql.xz.7

but it’s not working as advertised…

root@websrv:/var/db/pkg # pkg backup -r /var/backups/pkg.sql.xz
Restoring database:
Restoring: 100%
pkg: sqlite error while executing backup step in file backup.c:99: not an error
pkg: sqlite error — (null)

root@websrv:/tmp # pkg backup -r pkg.sql
Restoring database:
Restoring: 100%
pkg: sqlite error while executing backup step in file backup.c:99: not an error
pkg: sqlite error — (null)

always results in an fresh but empty /var/db/local.sqlite..

root@websrv:/var/backups # pkg info

manual fix

root@websrv:/var/db/pkg # pkg install sqlite3
Updating FreeBSD repository catalogue…
FreeBSD repository is up-to-date.
All repositories are up-to-date.
The following 1 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:

root@websrv:/var/backups # cp pkg.sql.xz /tmp
root@websrv:/var/backups # xz -d /tmp/pkg.sql.xz
root@websrv:/var/backups # cd /var/db/pkg
root@websrv:/var/db/pkg # mv local.sqlite local.sqlite.broken
root@websrv:/var/db/pkg # sqlite3 local.sqlite
SQLite version 2015-07-29 20:00:57
Enter “.help” for usage hints.
sqlite> .read /tmp/
Display all 1316 possibilities? (y or n)
sqlite> .read /tmp/pkg.sql


root@websrv:/var/backups # pkg info
ap24-mod_mpm_itk-2.4.7_1 This MPM allows you to run each vhost under a separate uid and gid
apache24-2.4.16_1 Version 2.4.x of Apache web server
apr- Apache Portability Library
autoconf-2.69 Automatically configure source code on many Un*x platforms
autoconf-wrapper-20131203 Wrapper script for GNU autoconf
automake-1.15 GNU Standards-compliant Makefile generator
automake-wrapper-20131203 Wrapper script for GNU automake
binutils-2.25.1 GNU binary tools
bison-2.7.1,1 Parser generator from FSF, (mostly) compatible with Yacc
boost-jam-1.55.0 Build tool from the boost.org
boost-libs-1.55.0_9 Free portable C++ libraries (without Boost.Python)
ca_root_nss-3.20 Root certificate bundle from the Mozilla Project
cmake-3.3.1 Cross-platform Makefile generator
cmake-modules-3.3.1 Modules and Templates for CMake
curl-7.44.0 Non-interactive tool to get files from FTP, GOPHER, HTTP(S) servers
db5-5.3.28_2 The Oracle Berkeley DB, revision 5.3
dialog4ports-0.1.5_2 Console Interface to configure ports

Mar 31


This post is about OwnCloud 6.x which seems finally mature enough to replace most of my current workarounds in a single fine solution.

old Workaround

  • Davical as calendar solution, supports CalDAV and uses PHP (comes with a webfrontend) with postgres as backend database. Been a fine solution so far, but looks like the project got somewhat abandoned.. sometimes the homepage wasn’t even reachable anymore for me. I’ve had quite some issues getting it to work properly on iOS devices after iOS 7.x became available. I found some 3rd party workaround, that fixed some database structure. There was also some issue on OSX iCal, whenever you added an item, it didn’t seem to stick. Only after you manually triggered a fresh sync before adding a new item, it seemed to work. This was one of the hassle’s which made me look for an alternative. As for sharing, my wife simply added my account as well to see my appointments.davical permissions
  • Contacts in OSX. I’ve been using the standard iTunes SYNC with iOS devices (iPhone/iPad) to sync my contacts and groups. If you keep your contacts up2date with pictures and stuff, you will also see the picture of the caller right away. This was a feature i wanted to keep. I haven’t found / or searched long enough, for a replacement to make this available remotely without the need to sync. Sharing more or less didn’t happen. Everyone’s keeping their own contacts up2date.
  • 1Password in OSX. I’ve been using 1password for quite some time but i am not a friend of sync solutions such as dropbox. While AgileBits is telling you all the time, your 1password files are secure and it requires billions of years to crack them, i have my doubts. Only because it is not crackable today, it doesn’t mean some major super duper quantum computer can’t crack it tomorrow. Keeping your files to yourself in the first place, sort of avoids this problem. Even though, they can probably hack everything by then anyways. Anyway, 1password suppors WiFi-Sync, so i used that one to sync my stuff between OSX and iOS devices. It’s a little bothersome, since you have to open the applications everywhere, make sure they are on the same wifi network and even open some special submenu on OSX these days.. not very comfortable .. making the sync a real “sunday morning” task instead of having it just happening in the background. By this time my Windows Gaming Box was not involved in the process, since WiFi sync was not available here.
  • Files. AFP/Samba. For simple file sharing, i’ve been using AFP and/or SAMBA. Remotely connect via VPN.
  • Bookmark Management. I don’t like to store my bookmarks on 3rd party pages. I think bookmarks are a very personal thing. Like what type of books you read. Telling a stranger much about you, your personality.. maybe beliefs, religion, policitical views etc. I’d like to decide on my own, with whom i want to share this with. So my bookmark management was the mozilla weave server. You may use theirs or install your own weave server, which i did. The application depends on a python environment, combined with some database backend (mysql, sqllite). Looking into the database structure, everything seems properly encrypted. (only garbled blobs there). This behind an apache SSL Proxy. Unfortunately this works only with firefox, even though with all OS versions of firefox. I haven’t found a proper way to use this on Safari or Chrome without using some 3rd party website again.firefox sync

new ownCloud era

  • OwnCloud is a solution for all problems above.
  • CalDAV Support. In OwnCloud you get a fine calendar solution with support for multiple calendars and the ability to share them to other OwnCloud Users (with fine grained permissions) or public readonly links.
    • Works perfectly on iOS devices, OSX iCal. Simply add the link, OSX will take care about the rest and show you all calendars automatically your User is supposed to see.
  • CardDAV Support. With OwnCloud you can keep track of all your contacts, with extra fields, pictures etc. You can also have multiple adressbooks (for example corporate, private) and can share them to other OwnCloud users. They will automatically see your adressbooks in their contacts webpage.
    • iOS devices work just fine. They will also show you all adressbooks that have been shared to you. Adding / Updating entries, no problem. You can even update the pictures right from your iPhone.
    • Mac OSX 10.8 / 10.9 ..  here comes the downside, but Apple is to blame. It doesn’t work properly here. Only a single adressbook is shown to you no matter how much adressbooks you have or even if you explicitely asked for a special adressbook via URL (eg. /USERNAME/adressbookname). This includes shared ones. I’ve submitted some feedback on the apple webpage, since obviously the code in the iOS versions was already there and just have to be ported back to OSX.
    • Since the Contacts App in OSX didn’t work properly, i’ve switched to Thunderbird. Here you have to install the “Inverse SoGo Connector” extension in order to use CardDAV adressbooks. After that is pretty much just adding a “remote adressbook”, one by one for each adressbook you want to see. Thunderbird will allow you to choose a default adressbook. One downside here i haven’t quite figured out yet, it seems to ask for your owncloud credentials every time you start it, but it doesn’t seem to ask for it if you just wakeup your MacBook. Here it just fails and you have to restart the app. Maybe there is a workaround i just don’t know yet.
  • Filesharing & Sync. OwnCloud provides a small sync application for almost all Operating Systems (OSX; Linux; Windows, iOS, Android) to access the storage part of their suite. The tool on osx/windows side i’ve tested, simply asks for your credentials and server address, lets you pick a local and a remote directory and keeps them in sync. I picked a single extra directory, so it doesn’t download everything. Everything for example, includes all directories people have shared to you. These directories show up in some special “shared” directory in the root of your “filesystem”.owncloud win
  • 1password. With the sync tool from above, you can simply use 1passwords “synchronization with folder” option and pick your OwnCloud local folder. It will sync all items automatically. My Windows 1password installation could pick that newly created 1password file (its actually a directory) right away and use it. Adding an item on Mac 1password triggered a 1password sync, followed by an owncloud sync UP to the owncloud server, followed by an owncloud sync DOWN to the windows installation, making it kind of instantly available to the windows 1password installation. Finally a working sync between Windows and OSX without a 3rd party.1password win
  • bookmark management. Some form of weave service can be installed as plugin into OwnCloud. Switching from weave to OwnCloud worked right away since switching the old service off in firefox, doesn’t delete any bookmarks. So i disabled the old sync and setup a new one. You need to create a new account and choose your owncloud installation. Everything you need, such as the exact URL you can find in the personal area of your OwnCloud. One more thing tho, once you setup everything, you may want to check on the new “recovery key” in firefox and store it somewhere safe (maybe in 1password?).

Since this is a pretty new installation, i cannot say much about stability but for now it makes a good impression on me so far.


  • If you run your owncloud installation behind a Pound Proxy, you may need to patch that one so it allows the PATCH http method.
Sep 22
dovecot: master: Warning: service(imap-login): process_limit (256) reached, client connections are being dropped

So you found this error message in your server logs and noticed you cannot login anymore via IMAP because all available ‘slots’ have been consumed. My working theory is, it is related to the IOS7 release and it’s IPv6 support.  With privacy extensions enabled ( See RFC 4941 ) it looks like the IOS device is grabbing a new IPv6 address every time it wakes up. This is a perfect fine behaviour if it weren’t for IMAP IDLE. From my understanding, IMAP idle is sort of a long lasting SSL tunnel with a very long TTL. This way your client doesn’t need to be online all the time and only wakes up, if there anything new on the server ( RFC 2177 ).

Workaround: Break IMAP IDLE. Not really, but at least reduce the TTL for the Tunnel by somewhat. Don’t be to harsh, otherwise your’e mobile device is gonna wake up too often, therefore consuming too much power. I set it to 30minutes.

protocol imap {
 #process_limit = 512
 # process_min_avail = 5
 imap_idle_notify_interval = 30 mins
 mail_max_userip_connections = 10
#You can check your configuration by using "doveconf -N" before reloading/restarting.

If it works, dovecot will drop the connections to not responsive ‘expired’ IPv6 IPs, freeing resources.

Sep 22 11:04:36 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=273/1229
Sep 22 11:04:37 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=237/1161
Sep 22 11:04:37 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=189/1073
Sep 22 11:04:37 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=222/1132
Sep 22 11:04:37 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=294/1268
Sep 22 11:04:37 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=273/1229
Sep 22 11:04:37 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=222/1211
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=246/1180
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=288/1258
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=252/1190
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=273/1229
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=267/1219
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=288/1258
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=252/1190
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=165/1104
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=210/1112
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=216/1201
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=237/1161
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=189/1073
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=237/1161
Sep 22 11:04:40 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=273/1229
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=216/1122
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=258/1200
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=201/1172
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=252/1190
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=231/1151
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=231/1151
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=252/1190
Sep 22 11:04:41 mx dovecot: imap(email@server): Disconnected: Disconnected in IDLE bytes=189/1073
Tagged with:
Feb 22

Installation completed successfully.

with 8x 3TB drives, 2 SSD
But lets start from the beginning…

Delivery & Hardware System Setup


FreeBSD Installation with ZFS Setup

  • since i am pretty much a FreeBSD noob, i have been googl’ing a lot and came up with a few things to consider.
    • Sector Alignment – New hard-drives, including SSDs, show 512k sectorsize to the Operating system but use 4k blocks in reality. This matters because, today, where you have multiple layers in between (harddisk, lvm, filesystem, database tablespaces etc.) .. if you screw this up, every single i/o call will multiply, reducing performance dramatically and also puts more wearing on your SSDs. So make sure you have formatting etc. in place to use 4k sectors.
    • there are a few tools on FreeBSD to simulate 4k blocks. Also using encryption allows you to set fixed block sizes.
    • Another thing to consider when partitioning, leave some space between the start of the disk and your first partition. I started at 2megabytes. This helps because its a multiply of 512k and maybe if you need to replace a disk a few years later, you have some room in case the new drive has different sectors as your previous hard-drive.


        1. I used the latest production release, FreeBSD 9.1 as DVD image. Burned it onto the disk and used the following pages to guide me through the installation.
        2. my /boot/loader.conf
          aesni_load="YES" #Xeon has hardware support for AES which will get used by geli
          vesa_load="YES" # we want a better console
          if_lagg_load="YES" # required if you want to bond multiple devices
          # zfs tuning i picked up from all the pages everywhere
          vfs.zfs.txg.timeout="120" # i believe this is the timer when to actually write to disk. Beware 120seconds loss of data if you dont have a USV.
          # low level tuning of the vdev device
          # Usefull if you are using Intel-Gigabit NIC
        3. my /etc/sysctl.conf
          #basically energy settings, trying to send most of the cores into c-state 3 but keep one core at C2
          # XEON supports 200Mhz rate :)
          # Network Tuning, more buffers etc.
          # ZFS tuning
          vfs.zfs.l2arc_write_max=200000000 # ssd can deliver more than 8MB/sec speed, beware the wearing that comes with it
          vfs.zfs.l2arc_write_boost=380000000 # ssd can deliver more than 8MB/sec speed, beware the wearing that comes with it
  • if there are any BSD guru’s out there reading this, any hints especially in regards to power consumption are very welcome. The system right now with the specs above, shows ~52W power consumption (with 4x3TB WD red installed) which is more than 100W less as my previous server 🙂

Update 24/Feb/2013: I’ve installed my old 3TB seagate barracuda drives now (4x). Alternate says they have a power consumption of 8W each. I am using the 4 remaining SATA 3GB ports on the Supermicro Board, instead of the 4 remaining 6GB ports on the LSI card. Despite only half the speed (not that they would reach that anyway), they were properly detected in FreeBSD, which means i could send them IDLE/STANDBY commands via camcontrol. So i created a zpool called “FILES ARCHIVE” with those disk and set them to go into standby mode as soon as possible. With this setting, only the 4 WD red drives and SSDs are active, the system consumes ONLY 56watts. Considering my old system used more like 160watts, i am pretty happy with the result 🙂

Feb 10

iTunes Backup greyed out

This is one of the posts that are basically for my increasing digital dementia 🙂 I’ve been wondering what i broke in my iTunes as it was no longer able to create any backups, which i need to use from time to time, jailbreaking the devices. The button in my german iTunes says “Jetzt sichern” but is greyed out. Also the rightclick menu on the device itself does not show any backup function anymore.

I started wondering if it was due to my Libary being on a different server, so the first thing was to create an entirely new library locally, with no effect.
iTunes Backup greyed out

The solution was pretty simple. I google’d around what could have disabled this function instead of continuing to search for a fix to enable it.. and here we go.. Looks like i disabled the function a few month ago. Fortunately the same link that helped me disable backup also shows how to re-enable it 🙂


ENABLE backups
defaults delete com.apple.iTunes DeviceBackupsDisabled
DISABLE backups
defaults write com.apple.iTunes DeviceBackupsDisabled -bool YES

Thanks to OSXDaily for the hint 🙂


Tagged with:
Dec 30

Mission Goal

So whats this all about… I’ve been running a homeserver for a few years now, using different kinds of linux distro’s. The server usually more or less built from leftovers of previous workstations. The old system also includes 2x 3slot SATA harddisk enclosures, connected to a promise raid controller. The system was a 2.6Ghz core2duo with 4GB memory and 2x 250GB system drives. The system was storing all our data, videos, photos via Samba/Netatalk and took backups (bacula) of my various servers on the net. It was also running a nagios monitoring installation. Everything was encrypted with the usual linux LUKS stuff.

PC V2120

So why a new system?

  • Energy consumption too high. As you may know, energy isn’t as cheap anymore. With the recent changes in Germany and some not so clever decisions made by our fearless leaders, the prices for energy skyrocketed and the pressure to built intelligent less power consuming systems keeps on growing. While i totally agree on shutting down nuclear power plants, i don’t like the way how renewable energy is subsidized and how big energy companies profit by putting the burden on the customer. Actually i think, core infrastructure such as energy, water, public transport etc. should be handled by the government or non-profit organizations, rather than companies.
  • Next generation filesystem. Everyone’s generating lots of data these days. Documents, Scans, Photos and Videos of your family, your music etc. Maybe you already convinced your family to create backups, do this extra step and bought them a time capsule or similar. You have a raid in your homeserver and you are aware of the fact, harddrives wear out over time..  Now considering, you store your digital life for centuries and do everything right, keep replacing disks and so on.. collecting terrabytes of data over the years.. you won’t even notice if any of your data is damaged until it is too late. Here comes ZFS to the rescue, by taking care of the integrity of your files. By generating checksums for all your files and keeping multiple copies of it. It will detect broken files and replace them automatically with the working copy. A nice side effect for ZFS, it includes also compression and deduplication. On Solaris it even includes an encryption layer.



  1. Data integrity. The ZFS Filesystem is said to require 1GB memory per TB stored, especially if you want to use deduplication, since this feature will hold big hashtables in memory. Afaik, only the Oracle Solaris 11 supports the builtin ZFS encryption layer. But Solaris is a commercial system, requiring you to have some support contract if you use it in production. While this isn’t necessarily a problem for a homeserver, the supported hardware list for solaris is very short. So i will try to stick with FreeBSD and take the performance hit it comes with by using GELI encryption below the ZFS layer. Since i will be using SSD drives for the main OS, i try to get some performance back by adding some SSD caching to the ZFS. I would also love to use ECC memory.
  2. diskspace should be at least 6-8TB usable space, with room for additional drives
  3. As for energy, i am trying to get the most performance at the lowest energy. Performance is required for encryption, compression, occasional realtime transcoding. Depending on how it works out, everything should spin down or step down if it is idle.
  4. Remote Access
  5. Low Noise

Hardware so far…

  • Intel Server Board S1200BTLR – Sockel1155, SandyBridge, 2xGbit, 2x SATA3, 4x SATA2, onboard GFX, up to 4x8GB ECC DDR3 Memory, IPMI 2.0 ~200EUR
  • Intel Xeon E3-1265LV2 – TDP 45W, QuadCore 2.5Ghz, IvyBridge, AES-NI, HT, Turbo Boost, VT flags ~300EUR (wikipedia)
  • Adaptec 7805 – 8x Port SAS/SATA Raid Controller, lowprofile, 1GB cache, support for FreeBSD, support for drives with 4TB size, up to 256 drives using expander. ~500EUR
  • cheaper “dumb” controller LSI SAS 9207-8i for ~200EUR even got Solaris Support.. and FreeBSD.
  • Lian Li PC V2120 – beautiful, low noise chassis with plenty of room for more disks ~400EUR
  • Western Digital Red Harddrive – 3TB SATA3, low 24dB Noise, 24/7 support, Low power: 4,4W read/write, <1W sleep/standby power consumption ~140EUR


  • Update: I found a mainboard with USB3 and ECC. Have a look at Supermicro X9SAE.
  • Update: Order is out to 3 different stores. I took the Supermicro X9SAE-V which allows two x8 PCIe3.0 instead of a single x16 PCIe3.0 .. considering i may need more disks some day and a 2nd LSI SAS 9207-8i Controller. Rest as expected, 3x 3TB WD red drives, Xeon E3-1265LV2 but a slight change for the chassis, its a Lian Li PC-P80N now, since its just standing in some dark corner anyway, so no need to look beautiful.. but not getting my hands bloody on the installation and having 10 3,5″ harddrive slots as well as 2 2,5″ slots for 2 ssd drives, is nice. I will be using two Sandisk G25-G3 Extreme SSD 2,5″ 120GB for the system itself and as cache for the ZFS. The reason for the sandisk was it is pretty fast Sata3(6Gbit), 550MB read/510MB write, a good MTBF of 2.500.000 hours and as expected a low 0,6W read/write energy consumption. For the operating system, i will see how a solaris 11.1 installation will work out. If it fails to support anything or does not fully use powersaving features, i may still consider FreeBSD on the 2nd run 🙂
  • Latest Update: No free updates, no solaris.


This post will be updated as they come in.

Tagged with:
Feb 23

Another fancy error message that took me some time to figure out. I haven’t even found the entire reason yet, but found a workaround.
The error is thrown by accessing the repository catalog in the Contao Backend.

Ok, since i use a Gentoo Installation, that is always up2date, but sometimes runs into some dependency problems i wasn’t sure if the SOAP part of PHP has some generic error. First try was to search for the WSDL path in the files.

I found it only once, contaoroot/system/config/config.php :
$GLOBALS[‘TL_CONFIG’][‘repository_wsdl’]      = ‘http://www.contao.org/services/repository.wsdl’;
I downloaded the file, placed it locally and changed the value. Worked, so the SOAP part of PHP is working.

After some more fiddling around, checking with tcpdump, it doesn’t even try to connect to the outside world, so i’m assuming i have some other network/naming related issues since this stuff runs on a VM with a RFC1918 private IP but with access to the internet.

Anyway, the better workaround was to use my proxy by adding the following to the config:
$GLOBALS[‘TL_CONFIG’][‘useProxy’] = true;
$GLOBALS[‘TL_CONFIG’][‘proxy_url’] = ‘’;

Original Error Message:
[22-Feb-2012 21:35:50 UTC] PHP Fatal error: Uncaught exception ‘SoapFault’ with message ‘SOAP-ERROR: Parsing WSDL: Couldn’t load from ‘http://www.contao.org/services/repository.wsdl’ : Start tag expected, ‘<‘ not found
‘ thrown in /var/www/xxxxx.de/system/modules/rep_client/RepositoryBackendModule.php on line 139



Mar 13

Ping Logo
I am using a Squid Proxy in my home network to filter outbound access. The WLAN configuration in my iPhone is using this proxy too, but since there is no ‘exclude from proxy’ option there, everything on any ports gets thrown at this Squid Proxy. The Ping Tool is also using a specific port to receive it’s messages. I also sent a mail to the developer, telling him to consider a more friendly port (80,443) for his app so people could use this app also behind firewalls, proxies which you have … at least in a corporate environments.

No answer so far. So here is the solution, at least to get it to work if you have access to your Squid Proxy.

acl http proto http
acl iphone_push dstdomain push.emailmii.net
acl iphone_push_port port 1919
always_direct allow iphone_push
http_access allow CONNECT iphone_push_port iphone_push
http_access allow http iphone_push_port iphone_push

make sure its BEFORE those entries:

http_access deny !Safe_ports
http_access deny CONNECT !SSL_ports
http_access deny all


Update: This is obsolete by now. I think they realized to use standard ports.

Tagged with:
Jan 27

Nach einer kleinen Odyssee von Zahnarztbesuchen, muss ich einfach mal ein paar Dinge an die Werte Zahnarzt Gemeinschaft loswerden. Es gibt da ein paar Dinge, vor denen sich Eure Angstpatienten am meisten fürchten.

Hier also die TOP5 von Dingen wie Sie besser laufen könnten

1) Nehmt Angstpatienten als solche ernst. Kein, ach Schnick-Schnack und auf gehts.

2) Wenn Eure Angstpatienten nach Betäubung fragen und es wirklich ein Risiko auf Schmerzen gibt, ja Herr Gott dann betäubt!

3) Fachsprache. Wenn Euer Angstpatient auf Eurem Präsentier-Teller.. errm Behandlungsstuhl sitzt und die Augen zu hat, dann schläft er nicht. Im Gegenteil, er ist bis zum Bersten angespannt und super empfindlich auf jedes Geräusch, jeden Laut und jeden Fachbegriff. Leider kann der Otto-Normal-Zahnarzt-Gänger mit gewissen Fachbegriffen nicht umgehen und assoziiert diese automatisch mit bekannten Dingen. Aussprüche wie “OH, da müssen wir Kanäle suchen!” .. “da müssen wir VORNE REIN”, “Ich brauch die 45ziger Stäbe.. ja die Großen” sind da sehr gefährlich und schon pauschal mit Phantomschmerzen behaftet. Ein Arzt der “Ohje” sagt, ist nochmal eine Kategorie für sich. Etwas Erläuterung was da passiert, wann das Schlimmste vorbei ist usw. wäre sehr hilfreich.

4) Warteräume: In meinen Augen gibt es nichts Schlimmeres als total helle weisse klinisch rein stinkende Behandlungsräume und Wartezimmer. Man weiß sofort wo man sich befindet, in der Zahnarzt Hölle und Mephisto spricht “Guten Morgen” durch Ihren S.A.R.S. Mundschutz am Empfang. Sterile Wartezimmer mit vielen aktuellen Aushängen was die schönsten neuesten Methoden zur Behandlung sind, das die Krankenkasse XY nicht mehr übernimmt und eine passende Akustik eines entfernten Bohrers und Schreie von Kindern (jedoch aus dem nahe liegenden Kindergarten) .. alles äußerst hilfreich 🙁

5) Behandlungsräume: Man wird also richtig zum Schafott, sprich Behandlungsstuhl geführt, der am besten noch schön zentral das Zentrum des Raumes ausmacht, selbstverständlich mit Tür im Rücken das man sich schon generell im Ungewissen fühlt (Sogar die Neandertaler haben mit Höhleneingang im Blick geschlafen). Dann der Stuhl; darüber befindet sich dann ein Halogenstrahler der sicherlich gefühlt auch ein Fußball Stadion beleuchten könnte. Gerne darf man auch erste Einblicke über die gesamte Bohrer-Kollektion sammeln oder andere mehr oder weniger aktuelle technischer Errungenschaften , die stolz direkt im Blickfeld des Opfers aufgebaut wurden und dem gemeinen Computer Nerd nur zu einem verängstigten “OH GOTT; Steinzeit!” verleiten.

Hier darf gerne mal was geändert werden.. 🙂

Nerd Visions – oder wie es sein sollte!

Fangen wir die Wunschentwicklung mal langsam an.

Q1 / 2011 – Nachdem der Hausbesuch Ihres Zahnarztes zum Zwecke des Halbjahres Checks im heimischen Wohnzimmer (nach zuvor einem entspannten Gott-und-die-Welt Plausch bei Kaffee und Kuchen), ein paar kleine Probleme zu Tage geführt hatten, wurden Sie von diesem zeitnah in seine Praxis eingeladen. Dort angekommen begrüßt Sie eine hübsche Zahnarzthelferin in einem asiatisch angehauchtem Begrüßungsraum, in feinem Ambiente mit schönen Gerüchen und beruhigenden exotischen Klängen. Sie werden zu einer kleinen Theke geführt und dürfen sich Ihre Wartezeit bei einem warmen Getränk oder Cocktail vertreiben oder aber im Nebenraum eine kleine Kopf und/oder Schultermassage genießen. Für den gemeinen Nerd, ist selbstverständlich ein offenes WLAN verfügbar.

Update Q1/2010: Juchhee, scheint sowas schon zu geben. Check.

Q1 / 2015 – Nach den enormen Fortschritten im Computerbereich seitdem Anfang der 90ziger, zog die Medizin im zweiten Jahrzehnt nach und Miniaturisierung, Nano Technologie, Molekular Biologie feiert Ihren Einzug in fast alle medizinischen Branchen. Anfangs unterstützend, konnten normale Füllungen absofort durch zu dem Zeitpunkt noch nicht intelligente Nano Partikel repariert und der Zahn wieder fast vollständig intakt gesetzt werden. Dabei kamen Materialien aus der Raumfahrt zum Einsatz und die somit ersetzten Bestandteile eines Zahnes wurden somit unkaputtbar und konnten sowohl Kälte, Hitze und Säuren jeder Art trotzen.

Q3 / 2020 – Intelligente Nano Partikel können durch komplexe Computerprogramme Zähne komplett neu aufbauen. Bis auf mögliche Abstossungsprobleme seitens des Patienten, führte dieser Fortschritt zu einer enormen Steigerung der Lebensqualität. Dem nahezu schmerzfreien Eingriff (spritzen der NanoPartikel) ging eine ausgiebige Computeranalyse und ein “TetraHydroCloud” Scan voraus, welcher für die Programmierung der Nanopartikel notwendig war. Der nun ungefährliche Scanner ersetzte die Röntgengeräte die bis 2017 noch im Einsatz waren. Dies war ein Nebenprodukt der durch die Sicherheits-Hersteller-Lobby inszenierten Terror-Wahns Anfang des 21. Jahrhundert hervorgegangenen Forschung entstanden, nachdem 2014 Hacker die komplette interne Kommunikation dieser Firmen und einschlägiger Politiker veröffentlichten.

Q2 / 2030 – Ein Unterteilung von Ärzten findet nicht mehr statt. Nach der Weiterentwicklung der Gentherapien und Analyse des Körpers auf molekularem Level sind physische Eingriffe nur noch in der kurzfristigen Unfallmedizin notwendig, insofern der Patient nicht rechtzeitig in die Cryostasis Zellen gebracht werden konnte. Die Menschen werden permanent durch im Körper befindliche Nano Einheiten auf Defekte auf molekularem Level überwacht. Erkannte Probleme können durch diese kurzfristig repariert werden oder übermitteln notwendige Daten für eine Gentherapie an den Menschen. Kleine Schäden an Zähnen werden somit entweder sofort repariert oder unfallbedingte Komplett-Ausfälle können durch eine Gentherapie veranlasste Neubildung des Zahns wie bei Schulkindern in wenigen Wochen behoben werden. Nur noch wenige Menschen haben Ihre ursprünglichen Zähne und meist kommen gentechnisch improvte Varianten zum Einsatz. Lediglich in gewissen höheren Kreisen gehört es zum extrem kostspieligen Schönheitsbild noch seine ursprünglichen Zähne zu besitzen und von Schönheitszahnärzten warten zu lassen.

Nov 03

So this is my late good bye india post.
At the time i am finishing this draft, we are already back in Germany and ate our first Schnitzel on Saturday evening. The flight back home went more or less well (thanks to Online Checkin), even though the Delhi airport was very confusing… But lets do a little review for a few more details and feedback.

– Thanks to some other Koenig students, we found a proper tailor! As usual in India, everyone stared at us and the manager instantly charged us, asking us for our wishes. Being european, you are kind of overwhelmed by so much customer care, because you are not used to it. Fortunately the manager was very kind and spoke very good english, so we quickly felt comfortable in his shop, which by the way had western standard. We told him our departure would be in just 3 days ahead and asked if it would be possible to get a suit done in this short time. After a confident “YES, SURE!” we tried to find the right fabric, which took quite a while because there were millions to choose from. Next up we had to decide on a design and all the extras we wanted to have, followed by detailed measuring of my size. Two hours and a coffee later we were finally done. On Thursday, we went back to the tailor for the fitting of the jacket, which already looked quite good. We inquired to see the trousers too, which unfortunatly didn’t fit! Now it was going to get close for them, because there was only 1 night left to fix this. The manager promised us that there will be no charge at all if they failed to make this right. Next day (shortly before our departure)i tried the trousers again and they fit perfect. It was quite a challenge for them to create a complete suit in just 3 days, but they did great. So here is my recommendation for “Reid & Taylor” on Rajpur Road in Dehradun. The price for the complete suit was 110 Euro (6800 Rupees), most of it for the fabric.

Reid & Taylor in Dehradun
Reid & Taylor in Dehradun

– I followed my lovely wifey for some shopping at the market. We took a Tuk-Tuk and got dropped of at Clock Tower right at the start of the chaos. Welcome to the most annoying shopping experience ever. It’s common knowledge that men don’t like shopping, except for the huge electronic stores or some other special shops. This was pure madness. Imagine a shopping street, with just 5-6m width, thousands of small shops that basically just sold jewels, food or cloth… crowded like hell and on top of that motorbikes everywhere. They were either parked in the way or chasing you from all sides… and as usual supported by lots of horn sounds. I have no idea how people are supposed to buy anything or look into the show cases, being in constant danger! After endless hours of running around we finally got Sandra’s shawls. If you ever thought Frankfurts main shopping mile at christmas time is chaos, check out indian markets on Diwali.

– Fun note, we went into a bookstore because i had hoped to find some cheap english computer books for a few topics or programming languages.. but i was shocked because all i could find were old Windows 3.1 and Word 97 books 😉

Beware of indian firecrackers! I remember some years ago, radio announcements telling me not to buy firecrackers in the countries around germany like poland or czech republic because of unforseen explosions. We bought them anyway cause they were much louder than the german firecrackers. But you should really see the indian ones.. everytime you dropped a firecracker it caused a blast like a grenade and left over a crater.

Good Bye Madhuban Hotel! Special thanks to all the employees in the Madhuban hotel who brought us a newspaper every morning, made us scrambled eggs, made our laundry for a cheap price and cleaned our room without having a hoover. The room was pretty nice, not exactly european 4****, but clean, with a very nice view and a very comfortable bed. I am just glad we didnt stay at the cheaper Grand Meedos Hotel, which was located right at the street with all the noise and polution.

– I would also like to thank all the friendly indians we met there. With the religion permanently present, (pictures, statues and merchandising articles) everyone seemed very calm, friendly and relaxed. One thing Indians definately need to care more about is their environment. They have a very healthy way of life, only vegetables, no meat, no drugs… but the polution problem causes the deadliest diseases ever. Another negative thing to say is about the garbage everywhere, which often makes amazing temples and beautiful places look dirty und ugly. Not to mention there is a climatic change that will probably hit countries like India or southern asia FIRST!

Please keep clean !
Please keep clean !

– The Pizza Hut in Dehradun does not deserve our Thanks at all, because they were the reason for our sickness on the way back. Obviously the pincher Pepsi wasn’t coming from a bottle and kind of poisoned us. We still havent fully recovered from this.

Europeans, maybe it is because of being in a foreign country or maybe because all the indian people looking at you like you are an alien… but europeans in India seem to instantly bond with each other and get a conversation running. Usually europeans wouldnt talk to each other without apparent reason. This totally changed in India because everyone seems to be happy to find another ‘familiar’ face, which most likely shares the same experiences here and most likey speaks good english! So this Thanks goes to all those nice students out there, which became our friends or provided some company 🙂 Greetings especially to the peeps from the United Kingdom, Ireland, Switzerland, Netherlands and Belgium 🙂

Traveling back started very funny. On the way to the train station, our british mate got a phonecall from Koenig, because he forgot his keys. Being a little under pressure to catch our train, we still had to wait then for someone from Koenig to bring the keys. Being constantly under attack from beggers / kids asking for money or food this was a long wait. Finally a Koenig’s Sysadmin showed up on his motorbike and brought the keys 🙂
Then our travel towards home continued. The train was easy to find and the Koenig staff helped us with everthing. Thanks a lot for this! On the 6 hour train trip back to Delhi we have been watching Becker Episodes on my Macbook. Fortunately we had a power socket right above our window. Well we still had to monitor the socket all the time, because the plug was about to fall out everytime the train was shaking a little.
In Delhi we got picked up from Koenig Staff Members who spoke very good English and brought us to the car, which then took our british collegue to his hotel and us to the Delhi airport.
The Delhi airport was basically very good, except there is military checking you in and you have to fill out this immigration form again.

– Thanks to the early ONLINE checkin, we got our seats in the plane this time, which were in the very back of the plane. This was a lucky circumstance since Sandra was hit pretty hard by this nasty stomache problem and was basically camping the toilet the entire flight. I was able to sleep some and then we were back in Germany again 🙂
We took a taxi back home and were glad to eat our first Schnitzel the next day…

– The nasty stomache and diarrhea was keeping us busy for a total of two weeks.

– After all it was a very nice experience and most of the credit for it goes to the Koenig staff. Everything was very well organized and taken care off. I can recommend it for everyone who wants some adventure and experiences in a foreign country along with a cheap way to get some of the most accepted IT certificates around.

Tagged with:
preload preload preload