Page History

...

Installation and Deployment

Step 1.  DB changes to be deployed to migrate to

...

caNanoLab 2.2 from caNanoLab 2.1

a   Execute the following scripts in the order specified below:

1. Create the following table: 
   CREATE TABLE favorite_data (   
  favorite_data_id bigint(20) DEFAULT NULL,  
  data_id bigint(20) DEFAULT NULL,  
  data_type varchar(200) DEFAULT NULL,  
  data_name varchar(200) DEFAULT NULL,  
  login_name varchar(200) DEFAULT NULL,  
  protocol_file_id bigint(20) DEFAULT NULL,  
  pubmed_id bigint(20) DEFAULT NULL,  
  editable tinyint(1) DEFAULT '0',  
  description text,  
  protocol_file_title varchar(200) DEFAULT NULL
2. https://github.com/CBIIT/common-security-modulecananolab/blob/master/software/common/resources/db/db-upgrade/mysql/MigrationScript5.0MySQL.sql
3. https://github.com/CBIIT/common-security-module/blob/master/software/common/resources/db/db-upgrade/mysql/MigrationScript5.1MySQL.sql
4. Execute the following script to reset passwords for all of the accounts:
   update csm_user set password = 'zJPWCwDeSgG8j2uyHEABIQ==';
update csm_user set first_time_login = 1;cananolab-2.2-it-11/software/cananolab-webapp/db-scripts/2.2/caNanoLab22.sql

Return to top

b  Migrate

...

access control data from CSM 5.2 to Spring Security.

CSM 5.0 has introduced using AES encryption to encrpt CSM User information while storing it in CSM_USER table. If you are upgrading CSM from 4.x to 5.x, apart from migrating the database, you would need to run encryption migration. This step expects PASSWORD column values in CSM_USER are not altered from the their original values created through CSM API.

...