Page History

...

Language Selection
- Select the language to be used for the setup: English and German are available.
Step 1 - Welcome Screen

Step 2 - Licensing Agreement
- The License Agreement shown in Step 2 of the installation has to be accepted before installation can take place.
Step 3 - Target Path for the Installation
- The path to the installation directory for the JOC Cockpit program files - referred to later in this page as the joc_installation_directory - is set in this step.
- The default installation paths for the JOC Cockpit are:
  - /opt/sos-berlin.com/joc on Linux systems and
  - C:\Program Files\sos-berlin.com\joc on Windows.
- Users can use the Step 3 installation form shown below to specify their own installation path for the JOC Cockpit if required.

Anchor
jetty-base
jetty-base
Step 4 - Jetty Installation & Configuration
- The JOC Cockpit requires a Java-capable web server and comes with a Jetty server. Step 4 allows system administrators to specify whether this web server is to be installed and if so, to specify its configuration - i.e. the port(s) it uses, installation path, memory pool, etc..
- The Install JOC ... including Jetty checkbox specifies whether the Jetty web server should be installed.
- Default Paths
- While the Jetty web server delivered with the JOC Cockpit is installed in the joc_installation_directory, which was configured in the previous step - the Jetty configuration files are installed in the jetty_base directory. The Jetty Base field in the form shown in the screenshot can be used to set the jetty_base directory.
  - The default path to the jetty_base directory on Linux systems leads to the user's home directory:
    - e.g. /home/sos/sos-berlin.com/joc
  - Log files are saved by default in:
    - /var/log/sos-berlin.com/joc on Linux systems.
  - The default path to the jetty_base directory and log files on Windows systems is:
    - C:\ProgramData\sos-berlin.com\joc .
- Note that if If the Jetty delivered with the JOC Cockpit is not to be installed and either an alternative Jetty installation or another web server is to be used, then relevant configuration files for such a server such as the shiro.ini and joc.properties files will still be written to the file system. These files can then be moved by the system administrator to the suitable location for their web server as required. See the Configuration with Alternative Web Servers section below for more information.
Step 5 - Specify the Reporting DBMS
- Choose the DBMS to be used by the JOC Cockpit for the Reporting Database.
  Caution: the order in which the Reporting and JobScheduler Databases are configured is the opposite to that used in the installation of the JobScheduler.
Step 6 - Configure the Reporting Database Connection
- Specify the parameters for the connection to the Reporting Database.
- It will be probably be obvious from the names given to the parameters in the screenshot above that the values are for a database to be used by the JobScheduler. In this case the Reporting Database Tables will be integrated in the JobScheduler Database. This will be described in the next step.
- The database configuration for the JOC Cockpit is written to an XML file during installation and saved in the jetty_base/resources/joc folder.
  The default name of the database configuration file is:
  - reporting.hibernate.cfg.xml
  This file can be modified at a later date if required using a text editor. The JOC Cockpit service will then have to be restarted before changes made to this file are implemented.
- The name and location of the database configuration file itself is specified in the joc.properties file, which can also be found in the jetty_base/resources/joc folder.

...

Step 7 - Specify the JDBC Driver for the Reporting Database Connection

Specify if an JDBC driver provided with the installation should be used for the Reporting Database Connection or whether an external driver is required.
The information shown in this form depends on the DBMS previously selected:
- The jTDS JDBC® driver delivered with the JobScheduler is only shown as an option when Sybase^® or Microsoft SQL Server^® DBMSs have been specified.
- If you have specified a MySql^® DBMS then you will get a checkbox for specifying whether you want to use the MariaDB^® JDBC
driver provided with the installation should be used for the Reporting Database Connection or whether an external driver is required.
Image Removed
- ^® driver provided with the JobScheduler.
- If you do not check the jTDS JDBC^® or the MariaDB JDBC drivers then you must enter your own JDBC^® driver in the form shown below.
- Image Added

