You are here

Guide

MySQL charset issues while importing data using LOAD DATA INFILE

Submitted by Druss on Tue, 2011-09-27 20:47

Earlier today, I was banging my head against the wall trying to import some data in a CSV file into MySQL. While my imports have gone well thus far, this time around I was dealing with data involving lots of strange diacritics, runic squiggles and other manners of gibberish that make the world as fun as it can be. In other words, I was dealing with Unicode.

Implementing a shutdown timer in Windows 7

Submitted by Druss on Wed, 2011-08-17 21:15

Every now and then, I find the need to shutdown my PC automatically at a specified time for some reason or the other. In my most recent case, I needed to shut my Windows 7 PC down at 8am in the morning anticipating a scheduled power shutdown in my block. While there are many GUI-based applications out there that could do this for me, I chanced upon a simpler solution detailed below:

Google Chrome infected with the Facemoods toolbar and search engine

Submitted by Druss on Thu, 2011-08-11 00:38

I tried searching for something in Chrome a few minutes ago and found that my search was being handled by something sinisterly named Facemoods. Aghast, a few more checks confirmed that I had a toolbar installed on my system of the same name, the Chrome search engine was set to Facemoods by default and that I had an extension installed as well. A little more digging revealed that all this was jDownloader's fault as it installs the toolbar during its own installation process. Not good.

Removing all this junk involves the following steps:

Configuring Vim/Gvim to use spaces instead of TABs for indentation

Submitted by Druss on Wed, 2011-08-10 03:00

Some people like to indent their code using TABs. I used to like doing this. I still think that it's a good idea. But circumstances have dictated for the past several years that I need to indent using spaces instead. My favourite command-line editor in Linux and text editor in Windows is VIM / Gvim (where Gvim is basically Vim with a GUI). To configure this editor to override its default and use spaces instead of TABs for indentation, perform the following steps:

SSH password-less login using PuTTY on Windows

Submitted by Druss on Thu, 2011-06-30 00:27

So, if you, like me, have to resort to PuTTY sometimes to SSH into a Linux box, I'm sure that you have also subjected yourself to much gnashing of teeth at the lack of a Windows solution to password-less logins into your server. For the uninitiated, password-less SSH allows you to log into a server without manually authenticating yourself.

Setting up a Bind 9 DNS server in Debian/Ubuntu

Submitted by Druss on Tue, 2011-05-03 11:46

The Internet will go bust without DNS and the following is a guide to setting up your own DNS server to provide information about your domains and associated services. While this task can be accomplished very easily when using a hosting control panel, it is great fun to set things up on your own.

Compiling and installing KTorrent 3.3RC1 on Kubuntu Karmic

Submitted by Druss on Sat, 2009-11-07 20:30

Compiling KTorrent 3.3 RC1 on Kubuntu 9.10 Karmic with KDE 4.3:

Update 1: This works with 3.3 final as well.
Update 2: This works with 4.0 beta1 as well.

  1. Install cmake and related tools:
    sudo apt-get install cmake automoc build-essential gettext
  2. Install other required libraries:
    sudo apt-get install kdelibs5-dev kdebase-workspace-dev kdepimlibs5-dev python-kde4 libboost-dev libtag1-dev libqca2-dev libgmp3-dev

Upgrading KTorrent to 3.2 RC1 on Kubuntu Intrepid with KDE 4.2

Submitted by Druss on Fri, 2009-02-06 03:57

Upgrading KTorrent from 3.1.2 to 3.2 RC1 on Kubuntu 8.10 Intrepid with KDE 4.2:

  1. Install cmake and related tools:
    sudo apt-get install cmake automoc build-essential gettext
  2. Install other required libraries:
    sudo apt-get install kdelibs5-dev libqca2-dev libgmp3-dev kdebase-workspace-dev kdepimlibs5-dev libkrosspython0 libkrossruby0
  3. Remove the existing ktorrent installation as a precaution: sudo apt-get remove ktorrent. This should not affect your configuration files.

Restarting system services in KDE

Submitted by Druss on Mon, 2007-09-03 19:47

Here's a simple how-to on restarting services in KDE. I will be alluding to this article in other guides on this site, rather than repeating myself every time - Lazy organisation, I call it :)

  1. Click on KMenu and select System settings.
  2. Select the Advanced tab and click on System services.
  3. Click on the administrator mode button and enter your superuser password.
  4. In the huge list of services on the left, navigate to the service you would like to restart.

Installing and setting up Tor & Privoxy in Kubuntu & Firefox

Submitted by Druss on Mon, 2007-09-03 19:17

Tor is an open source project that allows users to utilise the Internet anonymously through the use of something along the lines of distributed proxies - the Onion router network. Privoxy is more of a local web proxy that, when configured correctly, can protect your privacy by filtering such information at the source. Together they are an effective and user-friendly (but not necessarily perfect) solution to preserving your anonymity on the Internet.

Pages

Subscribe to RSS - Guide