skilja/sitemanagement repository overview

⁠Quick reference

• Maintained by:
  Skilja GmbH⁠

• Where to get help:
  The Partner Portal⁠ or via email [[email protected]⁠⁠]

⁠Supported tags and Versioning

Image tags adhere to <major>.<minor>.<patch>.<revision> format.

<major>.<minor>.<patch>.<revision> points to a specific version. <Major>.<Minor> always points to the latest version. This version is compatible with all previous images of the same <Major>.<Minor> version. <latest> always points to the latest version, but such a version might require service and project database schema updates. For loading the latest but compatible version, we recommend to pull a <Major>.<Minor> with

docker pull skilja/sitemanagement:<Major>.<Minor>

The latest image tags are :

• 8.0⁠
  
  

⁠What is the Site Management Tool?

The Site Management Tool is a command line tool that allows maintaining users and groups assignments for license management, organization administrator, and site administrator roles and allows maintaining organizations.

The roles and user assignments are needed when you enable user authentication for your installation to have access control and define user rights for the installed applicatio

When the following Services is started for the first time, users do not have any permissions assigned by default.

• Tegra Classification Service⁠
• Classification Designer⁠
• Classification Monitor⁠
• Tegra Extraction Service⁠
• Extraction Designer⁠
• Extraction Monitor⁠

⁠How to use this image

The following sample shows how to run the Site Management Tool:

1. Create the needed envfile.txt

Just add your DB connections to the variables and that's it.
Leave *_HASAUTHENABLED=true

CLSSERVICE_CLSSDATABASESERVERTYPE=0
CLSSERVICE_CLSSDATABASESERVER=host.docker.internal
CLSSERVICE_CLSSDATABASENAME=ClassificationService
CLSSERVICE_CLSSUSEINTEGRATEDSECURITY=false
CLSSERVICE_CLSSSQLUSER=
CLSSERVICE_CLSSSQLPASSWORD=
CLSSERVICE_HASAUTHENABLED=true

CLSDESIGNER_DATABASESERVERTYPE=0
CLSDESIGNER_DATABASESERVER=host.docker.internal
CLSDESIGNER_DATABASENAME=ClassificationProjects
CLSDESIGNER_SQLUSER=
CLSDESIGNER_SQLPASSWORD=
CLSDESIGNER_USEINTEGRATEDSECURITY=false
CLSDESIGNER_USESSL=false
CLSDESIGNER_TRUSTCERTIFICATE=false
CLSDESIGNER_HASAUTHENABLED=true

OLCLS_OLDATABASESERVERTYPE=0
OLCLS_OLDATABASESERVER=host.docker.internal
OLCLS_OLUSESSL=false
OLCLS_OLTRUSTCERTIFICATE=false
OLCLS_OLDATABASENAME=OLClassification
OLCLS_OLUSEINTEGRATEDSECURITY=false
OLCLS_OLSQLUSER=
OLCLS_OLSQLPASSWORD=

EXTRSERVICE_EXTRSDATABASESERVERTYPE=0
EXTRSERVICE_EXTRSDATABASESERVER=host.docker.internal
EXTRSERVICE_EXTRSDATABASENAME=ExtractionService
EXTRSERVICE_EXTRSUSEINTEGRATEDSECURITY=false
EXTRSERVICE_EXTRSSQLUSER=
EXTRSERVICE_EXTRSSQLPASSWORD=
EXTRSERVICE_HASAUTHENABLED=true

EXTRDESIGNER_DATABASESERVERTYPE=0
EXTRDESIGNER_DATABASESERVER=host.docker.internal
EXTRDESIGNER_DATABASENAME=ExtractionProjects
EXTRDESIGNER_SQLUSER=
EXTRDESIGNER_SQLPASSWORD=
EXTRDESIGNER_USEINTEGRATEDSECURITY=false
EXTRDESIGNER_USESSL=false
EXTRDESIGNER_TRUSTCERTIFICATE=false
EXTRDESIGNER_HASAUTHENABLED=true

