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

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