JuiceBlog A TFC - Internet - Debian - Juice blog. Formerly named the most famous orange juice of the world, ever!

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.

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.

Windows 8 clean install with an upgrade license

I really needed a clean Windows installation, so after moving a lot of files I reinstalled it, and all went well so far. But then Windows 8 told me it wasn’t activated. I tried entering my key again, but it then told me: The Software Licensing Service determined that this specified product key can only be used for upgrading, not for clean installs. Luckily, I wasn’t the only one with this issue. This post in the Microsoft forums describes the solution quite well. Here’s a step-by-step tutorial for you. Press 🪟 to open the start menu, type in regedit and press ENTER .

A few helpful mail tips

Most of these things never really bothered me on their own, but after some time it just starts to get annoying. Especially when all the mail you get is about how a file exists that you could easily and quickly delete, or how the configuration is just not right for another certain, convenient feature. How do I read mail? / Which client should I use? To read your mails, you could use the standard mail application. I suggest you try others, like mutt. It’s actually quite nice, if, like me, you just need a client to read local system mail. When it comes to more, you might want to check if your favourite E-Mail desktop application can read the system mail.

Upgrade ownCloud from manual install to repository

I started out with a manual installation on version 4.5.4. It was located in a /home/ folder rather than the /var/www/ directory, which gave me opportunity to think some more. So, let’s begin. Go to the folder your ownCloud installation is in and tar it, in case anything goes wrong. sudo tar -cjvf owncloud.tar.bz2 owncloud/ Since it’s now owned by root because of the sudo, make it yours now. sudo chown orangensaft:orangensaft owncloud.tar.bz2 Subscribe to the new ownCloud server repository. sudo vim /etc/apt/sources.list Add this line at the bottom: deb http://download.opensuse.org/repositories/isv:ownCloud:community/Debian_6.0/ / Then add the key, update your repositories and install owncloud.

MySQL Dump: Access Denied

I needed an SQL dump of my Global GoldSrc Database to continue work locally. Un-/Fortunately, the server owner and sysadmin is very concerned about server security, so I was unable to just dump the database with this: mysqldump -p -u osaft osaft_gtfcdb4 > osaft_gtfcdb4-20130213.sql The server wouldn’t let me because of insufficient access. mysqldump: Got error: 1044: Access denied for user ‘osaft’@’localhost’ to database ‘osaft_gtfcdb4’ when using LOCK TABLES Fortunately, there’s a simple solution that should work like a charm: –single-transaction. mysqldump -p -u osaft osaft_gtfcdb4 --single-transaction > osaft_gtfcdb4-20130213.sql Then just bzip it (or not) and you’re done! tar -cvjf osaft_gtfcdb4-20130213.

Installing Fonts on Debian

Soo, I was told that the font I use isn’t a proper coding font and I should use Source Code Pro. Fine. But if we’re already installing fonts, let’s download Source Sans Pro aswell. Source Code Pro is obviously for development environments, while Source Sans Pro is meant for user interface usage. Installing fonts on a GNU/Linux machine is really simple; you just have to move them to a /usr/share/fonts/ folder and update the font cache. Thanks to Linux And Friends for providing me with this solution. Alright, let’s begin. Download the font packages wget http://sourceforge.net/projects/sourcecodepro.adobe/files/SourceCodePro_FontsOnly-1.017.zip wget http://sourceforge.net/projects/sourcesans.adobe/files/SourceSansPro_FontsOnly-1.038.zip Extract the files

Installing Chrome on Intenso Tab 417

Basically.. (2013-01-22) All you need to do is download the Google Play store *.apk file and install it on your device, then download Google Chrome through the App store. Solutions found on Intenso Tab 714 – Playstore installieren. USB connection (2013-01-22) Start your Tab 417 and connect it to a computer with a USB to Micro USB cable. A notification about an established USB connection will appear on your device in the lower right corner. Click on it and enable the device’s USB storage feature. This will enable you to mount the whole drive on your computer and transfer the file if you chose to download it on your computer.

User Startup Programmes in Debian

I’ve always loved to start programmes automatically. Just boot up the computer, maybe even log in automatically if it’s a desktop at home, and start all the programmes you need. It took me quite a while, but I figured out the one and only, perfect way to do that: *.desktop files. Let’s go to our applications folder, which should contain most of the *.desktop files responsible for your Applications menu. cd /usr/share/applications/ Let’s assume you want to autostart guake. Check for folder contents with ls or find the programme you want to auto start with ls | grep guake. Then, copy that file to your autostart folder.

Booting Win8 to Desktop

Windows 8 Metro is a joke. Luckily, there are a few workarounds to start with the proper desktop shell. My favourite: Scheduling a task that runs explorer.exe after every log in. Since there are enough tutorials out there, I’m not going to bother writing it down here. Make Windows 8 boot straight to the desktop Alternatively, you could just download a GNU/Linux distribution. Why not Ubuntu?