Issue connecting Graphana with Zammad via Docker

[ksazua]

Infos:

• Used Zammad version: Docker-based (latest version)
• Used Zammad installation type: Docker Compose
• Operating system: Server is Centos 9
• Browser + version: Google Chrome 90.0.4430.212

Hello,

I’m facing a connection issue while trying to integrate Grafana and Zammad. I have Grafana and Zammad both running as Docker containers. However, when configuring the data source in Grafana, it is unable to recognize the Zammad database.

The challenge I’m encountering is that the Zammad database, running inside the Docker container, is configured to use sockets for authentication rather than a direct connection. As a result, I’m unsure how to establish the connection between these two tools.

Could anyone provide guidance on how I can properly integrate Grafana and Zammad, considering the socket-based authentication used by Zammad’s Dockerized database?

Any help or suggestions would be greatly appreciated. Thank you in advance!

Expected behavior:

• • I expect to be able to establish a successful connection between Grafana and Zammad’s Dockerized database.

Actual behavior:

• Grafana is unable to recognize the Zammad database, and I’m unable to establish a connection.

[MrGeneration]

Apart from us not suggesting to use direct database access (Elasticsearch should cover 98% of your use cases already…).

If your Grafana is not running in the same compose / network scope, this may be your issue.
By default Zammads containers actually use username and password in database scope.

So basically what you have to worry about is talking to the database or elasticsearch container (depending on your approach) and if that’s successful and you’re using correct login credentials, then you should be fine.