Netdata was not enabled the MySQL

Hi @satyadeep777 ,

Welcome to Netdata Forums.

Could please provide more details into your issue?
What steps did you do? What were you expecting to happen that didn’t happen?

Regards,
Hugo

My hurdle is i have installed netdata agent By this kickstart.sh from the official netdata website by MySQL was not monitored automatically and also i was tryed with adding mysql.config but no use
MY requirements is I need to monitor only required metrics Like CPU,RAM,MEMORY,NETWORK AND APM FOR MySQL,memcache,postgresql,and apache.
If all the things get automatically monitored then consumption will be more So i required like this.

Have you followed the setups under the integration Setup section? MySQL | Learn Netdata

If yes, could try to run the plugin in debug mode MySQL | Learn Netdata

Hi
I have try this but still facing same issue

ok thanks for trying.

my recommendation then is to open a bug report - Sign in to GitHub · GitHub - with as much details as you can including the output of the execution of the plugin in debug mode.

If yes, could try to run the plugin in debug mode MySQL | Learn Netdata

I have try this but still facing same issue

What issue? What error do you get? Can you share the debug output?

In my dashboard Iam unable to monitor Mysql and postgres So i found this collectors are Failed to gather metrics,So could help me to monitor those Provide me solution to Overcome this issue.

When I go with any GUI options on failed collectors, it was asking This Netdata must be connected to Netdata Cloud for Single-Sign-On (SSO) access this feature. Claim this Netdata to Netdata Cloud to enable access.
But I dont want to connect with netdata Cloud as of now
How Other collectors are connected and gathered metrics Likewise i want it for Mysql and postgres.
Provide me any solution for the issue

Thank You in Advance.

In my dashboard Iam unable to monitor Mysql and postgres So i found this collectors are Failed to gather metrics,So could help me to monitor those Provide me solution to Overcome this issue.

Without having details about the failures it is difficult to help, could be for example issues with missing user or permissions on the DB.

If you can try again the debug mode and shared the results of that we may be able to hepl.

If you don’t want to connect to Cloud this configurations from the UI is not available. the only option you have is to follow the details form here MySQL | Learn Netdata (shared on a previous post).

An easier way is to click on the restart icon and see the error. I think in both cases the issue is the credentials - you need to create netdata user (this is described in the collectors readme).

Hi
i was done debug mode for MySQL I have found some issues also i was attached the Screenshot of those Lines.

Please Guide me to overcome this errors and I need to add MYSQL monitoring to my nedata dashboard.

This is my errors which i found while running the debug mode of MySQL.

With the screenshot showing root@tcp(localhost:3306)/ seems to be an error on your configuration.

An example of what we have on our docs on the previously shared setup instructions

jobs:
  - name: local
    dsn: netdata@tcp(127.0.0.1:3306)/

Note: This specific details is here

Please go carefully through the full setup setps, if you after that you faces some issues please share again the output of the debug mode execution.

This is my current mysql.conf Can you help me with the changes should I need to made!

ThankYou in Advance.

It seems you’re missing the dsn: before the netdata@tcp(127.0.0.1:3306)/ and that should be the reason why it is taking the default value of root@tcp(localhost:3306)/

After making the changes like this still also not enabled in the netdata.

Have you restarted the Netdata Agent after the changes? Since you are still facing issues please share again the output of the debug mode execution.

I have restarted but no use

please share again the output of the debug mode execution.

Here is my current config file