The future of GoldSrc mapping on GNU/Linux

I like GNU/Linux and the fact that Valve is releasing their Steam and Team Fortress Classic clients on it.
I also like mapping for TFC and just recently picked it up again. Due to my recent decision to move to Debian Wheezy on my gaming / desktop computer I have been denied the pleasure of mapping with native mapping tools so far. The Valve Hammer Editor (formerly Worldcraft) is a win32 programme, other editors could be an option, but I prefer the "offiical" tools.
I wrote Alfred Reynolds [Steam] [GitHub] an e-mail about this, since he's currently one of the main GoldSrc developers at Valve. While I was happy for a quick response, his words saddened me. I'd like to share them with you.
Hammer is a very win32 specific tool and we have no plans on making it run natively on Linux at this time, I suspect your best bet here will be to use Wine to let you run it.
Well, is my best bet Wine? I haven't tried Wine/VHE yet.
I've always preferred native programmes, it just feels right. And I know there are Linux-based mapping tools our there for the Quake engine, which should be fairly compatible to GoldSrc, which itself is "just" a QuakeWorld modification. I haven't found a proper, as in easy to use and fairly to fully compatible to the GoldSource RMF or MAP format, map editor.
If anyone knows of any, please leave a comment or write me. I'll post something as soon as I find a solution.

How to find the MSSQL version in a backup file

Okay, so I had this SQL dump, but no idea which Microsoft SQL server version it came from.
It's not that difficult to make a good guess though; In the file it shows the original database paths. If you're lucky, you didn't completely change the instance's folders and your instance folder is named somewhat like these.
  • SQL Server 2005 uses MSSQL.<n> (counting up, starting at 1, n+1)
  • SQL Server 2008 uses MSSQL10.<INSTANCENAME>
  • SQL Server 2008R2 uses MSSQL10_50.<INSTANCENAME>
So, open the SQL backup file in a text editor of your choice and search for .mdf. That should put you at the end of the path you need. Just check the path against the list above.

Why the NVIDIA graphics driver should be available in repositories

It's not that big of a deal, but would it really be that big of a problem to deliver a proper .deb package for the driver installation? I had to let the Nvidia installer disable my Nouveau driver, I had to manually stop LightDM and I also had to correct the /usr/bin/gcc link, since Nvidia apparently doesn't care about my CC environment variable.
sudo service lightdm stop
sudo rm /usr/bin/gcc
sudo ln -s /usr/bin/gcc-4.6 /usr/bin/gcc
What's up with that?


Installing Debian with Mate

Preparing your installation medium

First you need to put your Debian image on a USB stick. You can do this by using the dd command; if is the input file, of is the output file. We are going to use the ISO as input and the USB device address as output.
dd if=/home/orangensaft/Downloads/debian-wheezy-DI-rc1-amd64-netinst.iso of=/dev/sdb
When it's done you'll see a new line, ready for input. At that point, you may restart your system and boot from USB.

Installing Debian & initial setup

I recommend keeping a second USB stick around to conveniently deliver missing firmware to the installer, although this is optional if they aren't essential network or display drivers. Put the missing firmware files or its packages into the root, or a firmware/ folder on your installation media or a second USB stick.
When the system is running, we'll switch to root..
su root
.. and install sudo, vim (or your favourite text editor) and bash-completion (to get the convenient tab feature).
apt-get install sudo vim bash-completion
After that, add your user to the sudoers group.
adduser username sudo
And let's restart.
shutdown -r now

Installing MATE, LightDM


Follow MATE instructions.


We'll use LightDM as our display manager. It's relatively small, has a bunch of features and.. "why not?".
sudo apt-get install lightdm
By default you'll have a login window with a username and password input. If you'd rather have a list of users to choose from, apply this change.
sudo vim /etc/lightdm/lightdm.conf 
Set greeter-hide-users to false
or, if you haven't touched your ligthdm.conf yet or just don't want to, you may also use the following to append the line to your LightDM config file.
su root 
echo "greeter-hide-users=false" >> /etc/lightdm/lightdm.conf


Depending on your needs and your installed system, you may want to enable other architectures. If you are installing an amd64 system and additionally want i386 packages, this is what you have to do.
sudo dpkg --add-architecture i386 
sudo apt-get update


The sources.list is your system's repository file. If you're often checking other repositories for files or just want more available packages, you should take my own sources.list and replace yours with it for awesomeness.
sudo pluma /etc/apt/sources.list 
Replace it with mine


su root 
apt-get install -y sudo vim bash-completion 
adduser orangensaft sudo 
shutdown -r now
sudo dpkg --add-architecture i386 
sudo vim /etc/apt/sources.list 
> deb http://repo.mate-desktop.org/debian wheezy main
sudo apt-get update 
sudo apt-get install -y mate-archive-keyringsudo 
apt-get updatesudo apt-get install -y mate-core mate-desktop-environment lightdm 
shutdown -r now
sudo pluma /etc/apt/sources.list 
> # https://gist.github.com/kriswema/5431388 contents here, adjust to your needs 
sudo apt-get install -y pidgin pidgin-otr vlc eiskaltdcpp libreoffice gdebi netbeans