# Configure MySQL module

**URL:** <https://discuss.elastic.co/t/configure-mysql-module/120899>\
**Category:** Beats\
**Tags:** filebeat\
**Created:** [February 21, 2018, 4:58pm UTC](https://discuss.elastic.co/t/configure-mysql-module/120899 "2018-02-21T16:58:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\
**Post date:** [February 21, 2018, 4:58pm UTC](https://discuss.elastic.co/t/configure-mysql-module/120899/1 "2018-02-21T16:58:11Z")

</div>

Per [Configure the MySQL module](https://www.elastic.co/guide/en/beats/filebeat/current/filebeat-module-mysql.html#configuring-mysql-module)

```
# cat mysql.yml 
- module: mysql
  # Error logs
  error:
    enabled: true

    # Set custom paths for the log files. If left empty,
    # Filebeat will choose the paths depending on your OS.
    var.paths: ["/var/log/mysql/error.log*"]

  # Slow logs
  slowlog:
    enabled: true

    # Set custom paths for the log files. If left empty,
    # Filebeat will choose the paths depending on your OS.
    #var.paths:
# ls -ld /var/log/mysql/error.log* | head -1
-rw-r----- 1 mysql adm 2472 Feb 21 16:47 /var/log/mysql/error.log
# 

```

however whenever I open `Filebeat MySQL Dashboard` via Kibana, I get

> No results found

Please advise.

---

<div class="post-metadata">

**Author:** ![adrisr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adrisr/32/25423_2.png) [@adrisr](https://discuss.elastic.co/u/adrisr)\
**Post date:** [February 22, 2018, 10:50am UTC](https://discuss.elastic.co/t/configure-mysql-module/120899/2 "2018-02-22T10:50:46Z")

</div>

What is your output configuration? Are you sending directly to Elasticsearch?

Did you configure the Default Index Pattern in Kibana? are you looking at the filebeat indices? Did you check in the Time Filter that your selected range contains events?

Run filebeat with debug logs enabled, to confirm that it is publishing events: `filebeat run -e -d publish`

---

<div class="post-metadata">

**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\
**Post date:** [February 22, 2018, 4:35pm UTC](https://discuss.elastic.co/t/configure-mysql-module/120899/3 "2018-02-22T16:35:00Z")

</div>

I should have included that information from the beginning:

mysql -\> filebeat -\> logstash -\> elasticsearch -\> kibana

```
# filebeat test output
logstash: logstash:5044...
  connection...
    parse host... OK
    dns lookup... OK
    addresses: 10.X.X.X
    dial up... OK
  TLS... WARN secure connection disabled
  talk to server... OK
# 

```

I do see events inside of `filebeat-6.2.1-2018.02.21` with following filter:

```
{
  "query": {
    "match": {
      "fileset.module": {
        "query": "mysql",
        "type": "phrase"
      }
    }
  }
}

```

yet not in Kibana's Dashboard/Visualization...

---

<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:** [March 22, 2018, 4:35pm UTC](https://discuss.elastic.co/t/configure-mysql-module/120899/4 "2018-03-22T16:35:05Z")

</div>

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