Setup Java, Tomcat, MySQL on Ubuntu (JSP Hosting)

This tutorial will lead you to setup a simple JSP hosting on Ubuntu machine. You may want to consider this as a basic setup to host any of your web application which developed using Java - JSP or Servlet, Tomcat and MySQL.

** If you had downloaded Ubuntu 8.04 LTS Desktop Edition, you can skip the step below and goto Step 8. Desktop edition will be easy to install. All you need is to boot from the CD and follow the instruction closely.

Install Ubuntu Ubuntu 8.04 LTS Server
Step 1: Download the Ubuntu Server from http://www.ubuntu.com/
Step 2: Burn the ISO file into CD and boot your machine from CD.
Step 3: Follow the installation step closely and it is easy to do it
Step 4: Once install successfully, you will require to login.
Step 5: After login, perform the necessary updates. Make sure you have the internet connections. Type sudo apt-get update to do the update.

Install the GNOME desktop
Step 6: Type sudo apt-get install ubuntu-desktop to download and install GNOME.
Step 7: Type startx to start the GNOME

**You can install KDE desktop instead of GNOME. However, this is up to your taste. To install KDE, type the command sudo apt-get install kubuntu-desktop

Install JDK and JRE (Java)
Step 8: Open the terminal. Applications --> Accessories --> Terminal


Step 9: Type sudo apt-get install sun-java6-jdk


Step 10: After successful install, you can do some verification to find out the installed JDK and JRE version. At the terminal, type javac –version for JDK and java –version for JRE.



Install Apache Tomcat 5.5
**Before installing the Tomcat 5.5, you will need to ensure that you had installed JDK and JRE.

Step 11: Download the tomcat 5.5 from http://tomcat.apache.org/ and saved it to desktop. Here, apache-tomcat-5.5.26.tar.gz been used.
Step 12: Right click on the file and click on Extract Here


Step 13: Rename the folder to tomcat for easier to remember the folder name.
Step 14: Is good idea to move the tomcat to /usr/local directory.
Type the command sudo mv tomcat-on-your-desktop-path /usr/local


**You need to tell the tomcat where the JDK has been installed and to do this you need to define the JAVA_HOME environment variable in .bashrc file.

Step 15: You are about to edit the .bashrc file. Please backup the file first before make any changes. The .bashrc is a hidden file and is located in your home directory.




Step 16: Right click on the .bashrc and select Open with “Text Editor”.

**Alternatively, at terminal, type the command gedit ~/.bashrc (GNOME) or kate ~/.bashrc (KDE)

Step 17: At the end of the file type export JAVA_HOME=/usr/lib/jvm/java-6-sun and save the file.


Start and Stop tomcat
Step 18: At terminal, type sh /usr/local/tomcat/bin/startup.sh
Step 19: You can verify the success installation by open the Mozilla Firefox browser and browse to http://localhost:8080/
Step 20: At terminal, type sh /usr/local/tomcat/bin/shutdown.sh

Install the MySQL Server 5.0
Step 21: At terminal, sudo apt-get install mysql-server

** The step 22 and 23 are optional. Both are GUI which allow you to manage the database easily.

Install MySQL Query Browser.
Step 22: At terminal, type sudo apt-get install mysql-query-browser

Install MySQL Administrator
Step 23: At terminal, type sudo apt-get install mysql-admin

**I am assuming that you have the experience to do the deployment by yourself. All you need to do now, are:
-create all the necessary database, tables and fields,
-you will place your .war file into /usr/local/tomcat/webapps,
-start the tomcat....