OLEXTR_OLDATABASESERVERTYPE=0
OLEXTR_OLDATABASESERVER=host.docker.internal
OLEXTR_OLUSESSL=false
OLEXTR_OLTRUSTCERTIFICATE=false
OLEXTR_OLDATABASENAME=OLExtraction
OLEXTR_OLUSEINTEGRATEDSECURITY=false
OLEXTR_OLSQLUSER=
OLEXTR_OLSQLPASSWORD=

2. Pull and start the Site Management CLI tool in interactive mode:

docker pull skilja/sitemanagement
docker run -it --env-file envfile.txt skilja/sitemanagement:8.0

3. Configure user assignments and organizations in the Site Management CLI tool.

After the tool starts, select the application or service that you want to configure.

Depending on the selected module, you can manage:

• license managers
• organization admins
• organizations

Multiple selections are possible by entering one or more numbers. To clear a selected item, reenter the corresponding number.
Press ENTER to continue.

For license managers and organization admins, you can:

• list assigned users
• add a new user or group
• remove an existing assignment

For organizations, you can:

• list organizations
• add a new organization
• remove an existing organization
• edit an organization and manage its assigned organization admins

When adding a new user or group assignment, provide:

• the display name or user/group name
• the role identifier from the Process Authorization Server
• the user name from the Process Authorization Server
• 0 for a user or 1 for a group

To save the changes, type y or yes and press ENTER. To cancel without saving, press ENTER.

⁠Environment Variables

The Site Management image uses several environment variables, of which all are required. Currently, not needed modules / env variabled can't be removed. Otherwise the tool doesent start up properly. Just leave the not needed parts empty. Also leave *_HASAUTHENABLED=true

The variables are grouped into their respective modules.

• EXTRDESIGNER_ — Extraction Designer
• EXTRSERVICE_ — Extraction Service
• OLEXTR_ — Online Extraction Monitor
• CLSDESIGNER_ — Classification Designer
• CLSSERVICE_ — Classification Service
• OLCLS_ — Online Classification Monitor

If you want to configure the Classification Designer e.g, you need to adjust the CLSDESIGNER_* env vars and so on.

⁠EXTRSERVICE_

⁠EXTRSERVICE_EXTRSDATABASESERVERTYPE

The environment variable EXTRSERVICE_EXTRSDATABASESERVERTYPE sets the database server type for the extraction service database as an integer.

- 0 - SQL Server
- 1 - Oracle database
- 2 - PostgreSQL

⁠EXTRSERVICE_EXTRSDATABASESERVER

The environment variable EXTRSERVICE_EXTRSDATABASESERVER defines the database server host name or address for the extraction service database.

⁠EXTRSERVICE_EXTRSDATABASENAME

The environment variable EXTRSERVICE_EXTRSDATABASENAME sets the database name for the extraction service database.

⁠EXTRSERVICE_EXTRSUSEINTEGRATEDSECURITY

The environment variable EXTRSERVICE_EXTRSUSEINTEGRATEDSECURITY controls whether integrated security is used for database access. When set to true, the service uses integrated security; when set to false, it uses SQL user and password credentials.

⁠EXTRSERVICE_EXTRSSQLUSER

The environment variable EXTRSERVICE_EXTRSSQLUSER sets the SQL user name when integrated security is disabled.

⁠EXTRSERVICE_EXTRSSQLPASSWORD

The environment variable EXTRSERVICE_EXTRSSQLPASSWORD sets the SQL password when integrated security is disabled.

⁠EXTRSERVICE_HASAUTHENABLED

Just set it to "true"

⁠EXTRDESIGNER_

⁠EXTRDESIGNER_DATABASESERVERTYPE

The environment variable EXTRDESIGNER_DATABASESERVERTYPE sets the database server type for the extraction designer database as an integer.

- 0 - SQL Server
- 1 - Oracle database
- 2 - PostgreSQL

⁠EXTRDESIGNER_DATABASESERVER

