How to Install Apache, PHP and MySQL on CentOS

How to, Linux, OpenSource, PHP, Resources, Tips and Tricks, Tutorials
I have seen people installing Apache, PHP and MySQL from source code on a production server. You should NEVER, NEVER, NEVER install these packages from source on an RPM or DEB based Linux distributions. Did I say “NEVER” enough times to make your realize that it is not a good practice? Installing from source is bad idea; there are many reasons for this but the major one is that you will be spending a lot of time keeping the system updated. If you love installing from source then I would suggest using a different distribution e.g. Gentoo. You can build from source if the package is not available in yum but still, try to use “yum” (or “apt-get” on Ubuntu) because it will save a lot of your time when…
Read More

How to Install Webmin on CentOS

How to, Linux, OpenSource, Resources, Tips and Tricks, Tutorials
Install dependencies before we proceed to install webmin [code][root@testbed ~]# yum -y install perl-Net-SSLeay[/code] Download latest rpm package from Webmin's official website [code][root@testbed ~]# http://www.webmin.com/download/rpm/webmin-current.rpm -O /tmp/webmin.rpm[/code] Once it is downloaded, install the RPM using the following command [code][root@testbed ~]# rpm -i /tmp/webmin.rpm[/code] No more steps required. Its installed :) Go to your browser and access the control panel with valid ssh credentials. Default URL is https://your-ip:10000/ (IF you have not changed the default port)
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

Join Vteams (NEXTBRIDGE) Network on Facebook

How to, Linux, Resources, Tips and Tricks, Tutorials
I have recently request FaceBook to add the Vteams (aka NEXTBRIDGE in Lahore, Pakistan) as a network. To join, you must have an active @nxvt.com email account, just go to Setting -> Account, select network tab. In network name box type "Vteams", enter email address and click JOIN. Check your email and click on the confirmation link Congratulation, you have joined the Vteams Network
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