From e900e496162bbaed662518910b5b41ba8d18c624 Mon Sep 17 00:00:00 2001
From: Philipp Dallig <philipp.dallig@pixelpark.com>
Date: Thu, 29 Jun 2017 13:29:53 +0200
Subject: [PATCH] fbb-db - add logstash for mysql

---
 customer/fbb-db/common.yaml      | 34 ++++++++++++++++++++++++++++++++
 customer/fbb-db/development.yaml |  1 +
 2 files changed, 35 insertions(+)

diff --git a/customer/fbb-db/common.yaml b/customer/fbb-db/common.yaml
index 1a9d2704..9ff6fa2b 100644
--- a/customer/fbb-db/common.yaml
+++ b/customer/fbb-db/common.yaml
@@ -30,3 +30,37 @@ accounts::users:
     apply: true
   holger.voigt:
     apply: true
+
+infra::generic_resource:
+  mysql_error:
+    resource: file
+    order: 10  # Input
+    parameters:
+      path: 
+        - '/var/log/mariadb/mariadb.log'
+        - '/var/log/mariadb/mysql.log'
+        - '/var/log/mariadb/error.log'
+        - '/var/log/mysql/mysql.log'
+        - '/var/log/mysql/mariadb.log'
+        - '/var/log/mysql/error.log'
+        - '/var/log/mysqld.log'
+      type: mysql-error
+      tags:
+        - "%{customer}"
+        - "%{tier}"
+  mysql_filter_1:
+    condition: 'if [type] == "mysql-error"'
+    resource: multiline
+    order: 39  # Filter
+    parameters:
+      pattern: '^%%{ich-trickse}{NUMBER} *%%{ich-trickse}{NUMBER}'
+      negate: 'true'
+      what: 'previous'
+  mysql_filter_2:
+    condition: 'if [type] == "mysql-error"'
+    resource: grok
+    order: 40  # Filter
+    parameters:
+      match:
+        - message
+        - '%%{ich-trickse}{TIMESTAMP_ISO8601:time} *%%{ich-trickse}{INT:threadid}? *\[%%{ich-trickse}{WORD:loglevel}\] *%%{ich-trickse}{GREEDYDATA:message}'
\ No newline at end of file
diff --git a/customer/fbb-db/development.yaml b/customer/fbb-db/development.yaml
index 537ebb7d..852d769b 100644
--- a/customer/fbb-db/development.yaml
+++ b/customer/fbb-db/development.yaml
@@ -3,6 +3,7 @@ infra::role: base
 infra::additional_classes:
   - infra::profile::mysql_server
   - infra::profile::postfix
+  - logstash
 
 mysql::server::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEASNMwg7N9Azc0Tr7mFpHm2dr8b7M9akSH/WKnkBM5EzNGen9tVHjBt3GDoo73ziWy9HETeZJi4TT0eflkS2E462YuM/k1W2RkVfuz1LvdN4ZOVWRyhc9eRkRd3a/2DKnoqDcJfZ0MZ0VSIqOAk1j8nc2OMPNFJMf5OufPQJR8XQb618LpwLltesDanRFPhssTnc+wt8PhbAG/63419JPPMiD4fcwu6qZw/899rDU4gDP8IQpYPOG2oLw4J6kUAtyUGWp2iAaWtJbM3/u7sdc10WNhG+dD1pnLM7Q8D/7GyaFgxRu5RhQCo9UXqlotC/kNQgKURpKPUMBbjdHesAzrVjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC5pmX8pNOaM9/SS62boOJFgCAXrHV8iIv1JMfHHp+H0UJQppPhlblXjn76n9wcfn3bgQ==]
 mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAUEvGJpXBwWrnCT/bXkwzZeJMw05awGcVK79eLcUOcIEe0RbIAQYE9BqgzB1K1RsNVl9lTOIUDrCspcX7lH6Nnx5XM8/S4l/dYMYzV62Ml4Pwayh1Q2U8SiRd0mpl9nu6/rNdYdiIy/u0Cr3rBkYuYqP6pqWOVyTXOc3yTGP3vE6x34bTDqpw3hyIhKCSVat3BBcbdBfgxnI+1hi3ShlU0gTOmJW2BZlaY2oDMBqiO92sl39eQvlolHUWc5RCJjAYB2TaKylDGVNRl3Dx1bsQ+hNA2jfPIX/5Q9D5VRP4EFI+NAgZTer89BJBGgsEsjcaDbW19b9Rs+AJek3SaaEOaDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBAIbEp/T2gOFkCq1RYLgKgSgCC49xdMMiUQS220Zbwkrj8hwlnRiZAGldbik6ht41bL6Q==]
-- 
2.39.5