Connecting the Application to the ClickHouse Analytical DBMS

After installing the application and the ClickHouse DBMS, you need to connect them.

In the web interface of the application, navigate to the settings (the gear icon in the upper right corner of the page). Then, open Data storages in the Data processing section.

Specify the parameters of the ClickHouse DBMS as indicated on the Installing, Activating, And Removing The Operavix Application page:

• Server name
• Host: FQDN of the ClickHouse server
• Port: the default is 8123
• Username: login of the DBMS administrator
• User password of the DBMS administrator
• SSL (On/Off). Enable if ClickHouse operates over HTTPS. When SSL is enabled, you can upload the root certificate signed by the ClickHouse server certificate (or self-signed, if applicable)
• Memory per request (MB): the maximum amount of RAM allocated for this ClickHouse connection per SQL query. It is recommended to specify a value within 40-60% of the total RAM volume
• Dashboard query memory limit (MB) — the maximum amount of RAM that ClickHouse server allocates for executing a single SQL query initiated from a dashboard. The value is capped at 1024 MB.
• Number of concurrent connections: the allowed number of open sessions of the Operavix server with this ClickHouse connection. It is recommended to use the default value
• Execution queue size: the limit on the number of SQL queries awaiting execution. It is recommended to use the default value
• Session time (minutes): specifies the number of minutes allocated for storing a session for an individual SQL query. It is recommended to use the default value

Click Test connection to check if the settings are correct. If the connection test is successful, click Save. The connection is established.

If the connection test fails, refer to the Operavix application log located at:

• Windows: C:\ProgramData\Operavix\logs\main.log
• Linux: var/lib/docker/volumes/operavix-app-log/_date/main.log or execute the command:
  # docker service logs operavix-app