The environment variable EXTRDESIGNER_DATABASESERVER defines the database server host name or address for the extraction designer database.

⁠EXTRDESIGNER_DATABASENAME

The environment variable EXTRDESIGNER_DATABASENAME sets the database name for the extraction designer database.

⁠EXTRDESIGNER_SQLUSER

The environment variable EXTRDESIGNER_SQLUSER sets the SQL user name when integrated security is disabled.

⁠EXTRDESIGNER_SQLPASSWORD

The environment variable EXTRDESIGNER_SQLPASSWORD sets the SQL password when integrated security is disabled.

⁠EXTRDESIGNER_USEINTEGRATEDSECURITY

The environment variable EXTRDESIGNER_USEINTEGRATEDSECURITY controls whether integrated security is used for database access. When set to true, the service uses integrated security; when set to false, it uses SQL user and password credentials.

⁠EXTRDESIGNER_USESSL

The environment variable EXTRDESIGNER_USESSL defines whether SSL encryption is used for the database connection.

⁠EXTRDESIGNER_TRUSTCERTIFICATE

The environment variable EXTRDESIGNER_TRUSTCERTIFICATE is only relevant when EXTRDESIGNER_USESSL=true. If set to true, the service trusts the SSL certificate even if it is not publicly signed. Otherwise, the connection is rejected if the certificate is invalid or self-signed.

⁠EXTRDESIGNER_HASAUTHENABLED

Just set it to "true"

⁠OLEXTR_

⁠OLEXTR_OLDATABASESERVERTYPE

The environment variable OLEXTR_OLDATABASESERVERTYPE sets the database server type for the OL extraction database as an integer.

- 0 - SQL Server
- 1 - Oracle database
- 2 - PostgreSQL

⁠OLEXTR_OLDATABASESERVER

The environment variable OLEXTR_OLDATABASESERVER defines the database server host name or address for the OL extraction database.

⁠OLEXTR_OLDATABASENAME

The environment variable OLEXTR_OLDATABASENAME sets the database name for the OL extraction database.

⁠OLEXTR_OLUSEINTEGRATEDSECURITY

The environment variable OLEXTR_OLUSEINTEGRATEDSECURITY controls whether integrated security is used for OL database access. When set to true, the service uses integrated security; when set to false, it uses SQL user and password credentials.

⁠OLEXTR_OLUSESSL

The environment variable OLEXTR_OLUSESSL defines whether SSL encryption is used for the OL database connection.

⁠OLEXTR_OLTRUSTCERTIFICATE

The environment variable OLEXTR_OLTRUSTCERTIFICATE is only relevant when OLEXTR_OLUSESSL=true. If set to true, the service trusts the SSL certificate even if it is not publicly signed. Otherwise, the connection is rejected if the certificate is invalid or self-signed.

⁠OLEXTR_OLSQLUSER

The environment variable OLEXTR_OLSQLUSER sets the SQL user name when integrated security is disabled.

⁠OLEXTR_OLSQLPASSWORD

The environment variable OLEXTR_OLSQLPASSWORD sets the SQL password when integrated security is disabled.

⁠CLSSERVICE_

⁠CLSSERVICE_CLSSDATABASESERVERTYPE

The environment variable CLSSERVICE_CLSSDATABASESERVERTYPE sets the database server type for the classification service database as an integer.

- 0 - SQL Server
- 1 - Oracle database
- 2 - PostgreSQL

⁠CLSSERVICE_CLSSDATABASESERVER

The environment variable CLSSERVICE_CLSSDATABASESERVER defines the database server host name or address for the classification service database.

⁠CLSSERVICE_CLSSDATABASENAME

The environment variable CLSSERVICE_CLSSDATABASENAME sets the database name for the classification service database.

⁠CLSSERVICE_CLSSUSEINTEGRATEDSECURITY

The environment variable CLSSERVICE_CLSSUSEINTEGRATEDSECURITY controls whether integrated security is used for database access. When set to true, the service uses integrated security; when set to false, it uses SQL user and password credentials.

