Install Steam on Debian Jessie (Testing)

Finally, Jessie got the new libc 2.15 required for the Steam installer (2.17 even) – and no, I do not want to download system critical ubuntu debs and installing them somewhere in my home dir, especially not when it’s _libc6_.

# vim /etc/apt/source.list

deb jessie main non-free contrib
deb-src jessie main non-free contrib

deb jessie/updates main contrib non-free
deb-src jessie/updates main contrib non-free

# apt-get update
# apt-get upgrade
# reboot
# apt-get dist-upgrade
# reboot

As it seems that the steam deb package is sort of dependency wrapper for the steam-client, we’ll deal with all the dependencies first. Further, Steam is a 32 bit application and will require i386 libraries therefore. The guides on the internet for ubuntu and such just reference ia32-libs which have been deprecated/removed from wheezy in favor of real multiarch support with :amd64 and :i386 package name suffixes.

Note: Keep in mind that Debian Testing may require package migration from sid/experimental after wheezy release. Maybe it’s even better to wait for the first wheezy point release and let all on-hold packages from wheezy freeze first being migrated to testing, and then actually getting Steam to work here 😉

For the requirements – zenity (whatever that is).

# apt-get install zenity

The ugly part – the steam package requires the ubuntu-only jockey-common package. We’ll just wget and install here.

# wget
# wget
# dpkg -i python3-xkit_0.5.0ubuntu1_all.deb
# dpkg -i jockey-common_0.9.7-0ubuntu11_all.deb

On amd64, there are various i386 only packages required by Steam, so let’s enable that arch.

# dpkg --add-architecture i386

# apt-get install libc6:i386 libstdc++6:i386
# apt-get install libgl1-mesa-dri:i386
# apt-get install libgl1-mesa-glx:i386

Using nvidia graphics chip, install the openGL libraries for 32bit too (Steam is not built against 64bit, which is a shame, as even openarena is)

# apt-get install libgl1-nvidia-glx:i386

Then get the latest Steam deb and install it manually.

# wget
# dpkg -i steam.deb

Now run steam as your preferred user …




… and install CS 🙂


CS on Win7 VM – no jumping mouse pointer

“Steam on Linux” just means that some weird Ubuntu version got a package with tested dependencies, and is currently not of any fun to install on a real linux like debian provides.
So, the idea is fire up the windows 7 virtual machine and install Steam and Counter Strike in there. Not a problem at all – except for the mouse movements.

After a while, I figured 2 things:

* the vm must not use the absolute pointing device (“absolutes zeigegerät aktivieren”) in “Settings” – “System”


* the game itself requires at least “raw mouse input”




Then it’s time for …Fire in the hole….!


get year value from date cell in Excel

The german version of Excel uses the german translated function names (someone said ugly?). Now the challenge is

– add a date into a cell (excel auto-detects this to be a date)
– get only the year value into a new cell

Steps needed

– convert B4 date to string
– get the date value of that string
– get the year of that integer



Keep in mind that this is formatted for the german locales.

Z The Game in Dosbox

Install dosbox.

# apt-get install dosbox

Run dosbox once to create ~/.dosbox and the initial config. Then copy it to the unique name for “Z”.

$ dosbox
$ cd ~/.dosbox
$ cp dosbox-0.74.conf dosbox-z.conf
$ mkdir drive_c

Get “Z The Game” e.g. from over e.g. here. There’s an already installed image available here as well. Then copy the game folder “Z” to drive_c (and keep in mind to own the original game’s cd when applying the mini image trick here).

Add the following to your dosbox-z.conf in the [autoexec] section:

# Lines in this section will be run at startup.
# You can put your MOUNT lines here.
keyb gr
mount c /home/michi/.dosbox/drive_c

imgmount d /home/michi/.dosbox/drive_c/Z/Z_DOS.iso -t iso
cd Z

To start it full screen, put a new alias e.g. in your bashrc and start it.

alias z_game='dosbox -conf ~/.dosbox/dosbox-z.conf -fullscreen'

Speedport W921V with Client Bridged Linksys wrt320n

Well, referencing the old setup, it was time to change locations which included a new router, gotten from German Telekom. You may figure, that many people look for repeaters extending their range, but not that many speak of client bridge routers. Even more, they reduce the router to a vdsl modem and put their very own – though for the Entertain package you’ll require various vlan tagging which may be broken then. So, my goal is still to add clients in the flat and do not use any cables (and no powerplugs either).

Luckily, the Speedport W921V provides the 2,5 and 5Ghz bands too, so I will be re-using the 5Ghz one for adding the client bridge like before. The only slight change in this regard is the ssid and the wpa key. The speedport supports WPA2 Personal plus TKIP as well as AES, so perfectly fine. If there are connection issues, keep in mind that the 5Ghz band got a lower range than the 2,4Ghz.


So, no need to buy the Telekom bridge combinations, but use an old working router with dd-wrt 🙂

download youtube videos on debian squeeze

Downloading youtube videos is always a pita, some use firefox plugins, some install a windows app to snatch loaded flash videos, and some just want to use native shell without X – like me.

For gods sake, there is a debian package called youtube-dl which is available in wheezy and sid, but luckily backported to squeeze-backports as well.

IF using debian squeeze, first add the backports repository like described here.

# echo "deb squeeze-backports main" > /etc/apt/sources.list.d/backports.list
# apt-get update

Install it from backports (which is lower priority than your systems repo).

# apt-get -t squeeze-backports install youtube-dl

and run “man youtube-dl” to see all available options.

Below is an example of a 10h set of ASOT 550 which is rather huge.

$ youtube-dl "" -o A_State_of_Trance_550_Den_Bosch_-_Blue_Stage_Full_Set.flv
[youtube] Setting language
[youtube] 2zJOJbJeSZc: Downloading video webpage
[youtube] 2zJOJbJeSZc: Downloading video info webpage
[youtube] 2zJOJbJeSZc: Extracting video information
[download] Destination: A_State_of_Trance_550_Den_Bosch_-_Blue_Stage_Full_Set.flv
[download]   0.1% of 3.20G at    1.05M/s ETA 51:45

After downloading, you’ll get a flash video file (*.flv extension) which can be either played with VLC and comparable players, or encoded with ffmpeg, mplayer, etc. Keep in mind that h264 files will result in *.mp4 extension – so make sure to check that before defining the -o parameter.

For those interested in the origin source – it’s a python script kept updated on github: