TechBytes | Technology Bytes

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

sudo apt-get install phpmyadmin

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)

sudo nano /etc/apache2/apache2.conf
# better to use the following command instead of the one above
#gksudo gedit /etc/apache2/apache2.conf

Add the following line of code inside apache2.conf:

Include /etc/phpmyadmin/apache.conf

Now restart Apache:

sudo /etc/init.d/apache2 restart

Go to /phpmyadmin/ and login with your mysql username and password.

Few weeks ago I wrote an article on how to setup Xampp package on Ubuntu. Today, I am revisiting this.

I came across a great article straight from the Ubuntu community, it is very simple, very strraight forward to setup Apache / MySQL and PHP on your Ubuntu box (server or desktop)

Read the article here.

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

sudo nano /etc/network/interfaces

You can edit everything there as shown in the screenshot below (click to enlarge)

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

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

wget http://nchc.dl.sourceforge.net/sourceforge/xampp/xampp-linux-1.7.tar.gz

(I have selected NCHC, Taiwan as the mirror to download this package, you may try another)

Extract the files

sudo tar xvfz xampp-linux-1.7.tar.gz -C /opt

Chmod the files to have nobody ownership

sudo chown -R nobody:root /opt/lampp/

Configure xampp security

sudo /opt/lampp/lampp security

Start xampp with this command

sudo /opt/lampp/lampp start

Stop xampp

sudo /opt/lampp/lampp stop

Restart xampp

sudo /opt/lampp/lampp restart

Login to ftp using the username nobody and the password that you have set up in the “xampp security”

To uninstall xampp

sudo rm -fr /opt/lampp

Enjoy!!

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

wget http://secure.asim.pk/myfiles.tar 

Luckily, we can pass two arguments to the same command and tell wget what the username and password is

wget http://secure.asim.pk/myfiles.tar --http-user=myuser --http-password=mypass 

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

sudo wget http://secure.asim.pk/myfiles.tar --http-user=myuser --http-password=mypass 

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).

sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl libmd5-perl 

(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)

wget http://ignum.dl.sourceforge.net/project/webadmin/webmin/1.500/webmin_1.500_all.deb 

Downloading Webmin

After the package has been downloaded, run the following command to install it

sudo dpkg -i webmin_1.500_all.deb 

You should now be able to login to Webmin at the URL https://localhost:10000/ using root or any other user with sudo access.