openstef-reference icon indicating copy to clipboard operation
openstef-reference copied to clipboard

Grafana - mysql

Open ruchan-ziya opened this issue 2 years ago • 7 comments

After setting up the container tst_icarus database is set up and accessible via phpMyAdmin. But Graphana does not have tst_icarus as a configured DataSource. And I could not set Graphana to connect to the database.

image

The container terminal displays:

openstef-grafana | logger=tsdb.mysql t=2023-05-19T07:59:07.819527312Z level=error msg="Query error" err="dial tcp 127.0.0.1:3306: connect: connection refused"

ruchan-ziya avatar May 19 '23 08:05 ruchan-ziya

Hi @ruchan-ziya is the issue still actual?

gecube avatar Sep 02 '24 06:09 gecube

o.k. I checked and really mysql password is not properly added to grafana.

gecube avatar Sep 20 '24 11:09 gecube

fixed via #37

gecube avatar Sep 23 '24 12:09 gecube

Still getting an error and I still see the tst_icarus is there in phpMyAdmin... Maybe it is me?

openstef-grafana | logger=tsdb.mysql t=2024-09-25T11:37:35.394429832Z level=error msg="Query error" err="dial tcp [::1]:3306: connect: connection refused" openstef-grafana | logger=context userId=1 orgId=1 uname=admin t=2024-09-25T11:37:35.394504706Z level=info msg="Request Completed" method=GET path=/api/datasources/uid/cdyyl940ws074b/health stat

image

ruchan-ziya avatar Sep 25 '24 11:09 ruchan-ziya

@ruchan-ziya did you try to start from scratch? I will be able to check the deployment today later. I am using docker desktop on Mac OS (MacBook Pro 2019 2,6 GHz 6-Core Intel Core i7) if it's important.

gecube avatar Sep 25 '24 11:09 gecube

Yes, from scratch... I tested on a Win11 Docker Desktop.

ruchan-ziya avatar Sep 25 '24 11:09 ruchan-ziya

worked for me on M1 after restart of influxdb-configurator

Screenshot 2024-09-25 at 15 43 29

gecube avatar Sep 25 '24 13:09 gecube