Description:
In the PMM2 version, I was able to connect the Clickhouse DB externally (outside of the container or PMM server) using the DBeaver tool or other tools. Now, after upgrading to the PMM3 version, we are not able to connect the Clickhouse DB, and the Clickhouse DB becomes down if we change the listen IP. If I uncomment the below line, then immediately Clickhouse is stopping.
[pmm@e6a966547499 opt] # cat /etc/clickhouse-server/config.xml |grep listen
Steps to Reproduce:
-
Opened the Clickhouse DB ports using the below command.
docker run --detach --restart always --publish 443:8443 --publish 8123:8123 --volumes-from pmm-data --name pmm-server percona/pmm-server:3 -
I have uncommented the below line to create the user in the /etc/clickhouse-server/users.xml file.
<access_management>1</access_management>
-
Created the user for connecting remotely.
CREATE USER readonly_user IDENTIFIED WITH plaintext_password BY ‘XXXXXXXXXX’;
GRANT SELECT ON pmm.* TO readonly_user; -
Uncomment the below line to connect the DB remotely anywhere outside of the network.
[pmm@e6a966547499 opt] # cat /etc/clickhouse-server/config.xml |grep listen
<!-- <listen_host>::</listen_host> -->
After the above steps, ClickhouseDB is down, where as the same steps I did in the PMM2 version it was working fine.
Is there additionally something I should enable in the PMM3 version? Can someone please help me with the issue?
Version:
PMM3