Hi all,
Has anyone had much luck with the newer versions of Zabbix and Grafana? Previous versions never had any issues. Now we have upgraded to Zabbix 6.2.1 and Grafana 9.0.2 we cannot get the MySQL datasource to work
Checked and tried IP, same server its hosted on.
Changed the below for security - made no difference.
User Permission
The database user should only be granted SELECT permissions on the specified database & tables you want to query. Grafana does not validate that queries are safe so queries can contain any SQL statement. For example, statements like USE otherdb; and DROP TABLE user; would be executed. To protect against this we Highly recommmend you create a specific MySQL user with restricted permissions. Checkout the MySQL Data Source Docs for more information.
Keep getting the error
db query error: failed to connect to server
Running the below plugin and whitelisted in the config file.
Alexander Zobnin
Dependencies:
Grafana >=8.3.0
Any help appreciated.
Has anyone had much luck with the newer versions of Zabbix and Grafana? Previous versions never had any issues. Now we have upgraded to Zabbix 6.2.1 and Grafana 9.0.2 we cannot get the MySQL datasource to work
Checked and tried IP, same server its hosted on.
Changed the below for security - made no difference.
User Permission
The database user should only be granted SELECT permissions on the specified database & tables you want to query. Grafana does not validate that queries are safe so queries can contain any SQL statement. For example, statements like USE otherdb; and DROP TABLE user; would be executed. To protect against this we Highly recommmend you create a specific MySQL user with restricted permissions. Checkout the MySQL Data Source Docs for more information.
Keep getting the error
db query error: failed to connect to server
Running the below plugin and whitelisted in the config file.
Alexander Zobnin
Dependencies:
Grafana >=8.3.0
Any help appreciated.
Comment