Upgrade from v4.0.3 to v4.1.0

TL;DR

  1. Export data from host with v4.0.3
  2. Install on another host a fresh v4.1.0
  3. Import data from v4.0.3
  4. Update SQL schema
  5. Enjoy

1. Export data from v4.0.3

  1. Stop Apache
  2. Stop Tomcat
  3. Then export DB with
mysqldump \
  --user=asqatasun \
  -p \
  --databases asqatasun \
  --result-file=SAVE_DB_asqatasun.sql

2. Install Asqatasun v4.1.0

3. Import data from v4.0.3

systemctl stop tomcat8.service
mysql --user=asqatasun -p -e "drop database asqatasun;"
mysql --user=asqatasun -p <SAVE_DB_asqatasun.sql

4. Update SQL schema

Grab the two following file:

And apply the following (order in important):

mysql --user=asqatasun -p asqatasun <asqatasun-40-update-from-4.0.3-to-4.1.0.sql
mysql --user=asqatasun -p asqatasun <tgol-40-update-from-4.0.3-to-4.1.0.sql
systemctl start tomcat8.service

5. Use Asqatasun 4.1.0

  • Accounts, credentials and projects have been imported, so you can use your usual login / password

Other information

One may have to update a few field definitions:

ALTER TABLE EVIDENCE_ELEMENT
    MODIFY `Element_Value` mediumtext NOT NULL;
ALTER TABLE PRE_PROCESS_RESULT
    MODIFY `Pre_Process_Value` mediumtext DEFAULT NULL;
ALTER TABLE PROCESS_REMARK
    MODIFY `Snippet` mediumtext DEFAULT NULL;
ALTER TABLE PROCESS_RESULT
    MODIFY `Indefinite_Value` mediumtext DEFAULT NULL;
ALTER TABLE TGSI_SCENARIO
    MODIFY `Content` mediumtext NOT NULL;