Plugin health check failed

[MichaelCarrik]

To reproduce

Plugin health check failed

QuestDB version:

7.4.2

Grafana version:

11.1 、10.4.5、9.5.20

Plugin version:

0.13

OS, in case of Docker specify Docker and the Host OS:

centos7

Full Name:

yingwei

Affiliation:

oss

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

Plugin health check failed

[insmac]

Hi @MichaelCarrik , thanks for raising the issue!

Typically when the plugin health check fails, this means there is a problem with connection details - have you put all the necessary host/port/user/pass values (all are empty by default) and selected "disable" for TLS if working with localhost instance?

[alex-aparin]

Hello, I came across the same issue. Configurations looks ok, tls is disabled. But it does not work. Trying to detect the reason.

UPD: I attached to grafana container's shell, questdb is accessible with RESTAPI. Credentials from docker compose are ok. How does health checker work? I will try to check Postgres Wire Protocol

UPD2: Grafana visualization is failed with error: querying the database: pq: invalid username/password

Finally I got answer - It turns out questdb has different credentials dependant of used protocol. I used ones from RESTAPI.

[tankisstank]

I'm having the same issue, and after couple of time "learn" the new environment (I'm very new to Docker, and QuestDB also), so here is some information:

https://github.com/questdb/grafana-questdb-datasource/?tab=readme-ov-file#configuration

`To configure a readonly user, follow these steps:

Open Source version
Set the following properties in server.conf file:
pg.readonly.user.enabled=true
pg.readonly.user=myuser
pg.readonly.password=secret
Restart QuestDB instance.`

Because I use Windows, so I need to go to this location to modify the config file.
C:\Windows\System32\qdbroot\conf

for other system, follow these instructions https://questdb.com/docs/concept/root-directory-structure/