MySQL and Tomcat can be installed, run and used independently of each other and openXdata and as a resulted can be installed as pre-built packages on many linux distributions as well as being freely available to download from their respective project home pages.

Installing MySQL

Full instructions regarding the install and running of MySQL can be found at the MySQL home page – www.mysql.org. MySQL is a very widely used database and you should find many, many resources online. Whilst, openXdata doesn’t provide support for MySQL but we’re happy to try and help where we can to get you up and running.

In ubuntu, to install MySQL

$ sudo apt-get install mysql-server

During the installation process you will be asked to set a root password.  For your own security:

  1. do not leave this blank
  2. do not set this to be the same as your computer’s user or root password
  3. make the password secure and keep if safe

Once installed, to access mysql type

$ mysql -u root -p

you will be prompted for your root password that you set during installation and you will then enter the mysql command line environment where you will be able to use commands to administer your mysql databases.

Installing Tomcat

Again, full instructions can be found on the apache tomcat website http://tomcat.apache.org.  On Ubuntu, Tomcat and the Tomcat Web Application Manager (useful if you’re not a fan of the command line) can be installed as follows:

$ sudo apt-get install tomcat6 tomcat6-admin

To use the Web Application Manager you will need to set-up a user to do this.

  • Browse to tomcat6 conf directory
    • $ cd /var/lib/tomcat6/conf
  • Edit the file tomcat-users.xml (you need to be root to do this on a default Ubuntu installation)
    • $ sudo nano -w tomcat-users.xml
    • Modify the file so it looks like this (replacing TOMCATUSER and PASSWORD for your own secure choices):
    <tomcat-users>
                   <role rolename="manager"/>
                   <user username="TOMCATUSER" password="PASSWORD" roles="manager"/>
    </tomcat-users>

    On Ubuntu (this may vary by distribution), once tomcat is installed via the package manager apt (method described above), then you can access all the required folders through the folder /var/lib/tomcat

    1. Tomcat logs – /var/lib/tomcat6/logs -> /var/log/tomcat6
      • If you’re having problems you may be asked for output from files in this folder.
    2. Tomcat configuration – /var/lib/tomcat6/conf -> /etc/tomcat6
      • Find files to configure custom aspects of your tomcat setup such as custom port configuration
    3. Tomcat webapps directory – /var/lib/tomcat6/webapps
      • The directory where all your web applications live, including openXdata

    On ubuntu to start and stop tomcat you will need sudoer privileges and the commands are:

    • To start tomcat
      • $ sudo /etc/init.d/tomcat6 start
    • To stop tomcat
      • $ sudo /etc/init.d/tomcat6 stop
    • To restart tomcat
      • $ sudo /etc/init.d/tomcat6 restart

    If you do a manual installation by downloading the tomcat zip file from the tomcat website, when you unzip it all the the folders listed above will be found in whichever location you extract your zip file. To start/stop/restart tomcat from a manual installation use /path/to/tomcatfolder/bin and then startup.sh and shutdown.sh e.g.

    • $ cd /home/myhome/tomcat/bin
    • $ ./startup.sh