Deploying The Blue Elephant Referee Scheduler

Prerequisites

The Blue Elephant Referee Scheduler is web-based software that must run on a Java web server (currently only tested on Tomcat 5.0.19). Ask your current web hosting provider for details on hosting Java web applications, or shop around for a web hosting provider if you do not have one (this will have the added benefit of allowing your league to go on-line with league e-mail and a league website).

The Software also requires a database to run. It is currently confirmed to run with the MySQL database: to use other databases some minor configurations changes will be necessary.

Getting the Software

Download the software through this link.
Use of this software, though free, is subject to the terms of the license.

Configuring the Software

Once you have all the files in a folder, several changes are needed to customize the software for your needs.

In pages/fragments/BaseTag.jsp, replace the web site address with the address where this software will be located.
In WEB-INF/src/resources/LocalizedStrings.properties, change the line ResetPassword.Email.Sender=<user>@<domain> to reflect your site administrator's email address.
In WEB-INF/web.xml, an SmtpServer parameter appears on line 99. Change it to the address of your web host's SMTP server.
In pages/fragments/BasicHeader.jsp, change the name of the organization to what fits you best.
If your league is not a Soccer League, you may want to change the image referenced in the first few lines of main.css to point to a more appropriate picture for your sport.

Setting up the Database

The next step is setting up the database on the web host. Install or run Ant. Select the file WEB-INF/src/build.xml as the Ant script to load. The database tables needed to support the Referee Scheduler can be generated from the exportDDLtoFile target. This creates the mossl-schema-export.ddl file in the WEB-INF directory. In MySQL, some additional work is needed. Database tables need to be of type InnoDB. To do this, you need to modify the mossl-schema-export.ddl file by appending "type=InnoDB" before the ';' at the end of each CREATE statement. i.e.:

CREATE TABLE GAME (.....)type=InnoDB;

Copy mossl-schema-export.dll to MySQL's bin directory. Then open a terminal and go to mySQL's bin and run

mysql -u root -p

(Go to http://dev.mysql.com/doc/mysql/en/Post-installation.html if you've not done anything to configure your MySQL server). Also remember to set a root MySQL password. Now that you're in the MySQL console, type the following commands:

create database test;
use test;

Now, if you've created the database test as shown before, you want to grant access to outside users. Do this like so:

grant all privileges on test.* to blue@"%" identified by 'elephant';

(test and blue elephant are the actual names - don't change them).

Completing the installation

Now that the database is set up, and the project is customized as you see fit, all that is left to do is copy the entire BERefereeScheduler into your web server's webapp directory. Then, use your web server's control panel to load the project, and you're done!