Sep 23

How to connect to Microsoft SQL server from Linux via command line

Although 95% of my work is done in Linux and MySQL, there are those unfortunate times I need to manipulate some data on a Microsoft SQL server. I didn’t want to install any apps on my computer that weren’t open source and I didn’t want to use a Micro$uck app through wine either. So after a few searches I came across an open source project called Sqsh. In this tutorial I’ll show you how to install sqsh and access a Microsoft SQL server from the Linux command line.

Continue reading

Aug 19

Apache Virtual Hosts in Ubuntu in 5 easy steps

In this tutorial I’ll walk you through setting up 3 Apache virtual hosts running on a single Ubuntu server. An Apache virtual host, as explained by Apache, refers to the practice of running more than one web site (such as www.company1.com and www.company2.com) on a single machine. Virtual hosts can be “IP-based” or “name-based”. By default, Ubuntu already has this capability enabled, so things are much easier to configure these days. Enough with the intro, this is how you do it:

Continue reading

Aug 07

Connect to Cisco Nortel Contivity VPN from Ubuntu

I finally figured out how to get Ubuntu to connect to a Nortel Contivity VPN. It took quite a while to find the right app and configuration, but after a lot of search, I’ve found a package called vpnc (vpn client for cisco3000 VPN Concentrator). The project homepage is found here and it is supposed to work with:

* Cisco VPN concentrator 3000 Series
* Cisco IOS routers
* Cisco PIX / ASA Zecurity Appliances
* Juniper/Netscreen

Continue reading

Jul 02

How to create a robotic voice using audacity

In this tutorial I’ll guide you through creating your very own robotic voice. You”ll need to have 1 tool installed, audacity audio editor. If you are running ubuntu, just run from the command line sudo apt-get install audacity, otherwise, head on over to their site and download the latest version and follow the install steps. Once audacity has been installed we can get started.

Continue reading

Jun 09

Setup Guest OS on a virtual disc image (virtual machine) on Linux

(This tutorial assumes you own a legal copy of the OS you’ll be using to install as the “guest” OS, be it Unix, Winblows or any other Operating System not mentioned here)

In this tutorial I’ll walk you through setting up a virtual machine in Linux using QEMU. According to QEMU site, QEMU is a generic and open source machine emulator and virtualizer. When used as a machine emulator, QEMU can run OSes and programs made for one machine (e.g. an ARM board) on a different machine (e.g. your own PC). By using dynamic translation, it achieves very good performance.

Continue reading