Command Line Tools

    Database Deployment

    Prior to successfully starting the application itself, an initial database schema has to be created. Besides the application war file ( RegistryCxn.war ) a zip package (e.g. RegistryCxn.zip ) is provided that contains a script responsible for creating the DB.

    1. Extract the zip file into a selected folder.

    2. Make sure that the location of the registry.properties file containing the DB connectivity information is referred by the environment variable REGISTRYCXN_HOME.

    3. Start ./RegistryCxn bash script or RegistryCxn.bat in the RegistryCxn/bin folder of the extracted content (depending on the OS type). The following are available: 

    
 -disableGlobalProjectAccess   together with sqldeploy, disables global
                               project access rights
 -dropSchema                   drops all database objects from
                               registration schema
 -dropSchemaDS                 drops all database objects from downstream
                               schema
 -help                         print this help summary
 -migrateSchema                create or upgrade database objects in
                               registration schema
 -migrateSchemaDS              create or upgrade database objects in
                               downstream schema
 -schemaInfo                   prints informations about the registration
                               schema
 -schemaInfoDS                 prints informations about the downstream
                               schema

    In order to create an initial DB schema or clean an existing one completely, please use the following command line: 

    
./RegistryCxn -migrateSchema
./RegistryCxn -dropSchema -migrateSchema

    Since version 16.09.05-917: 

    
./RegistryCxn install -migrateSchema
./RegistryCxn install -dropSchema -migrateSchema

    Clearing the Database

    It is possible to clear all the structures from the database while keeping the configuration, users, groups and projects in the system. After running a script, the structure-related database tables will be cleared and the sequences will be reset. This method is designed for testing purposes, it is not recommended execute it on a production database.

    In order to use this functionality, please use the database deployment script with the following argument:

    
./RegistryCxn clear-data

    Creating a group

    To create a group with the Command Line Tool, you have to use the "create-group" command where you have to enter the name, roles and optionally the source of the group (by default it's DB). The syntax is:

    
./RegistryCxn create-group -group <group_name> -source <source_name> -role <role_names>

    (Before version 19.13.0-1907171250 the -source attribute could not be used.)

    Source can be either DB, AD, LDAP, SAMLSSO, OAUTH2.

    Role names can be found here:https://docs.chemaxon.com/display/docs/Groups+and+roles

    (From version 19.13.0-1907171250 you can add multiple roles by entering a list of role names separated by spaces.)

    Updating a group

    From version 19.13.0-1907171250 it is possible to update the roles defined by a group using the Command Line Tool. To do this, you have to use the "update-group" command where you have to enter the name, roles and optionally the source of the group (by default it's DB). The syntax is:

    
./RegistryCxn update-group -group <group_name> -source <source_name> -role <role_names>

    The arguments have the same meaning as in the "create-group" command.

    Create a user

    To create a user with the Command Line Tool, you can use the "create-user" where you have to enter the name, password, and group.

    The syntax is: ./RegistryCxn create-user -name <user_name> -password <user_password> -group <group_name>

    Export/import configuration of the application

    This feature is available from version 20.8.0-2005111440. The configuration of the system at a given point can be exported with the migration command line tool. The application server needs to be stopped in order to correctly do the export or import. The configuration will be saved in JSON format.

    Currently the handled configurations involve the following items:

    -Forms

    -Dictionaries

    -Fields and their form associations, dictionary associations

    -Parameters

    During import, the version of the configuration in the file is matched against the exact version of the target application. Import will be prevented in case of a mismatch.

    Importing a configuration file will completely restore the configuration state of the application to the point when the configuration file was exported.

    Usage

    Export configuration

    Command line arguments for the migration script:

    First command line argument: export-configuration

    Second command line argument: -path export-path

    Options for the export-path:

    -The path to a valid directory can be provided, in this case the configuration is exported with default file name and extension: "compreg-configuration-timestamp.json"

    Where timestamp stands for the exact time of export.

    -The path to a file can be provided, in this case no default filename will be used:

    "my-exported-configuration.json"

    Examples

    Export to file with default name:

    $./RegistryCxn export-configuration -path /usr/export

    Export to file with custom name:

    $./RegistryCxn export-configuration -path /usr/export/my-export.json

    Import configuration

    Command line arguments for the migration script:

    First command line argument: import-configuration

    Second command line argument: -path import-path

    Options for the import-path:

    -A valid path to an exported file has to be provided

    Examples

    Import file:

    $./RegistryCxn import-configuration -path /usr/export/my-exported-configuration.json

    {info} The content of the file before import is not validated. Please do not modify this, otherwise it can lead to unforeseen consequences for which we don't take responsibility for.

    {info} If a new file is exported with the same name, the old one will be overwritten.