Error trying to connect WFA DB to Grafana

[Balu]

Hello,

I am trying to connect WFADB to Graphana to pull out the execution logs from WFA and display them as graph in Grafana.

I understood that WFADB is not exposed to public only accesible within the installed server.

But Is there any way to connect to WFADB from external server?

[moep]

WFA DB is standard MySQL. You can make it available on the network.

Remove the following from the mysql server configuration:

bind-address=127.0.0.1

https://dev.mysql.com/doc/refman/5.7/en/ipv6-server-config.html

Maybe you also need to tune your server firewall.

[Balu]

Moep,

Thanks for your time and info.

Anyways I have duplicated my wfa Database and added Grafana as a Data source now Grafana can collect all the info from WFA.

Now i am able to pull the logs per or month or per year.