Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
79:install [2023/04/19 11:37] – [Create Database, Database User and Grant privileges] bdss | 79:install [2024/03/15 11:28] (current) – [Start without Root Privileges on Linux] Mrozek, Marek | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Basic Installation ====== | ====== Basic Installation ====== | ||
+ | |||
===== Perform basic installation on Windows ===== | ===== Perform basic installation on Windows ===== | ||
- | * **Download and install Java Development Kit 8** | + | |
- | * see [[: | + | ==== Download and install Java Development Kit 8 ==== |
- | * **Database installation with MySQL 8.0** | + | |
- | * Get MySQL database dump from [[stages-support@ul.com? | + | |
- | * Download MySQL Installer for MySQL 8.0 | + | |
- | * Install MySQL 8.0 | + | |
- | * Select Setup Type “Server only” is recommended | + | ==== Database installation with MySQL 8.0 ==== |
- | * Install MySQL with config type “Server Machine”, default encoding “UTF-8” and service name “mysql80” | + | |
- | * Adapt/check the following properties within ”[mysql]“ and ”[mysqld]“ section in " | + | |
+ | * Download MySQL Installer for MySQL 8.0 | ||
+ | * Install MySQL 8.0 | ||
+ | * Select Setup Type “Server only” is recommended | ||
+ | * Install MySQL with config type “Server Machine”, default encoding “UTF-8” and service name “mysql80” | ||
+ | * Adapt/check the following properties within ”[mysql]“ and ”[mysqld]“ section in " | ||
< | < | ||
Line 53: | Line 59: | ||
</ | </ | ||
- | * **Database installation with Oracle 11g, 12c or 19c** | ||
- | * Get Oracle database dump and installation instructions from [[stages-support@ul.com? | ||
- | * **Stages installation** | + | ==== Database installation with Oracle 11g, 12c or 19c ==== |
- | * Execute Stages installer as administrator (will be sent to you by [[stages-support@ul.com? | + | |
- | | + | |
- | * Download MySQL JDBC connector (Connector/ | + | |
- | * Copy JDBC connector to ”< | + | |
- | * Edit ”< | + | ==== Stages installation |
+ | |||
+ | * Execute Stages installer as administrator (will be sent to you by [[stages-support@ul.com? | ||
+ | |||
+ | === Establish database connection with MySQL === | ||
+ | |||
+ | * Download MySQL JDBC connector (Connector/ | ||
+ | * Copy JDBC connector to ”< | ||
+ | * Edit ”< | ||
< | < | ||
Line 71: | Line 83: | ||
</ | </ | ||
+ | * Activate the configuration | ||
+ | * Windows Start Menu: Execute “Programs > Method Park > Stages > Update Configuration” | ||
+ | * Start Stages | ||
+ | * Windows: Start the services “Stages Search” and then “Stages” | ||
- | * Establish database connection with **Oracle** | + | === Establish database connection with Oracle |
- | * Download Oracle JDBC connector for your Oracle version | + | |
- | * Copy JDBC connector to ”< | + | * Download Oracle JDBC connector for your Oracle version |
- | * Edit ”< | + | * Copy JDBC connector to ”< |
+ | * Edit ”< | ||
< | < | ||
Line 92: | Line 109: | ||
* Start Stages | * Start Stages | ||
* Windows: Start the services “Stages Search” and then “Stages” | * Windows: Start the services “Stages Search” and then “Stages” | ||
+ | |||
===== Perform basic installation on Linux ===== | ===== Perform basic installation on Linux ===== | ||
Line 130: | Line 148: | ||
* complete the installation with your organizational policy | * complete the installation with your organizational policy | ||
* Proceed with the steps provided below | * Proceed with the steps provided below | ||
- | * Create Database, Database User and Grant Privileges | + | * [[: |
Line 182: | Line 200: | ||
- | ==== | + | ==== Database installation with Oracle 11g, 12c or 19c ==== |
- | * Get Oracle database dump and installation instructions from [[stages-support@ul.com? | + | |
- | * | + | * Get Oracle database dump and installation instructions from [[stages-support@ul.com? |
- | ==== | + | |
- | * Install RPM package “rpm -Uvh < | + | |
- | | + | |
- | * | + | ==== Stages Installation on Linux ==== |
- | === Establish database connection with | + | |
- | * Download MySQL JDBC connector (Connector/ | + | * Install RPM package “rpm -Uvh < |
- | * Copy JDBC connector to ”< | + | |
- | * Edit ”< | + | |
+ | |||
+ | === Establish database connection with MySQL === | ||
+ | |||
+ | | ||
+ | * Copy JDBC connector to ”< | ||
+ | * Edit ”< | ||
< | < | ||
Line 205: | Line 226: | ||
</ | </ | ||
- | * | + | === Establish database connection with Oracle === |
- | === Establish database connection with | + | |
- | * Download Oracle JDBC connector for your Oracle version | + | |
- | * Copy JDBC connector to ”< | + | * Copy JDBC connector to ”< |
- | * Edit ”< | + | * Edit ”< |
< | < | ||
Line 227: | Line 248: | ||
* execute “stages start” | * execute “stages start” | ||
+ | ==== (Optional) Start without Root Privileges on Linux ==== | ||
+ | |||
+ | Normally Stages is started by the " | ||
+ | |||
+ | Please note that privileged ports below 1024 cannot be opened in this configuration, | ||
+ | |||
+ | **How to configure the user that Stages service should run as?** | ||
+ | |||
+ | 1. Edit stages.service file: | ||
+ | * vi / | ||
+ | * add the line User=< | ||
+ | |||
+ | 2. Reload system manager configuration with systemctl command: | ||
+ | * Unordered List Itemsystemctl daemon-reload | ||
+ | |||
+ | 3. Additionally change the user ownership for all files below stages installation folder with following command: | ||
+ | * chown -R < | ||
===== (Optional) Secure MySQL connection with SSL ===== | ===== (Optional) Secure MySQL connection with SSL ===== | ||
Line 274: | Line 312: | ||
* Open file "< | * Open file "< | ||
* Modify the red colored setting: //set TOMCAT_OPTS=–JvmMx= | * Modify the red colored setting: //set TOMCAT_OPTS=–JvmMx= | ||
- | <font inherit/ | + | < |
* //Open a cmd with administrative permissions and navigate to folder "< | * //Open a cmd with administrative permissions and navigate to folder "< | ||
* //Reinstall the Stages service: **reinstallService.bat** // | * //Reinstall the Stages service: **reinstallService.bat** // | ||
Line 281: | Line 319: | ||
* //Open file "< | * //Open file "< | ||
* //Modify the red colored value: // | * //Modify the red colored value: // | ||
- | <font inherit/ | + | < |
* Restart the Stages service: **stages restart** | * Restart the Stages service: **stages restart** | ||
Line 321: | Line 359: | ||
===== Configure SSL ===== | ===== Configure SSL ===== | ||
- | To encrypt all connections between the users and Stages, we strongly recommend | + | Please refer to [[configure_stages# |
- | + | ||
- | * Ask for a DNS alias for the server, e.g. " | + | |
- | * Ask for a SSL certificate for the server which refers to the above alias. Depending on your local procedures, this might require creating a certificate request (see [[https:// | + | |
- | * Import the SSL certificate into a keystore (see link above for more info) | + | |
- | * Configure Tomcat to use this SSL certificate (see link above for more info). The relevant Tomcat config file is located in ''< | + | |
- | * To enforce redirection from http to https add the following to '' | + | |
- | < | + | |
- | + | ||
- | < | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | </ | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | </ | + | |
- | </ | + | |
- | + | ||
- | </ | + | |
=== Add CAs to your TrustStore === | === Add CAs to your TrustStore === | ||
- | For using reports in Stages, you need to add your companies root certificate and all Intermediate certificates (if existing) | + | Please refer to [[configure_stages# |
- | + | ||
- | * Import your companies root certificate and all intermediate certificates (if existing) into this file: \\ <Java Development Kit Installation Directory> | + | |
- | + | ||
- | (Linux directories may varify) | + | |
- | + | ||
- | * Please restart Stages service after applying changes to the Java Trust Store | + | |
- | + | ||
===== Accessing Stages ===== | ===== Accessing Stages ===== | ||
- | '' | + | After successful installation process - Stages is accessible via web browser by URL [[https://stages.localhost|https:// |
===== Change password of " | ===== Change password of " | ||
- | '' | + | Log in with the " |
===== Prepare Stages for productive usage ===== | ===== Prepare Stages for productive usage ===== |