ScholarScrum Files

INSTALLATION GUIDE
==================

ScholarScrum needs
- Tomcat6 or Tomcat7 
- sun-java6-jre or sun-java7-jre
- MYSQL version 14.14 5.5.22 

Server configuration
====================
You have to configure the SSL (https port 8443) for tomcat. Basically, you have to:

Generate a key pair
  keytool -genkey -alias tomcat -keyalg RSA

Uncomment the SSL part of the "/etc/tomcat6/server.xml" file and add this line:
  keystoreFile="${user.home}/.keystore" keystorePass="changeit"

Restart the server:
  sudo /etc/init.d/tomcat6 restart

To get more details see this http://tomcat.apache.org/tomcat-6.0-doc/ssl-howto.html.


Database configuration
======================
ScholarScrum needs a database into a mySql server. Once you have installed a mySQL Server you must access to the mySql console. To do this, from a terminal write:

  mysql -u root -p

Once you are into the mysql console, you have to create a DB named 'scholarscrum'.

  CREATE DATABASE scholarscrum; 

Then, you need to create a user called 'scholarscrum':

  CREATE USER 'scholarscrum'@'localhost' IDENTIFIED BY 'norevelarjamas';

And you have to grant permisions on that database:

  GRANT ALL ON scholarscrum.* to scholarscrum IDENTIFIED BY 'norevelarjamas';

Now you can exit from the database to test the created user.

  quit

Now, you must import the database schema:

  mysql -u scholarscrum -p scholarscrum < scholarscrum.sql

And create the 'admin' user:

  mysql -u scholarscrum -D scholarscrum -p -h 127.0.0.1

  SET foreign_key_checks = 1;

  insert into USERT(fullName,username,password,roleU,photo,activeUser,idUserCreator) values('ScholarScrum administrator','admin','99bde2e47ce26207d81e8cca3d3cd89f','ROLE_ADMIN','/scholarScrum/resources/images/user.png',1,1);

  SET foreign_key_checks = 0;



TEST
====

Now you must to have access from you browser to www.yourdirection.com:8443/scholarScrum