Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2
absoluteUrltrue

...

For additional information on verifying pre-requisites refer this article.

  1. The three servers should be on the same network and able to communicate with each other. Refer QMetry Deployment Document for the requirements.
  2. All the servers should have support of these commands: unzip, wget, curl and vim.
  3. Internet access should be enabled on all 3 servers to install using docker.
  4. Ensure Proxy Servers are not blocking downloads from the Internet.
  5. 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.
  6. 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.
  7. 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
  8. Get the following files from QMetry Support: QMetryApp.zip, Spark_Report_Install.zip, License and docker credentials required for installation.
  9. Post installation, QMetry Application and Report tool both should be configured either on https or http.
  10. 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.
ParametersValues

lower_case_table_names

1

max_allowed_packet

536870912
character_set_serverutf8mb4
collation_serverutf8mb4_unicode_ci
innodb_thread_concurrency10
query_cache_limit1073741824
table_definition_cache2000
group_concat_max_len1536000
innodb_autoinc_lock_mode2

tx_isolation

REPEATABLE-READ
sql_modeSTRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
binlog_error_actionABORT_SERVER
binlog_formatROW
binlog_group_commit_sync_delay0
binlog_group_commit_sync_no_delay_count0
binlog_gtid_simple_recovery 1
binlog_max_flush_queue_time0
binlog_order_commits1
binlog_row_imageFULL
binlog_rows_query_log_events 0
binlog_stmt_cache_size32768
max_binlog_stmt_cache_size18446744073709547520
log_bin_trust_function_creators1
log_bin_use_v1_row_events0

...

After waiting for about a minute, command docker ps should return the following : 

Step 4 - Restart Reports Services

...