Good bye CentOS! Hello Ubuntu

CentOS, Linux, PHP, Reviews, Tips and Tricks, Ubuntu
Its been about almost more then two years since I have been playing with CentOS on many different platforms etc. Its very stable but on the other hand, PHP/MySQL updates are very hard to get and still PHP is 5.1.6. I tried EPEL repo and it updated PHP to 5.3.1 but still there were conflicts with stuff and many core packages. So, I thought why not move to Ubuntu since it has just announced 10.04LTS (Long Term Support) in April 2010. Folks at iWeb were really nice to do a reinstall without any charges and also process a memory upgrade request at an amazing 50% discount. Ubuntu 10.04 LTS Apache 2 version is 2.2.14 PHP version is 5.3.2 MySQL version is 5.1.41-3ubuntu12 SVN (Subversion) version is 1.6.6 As a comparison…
Read More

To update or not to update?

CentOS, Linux, Thoughts, Ubuntu
All my technical life, I knew and followed this simple rule New updates to any application or component are meant to improve and fix the bugs present in it. Downloading new updates ensures that you system is up-to-update, has fixes to all those bugs you have been getting annoyed with and more stable. Unfortunately not every IT department thinks that, especially the one I am facing at work. According to them, the new updates should only be applied IF and only IF they offer some new functionality (duhh!). Hello! what happened to the bug-fixes that are promised with these updates? (more…)
Read More

Installing / re-installing and Configuring phpMyAdmin on Ubuntu

How to, Linux, OpenSource, PHP, Resources, Tips and Tricks, Tutorials, Ubuntu
phpMyAdmin is a very common and handy tool that most of the developers use. It is available on almost every server. Installing phpMyAdmin on Ubuntu server is even easier, you just need to [sourcecode language="plain"]sudo apt-get install phpmyadmin[/sourcecode] but what if we accidently skip the configuration screen where phpmyadmin makes modifications to apache? Dont worry just do the following Edit Apache's configuration file (assuming you are using apache2) [sourcecode language="plain"]sudo nano /etc/apache2/apache2.conf # better to use the following command instead of the one above #gksudo gedit /etc/apache2/apache2.conf[/sourcecode] Add the following line of code inside apache2.conf: [sourcecode language="plain"]Include /etc/phpmyadmin/apache.conf[/sourcecode] Now restart Apache: [sourcecode language="plain"]sudo /etc/init.d/apache2 restart[/sourcecode] Go to /phpmyadmin/ and login with your mysql username and password.
Read More

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

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

Using CPanel/WHM API to get detail list of all accounts

How to, Linux, Resources, Tips and Tricks, Tutorials, Ubuntu
Today I had this need to get a list of WHM Accounts using one of its APIs. I have never used it before but it was really simple to use. It returns an xml file that you can manipulate using your prefered language and store it in database for reporting etc. Here is what you need to do, connect to your server using SSH and run the following command [code lang="plain"]wget http://your-server-ip:2086/xml-api/listaccts --http-user=myuser --http-password=mypass --output-document=listaccts.xml[/code] Replace your-server-ip with your WHM's ip and myuser/mypass with the actual WHM/CPanel password. The resultant xml file will be saved as "listaccts.xml" in the same directory as you ran the command in. If you feel a bit insecure running these command over SSH then visit this page on your browser and save it as an…
Read More

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