pmm icon indicating copy to clipboard operation
pmm copied to clipboard

PMM Clickhouse Datasource Exception

Open dwaipayan05 opened this issue 1 year ago • 1 comments

Description

We’re currently running PMM on a VM with a docker container running the pmm-server. To embed the dashboards, we have started a proxy VM which basically adds a auth header to all the requests passed on to the PMM Endpoint (percona.domain.in).

While embedding the dashboards, it works fine while using it with dashboard having prometheus data source. However, we’ve been facing a weird issue while querying the Clickhouse based datasource dashboard through the Proxy VM.

Expected Results

The Clickhouse Query should be executed successfully.

Actual Results

Here’s what’s happening

while opening a dashboard on percona.domain.in a query is sent through the following endpoint percona.domain.in/api/datasources/proxy/3?query=‘Clickhouse Query’ while embedding a dashboard on Proxy VM with endpoint proxy.domain.in a query is sent through the following endpoint proxy.domain.in/api/datasources/proxy/3?query=‘Clickhouse Query’ However, while the Query is sent to the API, the following error is thrown by Clickhouse

Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = No authentication information found: Basic authentication expected (version 21.3.14.1 (official build))

To Debug the above error, we went ahead with enabling basic auth in the Clickhouse Datasource. Initially we tried the Datasource config on our percona.domain.in. It ended up working perfectly fine. However, the same config ( basic auth enabled ) threw the same error.

Any suggestions on handling this exception ?

Version

PMMVersion: 2.20.0

Steps to reproduce

Proxy the request sent to PMM for any Clickhouse based Datasource.

Relevant logs

No response

Code of Conduct

  • [X] I agree to follow Percona Community Code of Conduct

dwaipayan05 avatar Oct 11 '22 11:10 dwaipayan05