Page History
...
Welcome to the caNanoLab 2.1.1 2 Installation Guide.
Info | ||
---|---|---|
| ||
For any general information about the application, application support, or to report a bug, contact Application Support. |
Topics in this document include:
Introduction to caNanoLab
...
For more information about the 2.1.1 2 updates, see the caNanoLab 2.1.1 2 Release Note.
Open Source Technologies
...
Step 1. DB changes to be deployed to migrate to CSM 5.2
a Execute the following scripts in the order specified below
...
:
- 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
- https://github.com/CBIIT/common-security-module/blob/master/software/common/resources/db/db-upgrade/mysql/MigrationScript5.0MySQL.sql
- https://github.com/CBIIT/common-security-module/blob/master/software/common/resources/db/db-upgrade/mysql/MigrationScript5.1MySQL.sql
- 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;
b Migrate encryption from 4.x CSM database.
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.
- Download the CSM UPT v5.2 distribution file into a designated folder (for example,
c:\csm_52
). Be sure to note the folder name and location. - Extract the contents of the downloaded csm_upgrade5.2.zip into a designated folder (for example,
c:\csm_52\csm_upgrade5.2
). - In the designated folder, find and modify the upgrade.properties file. Database properties must be updated with the upgraded database connection details.
- Open the cmd window and navigate to
c:\csm_52\csm_upgrade5.2
- Run "ant -Dproperties.file=upgrade.properties migration:run".
...
Step 2. caNanoLab installation instructions to upgrade to 2.1.1
...
# | Action | |||||
---|---|---|---|---|---|---|
1 | Set up an environment variable JBOSS_HOME to point to the Wildfly installation directory.
| |||||
2 | Execute the Ant build script build.xml located at <CANANOLAB_SOURCE>/build with the target deploy:cananolab-webpp. Example: Issue the following commands to execute the Ant script: C:\>cd C:\caNanoLab_2.1\build Successful execution of the Ant script generates the following artifacts that include two deployable web archive war files, configuration files and libraries for running the web application in the Wildfly environment, and also places these artifacts in the appropriate directories under <JBOSS_HOME>. Artifacts generated are also available in the following folder under <CANANOLAB_SOURCE>:
| |||||
3 | We recommend increasing the JBoss JVM heap size to 2G bytes and permanent generation (permgen) memory space to 256M bytes by updating the file <JBOSS_HOME>/bin/standalone.conf with the following JAVA_OPTS:
This configuration file is read when Wildfly server starts. For a standalone server, pass in the JVM settings either as command line arguments when executing the | |||||
4 | 1. Create a new directory structure C:/local/content/caNanoLab/artifacts and move the following artifacts.
Create a new directory structure
| |||||
5 | Start JBoss application server in Standalone mode. From
The cli scripts assumes the CLI port is running at 19990. If it is different, update the port number at the second line in the script. For Windows environment:
For Linux environment:
Run the remaining After successful completion, you should see following output in the window.
|
...