Filebeat is not harvesting Mysql error logs

Elastic Stack Beats
1

Filebeat is harvesting mysql slow logs and that can be seen on Kibana dashboard but it isnt harvesting the mysql error log files.

Below is the mysql.yml:

# Module: mysql
# Docs: https://www.elastic.co/guide/en/beats/filebeat/7.3/filebeat-module-mysql.html

- module: mysql
  # Error logs
  error:
    enabled: true
    var.paths: ["/home/cmlogs/mysql_error.log*"] 
  # Slow logs
  slowlog:
    enabled: true
    var.paths: ["/home/mayank/cmlogs/slow-query.log*"]

---------------------------------------------------------------------------------------

permissions for both the logs is 644 mysql:mysql

2

Hi @Ashima83 :slightly_smiling_face:

Please, can you post an example of the contents of the file? It is also useful to konw the version of Filebeat and MySQL you are using.

Thanks

3

The path of your error log doesn't include mayank. Is that correct?

4

Yes! It does contain "mayank". Version of mysql is 5.6 and version of filebeat is 7.3.1

5

So can you share some example line from the logs that Filebeat is not harvesting? It might be a format issue