Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
79:install [2023/04/19 11:43] – [Download and install Java Development Kit 8] bdss | 79:install [2024/03/08 10:29] – [Configure SSL] Weinlein, Thomas | ||
---|---|---|---|
Line 10: | Line 10: | ||
- | ==== | + | ==== 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 | + | * Download MySQL Installer for MySQL 8.0 |
- | * Select Setup Type “Server only” is recommended | + | * Install MySQL 8.0 |
- | * Install MySQL with config type “Server Machine”, default encoding “UTF-8” and service name “mysql80” | + | * Select Setup Type “Server only” is recommended |
- | * Adapt/check the following properties within ”[mysql]“ and ”[mysqld]“ section in " | + | * 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 58: | Line 59: | ||
</ | </ | ||
- | * | ||
- | ==== | ||
- | * Get Oracle database dump and installation instructions from [[stages-support@ul.com? | ||
- | | + | ==== Database installation with Oracle 11g, 12c or 19c ==== |
- | ==== | + | |
- | * Execute Stages installer as administrator (will be sent to you by [[stages-support@ul.com? | + | |
- | * | + | |
- | === Establish database connection with | + | |
- | * Download MySQL JDBC connector (Connector/ | + | ==== Stages installation on Windows ==== |
- | * Copy JDBC connector to ”< | + | |
- | * Edit ”< | + | |
+ | |||
+ | === Establish database connection with MySQL === | ||
+ | |||
+ | | ||
+ | * Copy JDBC connector to ”< | ||
+ | * Edit ”< | ||
< | < | ||
Line 79: | 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 | + | |
- | * Download Oracle JDBC connector for your Oracle version | + | |
- | * Copy JDBC connector to ”< | + | * Copy JDBC connector to ”< |
- | * Edit ”< | + | * Edit ”< |
< | < | ||
Line 287: | Line 295: | ||
* 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 294: | Line 302: | ||
* //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 334: | Line 342: | ||
===== 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 ===== |