Table of Contents | ||||
---|---|---|---|---|
|
...
For additional information on verifying pre-requisites refer this article.
- The three servers should be on the same network and able to communicate with each other. Refer QMetry Deployment Document for the requirements.
- All the servers should have support of these commands: unzip, wget, curl and vim.
- Internet access should be enabled on all 3 servers to install using docker.
- Ensure Proxy Servers are not blocking downloads from the Internet.
- Docker installation requires root user access. To install using a non-root user, follow the steps specified here before starting the install on both QMetry and Report servers.
- QMetry and Report Servers should be able to communicate over 80/443 and Database Server 3306/DB Ports. Ports 8080 and 33061 should be enabled/open on Reports Server to allow connections from QMetry application server.
- Docker is installed under /var/lib/ directory. We recommend allocating enough space here to ensure QMetry has enough space to save your data.
- Data of QMetry attachments added is saved under : /var/lib/docker/volumes/qmetry_attachment/_data
- Get the following files from QMetry Support: QMetryApp.zip, Spark_Report_Install.zip, License and docker credentials required for installation.
- Post installation, QMetry Application and Report tool both should be configured either on https or http.
- Following Ports should be open on respective servers:
...
- Login to AWS Management Console and open the Amazon RDS console.
- RDS > Databases > Actions > Stop RDS Service.
- Go to Configurations tab > Parameter Group.
- Search and then add / edit the following parameters.
Parameters | Values |
---|---|
lower_case_table_names | 1 |
max_allowed_packet | 536870912 |
character_set_server | utf8mb4 |
collation_server | utf8mb4_unicode_ci |
innodb_thread_concurrency | 10 |
query_cache_limit | 1073741824 |
table_definition_cache | 2000 |
group_concat_max_len | 1536000 |
innodb_autoinc_lock_mode | 2 |
tx_isolation | REPEATABLE-READ |
sql_mode | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
binlog_error_action | ABORT_SERVER |
binlog_format | ROW |
binlog_group_commit_sync_delay | 0 |
binlog_group_commit_sync_no_delay_count | 0 |
binlog_gtid_simple_recovery | 1 |
binlog_max_flush_queue_time | 0 |
binlog_order_commits | 1 |
binlog_row_image | FULL |
binlog_rows_query_log_events | 0 |
binlog_stmt_cache_size | 32768 |
max_binlog_stmt_cache_size | 18446744073709547520 |
log_bin_trust_function_creators | 1 |
log_bin_use_v1_row_events | 0 |
...
- For users evaluating QMetry
- You should have received an evaluation license valid for 30 days along with the installation.
- For users requiring commercial license
- Server's domain name and mac address are required to generate your QMetry License. Follow the below steps to get your server mac address and send this information along with the domain name to QMetry Support to get your QMetry License generated. Send an email to qtmprofessional@qmetrysupport.atlassian.net to reach QMetry Support.
- Execute the below command to get your server mac address. Then send the MAC address to QMetry Support to receive license file.
- ifconfig (MAC address of Ethernet card e.g. eth0/eth1 )
- Once you receive license.key from QMetry Support, you can follow the Steps to Apply License file.
- Execute the below command to get your server mac address. Then send the MAC address to QMetry Support to receive license file.
- Server's domain name and mac address are required to generate your QMetry License. Follow the below steps to get your server mac address and send this information along with the domain name to QMetry Support to get your QMetry License generated. Send an email to qtmprofessional@qmetrysupport.atlassian.net to reach QMetry Support.
Step 6. Access QMetry application using the following details:
...
Once the script finishes executing it will prompt to enter the following parameters
Options | Details | Example |
---|---|---|
Enter Mysql Database Host IP / DNS Name (Qmetry) | QMetry DB Host Public IP/DNS | 10.10.11.100 |
Enter Mysql Database Port (Qmetry) | QMetry App MySQL DB Port. Enter 3306, unless QMetry DB port is different | 3306 |
Enter Mysql Database Schema (Qmetry) | QMetry App DB schema name. Enter : qmetry | qmetry |
Enter Mysql Database Username (Qmetry) | QMetry App DB username. Enter : root | root |
Enter Mysql Database Password (Qmetry) | QMetry App DB password. If it is unchanged from default, enter : qmetry | qmetry |
Enter Mysql Database Host IP / DNS Name (Reports) | Enter the static docker IP : 10.5.0.7 as the IP address of QMetry Reports server | 10.5.0.7 |
Enter Mysql Database Port (Reports) | Enter the port where reports DB is running. Enter : 3306 | 3306 |
Enter Mysql Database Schema (Reports) | Enter the database schema name of QMetry Reports DB - | qtmanalytics |
Enter Mysql Database Username (Reports) | Enter username of QMetry Reports DB | root |
Enter Mysql Database Password (Reports) | Enter password of QMetry Reports DB - qmetryreports@!Nf0# | qmetryreports@!Nf0# |
Enter Port To Start SyncJob (Reports) | Reports Sync Job runs from this port : 8080 | 8080 |
Do you want to Run Force Sync Now ? (y/n) | Enter y to sync all the QMetry data to Reports DB with the current script. Always enter y at the time of fresh reports install | Type : y |
Enter Memory to allocate in GB(s) to Spark | Entered memory would be used by the sync job while running a full sync of data. Enter 3/4th of total memory available on server. For example, if memory on server is 24 GB, enter 18 | 18 |
...
After waiting for about a minute, command docker ps should return the following :
Step 4 - Restart Reports Services
...