Configuring the JDBC Driver-URL for Oracle RAC databases

The JDBC driver URL for Oracle RAC databases should be entered in the Host field of the database connection form. For example:

Code Block

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON) 
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604)) 
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604))) 
(CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))

In addition the Schema and Port fields should be left empty.

Step 8 - Specify the Database Connection Used by the JobScheduler
- Specify whether a separate connection it to be specified for the JobScheduler Database
- If the JobScheduler(s) and JOC Cockpit share the same database then clicking Next will cause the Installation to proceed to Step 10. This step starts the installation process itself and changes to the configuration are no longer possible.
- If the JobScheduler(s) and JOC Cockpit use separate databases then the checkbox in the form should be deselected. In this case, clicking Next will cause the Installation to proceed to the specification of the DBMS and the connection parameters for the JobScheduler database, which are described next.
Step 9 - Specify the JobScheduler DBMS
- This form is identical to those already shown for the Reporting Database in Steps 5 to 8 above.
Step 10 - Configure the JobScheduler Database Connection
- Specify the parameters for the connection to the JobScheduler Database.
  - The DBMS type can be found in the database configuration for job history section of the $JOBSCHEDULER_DATA/factory.ini file of one of the JobSchedulers to be operated from the JOC Cockpit, where $JOBSCHEDULER_DATA is defined in the JobScheduler Master Installation - 2 - Dialog Installation article.
- The database configuration for the JOC Cockpit is written to an XML file during installation and saved in the jetty_base/resources/joc folder.
  The default name of the database configuration file is:
  - jobscheduler.hibernate.cfg.xml
- This file can be modified at a later date if required using a text editor. A JOC Cockpit user will then have to log in again before changes made to this file are implemented.
- The name and location of the database configuration file itself is specified in the joc.properties file, which can also be found in the jetty_base/resources/joc folder.

...

ProgramData
- sos-berlin.com
  - joc
    - joc_home (symlink, remains after uninstall)
    - logs (directory with files, remains after uninstall)
    - resources (remains after uninstall and (empty) after full uninstall)
      - joc
        jobscheduler.hibernate.cfg.xml (remains after uninstall if modified)
        joc.properties (remains after uninstall)
        log4j.properties (remains after uninstall if modified)
        reporting.hibernate.cfg.xml (remains after uninstall if modified)
        shiro.ini (remains after uninstall)
        shiro.ini-example (only added if shiro.ini file is found)
    - temp (directory with files, remains after uninstall)
    - webapps
    - start.ini (file, remains after uninstall)

...

Program Files
- sos-berlin.com
  - joc
    - install (directory with files)
      - install_jetty_base.cmd
      - update_jetty_base.cmd
    - jetty (directory with files)
    - jetty_base (symlink)
    - service
    - Uninstaller (directory, the empty remains after uninstall and full uninstall)
      - uninstall.cmd
      - uninstaller.jar
    - .jocinstallinformation (file, remains after uninstall)
    - joc_install.xml (file, remains after uninstall)

...

Code Block

language	text
title	Example Listing of the joc.properties File
linenumbers	true
collapse	true

################################################################################
### Path to log4j configuration file. Path can be absolute or relative
### to this file.
 
log4j.configuration = log4j.properties

################################################################################
### Path to hibernate configuration file of JOC's reporting database. 
### Path can be absolute or relative to this file.
 
hibernate_configuration_file = reporting.hibernate.cfg.xml

################################################################################
### Path to hibernate configuration file of a JobScheduler database. 
### Path can be absolute or relative to this file.
### The key must have the format 'hibernate_configuration_file_<jobschedulerId>'
### for a specific JobScheduler (cluster) 
### or 'hibernate_configuration_scheduler_default_file'
### for all JobSchedulers which don't have a specific setting.
 
hibernate_configuration_scheduler_default_file = jobscheduler.hibernate.cfg.xml

