# Metricbeat and MySQL doesnt show results

**URL:** <https://discuss.elastic.co/t/metricbeat-and-mysql-doesnt-show-results/132009>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [May 15, 2018, 11:27pm UTC](https://discuss.elastic.co/t/metricbeat-and-mysql-doesnt-show-results/132009 "2018-05-15T23:27:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fernando\_Ramirez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fernando_ramirez/32/31030_2.png) [@Fernando\_Ramirez](https://discuss.elastic.co/u/Fernando_Ramirez)\
**Post date:** [May 15, 2018, 11:27pm UTC](https://discuss.elastic.co/t/metricbeat-and-mysql-doesnt-show-results/132009/1 "2018-05-15T23:27:03Z")

</div>

Hi

I run ELK in serverA.

**Kibana 5.6**  
**Elasticsearch 5.6**  
**Logstash 5.6**

And, in a second serverB I have installed metricbeat 5.6 version to monitoring the MySQL database.

**metricbeat 5.6**  
**mysql 5,7**

The configuration file is:

> ```
> #========================== Modules configuration ============================
> metricbeat.modules:
> 
> #-------------------------------- MySQL Module -------------------------------
> - module: mysql
> metricsets: ["status"]
> enabled: true
> period: 5s
> 
> # Host DSN should be defined as "user:pass@tcp(127.0.0.1:3306)/"
> # The username and password can either be set in the DSN or using the username
> # and password config options. Those specified in the DSN take precedence.
> # hosts: ["tcp(127.0.0.1:3306)/"]
> hosts: ["user:pass@tcp(127.0.0.1:3306)/"]
> 
> ```

I replace the user and pass for a user valid.

I use logstash to send the data to Kibana in serverA

```
#----------------------------- Logstash output --------------------------------
output.logstash:
  # The Logstash hosts
  hosts: ["202.222.22.22:5044"]

  # Optional SSL. By default is off.
  # List of root certificates for HTTPS server verifications
  #ssl.certificate_authorities: ["/etc/pki/root/ca.pem"]

```

I assign the level of log in: debug

And the logs show me:

```
2018-05-15T18:17:10-05:00 DBG Publish: {
  "@timestamp": "2018-05-15T23:17:10.759Z",
  "beat": {
    "hostname": "ip-172-XX-XX-XX.ec2.internal",
    "name": "ip-172-XX-XX-XX.ec2.internal",
    "version": "5.6.9"
  },
  "error": "this authentication plugin is not supported",
  "metricset": {
    "host": "127.0.0.1:3306",
    "module": "mysql",
    "name": "status",
    "rtt": 447
  },
  "mysql": {
    "status": {}
  },
  "type": "metricsets"
}

```

And the Kibana doens't show me any results of Metricbeat MySQL module.

- I missing a parameters in process of configuration ?

Please your help to resolve this issue.

Thanks in advance for your help.

---

<div class="post-metadata">

**Author:** ![pierhugues](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pierhugues/32/48383_2.png) [@pierhugues](https://discuss.elastic.co/u/pierhugues)\
**Post date:** [May 16, 2018, 2:27pm UTC](https://discuss.elastic.co/t/metricbeat-and-mysql-doesnt-show-results/132009/2 "2018-05-16T14:27:48Z")

</div>

Did you try with a newer version of metricbeat 6.2.4 if the problem is solved?

---

<div class="post-metadata">

**Author:** ![Fernando\_Ramirez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fernando_ramirez/32/31030_2.png) [@Fernando\_Ramirez](https://discuss.elastic.co/u/Fernando_Ramirez)\
**Post date:** [May 21, 2018, 9:25pm UTC](https://discuss.elastic.co/t/metricbeat-and-mysql-doesnt-show-results/132009/3 "2018-05-21T21:25:01Z")

</div>

Thanks a lot this respond resolve my issue

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 18, 2018, 9:25pm UTC](https://discuss.elastic.co/t/metricbeat-and-mysql-doesnt-show-results/132009/4 "2018-06-18T21:25:11Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.