install-orderlystats-core

This page describes the installation process of OrderlyStats Core

Now you've got all the necessary pre-requisites, you can install the core application.

First, stop Tomcat with: /etc/init.d/orderlystatsse stop

Next, download the OrderlyStats SE distribution from the download page - or the following code will save it to your home directory:

> cd ~
> wget http://www.orderlyq.com/orderlystatsse/orderlystatsse17.0a.tar.gz

Now, unpack the distribution into Tomcat's webapps folder with

> export CATALINA_HOME=/usr/share/orderly/tomcat
> cd $CATALINA_HOME/webapps
> tar -xvzf ~/orderlystatsse17.0a.tar.gz

The above example assumes that you have saved the distribution to your home directory (~). If you have saved it to a different location, you will need to change the '~' in the last command to the full system path to the file.

This will create a new folder called orderlystatsse in your Tomcat webapps folder.

NOTE: Please do not rename the orderlystatsse folder. This will break your installation. It must be called orderlystatsse to work.

NOTE: The use of symbolic links to move the $CATALINA_HOME/webapps or $CATALINA_HOME/webapps/orderlystatsse folders to a different location has also been known to cause the system to not work properly, so please avoid doing this.

NOTE: You should never have more than one instance of OrderlyStats in your $CATALINA_HOME/webapps folder. If you ever need to back up your OrderlyStats installation, make sure you copy it to a different folder.

Next we have to create the database OrderlyStats will use to store your call logs. The following instructions are for MySQL. You can also switch to instructions for PostgreSQL. To create the database:

> mysql mysql

HINT: If you get an "Access denied" message, then your MySQL installation is password protected. You will need to log in with: mysql -u USERNAME -p mysql, where USERNAME is the master username for your MySQL installation (usually root). You'll then be prompted for the master password - sometimes this is blank by default, or you may have been asked to supply one when you installed MySQL.

If you don't know the master username or password for your installation, you should consult your linux documentation - there are instructions for resetting this on Debian here.

At the mysql command prompt, type

SQL> CREATE DATABASE orderlystats;

Then, to create a user for OrderlyStats:

GRANT ALL PRIVILEGES ON orderlystats.* TO 'orderlystats'@'localhost' IDENTIFIED BY 'orderlystats' WITH GRANT OPTION;

NOTE:If you're running OrderlyStats SE on a different machine from MySQL, then you'll need to replace 'localhost' with 'orderlystats.ip.address' in the above command.

When the database has been created type \q to exit mysql.

Now that the database is created, we need to create the tables in it for OrderlyStats to use. OrderlyStats SE comes with a script to do this - to run it type:

> mysql -u orderlystats -p orderlystats < $CATALINA_HOME/webapps/orderlystatsse/WEB-INF/database_mysql.sql

If you are asked for a password, it is orderlystats

The last step is to install the JDBC drivers for your version of MySQL. You can get these at "http://dev.mysql.com/downloads/connector/j, or use this direct link (right-click to save).

Once you've downloaded the Source+Binaries file and unzipped it, you'll find a pre-compiled binary jar in its top level directory. Copy it to Tomcat with: cp mysql-connector-java-5.1.7-bin.jar $CATALINA_HOME/lib

One last thing: If you are upgrading from HypersonicSQL (from the All-In-One installer) then you need to edit /usr/share/orderly/tomcat/webapps/orderlystatsse/WEB-INF/OrderlyStatsSE.xml and uncomment the MySQL section, and comment out the HypersonicSQL section, as indicated in the file.