Page History
...
Property | Description | |||||
---|---|---|---|---|---|---|
file.repository.dir | A directory on the system that hosts the Wildfly application server for storing uploaded files, for example,
| |||||
admin.email | The email address that receives requests for new user accounts, for example, the NCI CBIIT application support email for the NCI CBIIT installation. | |||||
ldap.authentication.enabled | A Boolean flag to indicate whether or not to use LDAP for user authentication. caNanoLab 2.1.1 and beyond does not support LDAP authentication. Set this to | |||||
database.server | The name of the server hosting the database, for example, | |||||
database.port | The database port number, for example, | |||||
database.user | The database user name used in the caNanoLab application, for example, | |||||
database.password | The password for the database that the user specified above, for example, | |||||
database.system.user | The system database user name with privileges to create a database, create tables, and grant user accesses to a database, for example, | |||||
database.system.password | The password for the system database that the user specified above, for example, | |||||
jboss.server.dir | The Wildfly server directory, for example:
|
...
- 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 password for all the accounts:
update csm_user set password = 'zJPWCwDeSgG8j2uyHEABIQ==';
update csm_user set first_time_login = 1;
- Create the following table:
- Migrate encryption from 4.x CSM database.
CSM 5.0 has introduced using AES encryption to encrypt 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 will need to run encryption migration. This step expects that the PASSWORD column values in CSM_USER are not altered from the original values created through the CSM API.- Download the CSM UPT v5.2 distribution file into a designated folder (for example,
c:\csm_52
). Be sure to note 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. Update the database properties 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.
- Download the CSM UPT v5.2 distribution file into a designated folder (for example,
...
# | Action | |||||
---|---|---|---|---|---|---|
1 | Set up an environment variable JBOSS_HOME to point to the Wildfly installation directory. Note
| |||||
2 | Execute the Ant build script build.xml located at <CANANOLABat For example, issue the following commands to execute the Ant script:
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. The Ant script also places these artifacts in the appropriate directories under <JBOSSunder
| |||||
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 <JBOSSfile
| |||||
4 |
| |||||
5 | Start JBoss application server in Standalone mode. This script assumes the CLI port is running at 19990. If it is different, update the port number in the second line in the script. For Windows environment:
For Linux environment:
|
...
Once the deployment artifacts are deployed and the Wildfly application server is configured correctly configured, you can start the Wildfly application server, which in turn starts the caNanoLab application.
Open the URL, http://<APP_SERVER_URL>/caNanoLab/
, for example:
http://localhost:8080/caNanoLab
...