⁠CLSSERVICE_CLSSSQLUSER

The environment variable CLSSERVICE_CLSSSQLUSER sets the SQL user name when integrated security is disabled.

⁠CLSSERVICE_CLSSSQLPASSWORD

The environment variable CLSSERVICE_CLSSSQLPASSWORD sets the SQL password when integrated security is disabled.

⁠CLSSERVICE_HASAUTHENABLED

Just set it to "true"

⁠CLSDESIGNER_

⁠CLSDESIGNER_DATABASESERVERTYPE

The environment variable CLSDESIGNER_DATABASESERVERTYPE sets the database server type for the classification designer database as an integer.

- 0 - SQL Server
- 1 - Oracle database
- 2 - PostgreSQL

⁠CLSDESIGNER_DATABASESERVER

The environment variable CLSDESIGNER_DATABASESERVER defines the database server host name or address for the classification designer database.

⁠CLSDESIGNER_DATABASENAME

The environment variable CLSDESIGNER_DATABASENAME sets the database name for the classification designer database.

⁠CLSDESIGNER_SQLUSER

The environment variable CLSDESIGNER_SQLUSER sets the SQL user name when integrated security is disabled.

⁠CLSDESIGNER_SQLPASSWORD

The environment variable CLSDESIGNER_SQLPASSWORD sets the SQL password when integrated security is disabled.

⁠CLSDESIGNER_USEINTEGRATEDSECURITY

The environment variable CLSDESIGNER_USEINTEGRATEDSECURITY controls whether integrated security is used for database access. When set to true, the service uses integrated security; when set to false, it uses SQL user and password credentials.

⁠CLSDESIGNER_USESSL

The environment variable CLSDESIGNER_USESSL defines whether SSL encryption is used for the database connection.

⁠CLSDESIGNER_TRUSTCERTIFICATE

The environment variable CLSDESIGNER_TRUSTCERTIFICATE is only relevant when CLSDESIGNER_USESSL=true. If set to true, the service trusts the SSL certificate even if it is not publicly signed. Otherwise, the connection is rejected if the certificate is invalid or self-signed.

⁠CLSDESIGNER_HASAUTHENABLED

Just set it to "true"

⁠OLCLS_

⁠OLCLS_OLDATABASESERVERTYPE

The environment variable OLCLS_OLDATABASESERVERTYPE sets the database server type for the OL classification database as an integer.

- 0 - SQL Server
- 1 - Oracle database
- 2 - PostgreSQL

⁠OLCLS_OLDATABASESERVER

The environment variable OLCLS_OLDATABASESERVER defines the database server host name or address for the OL classification database.

⁠OLCLS_OLDATABASENAME

The environment variable OLCLS_OLDATABASENAME sets the database name for the OL classification database.

⁠OLCLS_OLUSEINTEGRATEDSECURITY

The environment variable OLCLS_OLUSEINTEGRATEDSECURITY controls whether integrated security is used for OL database access. When set to true, the service uses integrated security; when set to false, it uses SQL user and password credentials.

⁠OLCLS_OLSQLUSER

The environment variable OLCLS_OLSQLUSER sets the SQL user name when integrated security is disabled.

⁠OLCLS_OLSQLPASSWORD

The environment variable OLCLS_OLSQLPASSWORD sets the SQL password when integrated security is disabled.

⁠OLCLS_OLUSESSL

The environment variable OLCLS_OLUSESSL defines whether SSL encryption is used for the OL database connection.

⁠OLCLS_OLTRUSTCERTIFICATE

The environment variable OLCLS_OLTRUSTCERTIFICATE is only relevant when OLCLS_OLUSESSL=true. If set to true, the service trusts the SSL certificate even if it is not publicly signed. Otherwise, the connection is rejected if the certificate is invalid or self-signed.

⁠Other Platforms

The tool is also available for Windows installation. Please visit The Partner Portal⁠ or write us a email [email protected]⁠⁠ for more information.