################################################################################
### The time (in milliseconds) to establish the connection with the 
### remote host. Default = 2

jobscheduler_connection_timeout = 2

################################################################################
### The time (in milliseconds) waiting for data after the connection
### was established; maximum time of inactivity between two data packets.
### Default = 5

jobscheduler_socket_timeout = 5

################################################################################
### Should hostname verification be carried out for https certificate. 
### Default false
 
https_with_hostname_verification = false

################################################################################
### Location of the configuration file with e.g. url mapping, etc.
### Path can be absolute or relative to this file.


# configuration_file = joc.configuration.properties

################################################################################
### Location, type and password of the Java truststore which contains the 
### certificates of eachJobScheduler Master for HTTPS connections. Path can be 
### absolute or relative to this file.

# truststore_path = ../../etc/joc.jks
# truststore_type = PKCS12
# truststore_password = 

################################################################################
### Requests to all web services which modify JobScheduler objects such as 
### "start order", "stop job" etc. can contain a comment to describe the reason.
### This flag controls if the comment is required or not. Default false

force_comments_for_audit_log = false

################################################################################
### Settings for a custom logo file on the login page 
### The logo file has to be located in ./jetty_base/webapps/root/ext/images
### Possible units for width are according to
### https://www.w3schools.com/cssref/css_units.asp (default px)
### Possible values for the position are "top" or "bottom" (default=bottom).

custom_logo_name = 
custom_logo_height = 
custom_logo_position = 

################################################################################
### A default profile should be available that includes any profile settings 
### that are applied by default to new users.

default_profile_account = root

################################################################################
### Pre-defined comments used for example in the 'reasons' describing actions in 
### the audit log.

 
comments = System maintenance; \
 Repeat execution; \
 Business requirement; \
 Restart failed execution; \
 Re-instantiate stopped object; \
 Temporary stop; \
 Change of JobScheduler object; \
 Rerun with parameter changes; \
 Change of external dependency; \
 Application deployment and upgrade

...

```
https_with_hostname_verification
```
- This setting should be considered carefully. Effectively it forces the hostname host name in an HTTPS connection to a JobScheduler Master to be verified from the host's certificate. This guarantees that the certificate has been created for the respective host (FQDN).
- With this setting being assigned the value false no host name verification takes place and the HTTPS connection is vulnerable to man-in-the-middle attacks.
```
configuration_file
```
- This file is used for configuration details that are independent from the JOC Cockpit installation, see chapter The joc.configuration.properties File.
```
truststore_path, truststore_type, truststore_password
```
- A trust store is used if an HTTPS connection between clients, e.g. user browsers, and JOC Cockpit is used. For details see the JOC Cockpit - HTTPS Authentication article.
```
force_comments_for_audit_log
```
- Comments can be added whenever an operation is performed that modifies a JobScheduler object, e.g. if a job or job chain is started.
- Basically a user can choose in his profile to add comments which pops up a dialog box to select or enter a comment. If this profile setting is not active then a number of operations, such as starting a job, are performed immediately without additional dialog.
- With the force_comments_for_audit_log setting in place all users are forced to add a comment when modifying a JobScheduler object - independent of their profile settings.
```
custom_logo_name, custom_logo_height, custom_logo_position
```
- The custom logo is displayed on the login page.
- Jira
  server SOS JIRA
  columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
  serverId 6dc67751-9d67-34cd-985b-194a8cdc9602
  key JOC-473
default_profile_account
- The user profile of the account specified for this setting provides the default values for the profiles of new users.
- An account is specified exactly as the user would type for login. If LDAP Configuration is in place then the domain account is specified, optionally including the domain, e.g. domain\account or account@domain or by use of the samAccountName or the respective LDAP attribute configured by the JOC Cockpit administrator.
- Jira
  server SOS JIRA
  columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
  serverId 6dc67751-9d67-34cd-985b-194a8cdc9602
  key JOC-477
