[mysql] default-character-set=utf8 [mysqld] character-set-server=utf8 max_allowed_packet=500M transaction-isolation=READ-COMMITTED lower_case_table_names=1 sql-mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
grant all privileges on *.* to 'stages'@'%' identified by '<stages-password>'; flush privileges; exit;
mysqladmin -uroot -p<mysql-root-password> create stages mysql -uroot -p<mysql-root-password> stages <[PATH TO DUMP FILE\stages7_mysql_content.sql]
torque.database.default.driver = org.gjt.mm.mysql.Driver torque.database.default.url = jdbc:mysql://localhost:3306/stages?zeroDateTimeBehavior=round&jdbcCompliantTruncation=false torque.database.default.username = stages torque.database.default.password = <stages-password>
## settings for oracle torque.database.default.driver=oracle.jdbc.driver.OracleDriver torque.database.default.url=jdbc:oracle:thin:@<IP/hostname>:<port>:<SID> torque.database.default.username=<oracle-username> torque.database.default.password=<oracle-password>
If you want to secure your MySQL connection with SSL you need to provide the server certificate to the MySQL driver. To do this follow these steps:
$JAVA_HOME/bin/keytool -importcert -alias MySQLCACert -file ca.pem -keystore truststore -storepass mypassword
&clientCertificateKeyStoreUrl=file:/opt/stages/conf/truststore&&useSSL=trueclientCertificateKeyStorePassword=mypassword
torque.database.default.url = jdbc:mysql://localhost:3306/stages?zeroDateTimeBehavior=round&jdbcCompliantTruncation=false&useSSL=true&clientCertificateKeyStoreUrl=file:/opt/stages/conf/truststore&clientCertificateKeyStorePassword=mypassword
If you are using a virus scanner on your Stages server, please exclude all MySQL database files from analysis operations as this might corrupt your database. Also excluding Stages installation directory and Java installation directory might significantly improve Stages performance.
Depending on the desired performance and the purpose of your Stages Server, we strongly suggest to adjust the Java heap space according to the following values:
Please check System Requirements for Stages 7.2, 7.3 and 7.4 for detailed information on the range levels.
To adjust the Java heap space settings please proceed as follows:
Depending on the size of your database it can be necessary to adjust the memory settings of the search engine. To do that open the file “<Stages installation path>elasticsearch/config/jvm.options”.
Adjust the lines
-Xms1g -Xmx1g
After that restart the Stages search service.
If a customer specific metamodel has been migrated from Stages V6 to V7 by a Method Park product consultant, this metamodel will be provided as *.mm file. To install the metamodel please proceed as follows:
If you want to work with international UTF-8 charsets (e.g. Chinese), we suggest to install and configure Stages to use dedicated fonts:
Configuring font for Stages process visualizations (metamodel: Unified Configuration) [STAGES 7.4.4.4 and earlier]:
Caution: If Stages doesn't recognize your font via the config.xml, please additionally set the JVM parameter to the path of your fonts folder: -Dsun.java2d.fontpath=“c:/yourownfolder”.
Configuring font for Stages process visualizations (metamodel: Unified Configuration) [STAGES 7.4.4.5 and newer]:
Configuring font for Stages PDF printing:
To encrypt all connections between the users and Stages, we strongly recommend to configure SSL for the Stages server.
conf/server.xml
and the SSL info needs to be configured for each <Connector>
section. After updating the config file, run bin/update.sh
or bin\update.bat
to install it at the correct location.conf/web-customer.xml
. This needs a Stages Version > 7.4.2.0.<security-constraint> <display-name>Enforce HTTPS</display-name> <web-resource-collection> <web-resource-name>stages-public</web-resource-name> </web-resource-collection> <user-data-constraint> <description>Force SSL for all connections.</description> <transport-guarantee>CONFIDENTIAL</transport-guarantee> </user-data-constraint> </security-constraint>
[...] <properties> [...] <property name="global.secureMode.enabled" value="true"/> </properties> [...]
After successful installation process - Stages is accessible via web browser by URL https://localhost:8443 or http://localhost:8080 (depending on the SSL port)
Users
Delete all users except Superuser and Default, especially the demo users.
Workspaces
Delete the workspaces “Samples
” and “Proof of Concept
” or move them under “Archive
”.
Further setup
Please contact your Method Park Product Consultant to further adapt the Stages process content for productive usage.