WISE v4.8 Release Notes

Table of Contents Release Schedule Goals Unresolved Issues Major additions/changes Minor additions/changes Updating instructions (for people upgrading from v4.7) 1. Create the wise.properties file 2. Queries to merge sail_database and vle_database into wise_database 3. Other queries

Release Schedule

Release dates:
Stable: late Feb 2014
RC1: early/mid Feb 2014

Goals

1. Merge "VLE" and "PORTAL" projects into one "WISE" project: https://github.com/WISE-Community/WISE
   1. Reduce memory footprint by merging the two projects
   2. All configurations will be done in one "wise.properties" file
2. Create simpler workflow for developers who want to contribute
   1. Require less setup (use HSQLDB, one config file)
   2. Write up git workflow to check out project, make changes, and commit
3. Generic JS/HTML5 step type https://groups.google.com/d/msg/wise4-dev/WXKRETtmj8I/YeHyduXMR2wJ

Unresolved Issues

1. Use one import.sql file for HSQLDB and Mysql

Major additions/changes

1. Merged "VLE" and "Portal" codebase into "WISE": https://github.com/WISE-Community/WISE
   1. Merged "vle_database" and "sail_database" into "wise_database"

Minor additions/changes

1. Minor additions go here

Updating instructions (for people upgrading from v4.7)

1. Create the wise.properties file

1. Find the wise_sample.properties file located here /wise/src/main/resources/wise.properties
2. Copy the wise_sample.properties file and name the new copy wise.properties. Keep the wise.properties file in the same directory as the wise_sample.properties file.
3. Change the property values in the wise.properties file appropriately.

For example you will most likely need to change these three lines to point to the paths used on your computer

wiseBaseDir=/Users/wise/tomcat/webapps/wise
curriculum_base_dir=/Users/wise/tomcat/webapps/curriculum
studentuploads_base_dir=/Users/wise/tomcat/webapps/studentuploads

You may or may not need to change certain property values. A lot of them do not need to be changed.

2. Queries to merge sail_database and vle_database into wise_database

In v4.8, all of WISE's database is stored in "wise_database". In v4.7 and older, VLE data was stored in "vle_database", and PORTAL data was stored in "sail_database". We'll need to merge the two into "wise_database".

First, we'll need to create a new 'wise_database' and give appropriate privileges to the wise4user like so:

# log into mysql as root
$ mysql -u root -p     

# create new database called 'wise_database'
mysql> create database wise_database default character set=utf8;

# give wise4user access to the new database
mysql> grant all privileges on wise_database.* to 'wise4user'@'localhost' identified by 'wise4pass';

mysql> flush privileges;  
mysql> exit;

Next, we'll dump vle_database and sail_database into backup files, and them import them into wise_database

# dump vle_database into vle_database.sql
$ mysqldump vle_database --user=wise4user --password=wise4pass > vle_database_dump.sql

# dump sail_database into sail_database.sql
$ mysqldump sail_database --user=wise4user --password=wise4pass > sail_database_dump.sql

# import vle_database.sql into wise_database
$ mysql wise_database --user=wise4user --password=wise4pass < vle_database_dump.sql 

# import sail_databse.sql into wise_database
$ mysql wise_database --user=wise4user --password=wise4pass < sail_database_dump.sql 

3. Other queries

Run these queries in your database:

# update portal settings
mysql> INSERT INTO wise_database.portal (id,settings,sendmail_on_exception,OPTLOCK) VALUES (1,'{isLoginAllowed:true}',1,0);

# update class paths in acl_class table to match new code layout
mysql> update wise_database.acl_class set class="org.wise.portal.domain.project.impl.ProjectImpl" where class="org.telscenter.sail.webapp.domain.project.impl.ProjectImpl";

mysql> update wise_database.acl_class set class="org.wise.portal.domain.run.impl.RunImpl" where class="org.telscenter.sail.webapp.domain.impl.RunImpl";

mysql> update wise_database.acl_class set class="org.wise.portal.domain.workgroup.impl.WISEWorkgroupImpl" where class="org.telscenter.sail.webapp.domain.workgroup.impl.WISEWorkgroupImpl";