01May 2009 by Asim Zeeshan 6 Comments

Installing MySQL 5.1 on Ubuntu

How to, Linux, Tips and Tricks, Tutorials, Ubuntu
I wanted to use PARTITIONING introduced in MySQL 5.1 to handle some 2 Million records (and growing everyday) in a table. Ubuntu 8.10 does not have MySQL 5.1 available if you do apt-get the latest version available is 5.0 So this is what I did, its easy and this might help somebody. [sourcecode language="plain"]nano /etc/apt/sources.list[/sourcecode] I prefer nano editor but you can use any editor of your choice. Add these new lines at the end of the end of the file. [sourcecode language="plain"]deb http://ppa.launchpad.net/monty/ubuntu gutsy main universe restricted multiverse deb http://ppa.launchpad.net/smurf/ubuntu gutsy main universe restricted multiverse[/sourcecode] (These packages were targeted for 7.10 so I will recommend using them and removing them from this list once you got the latest MySQL version) Now run the following commands [sourcecode language="plain"]apt-get update apt-get…
Read More
22Jan 2009 by Asim Zeeshan No Comments

Ubuntu: Setting default gateway / ip etc

How to, Linux, Resources, Tips and Tricks, Tutorials, Ubuntu
If you want to specify a default gateway or ip address for your Ubuntu installation, try the following steps. Open SSH and type this command [code lang="plain"]sudo nano /etc/network/interfaces[/code] You can edit everything there as shown in the screenshot below (click to enlarge) [code lang="plain"] auto eth0 iface eth0 inet static address 192.168.1.231 netmask 255.255.255.0 network 192.168.1.0 broadcast 192.168.1.255 gateway 192.168.1.77 # dns-* options are implemented by the resolvconf package, if installed dns-nameservers 192.168.1.253 192.168.1.226 dns-search nextbridge.org [/code]
Read More
09Jan 2009 by Asim Zeeshan 2 Comments

Intall Apache, MySQL and PHP on Ubuntu 8.10

How to, Linux, OpenSource, Resources, Reviews, Tips and Tricks, Tutorials, Ubuntu
WARNING: Please use this method to install Apache, PHP and MySQL because its more suitable for most of your needs and has options to auto-upgrade your installation. The following method is obsolete and not recommended. After trying to install Apache, MySQL and PHP on Ubuntu 8.10 via several methods listed over the web. I opted for xampp package for linux. It is as easy as ABC Download the xampp linux package from their official website [code lang="plain"]wget http://nchc.dl.sourceforge.net/sourceforge/xampp/xampp-linux-1.7.tar.gz[/code] (I have selected NCHC, Taiwan as the mirror to download this package, you may try another) Extract the files [code lang="plain"]sudo tar xvfz xampp-linux-1.7.tar.gz -C /opt[/code] Chmod the files to have nobody ownership [code lang="plain"]sudo chown -R nobody:root /opt/lampp/[/code] Configure xampp security [code lang="plain"]sudo /opt/lampp/lampp security[/code] Start xampp with this command [code…
Read More
08Jan 2009 by Asim Zeeshan No Comments

Download files from a http authenticated directory using wget

How to, Linux, OpenSource, Resources, Thoughts, Tips and Tricks, Tutorials, Ubuntu
I wanted to download something off a sub-domain using wget that I have password protected using .htaccess so the following command was NOT working [code lang="plain"]wget http://secure.asim.pk/myfiles.tar [/code] Luckily, we can pass two arguments to the same command and tell wget what the username and password is [code lang="plain"]wget http://secure.asim.pk/myfiles.tar --http-user=myuser --http-password=mypass [/code] Works Great!! If you are using Ubuntu 8.10, have not enabled root user and trying to download to a directory that has "nobody" or "root" as owner then try pre-pending it with sudo [code lang="plain"]sudo wget http://secure.asim.pk/myfiles.tar --http-user=myuser --http-password=mypass [/code]
Read More
08Jan 2009 by Asim Zeeshan 2 Comments

How to Install Webmin in Ubuntu

How to, Linux, OpenSource, Resources, Reviews, Tips and Tricks, Tutorials, Ubuntu
From the little help that I can get over the internet, I found out that you need to install the following packages to prepare the system for Webmin installation. Run the following command over SSH or Ubuntu Desktop's terminal window (Applications -> Accessories -> Terminal). [code lang="plain"]sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl libmd5-perl [/code] (Learn how to configure SSH on Ubuntu 8.10 if you want to have a remote access to your Ubuntu box). Download the latest version of Webmin by running the following command (visit webmin download section for newer versions) [code lang="plain"]wget http://ignum.dl.sourceforge.net/project/webadmin/webmin/1.500/webmin_1.500_all.deb [/code] Downloading Webmin After the package has been downloaded, run the following command to install it [code lang="plain"]sudo dpkg -i webmin_1.500_all.deb [/code] You should now be able to login to Webmin at…
Read More
08Jan 2009 by Asim Zeeshan No Comments

Configuring SSH on Ubuntu 8.10

How to, Linux, OpenSource, Resources, Tips and Tricks, Tutorials, Ubuntu
The first issue that I had after installing Ubuntu 8.10 was that I could not connect to SSH on it because SSH server is not installed on Ubuntu 8.10 and it never asked me if I wanted to make a selection of what software packages I need to have installed. I guess thats why they are making a less then 25 min install promise. Here's how you can enable / configure / install SSH on your Ubuntu 8.10 Open a terminal window by selecting the Applications menu and selecting Terminal from the Accessories menu. In the terminal window enter the following command and press enter to execute it [code lang="plain"]sudo apt-get install openssh-server[/code] It will automatically download and install the SSH serve and configure it to run on port 22…
Read More
08Jan 2009 by Asim Zeeshan 1 Comment

Ubuntu 8.10, Perfect Linux distro for PHP development

Linux, OpenSource, Resources, Reviews, Thoughts, Ubuntu
I recently felt the urge to have a development testing environment on Linux (LAMP). I tried CentOS first since it is one of the leading industry standard Linux server. I was disappointed to see that CentOS does not have a 5.2.x series of PHP that I could install via "yum" (am not a very advance user so does not wanted to build it by typing long queries in SSH just to find out that I left some core thing in the first place). I did a bit of research and found out that Ubuntu could be a better choice. Luckily I had the latest version of Ubuntu already shipped via Postal Mail (aka Snail Mail) and this time the CDs DID get through the customs. For those new to Ubuntu,…
Read More