comments
- Add/modify/replace items to the list of comments in any language.
- Each comment ends with a semicolon. If comments are to follow then the line for the current comment ends with a backslash.

Anchor
joc.configuration.properties
joc.configuration.properties
The `joc.configuration.properties` File

This file is used for configuration details that are independent from a JOC Cockpit installation.

...

Detailed descriptions of each parameter are included in the file and are intended to be self-explanatory.

Code Block

language	text
title	Example Listing of the joc.configuration.properties File
linenumbers	true
collapse	true

################################################################################
### In almost all cases a JobScheduler Master has a URL in the form 
### http(s)://[jobSchedulerHost]:[jobSchedulerHTTP(S)Port].
### JOC Cockpit web services know this URL because the JobScheduler Master stores 
### this information to the Reporting Database.
### If the JobScheduler Master is running in a docker container or behind a reverse 
### proxy then the URL can be different and the JobScheduler Master cannot know by 
### which URL it is accessible. 
### Here you can set a url mapping in the form
###
###          jobscheduler_url_myJobSchedulerHost_myJobschedulerHTTPPort = url
###
### all entries have a prefix "jobscheduler_url_"
### Please note that the key has to be in lowercase and contains always the 
### HTTP port even if the URL uses the HTTPS protocol 


# jobscheduler_url_localhost_40444 = http://docker_url

...

on Linux systems in the directory:
- /etc/default/joc if the installer was executed by the root account.
- /home/<user>/jocrc if the installer was executed by a user account (./setup.sh -u <user>).
- On startup JOC Cockpit will check the /home/<user>/jocrc file and only if this cannot be found it will check the /etc/default/joc file.
on Windows systems in the Registry under:
- HKLM\SOFTWARE\WOW6432Node\Apache Software Foundation\Procrun 2.0\sos_joc\Parameters\Java
Java Memory options can also be configured by opening the sos_jocw.exe which can be found in the joc_home\service directory.

...

Tips from a user on Installation with Tomcat

...

Space shortcuts

Page tree

Versions Compared

Old Version 91

New Version Current

Key

Language Selection

Step 1 - Welcome Screen

Step 2 - Licensing Agreement

Step 3 - Target Path for the Installation

Anchor
jetty-base
jetty-base
Step 4 - Jetty Installation & Configuration

Default Paths

Step 5 - Specify the Reporting DBMS

Step 6 - Configure the Reporting Database Connection

Step 7 - Specify the JDBC Driver for the Reporting Database Connection

Configuring the JDBC Driver-URL for Oracle RAC databases

Step 8 - Specify the Database Connection Used by the JobScheduler

Step 9 - Specify the JobScheduler DBMS

Step 10 - Configure the JobScheduler Database Connection

Anchor
joc.configuration.properties
joc.configuration.properties
The `joc.configuration.properties` File

Space shortcuts

Page tree

Page History

Versions Compared

Old Version 91

New Version Current

Key

Language Selection

Step 1 - Welcome Screen

Step 2 - Licensing Agreement

Step 3 - Target Path for the Installation

Anchorjetty-basejetty-baseStep 4 - Jetty Installation & Configuration

Default Paths

Step 5 - Specify the Reporting DBMS

Step 6 - Configure the Reporting Database Connection

Step 7 - Specify the JDBC Driver for the Reporting Database Connection

Configuring the JDBC Driver-URL for Oracle RAC databases

Step 8 - Specify the Database Connection Used by the JobScheduler

Step 9 - Specify the JobScheduler DBMS

Step 10 - Configure the JobScheduler Database Connection

Anchorjoc.configuration.propertiesjoc.configuration.propertiesThe joc.configuration.properties File

Anchor
jetty-base
jetty-base
Step 4 - Jetty Installation & Configuration

Anchor
joc.configuration.properties
joc.configuration.properties
The `joc.configuration.properties` File