Clickhouse

the clickhouse settings pane in the integration module provides you with all the tools needed to set up and manage the clickhouse configuration the clickhouse settings pane includes the following sections clickhouse server displays a list of connection urls for the clickhouse ports this section includes the supported urls that can be used to connect to the clickhouse database, allowing you to enable and manage how clients can connect and retrieve data the urls are comprised of the ip address of the litmus edge manager and ports (these ports are default and cannot be changed ) 8123 for http 8543 for https 9000 for native 9004 for mysql users displays a list of users that can access clickhouse you can add a user name and password, change the user's password, and remove the user acl displays a list of users that can access a project database for clickhouse you can add an acl for a project with a specific user the entries display the company and project name, the database name, and the user name you can remove an acl entry explore allows you to open the tabix web interface access clickhouse ui to access the clickhouse ui log in to the litmus edge manager (lem) admin console at the following url https //\[lem ip address] 8446 from the navigation panel, select integration integration's kafka pane by default appears from integration's navigation sub panel, select clickhouse integration's clickhouse pane appears refer to the following actions you can take on litmus edge manager admin console's clickhouse pane action details \[1] change port status state change the port status \[2] copy to clipboard server url \[3] action menu edit you can add or remove up to three ip addresses to a network port interface the first two ip addresses are shown next to the network port interface as well as information about any additional ips editing or removing an ip address for a port interface causes the current ip to disconnect enable/disable \[4] show filter / hide filter search by user name \[5] create user make a new user \[6] action menu change password remove \[7] show filter / hide filter search by topic (company / project) , database name , or user name \[8] add acl once an user name has been associated with a topic , it will automatically generate a new database name \[9] action menu remove \[10] open tabix see docid\ a sy8z8lq6kh wnx0yfyk \[11] copy to clipboard topic \[12] copy database name to clipboard \[13] copy to clipboard user name