pre_exam.txt

Tue Jan  9 11:07:13 EET 2024
+ hostname
aekar
+ ansible-playbook infra.yaml --diff

PLAY [Initial setup] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]

TASK [init : Update APT cache] *************************************************
changed: [EmreKaratopuk-3]
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [init : Download certificates] ********************************************
The following packages will be upgraded:
  ca-certificates
1 upgraded, 0 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-3]
The following packages will be upgraded:
  ca-certificates
1 upgraded, 0 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-1]
The following packages will be upgraded:
  ca-certificates
1 upgraded, 0 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-2]

TASK [init : Install prometheus node exporter] *********************************
The following additional packages will be installed:
  libio-pty-perl libipc-run-perl libtime-duration-perl libtimedate-perl
  moreutils prometheus-node-exporter-collectors smartmontools
Suggested packages:
  gsmartcontrol smart-notifier mailx | mailutils
The following NEW packages will be installed:
  libio-pty-perl libipc-run-perl libtime-duration-perl libtimedate-perl
  moreutils prometheus-node-exporter prometheus-node-exporter-collectors
  smartmontools
0 upgraded, 8 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-3]
The following additional packages will be installed:
  libio-pty-perl libipc-run-perl libtime-duration-perl libtimedate-perl
  moreutils prometheus-node-exporter-collectors smartmontools
Suggested packages:
  gsmartcontrol smart-notifier mailx | mailutils
The following NEW packages will be installed:
  libio-pty-perl libipc-run-perl libtime-duration-perl libtimedate-perl
  moreutils prometheus-node-exporter prometheus-node-exporter-collectors
  smartmontools
0 upgraded, 8 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-2]
The following additional packages will be installed:
  libio-pty-perl libipc-run-perl libtime-duration-perl libtimedate-perl
  moreutils prometheus-node-exporter-collectors smartmontools
Suggested packages:
  gsmartcontrol smart-notifier mailx | mailutils
The following NEW packages will be installed:
  libio-pty-perl libipc-run-perl libtime-duration-perl libtimedate-perl
  moreutils prometheus-node-exporter prometheus-node-exporter-collectors
  smartmontools
0 upgraded, 8 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-1]

TASK [init : Modify rsyslog conf file] *****************************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/init/files/rsyslog-tel.conf
@@ -0,0 +1,6 @@
+$ActionQueueType LinkedList # use asynchronous processing
+$ActionQueueFileName srvrfwd # set file name, also enables disk mode
+$ActionResumeRetryCount -1 # infinite retries on insert failure
+$ActionQueueSaveOnShutdown on # save in-memory data if rsyslog shuts down
+
+*.* @influxdb:6514;RSYSLOG_SyslogProtocol23Format
\ No newline at end of file

changed: [EmreKaratopuk-3]
--- before
+++ after: /home/starlord/taltech/ica0002/roles/init/files/rsyslog-tel.conf
@@ -0,0 +1,6 @@
+$ActionQueueType LinkedList # use asynchronous processing
+$ActionQueueFileName srvrfwd # set file name, also enables disk mode
+$ActionResumeRetryCount -1 # infinite retries on insert failure
+$ActionQueueSaveOnShutdown on # save in-memory data if rsyslog shuts down
+
+*.* @influxdb:6514;RSYSLOG_SyslogProtocol23Format
\ No newline at end of file

changed: [EmreKaratopuk-1]
--- before
+++ after: /home/starlord/taltech/ica0002/roles/init/files/rsyslog-tel.conf
@@ -0,0 +1,6 @@
+$ActionQueueType LinkedList # use asynchronous processing
+$ActionQueueFileName srvrfwd # set file name, also enables disk mode
+$ActionResumeRetryCount -1 # infinite retries on insert failure
+$ActionQueueSaveOnShutdown on # save in-memory data if rsyslog shuts down
+
+*.* @influxdb:6514;RSYSLOG_SyslogProtocol23Format
\ No newline at end of file

changed: [EmreKaratopuk-2]

TASK [init : Create backup user] ***********************************************
changed: [EmreKaratopuk-3]
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

TASK [init : Add backup server to known hosts] *********************************
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmprxqgecvy/known_hosts
@@ -0,0 +1,3 @@
+192.168.42.132 ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
+backup ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
+backup.istikbal.ek ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
\ No newline at end of file

changed: [EmreKaratopuk-3]
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp7h51i1ki/known_hosts
@@ -0,0 +1,3 @@
+192.168.42.132 ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
+backup ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
+backup.istikbal.ek ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
\ No newline at end of file

changed: [EmreKaratopuk-2]
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp25ouwh55/known_hosts
@@ -0,0 +1,3 @@
+192.168.42.132 ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
+backup ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
+backup.istikbal.ek ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIEu6pFFWyuRrl4WGFPQGElYN9txwTGm2wSntcpVAaN90
\ No newline at end of file

changed: [EmreKaratopuk-1]

TASK [init : Create restore directory] *****************************************
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/restore",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-2]
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/restore",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-1]
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/restore",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-3]

TASK [init : Install duplicity] ************************************************
The following additional packages will be installed:
  librsync2 python3-bcrypt python3-fasteners python3-future python3-lockfile
  python3-monotonic python3-paramiko
Suggested packages:
  python3-boto ncftp lftp tahoe-lafs python3-swiftclient python3-pip par2
  python-future-doc python-lockfile-doc python3-gssapi
The following NEW packages will be installed:
  duplicity librsync2 python3-bcrypt python3-fasteners python3-future
  python3-lockfile python3-monotonic python3-paramiko
0 upgraded, 8 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-3]
The following additional packages will be installed:
  librsync2 python3-bcrypt python3-fasteners python3-future python3-lockfile
  python3-monotonic python3-paramiko
Suggested packages:
  python3-boto ncftp lftp tahoe-lafs python3-swiftclient python3-pip par2
  python-future-doc python-lockfile-doc python3-gssapi
The following NEW packages will be installed:
  duplicity librsync2 python3-bcrypt python3-fasteners python3-future
  python3-lockfile python3-monotonic python3-paramiko
0 upgraded, 8 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-1]
The following additional packages will be installed:
  librsync2 python3-bcrypt python3-fasteners python3-future python3-lockfile
  python3-monotonic python3-paramiko
Suggested packages:
  python3-boto ncftp lftp tahoe-lafs python3-swiftclient python3-pip par2
  python-future-doc python-lockfile-doc python3-gssapi
The following NEW packages will be installed:
  duplicity librsync2 python3-bcrypt python3-fasteners python3-future
  python3-lockfile python3-monotonic python3-paramiko
0 upgraded, 8 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-2]

TASK [init : Install dnspython] ************************************************
The following NEW packages will be installed:
  python3-dnspython
0 upgraded, 1 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-2]
The following NEW packages will be installed:
  python3-dnspython
0 upgraded, 1 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-1]
The following NEW packages will be installed:
  python3-dnspython
0 upgraded, 1 newly installed, 0 to remove and 264 not upgraded.
changed: [EmreKaratopuk-3]

RUNNING HANDLER [init : Restart rsyslog] ***************************************
changed: [EmreKaratopuk-3]
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

PLAY [Bind server] *************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [bind : Install bind9] ****************************************************
The following additional packages will be installed:
  bind9-dnsutils bind9-libs bind9-utils dns-root-data python3-ply
Suggested packages:
  bind-doc resolvconf python-ply-doc
The following NEW packages will be installed:
  bind9 bind9-utils dns-root-data python3-ply
The following packages will be upgraded:
  bind9-dnsutils bind9-libs
2 upgraded, 4 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]
The following additional packages will be installed:
  bind9-dnsutils bind9-libs bind9-utils dns-root-data python3-ply
Suggested packages:
  bind-doc resolvconf python-ply-doc
The following NEW packages will be installed:
  bind9 bind9-utils dns-root-data python3-ply
The following packages will be upgraded:
  bind9-dnsutils bind9-libs
2 upgraded, 4 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-3]
The following additional packages will be installed:
  bind9-dnsutils bind9-libs bind9-utils dns-root-data python3-ply
Suggested packages:
  bind-doc resolvconf python-ply-doc
The following NEW packages will be installed:
  bind9 bind9-utils dns-root-data python3-ply
The following packages will be upgraded:
  bind9-dnsutils bind9-libs
2 upgraded, 4 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]

TASK [bind : Configure bind9 files] ********************************************
changed: [EmreKaratopuk-3] => (item=None)
changed: [EmreKaratopuk-1] => (item=None)
changed: [EmreKaratopuk-2] => (item=None)
changed: [EmreKaratopuk-3] => (item=None)
changed: [EmreKaratopuk-3]
changed: [EmreKaratopuk-2] => (item=None)
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1] => (item=None)
changed: [EmreKaratopuk-1]

TASK [bind : Configure master zone] ********************************************
skipping: [EmreKaratopuk-1] => (item=istikbal.ek) 
skipping: [EmreKaratopuk-1] => (item=168.192.in-addr.arpa) 
skipping: [EmreKaratopuk-2] => (item=istikbal.ek) 
skipping: [EmreKaratopuk-2] => (item=168.192.in-addr.arpa) 
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp2t0lg62h/istikbal.ek.j2
@@ -0,0 +1,16 @@
+$TTL	604800
+istikbal.ek.	IN	SOA	vm1.istikbal.ek. alikar.istikbal.ek. (
+			      1		; Serial
+			 604800		; Refresh
+			  86400		; Retry
+			2419200		; Expire
+			 604800 )	; Negative Cache TTL
+;
+istikbal.ek.	IN	NS	EmreKaratopuk-3
+istikbal.ek.	IN	NS	EmreKaratopuk-1
+istikbal.ek.	IN	NS	EmreKaratopuk-2
+
+EmreKaratopuk-1	IN	A	192.168.42.173
+EmreKaratopuk-2	IN	A	192.168.42.47
+EmreKaratopuk-3	IN	A	192.168.42.31
+

changed: [EmreKaratopuk-3] => (item=istikbal.ek)
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpw67m0yy6/168.192.in-addr.arpa.j2
@@ -0,0 +1,19 @@
+$TTL	604800
+168.192.in-addr.arpa.	IN	SOA	vm1.168.192.in-addr.arpa. alikar.168.192.in-addr.arpa. (
+			      2		; Serial
+			 604800		; Refresh
+			  86400		; Retry
+			2419200		; Expire
+			 604800 )	; Negative Cache TTL
+;
+168.192.in-addr.arpa.	IN	NS	EmreKaratopuk-3
+168.192.in-addr.arpa.	IN	NS	EmreKaratopuk-1
+168.192.in-addr.arpa.	IN	NS	EmreKaratopuk-2
+
+EmreKaratopuk-1	IN	A	192.168.42.173
+EmreKaratopuk-2	IN	A	192.168.42.47
+EmreKaratopuk-3	IN	A	192.168.42.31
+
+173.42	IN	PTR	EmreKaratopuk-1.istikbal.ek.
+47.42	IN	PTR	EmreKaratopuk-2.istikbal.ek.
+31.42	IN	PTR	EmreKaratopuk-3.istikbal.ek.

changed: [EmreKaratopuk-3] => (item=168.192.in-addr.arpa)

TASK [bind : Install prometheus-bind-exporter] *********************************
The following NEW packages will be installed:
  prometheus-bind-exporter
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-3]
The following NEW packages will be installed:
  prometheus-bind-exporter
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]
The following NEW packages will be installed:
  prometheus-bind-exporter
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]

TASK [bind : Start bind9 and exporter] *****************************************
ok: [EmreKaratopuk-3] => (item=bind9)
ok: [EmreKaratopuk-2] => (item=bind9)
ok: [EmreKaratopuk-1] => (item=bind9)
ok: [EmreKaratopuk-3] => (item=prometheus-bind-exporter)
ok: [EmreKaratopuk-2] => (item=prometheus-bind-exporter)
ok: [EmreKaratopuk-1] => (item=prometheus-bind-exporter)

TASK [bind : Run handlers] *****************************************************

RUNNING HANDLER [bind : Restart bind9] *****************************************
changed: [EmreKaratopuk-3]
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

TASK [Add A records] ***********************************************************
skipping: [EmreKaratopuk-1] => (item={'key': 'backup', 'value': '192.168.42.132'}) 
skipping: [EmreKaratopuk-1] => (item={'key': 'google', 'value': '8.8.8.8'}) 
skipping: [EmreKaratopuk-2] => (item={'key': 'backup', 'value': '192.168.42.132'}) 
skipping: [EmreKaratopuk-2] => (item={'key': 'google', 'value': '8.8.8.8'}) 

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [Add NS records] **********************************************************
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-3) 
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-1) 
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-2) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-3) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-1) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-2) 

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Configure DNS settings for both] *****************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [config-dns : Stop systemd-resolved] **************************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-3]

TASK [config-dns : Change resolv.conf content] *********************************
--- before: /etc/resolv.conf
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp0eo0xvka/resolv.conf.j2
@@ -1,19 +1,3 @@
-# This file is managed by man:systemd-resolved(8). Do not edit.
-#
-# This is a dynamic resolv.conf file for connecting local clients to the
-# internal DNS stub resolver of systemd-resolved. This file lists all
-# configured search domains.
-#
-# Run "resolvectl status" to see details about the uplink DNS servers
-# currently in use.
-#
-# Third party programs must not access this file directly, but only through the
-# symlink at /etc/resolv.conf. To manage man:resolv.conf(5) in a different way,
-# replace this symlink by a static file or a different symlink.
-#
-# See man:systemd-resolved.service(8) for details about the supported modes of
-# operation for /etc/resolv.conf.
-
-nameserver 127.0.0.53
-options edns0 trust-ad
-search openstacklocal
+search istikbal.ek
+nameserver 192.168.42.173
+nameserver 192.168.42.47

changed: [EmreKaratopuk-2]
--- before: /etc/resolv.conf
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpo1zeq87u/resolv.conf.j2
@@ -1,19 +1,3 @@
-# This file is managed by man:systemd-resolved(8). Do not edit.
-#
-# This is a dynamic resolv.conf file for connecting local clients to the
-# internal DNS stub resolver of systemd-resolved. This file lists all
-# configured search domains.
-#
-# Run "resolvectl status" to see details about the uplink DNS servers
-# currently in use.
-#
-# Third party programs must not access this file directly, but only through the
-# symlink at /etc/resolv.conf. To manage man:resolv.conf(5) in a different way,
-# replace this symlink by a static file or a different symlink.
-#
-# See man:systemd-resolved.service(8) for details about the supported modes of
-# operation for /etc/resolv.conf.
-
-nameserver 127.0.0.53
-options edns0 trust-ad
-search openstacklocal
+search istikbal.ek
+nameserver 192.168.42.173
+nameserver 192.168.42.47

changed: [EmreKaratopuk-3]
--- before: /etc/resolv.conf
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpnrjp0m51/resolv.conf.j2
@@ -1,19 +1,3 @@
-# This file is managed by man:systemd-resolved(8). Do not edit.
-#
-# This is a dynamic resolv.conf file for connecting local clients to the
-# internal DNS stub resolver of systemd-resolved. This file lists all
-# configured search domains.
-#
-# Run "resolvectl status" to see details about the uplink DNS servers
-# currently in use.
-#
-# Third party programs must not access this file directly, but only through the
-# symlink at /etc/resolv.conf. To manage man:resolv.conf(5) in a different way,
-# replace this symlink by a static file or a different symlink.
-#
-# See man:systemd-resolved.service(8) for details about the supported modes of
-# operation for /etc/resolv.conf.
-
-nameserver 127.0.0.53
-options edns0 trust-ad
-search openstacklocal
+search istikbal.ek
+nameserver 192.168.42.173
+nameserver 192.168.42.47

changed: [EmreKaratopuk-1]

PLAY [Prometheus server] *******************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Install Prometheus] *****************************************
The following additional packages will be installed:
  fonts-glyphicons-halflings javascript-common libc-ares2 libjs-bootstrap
  libjs-bootstrap4 libjs-d3 libjs-eonasdan-bootstrap-datetimepicker
  libjs-jquery libjs-jquery-hotkeys libjs-moment libjs-moment-timezone
  libjs-mustache libjs-popper.js libjs-rickshaw libnode64 node-jquery nodejs
  nodejs-doc
Suggested packages:
  apache2 | lighttpd | httpd npm
The following NEW packages will be installed:
  fonts-glyphicons-halflings javascript-common libc-ares2 libjs-bootstrap
  libjs-bootstrap4 libjs-d3 libjs-eonasdan-bootstrap-datetimepicker
  libjs-jquery libjs-jquery-hotkeys libjs-moment libjs-moment-timezone
  libjs-mustache libjs-popper.js libjs-rickshaw libnode64 node-jquery nodejs
  nodejs-doc prometheus
0 upgraded, 19 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-3]

TASK [prometheus : Adjust Prometheus service] **********************************
--- before: /etc/default/prometheus
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpwzrt6ddf/prometheus
@@ -1,5 +1,5 @@
 # Set the command-line arguments to pass to the server.
-ARGS=""
+ARGS="--web.external-url=http://EmreKaratopuk-3/prometheus"
 
 # Prometheus supports the following options:
 #  --config.file="/etc/prometheus/prometheus.yml"
@@ -54,4 +54,4 @@
 #  --query.max-concurrency=20
 #                             Maximum number of queries executed concurrently.
 #  --log.level=info           Only log messages with the given severity or
-#                             above. One of: [debug, info, warn, error]
+#                             above. One of: [debug, info, warn, error]
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [prometheus : Add data source VMs] ****************************************
--- before: /etc/prometheus/prometheus.yml
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpsd9xc7pe/prometheus.yml
@@ -32,6 +32,7 @@
     scrape_timeout: 5s
 
     # metrics_path defaults to '/metrics'
+    metrics_path: /prometheus/metrics
     # scheme defaults to 'http'.
 
     static_configs:
@@ -42,3 +43,66 @@
     # machine by default.
     static_configs:
       - targets: ['localhost:9100']
+
+
+  
+  - job_name: linux
+    static_configs:
+      - targets:
+        
+        - EmreKaratopuk-1:9100
+        
+        - EmreKaratopuk-2:9100
+        
+        - EmreKaratopuk-3:9100
+          
+  - job_name: bind9
+    static_configs:
+      - targets:
+        
+        - EmreKaratopuk-3:9119
+        
+        - EmreKaratopuk-1:9119
+        
+        - EmreKaratopuk-2:9119
+          
+  - job_name: mysql
+    static_configs:
+      - targets:
+        
+        - EmreKaratopuk-1:9104
+        
+        - EmreKaratopuk-2:9104
+          
+  - job_name: nginx
+    static_configs:
+      - targets:
+        
+        - EmreKaratopuk-1:9113
+        
+        - EmreKaratopuk-2:9113
+        
+        - EmreKaratopuk-3:9113
+          
+  - job_name: influxdb
+    static_configs:
+      - targets:
+        
+        - EmreKaratopuk-3:9424
+          
+  - job_name: haproxy
+    static_configs:
+      - targets:
+        
+        - EmreKaratopuk-1:9101
+        
+        - EmreKaratopuk-2:9101
+          
+  - job_name: keepalived
+    static_configs:
+      - targets:
+        
+        - EmreKaratopuk-1:9165
+        
+        - EmreKaratopuk-2:9165
+          
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [prometheus : Start prometheus] *******************************************
ok: [EmreKaratopuk-3]

TASK [Add prometheus A record] *************************************************

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

RUNNING HANDLER [prometheus : Restart Prometheus] ******************************
changed: [EmreKaratopuk-3]

PLAY [Database server] *********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Install mysql] ***************************************************
The following additional packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-7
  libevent-pthreads-2.1-7 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
  libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl libmecab2 liburi-perl mecab-ipadic mecab-ipadic-utf8
  mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common
  mysql-server-8.0 mysql-server-core-8.0
Suggested packages:
  libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx tinyca
The following NEW packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-7
  libevent-pthreads-2.1-7 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
  libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl libmecab2 liburi-perl mecab-ipadic mecab-ipadic-utf8
  mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server
  mysql-server-8.0 mysql-server-core-8.0
0 upgraded, 24 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]
The following additional packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-7
  libevent-pthreads-2.1-7 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
  libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl libmecab2 liburi-perl mecab-ipadic mecab-ipadic-utf8
  mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common
  mysql-server-8.0 mysql-server-core-8.0
Suggested packages:
  libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx tinyca
The following NEW packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-7
  libevent-pthreads-2.1-7 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
  libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl libmecab2 liburi-perl mecab-ipadic mecab-ipadic-utf8
  mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server
  mysql-server-8.0 mysql-server-core-8.0
0 upgraded, 24 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]

TASK [mysql : Listen public] ***************************************************
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp5uh28lzs/override.cnf.j2
@@ -0,0 +1,7 @@
+[mysqld]
+bind-address = 0.0.0.0
+
+log-bin = /var/log/mysql/mysql-bin.log
+relay-log = /var/log/mysql/mysql-relay.log
+replicate-do-db = agama
+server-id = 173
\ No newline at end of file

changed: [EmreKaratopuk-1]
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpuzu88xvz/override.cnf.j2
@@ -0,0 +1,7 @@
+[mysqld]
+bind-address = 0.0.0.0
+
+log-bin = /var/log/mysql/mysql-bin.log
+relay-log = /var/log/mysql/mysql-relay.log
+replicate-do-db = agama
+server-id = 47
\ No newline at end of file

changed: [EmreKaratopuk-2]

TASK [mysql : Start mysql] *****************************************************

RUNNING HANDLER [mysql : Restart mysql] ****************************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [mysql : Install python3-pymysql] *****************************************
Suggested packages:
  python-pymysql-doc
The following NEW packages will be installed:
  python3-pymysql
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]
Suggested packages:
  python-pymysql-doc
The following NEW packages will be installed:
  python3-pymysql
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]

TASK [mysql : Add agama database] **********************************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [mysql : MySQL user] ******************************************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [mysql : Configure mysql exporter credentials] ****************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [mysql : Create mysql exporter user] **************************************
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

TASK [mysql : Install prometheus-mysqld-exporter] ******************************
The following additional packages will be installed:
  daemon
The following NEW packages will be installed:
  daemon prometheus-mysqld-exporter
0 upgraded, 2 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]
The following additional packages will be installed:
  daemon
The following NEW packages will be installed:
  daemon prometheus-mysqld-exporter
0 upgraded, 2 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]

TASK [mysql : Export replica status] *******************************************
--- before: /etc/default/prometheus-mysqld-exporter
+++ after: /home/starlord/taltech/ica0002/roles/mysql/files/prometheus-mysqld-exporter
@@ -1,120 +1 @@
-# By default the connection string will be read from
-# $HOME/my.cnf or from the file specified with the -config.my-cnf parameter.
-
-# To set a connection string from the environment instead, uncomment one of the
-# following lines.
-
-# Using UNIX domain sockets and authentication:
-# DATA_SOURCE_NAME="prometheus:nopassword@unix(/run/mysqld/mysqld.sock)/"
-
-# Using a TCP connection and password authentication:
-# DATA_SOURCE_NAME="login:password@(hostname:port)/dbname"
-
-# Note the user must be granted enough privileges for the exporter to run.
-# Example to create a user to connect with the UNIX socket:
-#
-#  CREATE USER IF NOT EXISTS 'prometheus'@'localhost' IDENTIFIED VIA unix_socket;
-#  GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'prometheus'@'localhost';
-
-# Set the command-line arguments to pass to the exporter.
-# ARGS='-config.my-cnf /etc/mysql/debian.cnf'
-
-# Usage of prometheus-mysqld-exporter:
-#   -collect.auto_increment.columns
-#     	Collect auto_increment columns and max values from information_schema
-#  --exporter.lock_wait_timeout=2
-#       Set a lock_wait_timeout on the connection to avoid long metadata
-#       locking.
-#  --exporter.log_slow_filter
-#       Add a log_slow_filter to avoid slow query logging of scrapes. NOTE: Not
-#       supported by Oracle MySQL.
-#  --collect.heartbeat.database="heartbeat"
-#       Database from where to collect heartbeat data
-#  --collect.heartbeat.table="heartbeat"
-#       Table from where to collect heartbeat data
-#  --collect.info_schema.processlist.min_time=0
-#       Minimum time a thread must be in each state to be counted
-#  --collect.info_schema.tables.databases="*"
-#       The list of databases to collect table stats for, or '*' for all
-#  --collect.perf_schema.eventsstatements.limit=250
-#       Limit the number of events statements digests by response time
-#  --collect.perf_schema.eventsstatements.timelimit=86400
-#       Limit how old the 'last_seen' events statements can be, in seconds
-#  --collect.perf_schema.eventsstatements.digest_text_limit=120
-#       Maximum length of the normalized statement text
-#  --collect.perf_schema.file_instances.filter=".*"
-#       RegEx file_name filter for performance_schema.file_summary_by_instance
-#  --collect.perf_schema.file_instances.remove_prefix="/var/lib/mysql/"
-#       Remove path prefix in performance_schema.file_summary_by_instance
-#  --web.listen-address=":9104"
-#       Address to listen on for web interface and telemetry.
-#  --web.telemetry-path="/metrics"
-#       Path under which to expose metrics.
-#  --config.my-cnf="$HOME/.my.cnf"
-#       Path to .my.cnf file to read MySQL credentials from.
-#  --collect.global_variables
-#       Collect from SHOW GLOBAL VARIABLES
-#  --collect.slave_status
-#       Collect from SHOW SLAVE STATUS
-#  --collect.info_schema.processlist
-#       Collect current thread state counts from the
-#       information_schema.processlist
-#  --collect.info_schema.tables
-#       Collect metrics from information_schema.tables
-#  --collect.info_schema.innodb_tablespaces
-#       Collect metrics from information_schema.innodb_sys_tablespaces
-#  --collect.info_schema.innodb_metrics
-#       Collect metrics from information_schema.innodb_metrics
-#  --collect.auto_increment.columns
-#       Collect auto_increment columns and max values from information_schema
-#  --collect.global_status
-#       Collect from SHOW GLOBAL STATUS
-#  --collect.perf_schema.tableiowaits
-#       Collect metrics from performance_schema.table_io_waits_summary_by_table
-#  --collect.perf_schema.indexiowaits
-#       Collect metrics from
-#       performance_schema.table_io_waits_summary_by_index_usage
-#  --collect.perf_schema.tablelocks
-#       Collect metrics from
-#       performance_schema.table_lock_waits_summary_by_table
-#  --collect.perf_schema.eventsstatements
-#       Collect metrics from
-#       performance_schema.events_statements_summary_by_digest
-#  --collect.perf_schema.eventswaits
-#       Collect metrics from
-#       performance_schema.events_waits_summary_global_by_event_name
-#  --collect.perf_schema.file_events
-#       Collect metrics from performance_schema.file_summary_by_event_name
-#  --collect.perf_schema.file_instances
-#       Collect metrics from performance_schema.file_summary_by_instance
-#  --collect.binlog_size
-#       Collect the current size of all registered binlog files
-#  --collect.info_schema.userstats
-#       If running with userstat=1, set to true to collect user statistics
-#  --collect.info_schema.clientstats
-#       If running with userstat=1, set to true to collect client statistics
-#  --collect.info_schema.tablestats
-#       If running with userstat=1, set to true to collect table statistics
-#  --collect.info_schema.innodb_cmp
-#       Collect metrics from information_schema.innodb_cmp
-#  --collect.info_schema.innodb_cmpmem
-#       Collect metrics from information_schema.innodb_cmpmem
-#  --collect.info_schema.query_response_time
-#       Collect query response time distribution if query_response_time_stats
-#       is ON.
-#  --collect.engine_tokudb_status
-#       Collect from SHOW ENGINE TOKUDB STATUS
-#  --collect.perf_schema.replication_group_member_stats
-#       Collect metrics from performance_schema.replication_group_member_stats
-#  --collect.heartbeat
-#       Collect from heartbeat
-#  --collect.slave_hosts
-#       Scrape information from 'SHOW SLAVE HOSTS'
-#  --collect.engine_innodb_status
-#       Collect from SHOW ENGINE INNODB STATUS
-#  --log.level="info"
-#       Only log messages with the given severity or above. Valid levels:
-#       [debug, info, warn, error, fatal]
-#  --log.format="logger:stderr"
-#       Set the log target and format. Example:
-#       "logger:syslog?appname=bob&local=7" or "logger:stdout?json=true"
+ARGS="--collect.slave_status"
\ No newline at end of file

changed: [EmreKaratopuk-2]
--- before: /etc/default/prometheus-mysqld-exporter
+++ after: /home/starlord/taltech/ica0002/roles/mysql/files/prometheus-mysqld-exporter
@@ -1,120 +1 @@
-# By default the connection string will be read from
-# $HOME/my.cnf or from the file specified with the -config.my-cnf parameter.
-
-# To set a connection string from the environment instead, uncomment one of the
-# following lines.
-
-# Using UNIX domain sockets and authentication:
-# DATA_SOURCE_NAME="prometheus:nopassword@unix(/run/mysqld/mysqld.sock)/"
-
-# Using a TCP connection and password authentication:
-# DATA_SOURCE_NAME="login:password@(hostname:port)/dbname"
-
-# Note the user must be granted enough privileges for the exporter to run.
-# Example to create a user to connect with the UNIX socket:
-#
-#  CREATE USER IF NOT EXISTS 'prometheus'@'localhost' IDENTIFIED VIA unix_socket;
-#  GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'prometheus'@'localhost';
-
-# Set the command-line arguments to pass to the exporter.
-# ARGS='-config.my-cnf /etc/mysql/debian.cnf'
-
-# Usage of prometheus-mysqld-exporter:
-#   -collect.auto_increment.columns
-#     	Collect auto_increment columns and max values from information_schema
-#  --exporter.lock_wait_timeout=2
-#       Set a lock_wait_timeout on the connection to avoid long metadata
-#       locking.
-#  --exporter.log_slow_filter
-#       Add a log_slow_filter to avoid slow query logging of scrapes. NOTE: Not
-#       supported by Oracle MySQL.
-#  --collect.heartbeat.database="heartbeat"
-#       Database from where to collect heartbeat data
-#  --collect.heartbeat.table="heartbeat"
-#       Table from where to collect heartbeat data
-#  --collect.info_schema.processlist.min_time=0
-#       Minimum time a thread must be in each state to be counted
-#  --collect.info_schema.tables.databases="*"
-#       The list of databases to collect table stats for, or '*' for all
-#  --collect.perf_schema.eventsstatements.limit=250
-#       Limit the number of events statements digests by response time
-#  --collect.perf_schema.eventsstatements.timelimit=86400
-#       Limit how old the 'last_seen' events statements can be, in seconds
-#  --collect.perf_schema.eventsstatements.digest_text_limit=120
-#       Maximum length of the normalized statement text
-#  --collect.perf_schema.file_instances.filter=".*"
-#       RegEx file_name filter for performance_schema.file_summary_by_instance
-#  --collect.perf_schema.file_instances.remove_prefix="/var/lib/mysql/"
-#       Remove path prefix in performance_schema.file_summary_by_instance
-#  --web.listen-address=":9104"
-#       Address to listen on for web interface and telemetry.
-#  --web.telemetry-path="/metrics"
-#       Path under which to expose metrics.
-#  --config.my-cnf="$HOME/.my.cnf"
-#       Path to .my.cnf file to read MySQL credentials from.
-#  --collect.global_variables
-#       Collect from SHOW GLOBAL VARIABLES
-#  --collect.slave_status
-#       Collect from SHOW SLAVE STATUS
-#  --collect.info_schema.processlist
-#       Collect current thread state counts from the
-#       information_schema.processlist
-#  --collect.info_schema.tables
-#       Collect metrics from information_schema.tables
-#  --collect.info_schema.innodb_tablespaces
-#       Collect metrics from information_schema.innodb_sys_tablespaces
-#  --collect.info_schema.innodb_metrics
-#       Collect metrics from information_schema.innodb_metrics
-#  --collect.auto_increment.columns
-#       Collect auto_increment columns and max values from information_schema
-#  --collect.global_status
-#       Collect from SHOW GLOBAL STATUS
-#  --collect.perf_schema.tableiowaits
-#       Collect metrics from performance_schema.table_io_waits_summary_by_table
-#  --collect.perf_schema.indexiowaits
-#       Collect metrics from
-#       performance_schema.table_io_waits_summary_by_index_usage
-#  --collect.perf_schema.tablelocks
-#       Collect metrics from
-#       performance_schema.table_lock_waits_summary_by_table
-#  --collect.perf_schema.eventsstatements
-#       Collect metrics from
-#       performance_schema.events_statements_summary_by_digest
-#  --collect.perf_schema.eventswaits
-#       Collect metrics from
-#       performance_schema.events_waits_summary_global_by_event_name
-#  --collect.perf_schema.file_events
-#       Collect metrics from performance_schema.file_summary_by_event_name
-#  --collect.perf_schema.file_instances
-#       Collect metrics from performance_schema.file_summary_by_instance
-#  --collect.binlog_size
-#       Collect the current size of all registered binlog files
-#  --collect.info_schema.userstats
-#       If running with userstat=1, set to true to collect user statistics
-#  --collect.info_schema.clientstats
-#       If running with userstat=1, set to true to collect client statistics
-#  --collect.info_schema.tablestats
-#       If running with userstat=1, set to true to collect table statistics
-#  --collect.info_schema.innodb_cmp
-#       Collect metrics from information_schema.innodb_cmp
-#  --collect.info_schema.innodb_cmpmem
-#       Collect metrics from information_schema.innodb_cmpmem
-#  --collect.info_schema.query_response_time
-#       Collect query response time distribution if query_response_time_stats
-#       is ON.
-#  --collect.engine_tokudb_status
-#       Collect from SHOW ENGINE TOKUDB STATUS
-#  --collect.perf_schema.replication_group_member_stats
-#       Collect metrics from performance_schema.replication_group_member_stats
-#  --collect.heartbeat
-#       Collect from heartbeat
-#  --collect.slave_hosts
-#       Scrape information from 'SHOW SLAVE HOSTS'
-#  --collect.engine_innodb_status
-#       Collect from SHOW ENGINE INNODB STATUS
-#  --log.level="info"
-#       Only log messages with the given severity or above. Valid levels:
-#       [debug, info, warn, error, fatal]
-#  --log.format="logger:stderr"
-#       Set the log target and format. Example:
-#       "logger:syslog?appname=bob&local=7" or "logger:stdout?json=true"
+ARGS="--collect.slave_status"
\ No newline at end of file

changed: [EmreKaratopuk-1]

TASK [mysql : Add mysql replication user] **************************************
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

TASK [mysql : Configure mysql dynamic variables for replica] *******************
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

TASK [mysql : Create backup and restore directories for mysql] *****************
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/mysql",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-2] => (item=mysql)
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/mysql",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-1] => (item=mysql)
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/restore/mysql",
-    "state": "absent"
+    "state": "directory"
 }

--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/restore/mysql",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-1] => (item=restore/mysql)
changed: [EmreKaratopuk-2] => (item=restore/mysql)

TASK [mysql : Create mysql backup user] ****************************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [mysql : Create backup user credentials to access mysql] ******************
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

TASK [mysql : Start mysql and prometheus services] *****************************
ok: [EmreKaratopuk-2] => (item=mysql)
ok: [EmreKaratopuk-1] => (item=mysql)
ok: [EmreKaratopuk-2] => (item=prometheus-mysqld-exporter)
ok: [EmreKaratopuk-1] => (item=prometheus-mysqld-exporter)

TASK [mysql : Create scheduled mysql backup task with cron] ********************
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpj23q_61f/cron-mysql-backup.j2
@@ -0,0 +1,4 @@
+0 20 * * * backup mysqldump agama > /home/backup/mysql/agama.sql
+15 20 * * 0  backup  duplicity --no-encryption full /home/backup/mysql/ rsync://EmreKaratopuk@backup.istikbal.ek/mysql --allow-source-mismatch
+20 20 * * 1-6  backup  duplicity --no-encryption incremental /home/backup/mysql/ rsync://EmreKaratopuk@backup.istikbal.ek/mysql --allow-source-mismatch
+

changed: [EmreKaratopuk-2]
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpqtegk8y2/cron-mysql-backup.j2
@@ -0,0 +1 @@
+

changed: [EmreKaratopuk-1]

TASK [Add mysql A records] *****************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
changed: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)

RUNNING HANDLER [mysql : Reset MySQL source] ***********************************
skipping: [EmreKaratopuk-2] => (item=stopreplica) 
skipping: [EmreKaratopuk-2] => (item=resetprimary) 
ok: [EmreKaratopuk-1] => (item=stopreplica)
changed: [EmreKaratopuk-1] => (item=resetprimary)

RUNNING HANDLER [mysql : Reset MySQL replica] **********************************
skipping: [EmreKaratopuk-1] => (item=stopreplica) 
skipping: [EmreKaratopuk-1] => (item=changeprimary) 
skipping: [EmreKaratopuk-1] => (item=resetreplica) 
skipping: [EmreKaratopuk-1] => (item=startreplica) 
ok: [EmreKaratopuk-2] => (item=stopreplica)
changed: [EmreKaratopuk-2] => (item=changeprimary)
changed: [EmreKaratopuk-2] => (item=resetreplica)
changed: [EmreKaratopuk-2] => (item=startreplica)

RUNNING HANDLER [mysql : Restart mysql-exporter] *******************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

PLAY [influxDB server] *********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Create influxdb directory] ************************************
--- before
+++ after
@@ -1,4 +1,4 @@
 {
     "path": "/opt/influxdb",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-3]

TASK [influxdb : Download influxdb] ********************************************
changed: [EmreKaratopuk-3]

TASK [influxdb : Install influxdb] *********************************************
Selecting previously unselected package influxdb.
(Reading database ... 65679 files and directories currently installed.)
Preparing to unpack .../influxdb_1.8.10_amd64.deb ...
Unpacking influxdb (1.8.10-1) ...
Setting up influxdb (1.8.10-1) ...
Processing triggers for man-db (2.9.1-1) ...
changed: [EmreKaratopuk-3]

TASK [influxdb : Configure influxdb] *******************************************
--- before: /etc/influxdb/influxdb.conf
+++ after: /home/starlord/taltech/ica0002/roles/influxdb/files/influxdb.conf
@@ -25,21 +25,6 @@
   # Where the metadata/raft database is stored
   dir = "/var/lib/influxdb/meta"
 
-  # Automatically create a default retention policy when creating a database.
-  # retention-autocreate = true
-
-  # If log messages are printed for the meta service
-  # logging-enabled = true
-
-###
-### [data]
-###
-### Controls where the actual shard data for InfluxDB lives and how it is
-### flushed from the WAL. "dir" may need to be changed to a suitable place
-### for your system, but the WAL settings are an advanced configuration. The
-### defaults should work for most systems.
-###
-
 [data]
   # The directory where the TSM storage engine stores TSM files.
   dir = "/var/lib/influxdb/data"
@@ -47,100 +32,9 @@
   # The directory where the TSM storage engine stores WAL files.
   wal-dir = "/var/lib/influxdb/wal"
 
-  # The amount of time that a write will wait before fsyncing.  A duration
-  # greater than 0 can be used to batch up multiple fsync calls.  This is useful for slower
-  # disks or when WAL write contention is seen.  A value of 0s fsyncs every write to the WAL.
-  # Values in the range of 0-100ms are recommended for non-SSD disks.
-  # wal-fsync-delay = "0s"
-
-
-  # The type of shard index to use for new shards.  The default is an in-memory index that is
-  # recreated at startup.  A value of "tsi1" will use a disk based index that supports higher
-  # cardinality datasets.
-  # index-version = "inmem"
-
-  # Trace logging provides more verbose output around the tsm engine. Turning
-  # this on can provide more useful output for debugging tsm engine issues.
-  # trace-logging-enabled = false
-
   # Whether queries should be logged before execution. Very useful for troubleshooting, but will
   # log any sensitive data contained within a query.
-  # query-log-enabled = true
-
-  # Provides more error checking. For example, SELECT INTO will err out inserting an +/-Inf value
-  # rather than silently failing.
-  # strict-error-handling = false
-
-  # Validates incoming writes to ensure keys only have valid unicode characters.
-  # This setting will incur a small overhead because every key must be checked.
-  # validate-keys = false
-
-  # Settings for the TSM engine
-
-  # CacheMaxMemorySize is the maximum size a shard's cache can
-  # reach before it starts rejecting writes.
-  # Valid size suffixes are k, m, or g (case insensitive, 1024 = 1k).
-  # Values without a size suffix are in bytes.
-  # cache-max-memory-size = "1g"
-
-  # CacheSnapshotMemorySize is the size at which the engine will
-  # snapshot the cache and write it to a TSM file, freeing up memory
-  # Valid size suffixes are k, m, or g (case insensitive, 1024 = 1k).
-  # Values without a size suffix are in bytes.
-  # cache-snapshot-memory-size = "25m"
-
-  # CacheSnapshotWriteColdDuration is the length of time at
-  # which the engine will snapshot the cache and write it to
-  # a new TSM file if the shard hasn't received writes or deletes
-  # cache-snapshot-write-cold-duration = "10m"
-
-  # CompactFullWriteColdDuration is the duration at which the engine
-  # will compact all TSM files in a shard if it hasn't received a
-  # write or delete
-  # compact-full-write-cold-duration = "4h"
-
-  # The maximum number of concurrent full and level compactions that can run at one time.  A
-  # value of 0 results in 50% of runtime.GOMAXPROCS(0) used at runtime.  Any number greater
-  # than 0 limits compactions to that value.  This setting does not apply
-  # to cache snapshotting.
-  # max-concurrent-compactions = 0
-
-  # CompactThroughput is the rate limit in bytes per second that we
-  # will allow TSM compactions to write to disk. Note that short bursts are allowed
-  # to happen at a possibly larger value, set by CompactThroughputBurst
-  # compact-throughput = "48m"
-
-  # CompactThroughputBurst is the rate limit in bytes per second that we
-  # will allow TSM compactions to write to disk.
-  # compact-throughput-burst = "48m"
-
-  # If true, then the mmap advise value MADV_WILLNEED will be provided to the kernel with respect to
-  # TSM files. This setting has been found to be problematic on some kernels, and defaults to off.
-  # It might help users who have slow disks in some cases.
-  # tsm-use-madv-willneed = false
-
-  # Settings for the inmem index
-
-  # The maximum series allowed per database before writes are dropped.  This limit can prevent
-  # high cardinality issues at the database level.  This limit can be disabled by setting it to
-  # 0.
-  # max-series-per-database = 1000000
-
-  # The maximum number of tag values per tag that are allowed before writes are dropped.  This limit
-  # can prevent high cardinality tag values from being written to a measurement.  This limit can be
-  # disabled by setting it to 0.
-  # max-values-per-tag = 100000
-
-  # Settings for the tsi1 index
-
-  # The threshold, in bytes, when an index write-ahead log file will compact
-  # into an index file. Lower sizes will cause log files to be compacted more
-  # quickly and result in lower heap usage at the expense of write throughput.
-  # Higher sizes will be compacted less frequently, store more series in-memory,
-  # and provide higher write throughput.
-  # Valid size suffixes are k, m, or g (case insensitive, 1024 = 1k).
-  # Values without a size suffix are in bytes.
-  # max-index-log-file-size = "1m"
+  query-log-enabled = false
 
   # The size of the internal cache used in the TSI index to store previously 
   # calculated series results. Cached results will be returned quickly from the cache rather
@@ -152,445 +46,9 @@
   # increase in cache size may lead to an increase in heap usage.
   series-id-set-cache-size = 100
 
-###
-### [coordinator]
-###
-### Controls the clustering service configuration.
-###
-
-[coordinator]
-  # The default time a write request will wait until a "timeout" error is returned to the caller.
-  # write-timeout = "10s"
-
-  # The maximum number of concurrent queries allowed to be executing at one time.  If a query is
-  # executed and exceeds this limit, an error is returned to the caller.  This limit can be disabled
-  # by setting it to 0.
-  # max-concurrent-queries = 0
-
-  # The maximum time a query will is allowed to execute before being killed by the system.  This limit
-  # can help prevent run away queries.  Setting the value to 0 disables the limit.
-  # query-timeout = "0s"
-
-  # The time threshold when a query will be logged as a slow query.  This limit can be set to help
-  # discover slow or resource intensive queries.  Setting the value to 0 disables the slow query logging.
-  # log-queries-after = "0s"
-
-  # The maximum number of points a SELECT can process.  A value of 0 will make
-  # the maximum point count unlimited.  This will only be checked every second so queries will not
-  # be aborted immediately when hitting the limit.
-  # max-select-point = 0
-
-  # The maximum number of series a SELECT can run.  A value of 0 will make the maximum series
-  # count unlimited.
-  # max-select-series = 0
-
-  # The maximum number of group by time bucket a SELECT can create.  A value of zero will max the maximum
-  # number of buckets unlimited.
-  # max-select-buckets = 0
-
-###
-### [retention]
-###
-### Controls the enforcement of retention policies for evicting old data.
-###
-
-[retention]
-  # Determines whether retention policy enforcement enabled.
-  # enabled = true
-
-  # The interval of time when retention policy enforcement checks run.
-  # check-interval = "30m"
-
-###
-### [shard-precreation]
-###
-### Controls the precreation of shards, so they are available before data arrives.
-### Only shards that, after creation, will have both a start- and end-time in the
-### future, will ever be created. Shards are never precreated that would be wholly
-### or partially in the past.
-
-[shard-precreation]
-  # Determines whether shard pre-creation service is enabled.
-  # enabled = true
-
-  # The interval of time when the check to pre-create new shards runs.
-  # check-interval = "10m"
-
-  # The default period ahead of the endtime of a shard group that its successor
-  # group is created.
-  # advance-period = "30m"
-
-###
-### Controls the system self-monitoring, statistics and diagnostics.
-###
-### The internal database for monitoring data is created automatically if
-### if it does not already exist. The target retention within this database
-### is called 'monitor' and is also created with a retention period of 7 days
-### and a replication factor of 1, if it does not exist. In all cases the
-### this retention policy is configured as the default for the database.
-
-[monitor]
-  # Whether to record statistics internally.
-  # store-enabled = true
-
-  # The destination database for recorded statistics
-  # store-database = "_internal"
-
-  # The interval at which to record statistics
-  # store-interval = "10s"
-
-###
-### [http]
-###
-### Controls how the HTTP endpoints are configured. These are the primary
-### mechanism for getting data into and out of InfluxDB.
-###
-
 [http]
-  # Determines whether HTTP endpoint is enabled.
-  # enabled = true
-
-  # Determines whether the Flux query endpoint is enabled.
-  # flux-enabled = false
-
-  # Determines whether the Flux query logging is enabled.
-  # flux-log-enabled = false
-
-  # The bind address used by the HTTP service.
-  # bind-address = ":8086"
-
-  # Determines whether user authentication is enabled over HTTP/HTTPS.
-  # auth-enabled = false
-
-  # The default realm sent back when issuing a basic auth challenge.
-  # realm = "InfluxDB"
-
   # Determines whether HTTP request logging is enabled.
-  # log-enabled = true
-
-  # Determines whether the HTTP write request logs should be suppressed when the log is enabled.
-  # suppress-write-log = false
-
-  # When HTTP request logging is enabled, this option specifies the path where
-  # log entries should be written. If unspecified, the default is to write to stderr, which
-  # intermingles HTTP logs with internal InfluxDB logging.
-  #
-  # If influxd is unable to access the specified path, it will log an error and fall back to writing
-  # the request log to stderr.
-  # access-log-path = ""
-
-  # Filters which requests should be logged. Each filter is of the pattern NNN, NNX, or NXX where N is
-  # a number and X is a wildcard for any number. To filter all 5xx responses, use the string 5xx.
-  # If multiple filters are used, then only one has to match. The default is to have no filters which
-  # will cause every request to be printed.
-  # access-log-status-filters = []
+  log-enabled = false
 
   # Determines whether detailed write logging is enabled.
-  # write-tracing = false
-
-  # Determines whether the pprof endpoint is enabled.  This endpoint is used for
-  # troubleshooting and monitoring.
-  # pprof-enabled = true
-
-  # Enables authentication on pprof endpoints. Users will need admin permissions
-  # to access the pprof endpoints when this setting is enabled. This setting has
-  # no effect if either auth-enabled or pprof-enabled are set to false.
-  # pprof-auth-enabled = false
-
-  # Enables a pprof endpoint that binds to localhost:6060 immediately on startup.
-  # This is only needed to debug startup issues.
-  # debug-pprof-enabled = false
-
-  # Enables authentication on the /ping, /metrics, and deprecated /status
-  # endpoints. This setting has no effect if auth-enabled is set to false.
-  # ping-auth-enabled = false
-
-  # Determines whether HTTPS is enabled.
-  # https-enabled = false
-
-  # The SSL certificate to use when HTTPS is enabled.
-  # https-certificate = "/etc/ssl/influxdb.pem"
-
-  # Use a separate private key location.
-  # https-private-key = ""
-
-  # The JWT auth shared secret to validate requests using JSON web tokens.
-  # shared-secret = ""
-
-  # The default chunk size for result sets that should be chunked.
-  # max-row-limit = 0
-
-  # The maximum number of HTTP connections that may be open at once.  New connections that
-  # would exceed this limit are dropped.  Setting this value to 0 disables the limit.
-  # max-connection-limit = 0
-
-  # Enable http service over unix domain socket
-  # unix-socket-enabled = false
-
-  # The path of the unix domain socket.
-  # bind-socket = "/var/run/influxdb.sock"
-
-  # The maximum size of a client request body, in bytes. Setting this value to 0 disables the limit.
-  # max-body-size = 25000000
-
-  # The maximum number of writes processed concurrently.
-  # Setting this to 0 disables the limit.
-  # max-concurrent-write-limit = 0
-
-  # The maximum number of writes queued for processing.
-  # Setting this to 0 disables the limit.
-  # max-enqueued-write-limit = 0
-
-  # The maximum duration for a write to wait in the queue to be processed.
-  # Setting this to 0 or setting max-concurrent-write-limit to 0 disables the limit.
-  # enqueued-write-timeout = 0
-
-	# User supplied HTTP response headers
-	#
-	# [http.headers]
-	#   X-Header-1 = "Header Value 1"
-	#   X-Header-2 = "Header Value 2"
-
-###
-### [logging]
-###
-### Controls how the logger emits logs to the output.
-###
-
-[logging]
-  # Determines which log encoder to use for logs. Available options
-  # are auto, logfmt, and json. auto will use a more a more user-friendly
-  # output format if the output terminal is a TTY, but the format is not as
-  # easily machine-readable. When the output is a non-TTY, auto will use
-  # logfmt.
-  # format = "auto"
-
-  # Determines which level of logs will be emitted. The available levels
-  # are error, warn, info, and debug. Logs that are equal to or above the
-  # specified level will be emitted.
-  # level = "info"
-
-  # Suppresses the logo output that is printed when the program is started.
-  # The logo is always suppressed if STDOUT is not a TTY.
-  # suppress-logo = false
-
-###
-### [subscriber]
-###
-### Controls the subscriptions, which can be used to fork a copy of all data
-### received by the InfluxDB host.
-###
-
-[subscriber]
-  # Determines whether the subscriber service is enabled.
-  # enabled = true
-
-  # The default timeout for HTTP writes to subscribers.
-  # http-timeout = "30s"
-
-  # Allows insecure HTTPS connections to subscribers.  This is useful when testing with self-
-  # signed certificates.
-  # insecure-skip-verify = false
-
-  # The path to the PEM encoded CA certs file. If the empty string, the default system certs will be used
-  # ca-certs = ""
-
-  # The number of writer goroutines processing the write channel.
-  # write-concurrency = 40
-
-  # The number of in-flight writes buffered in the write channel.
-  # write-buffer-size = 1000
-
-
-###
-### [[graphite]]
-###
-### Controls one or many listeners for Graphite data.
-###
-
-[[graphite]]
-  # Determines whether the graphite endpoint is enabled.
-  # enabled = false
-  # database = "graphite"
-  # retention-policy = ""
-  # bind-address = ":2003"
-  # protocol = "tcp"
-  # consistency-level = "one"
-
-  # These next lines control how batching works. You should have this enabled
-  # otherwise you could get dropped metrics or poor performance. Batching
-  # will buffer points in memory if you have many coming in.
-
-  # Flush if this many points get buffered
-  # batch-size = 5000
-
-  # number of batches that may be pending in memory
-  # batch-pending = 10
-
-  # Flush at least this often even if we haven't hit buffer limit
-  # batch-timeout = "1s"
-
-  # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max.
-  # udp-read-buffer = 0
-
-  ### This string joins multiple matching 'measurement' values providing more control over the final measurement name.
-  # separator = "."
-
-  ### Default tags that will be added to all metrics.  These can be overridden at the template level
-  ### or by tags extracted from metric
-  # tags = ["region=us-east", "zone=1c"]
-
-  ### Each template line requires a template pattern.  It can have an optional
-  ### filter before the template and separated by spaces.  It can also have optional extra
-  ### tags following the template.  Multiple tags should be separated by commas and no spaces
-  ### similar to the line protocol format.  There can be only one default template.
-  # templates = [
-  #   "*.app env.service.resource.measurement",
-  #   # Default template
-  #   "server.*",
-  # ]
-
-###
-### [collectd]
-###
-### Controls one or many listeners for collectd data.
-###
-
-[[collectd]]
-  # enabled = false
-  # bind-address = ":25826"
-  # database = "collectd"
-  # retention-policy = ""
-  #
-  # The collectd service supports either scanning a directory for multiple types
-  # db files, or specifying a single db file.
-  # typesdb = "/usr/local/share/collectd"
-  #
-  # security-level = "none"
-  # auth-file = "/etc/collectd/auth_file"
-
-  # These next lines control how batching works. You should have this enabled
-  # otherwise you could get dropped metrics or poor performance. Batching
-  # will buffer points in memory if you have many coming in.
-
-  # Flush if this many points get buffered
-  # batch-size = 5000
-
-  # Number of batches that may be pending in memory
-  # batch-pending = 10
-
-  # Flush at least this often even if we haven't hit buffer limit
-  # batch-timeout = "10s"
-
-  # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max.
-  # read-buffer = 0
-
-  # Multi-value plugins can be handled two ways.
-  # "split" will parse and store the multi-value plugin data into separate measurements
-  # "join" will parse and store the multi-value plugin as a single multi-value measurement.
-  # "split" is the default behavior for backward compatibility with previous versions of influxdb.
-  # parse-multivalue-plugin = "split"
-###
-### [opentsdb]
-###
-### Controls one or many listeners for OpenTSDB data.
-###
-
-[[opentsdb]]
-  # enabled = false
-  # bind-address = ":4242"
-  # database = "opentsdb"
-  # retention-policy = ""
-  # consistency-level = "one"
-  # tls-enabled = false
-  # certificate= "/etc/ssl/influxdb.pem"
-
-  # Log an error for every malformed point.
-  # log-point-errors = true
-
-  # These next lines control how batching works. You should have this enabled
-  # otherwise you could get dropped metrics or poor performance. Only points
-  # metrics received over the telnet protocol undergo batching.
-
-  # Flush if this many points get buffered
-  # batch-size = 1000
-
-  # Number of batches that may be pending in memory
-  # batch-pending = 5
-
-  # Flush at least this often even if we haven't hit buffer limit
-  # batch-timeout = "1s"
-
-###
-### [[udp]]
-###
-### Controls the listeners for InfluxDB line protocol data via UDP.
-###
-
-[[udp]]
-  # enabled = false
-  # bind-address = ":8089"
-  # database = "udp"
-  # retention-policy = ""
-
-  # InfluxDB precision for timestamps on received points ("" or "n", "u", "ms", "s", "m", "h")
-  # precision = ""
-
-  # These next lines control how batching works. You should have this enabled
-  # otherwise you could get dropped metrics or poor performance. Batching
-  # will buffer points in memory if you have many coming in.
-
-  # Flush if this many points get buffered
-  # batch-size = 5000
-
-  # Number of batches that may be pending in memory
-  # batch-pending = 10
-
-  # Will flush at least this often even if we haven't hit buffer limit
-  # batch-timeout = "1s"
-
-  # UDP Read buffer size, 0 means OS default. UDP listener will fail if set above OS max.
-  # read-buffer = 0
-
-###
-### [continuous_queries]
-###
-### Controls how continuous queries are run within InfluxDB.
-###
-
-[continuous_queries]
-  # Determines whether the continuous query service is enabled.
-  # enabled = true
-
-  # Controls whether queries are logged when executed by the CQ service.
-  # log-enabled = true
-
-  # Controls whether queries are logged to the self-monitoring data store.
-  # query-stats-enabled = false
-
-  # interval for how often continuous queries will be checked if they need to run
-  # run-interval = "1s"
-
-###
-### [tls]
-###
-### Global configuration settings for TLS in InfluxDB.
-###
-
-[tls]
-  # Determines the available set of cipher suites. See https://golang.org/pkg/crypto/tls/#pkg-constants
-  # for a list of available ciphers, which depends on the version of Go (use the query
-  # SHOW DIAGNOSTICS to see the version of Go used to build InfluxDB). If not specified, uses
-  # the default settings from Go's crypto/tls package.
-  # ciphers = [
-  #   "TLS_ECDHE_ECDSA_WITH_CHACHA20_POLY1305",
-  #   "TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305",
-  # ]
-
-  # Minimum version of the tls protocol that will be negotiated. If not specified, uses the
-  # default settings from Go's crypto/tls package.
-  # min-version = "tls1.2"
-
-  # Maximum version of the tls protocol that will be negotiated. If not specified, uses the
-  # default settings from Go's crypto/tls package.
-  # max-version = "tls1.3"
+  write-tracing = false

changed: [EmreKaratopuk-3]

TASK [influxdb : Activate influxdb] ********************************************
changed: [EmreKaratopuk-3]

TASK [influxdb : Get telegraf key] *********************************************
changed: [EmreKaratopuk-3]

TASK [influxdb : Get telegraf source with apt] *********************************
--- before: /dev/null
+++ after: /etc/apt/sources.list.d/influxdata.list.list
@@ -0,0 +1 @@
+deb [signed-by=/etc/apt/trusted.gpg.d/influxdata-archive_compat.gpg] https://repos.influxdata.com/debian stable main

changed: [EmreKaratopuk-3]

TASK [influxdb : Install telegraf from source] *********************************
The following NEW packages will be installed:
  telegraf
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-3]

TASK [influxdb : Configure telegraf] *******************************************
diff skipped: destination file size is greater than 104448
changed: [EmreKaratopuk-3]

TASK [influxdb : Download influxdb exporter] ***********************************
changed: [EmreKaratopuk-3]

TASK [influxdb : Create influxdb-exporter service] *****************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/influxdb/files/influxdb-stats-exporter.service
@@ -0,0 +1,10 @@
+[Unit]
+Description=Send InfluxDB logs to Prometheus
+After=network-online.target
+
+[Service]
+User=prometheus
+ExecStart=/usr/local/bin/influx_stats_exporter
+
+[Install]
+WantedBy=multi-user.target
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [influxdb : Restart systemctl daemon] *************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Start prometheus-influxdb-stats-exporter and telegraf] ********
changed: [EmreKaratopuk-3] => (item=prometheus-influxdb-stats-exporter.service)
changed: [EmreKaratopuk-3] => (item=telegraf.service)

TASK [influxdb : Create backup and restore directories for influxdb] ***********
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/influxdb",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-3] => (item=influxdb)
--- before
+++ after
@@ -1,7 +1,7 @@
 {
-    "group": 0,
-    "mode": "0755",
-    "owner": 0,
+    "group": 34,
+    "mode": "0777",
+    "owner": 34,
     "path": "/home/backup/restore/influxdb",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-3] => (item=restore/influxdb)

TASK [influxdb : Create scheduled influxdb backup task with cron] **************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/influxdb/files/cron-influxdb-backup
@@ -0,0 +1,3 @@
+0 21 * * * backup rm -rf /home/backup/influxdb/*; influxd backup -portable -database telegraf /home/backup/influxdb
+15 21 * * 0  backup  duplicity --no-encryption full /home/backup/influxdb/ rsync://EmreKaratopuk@backup.istikbal.ek/influxdb
+20 21 * * 1-6  backup  duplicity --no-encryption incremental /home/backup/influxdb/ rsync://EmreKaratopuk@backup.istikbal.ek/influxdb

changed: [EmreKaratopuk-3]

TASK [Add influxdb A record] ***************************************************

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

RUNNING HANDLER [influxdb : Restart influxdb] **********************************
changed: [EmreKaratopuk-3]

RUNNING HANDLER [influxdb : Restart telegraf] **********************************
changed: [EmreKaratopuk-3]

PLAY [Docker server] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [docker : Install docker] *************************************************
The following additional packages will be installed:
  bridge-utils containerd dnsmasq-base libidn11 pigz python3-websocket runc
  ubuntu-fan
Suggested packages:
  ifupdown aufs-tools cgroupfs-mount | cgroup-lite debootstrap docker-doc
  rinse zfs-fuse | zfsutils
The following NEW packages will be installed:
  bridge-utils containerd dnsmasq-base docker.io libidn11 pigz python3-docker
  python3-websocket runc ubuntu-fan
0 upgraded, 10 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]
The following additional packages will be installed:
  bridge-utils containerd dnsmasq-base libidn11 pigz python3-websocket runc
  ubuntu-fan
Suggested packages:
  ifupdown aufs-tools cgroupfs-mount | cgroup-lite debootstrap docker-doc
  rinse zfs-fuse | zfsutils
The following NEW packages will be installed:
  bridge-utils containerd dnsmasq-base docker.io libidn11 pigz python3-docker
  python3-websocket runc ubuntu-fan
0 upgraded, 10 newly installed, 0 to remove and 263 not upgraded.
changed: [EmreKaratopuk-3]
The following additional packages will be installed:
  bridge-utils containerd dnsmasq-base libidn11 pigz python3-websocket runc
  ubuntu-fan
Suggested packages:
  ifupdown aufs-tools cgroupfs-mount | cgroup-lite debootstrap docker-doc
  rinse zfs-fuse | zfsutils
The following NEW packages will be installed:
  bridge-utils containerd dnsmasq-base docker.io libidn11 pigz python3-docker
  python3-websocket runc ubuntu-fan
0 upgraded, 10 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]

TASK [docker : Start docker] ***************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]

PLAY [Pinger server] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Install fping] **************************************************
The following NEW packages will be installed:
  fping
0 upgraded, 1 newly installed, 0 to remove and 263 not upgraded.
changed: [EmreKaratopuk-3]

TASK [pinger : Create pinger user] *********************************************
changed: [EmreKaratopuk-3]

TASK [pinger : Add pinger source code] *****************************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/pinger/files/pinger.sh
@@ -0,0 +1,26 @@
+#!/bin/bash
+
+# Script contains several (more than 1) security issues.
+# Find them and fix them to get bonus on exam.
+# Problem example: SQL injection.
+
+for t in database_url database_name targets; do
+  if ! grep -q "^${t}=" /etc/pinger/pinger.conf; then
+    logger "$0 Failed to get $t from config"
+    exit 1
+  fi
+done
+
+which fping > /dev/null || (logger "fping not found"; exit 1)
+
+db_url=$(grep "^database_url=" /etc/pinger/pinger.conf | sed 's/^.*=//')
+db_name=$(grep "^database_name=" /etc/pinger/pinger.conf | sed 's/^.*=//')
+targets=$(grep "^targets=" /etc/pinger/pinger.conf | sed 's/^.*=//' | sed 's/\(,\|;\)/ /g')
+
+curl -i -XPOST "${db_url}/query" --data-urlencode "q=CREATE DATABASE $db_name" 1>/dev/null 2>/dev/null
+
+while true; do
+  result=$(fping -C1 -q $targets 2>&1 | awk '{print "rtt,dst="$1" rtt="$3}')
+  curl -i -XPOST "${db_url}/write?db=$db_name" --data-binary "$result" 1>/dev/null 2>/dev/null
+ sleep 1
+done
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [pinger : Add pinger service] *********************************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/pinger/files/pinger.service
@@ -0,0 +1,10 @@
+[Unit]
+Description=A monitoring service for network health
+After=network-online.target
+
+[Service]
+User=pinger
+ExecStart=/usr/local/bin/pinger
+
+[Install]
+WantedBy=multi-user.target
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [pinger : Restart systemctl daemon] ***************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Create pinger folder] *******************************************
--- before
+++ after
@@ -1,4 +1,4 @@
 {
     "path": "/etc/pinger",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-3]

TASK [pinger : Add pinger conf] ************************************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/pinger/files/pinger.conf
@@ -0,0 +1,3 @@
+database_url=localhost:8086
+database_name=pingResults
+targets=EmreKaratopuk-1, EmreKaratopuk-2, google.com
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [pinger : Start pinger] ***************************************************
changed: [EmreKaratopuk-3]

RUNNING HANDLER [pinger : Restart pinger] **************************************
changed: [EmreKaratopuk-3]

PLAY [Grafana server] **********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [grafana : Install Grafana via Docker] ************************************
--- before
+++ after
@@ -1,4 +1,4 @@
 {
-    "exists": false,
-    "running": false
+    "exists": true,
+    "running": true
 }

changed: [EmreKaratopuk-3]

TASK [grafana : Create volume directories] *************************************
--- before
+++ after
@@ -1,4 +1,4 @@
 {
     "path": "/opt/grafana/provisioning/dashboards",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-3] => (item=dashboards)
--- before
+++ after
@@ -1,4 +1,4 @@
 {
     "path": "/opt/grafana/provisioning/datasources",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-3] => (item=datasources)

TASK [grafana : Copy grafana configs to volume] ********************************
changed: [EmreKaratopuk-3]

TASK [grafana : Copy dashboards config to volume] ******************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/grafana/files/dashboards.yaml
@@ -0,0 +1,11 @@
+# # config file version
+apiVersion: 1
+
+providers:
+- name: 'default'
+  orgId: 1
+  folder: ''
+  folderUid: ''
+  type: file
+  options:
+    path: /etc/grafana/provisioning/dashboards
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [grafana : Copy datasources config to volume] *****************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/grafana/files/dataSources.yaml
@@ -0,0 +1,27 @@
+# # config file version
+apiVersion: 1
+
+datasources:
+- name: Prometheus
+  type: prometheus
+  access: proxy
+  orgId: 1
+  url: http://prometheus:9090/prometheus/
+  version: 1
+  editable: false
+
+- name: InfluxDB-pinger
+  type: influxdb
+  access: proxy
+  url: http://influxdb:8086
+  jsonData:
+    dbName: pingResults
+    httpMode: GET
+
+- name: InfluxDB-telegraf
+  type: influxdb
+  access: proxy
+  url: http://influxdb:8086
+  jsonData:
+    dbName: telegraf
+    httpMode: GET
\ No newline at end of file

changed: [EmreKaratopuk-3]

TASK [grafana : Copy all dashboards to volume] *********************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/grafana/files/main.json
@@ -0,0 +1,1725 @@
+{
+  "annotations": {
+    "list": [
+      {
+        "builtIn": 1,
+        "datasource": {
+          "type": "grafana",
+          "uid": "-- Grafana --"
+        },
+        "enable": true,
+        "hide": true,
+        "iconColor": "rgba(0, 211, 255, 1)",
+        "name": "Annotations & Alerts",
+        "type": "dashboard"
+      }
+    ]
+  },
+  "editable": true,
+  "fiscalYearStartMonth": 0,
+  "graphTooltip": 0,
+  "links": [],
+  "liveNow": false,
+  "panels": [
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [],
+          "max": 100,
+          "min": 0,
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 4,
+        "w": 5,
+        "x": 0,
+        "y": 0
+      },
+      "id": 1,
+      "options": {
+        "minVizHeight": 75,
+        "minVizWidth": 75,
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "showThresholdLabels": false,
+        "showThresholdMarkers": true,
+        "sizing": "auto"
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "(1 - avg(irate(node_cpu_seconds_total{mode=\"idle\", job=\"linux\"}[10m])) by (instance)) * 100",
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A"
+        }
+      ],
+      "title": "CPU Load",
+      "type": "gauge"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "fieldMinMax": true,
+          "mappings": [],
+          "max": 100,
+          "min": 0,
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 4,
+        "w": 5,
+        "x": 5,
+        "y": 0
+      },
+      "id": 2,
+      "options": {
+        "minVizHeight": 75,
+        "minVizWidth": 75,
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "showThresholdLabels": false,
+        "showThresholdMarkers": true,
+        "sizing": "auto"
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "100 * (1 - ((avg_over_time(node_memory_MemFree_bytes{job=\"linux\"}[10m]) + avg_over_time(node_memory_Cached_bytes{job=\"linux\"}[10m]) + avg_over_time(node_memory_Buffers_bytes{job=\"linux\"}[10m])) / avg_over_time(node_memory_MemTotal_bytes{job=\"linux\"}[10m])))",
+          "instant": false,
+          "legendFormat": "{{instance}}",
+          "range": true,
+          "refId": "A"
+        }
+      ],
+      "title": "Memory Consumption",
+      "type": "gauge"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 6,
+        "x": 10,
+        "y": 0
+      },
+      "id": 4,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "none",
+        "justifyMode": "auto",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "builder",
+          "expr": "bind_up",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "Bind9 Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 4,
+        "x": 16,
+        "y": 0
+      },
+      "id": 8,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "auto",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "mysql_up",
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A"
+        }
+      ],
+      "title": "MySQL Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 4,
+        "x": 20,
+        "y": 0
+      },
+      "id": 11,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "auto",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "nginx_up",
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A"
+        }
+      ],
+      "title": "Nginx Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 2,
+        "x": 10,
+        "y": 3
+      },
+      "id": 15,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "center",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "builder",
+          "expr": "haproxy_up{instance=\"EmreKaratopuk-1:9101\"}",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "HAProxy 1 Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 2,
+        "x": 12,
+        "y": 3
+      },
+      "id": 20,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "center",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "code",
+          "expr": "keepalived_up{instance=\"EmreKaratopuk-1:9165\"}",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "Keepalived 1 Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "yellow",
+                  "index": 0,
+                  "text": "Init"
+                },
+                "1": {
+                  "color": "orange",
+                  "index": 1,
+                  "text": "Backup"
+                },
+                "2": {
+                  "color": "green",
+                  "index": 2,
+                  "text": "Master"
+                },
+                "3": {
+                  "color": "red",
+                  "index": 3,
+                  "text": "Fault"
+                }
+              },
+              "type": "value"
+            },
+            {
+              "options": {
+                "match": "null+nan",
+                "result": {
+                  "color": "red",
+                  "index": 4,
+                  "text": "No Data"
+                }
+              },
+              "type": "special"
+            }
+          ],
+          "max": 3,
+          "min": 0,
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 2,
+        "x": 14,
+        "y": 3
+      },
+      "hideTimeOverride": true,
+      "id": 17,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "auto",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "builder",
+          "expr": "keepalived_vrrp_state{instance=\"EmreKaratopuk-1:9165\"}",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "timeFrom": "5s",
+      "title": "Keepalived 1 VRRP State ",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 2,
+        "x": 16,
+        "y": 3
+      },
+      "id": 19,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "center",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "builder",
+          "expr": "haproxy_up{instance=\"EmreKaratopuk-2:9101\"}",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "HAProxy 2 Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 2,
+        "x": 18,
+        "y": 3
+      },
+      "id": 21,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "center",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "code",
+          "expr": "keepalived_up{instance=\"EmreKaratopuk-2:9165\"}",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "Keepalived 2 Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "yellow",
+                  "index": 0,
+                  "text": "Init"
+                },
+                "1": {
+                  "color": "orange",
+                  "index": 1,
+                  "text": "Backup"
+                },
+                "2": {
+                  "color": "green",
+                  "index": 2,
+                  "text": "Master"
+                },
+                "3": {
+                  "color": "red",
+                  "index": 3,
+                  "text": "Fault"
+                }
+              },
+              "type": "value"
+            },
+            {
+              "options": {
+                "match": "null+nan",
+                "result": {
+                  "color": "red",
+                  "index": 4,
+                  "text": "No Data"
+                }
+              },
+              "type": "special"
+            }
+          ],
+          "max": 3,
+          "min": 0,
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 2,
+        "x": 20,
+        "y": 3
+      },
+      "hideTimeOverride": true,
+      "id": 18,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "auto",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "builder",
+          "expr": "keepalived_vrrp_state{instance=\"EmreKaratopuk-2:9165\"}",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "timeFrom": "5s",
+      "title": "Keepalived 2 VRRP State ",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "description": "",
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 2,
+        "x": 22,
+        "y": 3
+      },
+      "id": 13,
+      "options": {
+        "colorMode": "value",
+        "graphMode": "area",
+        "justifyMode": "auto",
+        "orientation": "auto",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "auto",
+        "wideLayout": true
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "influxdb_exporter_stats_query_success",
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A"
+        }
+      ],
+      "title": "InfluxDB health",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "palette-classic"
+          },
+          "custom": {
+            "axisBorderShow": true,
+            "axisCenteredZero": false,
+            "axisColorMode": "text",
+            "axisLabel": "",
+            "axisPlacement": "auto",
+            "barAlignment": 0,
+            "drawStyle": "line",
+            "fillOpacity": 0,
+            "gradientMode": "none",
+            "hideFrom": {
+              "legend": false,
+              "tooltip": false,
+              "viz": false
+            },
+            "insertNulls": false,
+            "lineInterpolation": "linear",
+            "lineWidth": 1,
+            "pointSize": 5,
+            "scaleDistribution": {
+              "type": "linear"
+            },
+            "showPoints": "auto",
+            "spanNulls": false,
+            "stacking": {
+              "group": "A",
+              "mode": "none"
+            },
+            "thresholdsStyle": {
+              "mode": "off"
+            }
+          },
+          "mappings": [],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 5,
+        "w": 10,
+        "x": 0,
+        "y": 4
+      },
+      "id": 12,
+      "options": {
+        "legend": {
+          "calcs": [],
+          "displayMode": "list",
+          "placement": "bottom",
+          "showLegend": true
+        },
+        "tooltip": {
+          "mode": "single",
+          "sort": "none"
+        }
+      },
+      "pluginVersion": "10.2.0",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "idelta(nginx_http_requests_total[1m])",
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A"
+        }
+      ],
+      "title": "HTTP Requests ",
+      "type": "timeseries"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            },
+            {
+              "options": {
+                "match": "null+nan",
+                "result": {
+                  "color": "red",
+                  "index": 2,
+                  "text": "No Data"
+                }
+              },
+              "type": "special"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 14,
+        "x": 10,
+        "y": 6
+      },
+      "hideTimeOverride": true,
+      "id": 16,
+      "options": {
+        "colorMode": "background",
+        "graphMode": "none",
+        "justifyMode": "auto",
+        "orientation": "vertical",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "value_and_name",
+        "wideLayout": false
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "haproxy_server_up{instance=\"EmreKaratopuk-1:9101\"}",
+          "hide": false,
+          "instant": false,
+          "legendFormat": "{{ instance }}, {{ server }}",
+          "range": true,
+          "refId": "A"
+        },
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "haproxy_server_up{instance=\"EmreKaratopuk-1:9101\", server=\"docker2\"} or on() vector(0)",
+          "hide": true,
+          "instant": false,
+          "legendFormat": "{{ instance }}, {{ server }}",
+          "range": true,
+          "refId": "B"
+        },
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "haproxy_server_up{instance=\"EmreKaratopuk-2:9101\", server=\"docker1\"} or on() vector(0)",
+          "hide": true,
+          "instant": false,
+          "legendFormat": "{{ instance }}, {{ server }}",
+          "range": true,
+          "refId": "C"
+        },
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "haproxy_server_up{instance=\"EmreKaratopuk-2:9101\", server=\"docker2\"} or on() vector(0)",
+          "hide": true,
+          "instant": false,
+          "legendFormat": "{{ instance }}, {{ server }}",
+          "range": true,
+          "refId": "D"
+        }
+      ],
+      "timeFrom": "5s",
+      "title": "HAProxy 1 Container Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "palette-classic"
+          },
+          "custom": {
+            "axisBorderShow": true,
+            "axisCenteredZero": false,
+            "axisColorMode": "text",
+            "axisLabel": "",
+            "axisPlacement": "auto",
+            "barAlignment": 0,
+            "drawStyle": "line",
+            "fillOpacity": 0,
+            "gradientMode": "none",
+            "hideFrom": {
+              "legend": false,
+              "tooltip": false,
+              "viz": false
+            },
+            "insertNulls": false,
+            "lineInterpolation": "linear",
+            "lineStyle": {
+              "fill": "solid"
+            },
+            "lineWidth": 1,
+            "pointSize": 5,
+            "scaleDistribution": {
+              "type": "linear"
+            },
+            "showPoints": "auto",
+            "spanNulls": false,
+            "stacking": {
+              "group": "A",
+              "mode": "none"
+            },
+            "thresholdsStyle": {
+              "mode": "off"
+            }
+          },
+          "mappings": [],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 5,
+        "w": 10,
+        "x": 0,
+        "y": 9
+      },
+      "id": 9,
+      "options": {
+        "legend": {
+          "calcs": [],
+          "displayMode": "list",
+          "placement": "bottom",
+          "showLegend": true
+        },
+        "tooltip": {
+          "mode": "single",
+          "sort": "none"
+        }
+      },
+      "pluginVersion": "10.2.0",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "builder",
+          "expr": "idelta(mysql_global_status_commands_total{command=\"select\"}[1m])",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "SELECT Queries ",
+      "type": "timeseries"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "thresholds"
+          },
+          "mappings": [
+            {
+              "options": {
+                "0": {
+                  "color": "red",
+                  "index": 1,
+                  "text": "DOWN"
+                },
+                "1": {
+                  "color": "green",
+                  "index": 0,
+                  "text": "UP"
+                }
+              },
+              "type": "value"
+            },
+            {
+              "options": {
+                "match": "null+nan",
+                "result": {
+                  "color": "red",
+                  "index": 2,
+                  "text": "No Data"
+                }
+              },
+              "type": "special"
+            }
+          ],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 3,
+        "w": 14,
+        "x": 10,
+        "y": 9
+      },
+      "hideTimeOverride": true,
+      "id": 23,
+      "options": {
+        "colorMode": "background",
+        "graphMode": "none",
+        "justifyMode": "auto",
+        "orientation": "vertical",
+        "reduceOptions": {
+          "calcs": [
+            "lastNotNull"
+          ],
+          "fields": "",
+          "values": false
+        },
+        "textMode": "value_and_name",
+        "wideLayout": false
+      },
+      "pluginVersion": "10.2.3",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "editorMode": "code",
+          "expr": "haproxy_server_up{instance=\"EmreKaratopuk-2:9101\"}",
+          "hide": false,
+          "instant": false,
+          "legendFormat": "{{ instance }}, {{ server }}",
+          "range": true,
+          "refId": "A"
+        }
+      ],
+      "timeFrom": "5s",
+      "title": "HAProxy 2 Container Status",
+      "type": "stat"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "palette-classic"
+          },
+          "custom": {
+            "axisBorderShow": true,
+            "axisCenteredZero": false,
+            "axisColorMode": "text",
+            "axisLabel": "",
+            "axisPlacement": "auto",
+            "barAlignment": 0,
+            "drawStyle": "line",
+            "fillOpacity": 0,
+            "gradientMode": "none",
+            "hideFrom": {
+              "legend": false,
+              "tooltip": false,
+              "viz": false
+            },
+            "insertNulls": false,
+            "lineInterpolation": "linear",
+            "lineStyle": {
+              "fill": "solid"
+            },
+            "lineWidth": 1,
+            "pointSize": 5,
+            "scaleDistribution": {
+              "type": "linear"
+            },
+            "showPoints": "auto",
+            "spanNulls": false,
+            "stacking": {
+              "group": "A",
+              "mode": "none"
+            },
+            "thresholdsStyle": {
+              "mode": "off"
+            }
+          },
+          "fieldMinMax": false,
+          "mappings": [],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 6,
+        "w": 14,
+        "x": 10,
+        "y": 12
+      },
+      "id": 6,
+      "options": {
+        "legend": {
+          "calcs": [],
+          "displayMode": "list",
+          "placement": "bottom",
+          "showLegend": true
+        },
+        "tooltip": {
+          "mode": "single",
+          "sort": "none"
+        }
+      },
+      "pluginVersion": "10.2.0",
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "builder",
+          "exemplar": false,
+          "expr": "idelta(bind_resolver_queries_total[1m])",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "DNS Queries ",
+      "type": "timeseries"
+    },
+    {
+      "datasource": {
+        "type": "prometheus",
+        "uid": "PBFA97CFB590B2093"
+      },
+      "fieldConfig": {
+        "defaults": {
+          "color": {
+            "mode": "palette-classic"
+          },
+          "custom": {
+            "axisBorderShow": true,
+            "axisCenteredZero": false,
+            "axisColorMode": "text",
+            "axisLabel": "",
+            "axisPlacement": "auto",
+            "barAlignment": 0,
+            "drawStyle": "line",
+            "fillOpacity": 0,
+            "gradientMode": "none",
+            "hideFrom": {
+              "legend": false,
+              "tooltip": false,
+              "viz": false
+            },
+            "insertNulls": false,
+            "lineInterpolation": "linear",
+            "lineWidth": 1,
+            "pointSize": 5,
+            "scaleDistribution": {
+              "type": "linear"
+            },
+            "showPoints": "auto",
+            "spanNulls": false,
+            "stacking": {
+              "group": "A",
+              "mode": "none"
+            },
+            "thresholdsStyle": {
+              "mode": "off"
+            }
+          },
+          "mappings": [],
+          "thresholds": {
+            "mode": "absolute",
+            "steps": [
+              {
+                "color": "green",
+                "value": null
+              },
+              {
+                "color": "red",
+                "value": 80
+              }
+            ]
+          }
+        },
+        "overrides": []
+      },
+      "gridPos": {
+        "h": 4,
+        "w": 10,
+        "x": 0,
+        "y": 14
+      },
+      "id": 14,
+      "options": {
+        "legend": {
+          "calcs": [],
+          "displayMode": "list",
+          "placement": "bottom",
+          "showLegend": true
+        },
+        "tooltip": {
+          "mode": "single",
+          "sort": "none"
+        }
+      },
+      "targets": [
+        {
+          "datasource": {
+            "type": "prometheus",
+            "uid": "PBFA97CFB590B2093"
+          },
+          "disableTextWrap": false,
+          "editorMode": "code",
+          "expr": "idelta(influxdb_write_write_ok[5m])",
+          "fullMetaSearch": false,
+          "includeNullMetadata": true,
+          "instant": false,
+          "legendFormat": "__auto",
+          "range": true,
+          "refId": "A",
+          "useBackend": false
+        }
+      ],
+      "title": "InfluxDB write rate",
+      "type": "timeseries"
+    }
+  ],
+  "refresh": "5s",
+  "schemaVersion": 39,
+  "tags": [],
+  "templating": {
+    "list": []
+  },
+  "time": {
+    "from": "now-5m",
+    "to": "now"
+  },
+  "timepicker": {},
+  "timezone": "",
+  "title": "Main",
+  "uid": "ef169fee-1fc6-49f8-a1d0-84a6819b8613",
+  "version": 1,
+  "weekStart": ""
+}
\ No newline at end of file

changed: [EmreKaratopuk-3] => (item=main.json)
--- before
+++ after: /home/starlord/taltech/ica0002/roles/grafana/files/mysql.json
@@ -0,0 +1,428 @@
+{
+    "annotations": {
+      "list": [
+        {
+          "builtIn": 1,
+          "datasource": {
+            "type": "grafana",
+            "uid": "-- Grafana --"
+          },
+          "enable": true,
+          "hide": true,
+          "iconColor": "rgba(0, 211, 255, 1)",
+          "name": "Annotations & Alerts",
+          "type": "dashboard"
+        }
+      ]
+    },
+    "editable": true,
+    "fiscalYearStartMonth": 0,
+    "graphTooltip": 0,
+    "id": 3,
+    "links": [],
+    "liveNow": false,
+    "panels": [
+      {
+        "datasource": {
+          "type": "prometheus",
+          "uid": "PBFA97CFB590B2093"
+        },
+        "fieldConfig": {
+          "defaults": {
+            "color": {
+              "mode": "thresholds"
+            },
+            "mappings": [],
+            "thresholds": {
+              "mode": "absolute",
+              "steps": [
+                {
+                  "color": "green",
+                  "value": null
+                },
+                {
+                  "color": "red",
+                  "value": 80
+                }
+              ]
+            }
+          },
+          "overrides": []
+        },
+        "gridPos": {
+          "h": 8,
+          "w": 6,
+          "x": 0,
+          "y": 0
+        },
+        "id": 5,
+        "options": {
+          "colorMode": "value",
+          "graphMode": "area",
+          "justifyMode": "center",
+          "orientation": "auto",
+          "reduceOptions": {
+            "calcs": [
+              "lastNotNull"
+            ],
+            "fields": "",
+            "values": false
+          },
+          "textMode": "auto",
+          "wideLayout": true
+        },
+        "pluginVersion": "10.2.2",
+        "targets": [
+          {
+            "datasource": {
+              "type": "prometheus",
+              "uid": "PBFA97CFB590B2093"
+            },
+            "editorMode": "code",
+            "expr": "mysql_up",
+            "instant": false,
+            "legendFormat": "__auto",
+            "range": true,
+            "refId": "A"
+          }
+        ],
+        "title": "MySQL Status",
+        "type": "stat"
+      },
+      {
+        "datasource": {
+          "type": "prometheus",
+          "uid": "PBFA97CFB590B2093"
+        },
+        "fieldConfig": {
+          "defaults": {
+            "color": {
+              "mode": "thresholds"
+            },
+            "mappings": [],
+            "thresholds": {
+              "mode": "absolute",
+              "steps": [
+                {
+                  "color": "green",
+                  "value": null
+                }
+              ]
+            }
+          },
+          "overrides": []
+        },
+        "gridPos": {
+          "h": 8,
+          "w": 6,
+          "x": 6,
+          "y": 0
+        },
+        "id": 1,
+        "options": {
+          "colorMode": "value",
+          "graphMode": "none",
+          "justifyMode": "center",
+          "orientation": "auto",
+          "reduceOptions": {
+            "calcs": [
+              "lastNotNull"
+            ],
+            "fields": "",
+            "values": false
+          },
+          "textMode": "auto",
+          "wideLayout": true
+        },
+        "pluginVersion": "10.2.2",
+        "targets": [
+          {
+            "datasource": {
+              "type": "prometheus",
+              "uid": "PBFA97CFB590B2093"
+            },
+            "editorMode": "code",
+            "expr": "mysql_global_variables_server_id",
+            "instant": false,
+            "legendFormat": "__auto",
+            "range": true,
+            "refId": "A"
+          }
+        ],
+        "title": "MySQL id",
+        "type": "stat"
+      },
+      {
+        "datasource": {
+          "type": "prometheus",
+          "uid": "PBFA97CFB590B2093"
+        },
+        "description": "",
+        "fieldConfig": {
+          "defaults": {
+            "color": {
+              "mode": "thresholds"
+            },
+            "mappings": [
+              {
+                "options": {
+                  "0": {
+                    "index": 0,
+                    "text": "Read/Write"
+                  },
+                  "1": {
+                    "index": 1,
+                    "text": "Read only"
+                  }
+                },
+                "type": "value"
+              }
+            ],
+            "thresholds": {
+              "mode": "absolute",
+              "steps": [
+                {
+                  "color": "green",
+                  "value": null
+                },
+                {
+                  "color": "red",
+                  "value": 80
+                }
+              ]
+            }
+          },
+          "overrides": []
+        },
+        "gridPos": {
+          "h": 8,
+          "w": 12,
+          "x": 12,
+          "y": 0
+        },
+        "id": 2,
+        "options": {
+          "colorMode": "value",
+          "graphMode": "area",
+          "justifyMode": "auto",
+          "orientation": "auto",
+          "reduceOptions": {
+            "calcs": [
+              "lastNotNull"
+            ],
+            "fields": "",
+            "values": false
+          },
+          "textMode": "auto",
+          "wideLayout": true
+        },
+        "pluginVersion": "10.2.2",
+        "targets": [
+          {
+            "datasource": {
+              "type": "prometheus",
+              "uid": "PBFA97CFB590B2093"
+            },
+            "editorMode": "code",
+            "expr": "mysql_global_variables_read_only",
+            "instant": false,
+            "legendFormat": "__auto",
+            "range": true,
+            "refId": "A"
+          }
+        ],
+        "title": "MySQL Server Mode",
+        "type": "stat"
+      },
+      {
+        "datasource": {
+          "type": "prometheus",
+          "uid": "PBFA97CFB590B2093"
+        },
+        "description": "",
+        "fieldConfig": {
+          "defaults": {
+            "color": {
+              "mode": "thresholds"
+            },
+            "mappings": [
+              {
+                "options": {
+                  "0": {
+                    "color": "blue",
+                    "index": 1,
+                    "text": "Stopped"
+                  },
+                  "1": {
+                    "color": "blue",
+                    "index": 0,
+                    "text": "Running"
+                  }
+                },
+                "type": "value"
+              }
+            ],
+            "thresholds": {
+              "mode": "absolute",
+              "steps": [
+                {
+                  "color": "green",
+                  "value": null
+                },
+                {
+                  "color": "red",
+                  "value": 80
+                }
+              ]
+            }
+          },
+          "overrides": []
+        },
+        "gridPos": {
+          "h": 8,
+          "w": 12,
+          "x": 0,
+          "y": 8
+        },
+        "id": 4,
+        "options": {
+          "colorMode": "value",
+          "graphMode": "area",
+          "justifyMode": "auto",
+          "orientation": "auto",
+          "reduceOptions": {
+            "calcs": [
+              "lastNotNull"
+            ],
+            "fields": "",
+            "limit": 2,
+            "values": false
+          },
+          "textMode": "auto",
+          "wideLayout": true
+        },
+        "pluginVersion": "10.2.2",
+        "targets": [
+          {
+            "datasource": {
+              "type": "prometheus",
+              "uid": "PBFA97CFB590B2093"
+            },
+            "editorMode": "code",
+            "expr": "mysql_slave_status_slave_sql_running{master_uuid!=\"\"}",
+            "instant": false,
+            "legendFormat": "__auto",
+            "range": true,
+            "refId": "A"
+          }
+        ],
+        "title": "SQL Status",
+        "type": "stat"
+      },
+      {
+        "datasource": {
+          "type": "prometheus",
+          "uid": "PBFA97CFB590B2093"
+        },
+        "description": "",
+        "fieldConfig": {
+          "defaults": {
+            "color": {
+              "mode": "thresholds"
+            },
+            "mappings": [
+              {
+                "options": {
+                  "0": {
+                    "color": "blue",
+                    "index": 1,
+                    "text": "Stopped"
+                  },
+                  "1": {
+                    "color": "blue",
+                    "index": 0,
+                    "text": "Running"
+                  }
+                },
+                "type": "value"
+              }
+            ],
+            "thresholds": {
+              "mode": "absolute",
+              "steps": [
+                {
+                  "color": "green",
+                  "value": null
+                },
+                {
+                  "color": "red",
+                  "value": 80
+                }
+              ]
+            }
+          },
+          "overrides": []
+        },
+        "gridPos": {
+          "h": 8,
+          "w": 12,
+          "x": 12,
+          "y": 8
+        },
+        "id": 3,
+        "options": {
+          "colorMode": "value",
+          "graphMode": "area",
+          "justifyMode": "auto",
+          "orientation": "auto",
+          "reduceOptions": {
+            "calcs": [
+              "lastNotNull"
+            ],
+            "fields": "",
+            "limit": 2,
+            "values": false
+          },
+          "textMode": "auto",
+          "wideLayout": true
+        },
+        "pluginVersion": "10.2.2",
+        "targets": [
+          {
+            "datasource": {
+              "type": "prometheus",
+              "uid": "PBFA97CFB590B2093"
+            },
+            "disableTextWrap": false,
+            "editorMode": "code",
+            "expr": "mysql_slave_status_slave_io_running{master_uuid!=\"\"}",
+            "fullMetaSearch": false,
+            "includeNullMetadata": true,
+            "instant": false,
+            "legendFormat": "__auto",
+            "range": true,
+            "refId": "A",
+            "useBackend": false
+          }
+        ],
+        "title": "I/O Status",
+        "type": "stat"
+      }
+    ],
+    "refresh": "5s",
+    "schemaVersion": 38,
+    "tags": [],
+    "templating": {
+      "list": []
+    },
+    "time": {
+      "from": "now-3h",
+      "to": "now"
+    },
+    "timepicker": {},
+    "timezone": "",
+    "title": "MySQL Health",
+    "uid": "ceb04da1-1169-4b49-a0b9-0d85451d76d0",
+    "version": 2,
+    "weekStart": ""
+  }
\ No newline at end of file

changed: [EmreKaratopuk-3] => (item=mysql.json)
--- before
+++ after: /home/starlord/taltech/ica0002/roles/grafana/files/syslog.json
@@ -0,0 +1,1029 @@
+{
+    "annotations": {
+      "list": [
+        {
+          "builtIn": 1,
+          "datasource": {
+            "type": "datasource",
+            "uid": "grafana"
+          },
+          "enable": true,
+          "hide": true,
+          "iconColor": "rgba(0, 211, 255, 1)",
+          "name": "Annotations & Alerts",
+          "type": "dashboard"
+        }
+      ]
+    },
+    "description": "Telegraf / InfluxDB / Grafana as syslog receiver",
+    "editable": true,
+    "fiscalYearStartMonth": 0,
+    "gnetId": 12433,
+    "graphTooltip": 0,
+    "id": 2,
+    "links": [],
+    "liveNow": false,
+    "panels": [
+      {
+        "aliasColors": {},
+        "bars": true,
+        "dashLength": 10,
+        "dashes": false,
+        "datasource": {
+          "type": "influxdb",
+          "uid": "PC61D9CAFA4D33E15"
+        },
+        "decimals": 0,
+        "fill": 1,
+        "fillGradient": 0,
+        "gridPos": {
+          "h": 7,
+          "w": 24,
+          "x": 0,
+          "y": 0
+        },
+        "hiddenSeries": false,
+        "id": 10,
+        "interval": "",
+        "legend": {
+          "alignAsTable": true,
+          "avg": true,
+          "current": false,
+          "max": true,
+          "min": false,
+          "rightSide": true,
+          "show": true,
+          "total": true,
+          "values": true
+        },
+        "lines": false,
+        "linewidth": 1,
+        "links": [],
+        "nullPointMode": "connected",
+        "options": {
+          "alertThreshold": true
+        },
+        "percentage": false,
+        "pluginVersion": "10.2.0",
+        "pointradius": 2,
+        "points": false,
+        "renderer": "flot",
+        "seriesOverrides": [
+          {
+            "alias": "Info",
+            "color": "rgb(80, 80, 80)",
+            "stack": "A"
+          },
+          {
+            "alias": "Notice",
+            "color": "rgb(182, 182, 182)",
+            "stack": "A"
+          },
+          {
+            "alias": "Warning",
+            "color": "#E0B400",
+            "stack": "A"
+          },
+          {
+            "alias": "Error",
+            "color": "#FF780A",
+            "stack": "A"
+          },
+          {
+            "alias": "Critical",
+            "color": "#E02F44",
+            "stack": "A"
+          },
+          {
+            "alias": "Alert",
+            "color": "#8F3BB8",
+            "stack": "A"
+          },
+          {
+            "alias": "Emergency",
+            "color": "#8F3BB8",
+            "stack": "A"
+          }
+        ],
+        "spaceLength": 10,
+        "stack": false,
+        "steppedLine": false,
+        "targets": [
+          {
+            "alias": "Info",
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "1m"
+                ],
+                "type": "time"
+              },
+              {
+                "params": [
+                  "null"
+                ],
+                "type": "fill"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "A",
+            "resultFormat": "time_series",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                },
+                {
+                  "params": [],
+                  "type": "count"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "severity",
+                "operator": "=",
+                "value": "info"
+              },
+              {
+                "condition": "AND",
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          },
+          {
+            "alias": "Notice",
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "1m"
+                ],
+                "type": "time"
+              },
+              {
+                "params": [
+                  "null"
+                ],
+                "type": "fill"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "B",
+            "resultFormat": "time_series",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                },
+                {
+                  "params": [],
+                  "type": "count"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "severity",
+                "operator": "=",
+                "value": "notice"
+              },
+              {
+                "condition": "AND",
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          },
+          {
+            "alias": "Warning",
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "1m"
+                ],
+                "type": "time"
+              },
+              {
+                "params": [
+                  "null"
+                ],
+                "type": "fill"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "D",
+            "resultFormat": "time_series",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                },
+                {
+                  "params": [],
+                  "type": "count"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "severity",
+                "operator": "=",
+                "value": "warning"
+              },
+              {
+                "condition": "AND",
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          },
+          {
+            "alias": "Error",
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "1m"
+                ],
+                "type": "time"
+              },
+              {
+                "params": [
+                  "null"
+                ],
+                "type": "fill"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "C",
+            "resultFormat": "time_series",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                },
+                {
+                  "params": [],
+                  "type": "count"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "severity",
+                "operator": "=",
+                "value": "err"
+              },
+              {
+                "condition": "AND",
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          },
+          {
+            "alias": "Critical",
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "1m"
+                ],
+                "type": "time"
+              },
+              {
+                "params": [
+                  "null"
+                ],
+                "type": "fill"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "E",
+            "resultFormat": "time_series",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                },
+                {
+                  "params": [],
+                  "type": "count"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "severity",
+                "operator": "=",
+                "value": "crit"
+              },
+              {
+                "condition": "AND",
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          },
+          {
+            "alias": "Alert",
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "1m"
+                ],
+                "type": "time"
+              },
+              {
+                "params": [
+                  "null"
+                ],
+                "type": "fill"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "F",
+            "resultFormat": "time_series",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                },
+                {
+                  "params": [],
+                  "type": "count"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "severity",
+                "operator": "=",
+                "value": "alert"
+              },
+              {
+                "condition": "AND",
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          },
+          {
+            "alias": "Emergency",
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "1m"
+                ],
+                "type": "time"
+              },
+              {
+                "params": [
+                  "null"
+                ],
+                "type": "fill"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "G",
+            "resultFormat": "time_series",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                },
+                {
+                  "params": [],
+                  "type": "count"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "severity",
+                "operator": "=",
+                "value": "emerg"
+              },
+              {
+                "condition": "AND",
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          }
+        ],
+        "thresholds": [],
+        "timeRegions": [],
+        "title": "syslog count",
+        "tooltip": {
+          "shared": true,
+          "sort": 0,
+          "value_type": "individual"
+        },
+        "type": "graph",
+        "xaxis": {
+          "mode": "time",
+          "show": true,
+          "values": []
+        },
+        "yaxes": [
+          {
+            "decimals": 0,
+            "format": "none",
+            "label": "Messages / min",
+            "logBase": 1,
+            "show": true
+          },
+          {
+            "format": "short",
+            "logBase": 1,
+            "show": false
+          }
+        ],
+        "yaxis": {
+          "align": false
+        }
+      },
+      {
+        "datasource": {
+          "type": "influxdb",
+          "uid": "PC61D9CAFA4D33E15"
+        },
+        "description": "",
+        "fieldConfig": {
+          "defaults": {
+            "color": {
+              "mode": "thresholds"
+            },
+            "custom": {
+              "align": "left",
+              "cellOptions": {
+                "type": "auto"
+              },
+              "filterable": false,
+              "inspect": false
+            },
+            "mappings": [],
+            "thresholds": {
+              "mode": "absolute",
+              "steps": [
+                {
+                  "color": "dark-purple",
+                  "value": null
+                },
+                {
+                  "color": "dark-red",
+                  "value": 2
+                },
+                {
+                  "color": "dark-orange",
+                  "value": 3
+                },
+                {
+                  "color": "dark-yellow",
+                  "value": 4
+                },
+                {
+                  "color": "rgb(150, 150, 150)",
+                  "value": 5
+                },
+                {
+                  "color": "rgb(51, 51, 51)",
+                  "value": 6
+                },
+                {
+                  "color": "rgb(5, 5, 5)",
+                  "value": 7
+                }
+              ]
+            }
+          },
+          "overrides": [
+            {
+              "matcher": {
+                "id": "byName",
+                "options": "severity_code"
+              },
+              "properties": [
+                {
+                  "id": "mappings",
+                  "value": [
+                    {
+                      "options": {
+                        "0": {
+                          "text": "Emergency"
+                        },
+                        "1": {
+                          "text": "Alert"
+                        },
+                        "2": {
+                          "text": "Critical"
+                        },
+                        "3": {
+                          "text": "Error"
+                        },
+                        "4": {
+                          "text": "Warning"
+                        },
+                        "5": {
+                          "text": "Notice"
+                        },
+                        "6": {
+                          "text": "Info"
+                        },
+                        "7": {
+                          "text": "Debug"
+                        }
+                      },
+                      "type": "value"
+                    }
+                  ]
+                },
+                {
+                  "id": "custom.cellOptions",
+                  "value": {
+                    "mode": "gradient",
+                    "type": "color-background"
+                  }
+                },
+                {
+                  "id": "custom.width",
+                  "value": 119
+                }
+              ]
+            },
+            {
+              "matcher": {
+                "id": "byName",
+                "options": "Time"
+              },
+              "properties": [
+                {
+                  "id": "custom.width",
+                  "value": 163
+                }
+              ]
+            },
+            {
+              "matcher": {
+                "id": "byName",
+                "options": "hostname"
+              },
+              "properties": [
+                {
+                  "id": "custom.width",
+                  "value": 194
+                }
+              ]
+            },
+            {
+              "matcher": {
+                "id": "byName",
+                "options": "appname"
+              },
+              "properties": [
+                {
+                  "id": "custom.width",
+                  "value": 264
+                }
+              ]
+            }
+          ]
+        },
+        "gridPos": {
+          "h": 24,
+          "w": 24,
+          "x": 0,
+          "y": 7
+        },
+        "id": 12,
+        "options": {
+          "cellHeight": "sm",
+          "footer": {
+            "countRows": false,
+            "fields": "",
+            "reducer": [
+              "sum"
+            ],
+            "show": false
+          },
+          "showHeader": true,
+          "sortBy": [
+            {
+              "desc": true,
+              "displayName": "Time"
+            }
+          ]
+        },
+        "pluginVersion": "10.2.0",
+        "targets": [
+          {
+            "datasource": {
+              "type": "influxdb",
+              "uid": "PC61D9CAFA4D33E15"
+            },
+            "groupBy": [
+              {
+                "params": [
+                  "hostname"
+                ],
+                "type": "tag"
+              },
+              {
+                "params": [
+                  "appname"
+                ],
+                "type": "tag"
+              }
+            ],
+            "measurement": "syslog",
+            "orderByTime": "ASC",
+            "policy": "default",
+            "refId": "A",
+            "resultFormat": "table",
+            "select": [
+              [
+                {
+                  "params": [
+                    "severity_code"
+                  ],
+                  "type": "field"
+                }
+              ],
+              [
+                {
+                  "params": [
+                    "message"
+                  ],
+                  "type": "field"
+                }
+              ]
+            ],
+            "tags": [
+              {
+                "key": "hostname",
+                "operator": "=~",
+                "value": "/^$hostname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "appname",
+                "operator": "=~",
+                "value": "/^$appname$/"
+              },
+              {
+                "condition": "AND",
+                "key": "severity",
+                "operator": "=~",
+                "value": "/^$severity$/"
+              },
+              {
+                "condition": "AND",
+                "key": "message",
+                "operator": "=~",
+                "value": "/$Query/"
+              }
+            ]
+          }
+        ],
+        "title": "Syslog Messages",
+        "type": "table"
+      }
+    ],
+    "refresh": "5s",
+    "schemaVersion": 38,
+    "tags": [],
+    "templating": {
+      "list": [
+        {
+          "allValue": "",
+          "current": {
+            "selected": false,
+            "text": "All",
+            "value": "$__all"
+          },
+          "datasource": {
+            "type": "influxdb",
+            "uid": "PC61D9CAFA4D33E15"
+          },
+          "definition": "SHOW TAG VALUES FROM syslog WITH KEY=appname",
+          "hide": 0,
+          "includeAll": true,
+          "label": "Appname",
+          "multi": true,
+          "name": "appname",
+          "options": [],
+          "query": "SHOW TAG VALUES FROM syslog WITH KEY=appname",
+          "refresh": 2,
+          "regex": "",
+          "skipUrlSync": false,
+          "sort": 1,
+          "tagValuesQuery": "",
+          "tagsQuery": "",
+          "type": "query",
+          "useTags": false
+        },
+        {
+          "allValue": "",
+          "current": {
+            "selected": false,
+            "text": "All",
+            "value": "$__all"
+          },
+          "datasource": {
+            "type": "influxdb",
+            "uid": "PC61D9CAFA4D33E15"
+          },
+          "definition": "SHOW TAG VALUES FROM syslog WITH KEY=hostname",
+          "hide": 0,
+          "includeAll": true,
+          "label": "Hostname",
+          "multi": true,
+          "name": "hostname",
+          "options": [],
+          "query": "SHOW TAG VALUES FROM syslog WITH KEY=hostname",
+          "refresh": 2,
+          "regex": "",
+          "skipUrlSync": false,
+          "sort": 1,
+          "tagValuesQuery": "",
+          "tagsQuery": "",
+          "type": "query",
+          "useTags": false
+        },
+        {
+          "allValue": "",
+          "current": {
+            "selected": false,
+            "text": "All",
+            "value": "$__all"
+          },
+          "datasource": {
+            "type": "influxdb",
+            "uid": "PC61D9CAFA4D33E15"
+          },
+          "definition": "SHOW TAG VALUES FROM syslog WITH KEY=severity",
+          "hide": 0,
+          "includeAll": true,
+          "label": "Severity",
+          "multi": true,
+          "name": "severity",
+          "options": [],
+          "query": "SHOW TAG VALUES FROM syslog WITH KEY=severity",
+          "refresh": 2,
+          "regex": "",
+          "skipUrlSync": false,
+          "sort": 0,
+          "tagValuesQuery": "",
+          "tagsQuery": "",
+          "type": "query",
+          "useTags": false
+        },
+        {
+          "current": {
+            "selected": false,
+            "text": "",
+            "value": ""
+          },
+          "description": "Querystring",
+          "hide": 0,
+          "label": "MessageQuery",
+          "name": "Query",
+          "options": [
+            {
+              "selected": true,
+              "text": "",
+              "value": ""
+            }
+          ],
+          "query": "",
+          "skipUrlSync": false,
+          "type": "textbox"
+        }
+      ]
+    },
+    "time": {
+      "from": "now-1h",
+      "to": "now"
+    },
+    "timepicker": {
+      "refresh_intervals": [
+        "5s",
+        " 10s",
+        " 30s",
+        " 1m",
+        " 5m"
+      ],
+      "time_options": [
+        "5m",
+        "15m",
+        "1h",
+        "6h",
+        "12h",
+        "24h",
+        "2d",
+        "7d",
+        "30d"
+      ]
+    },
+    "timezone": "",
+    "title": "Syslog",
+    "uid": "TIYeHqRgZ",
+    "version": 1,
+    "weekStart": ""
+  }
\ No newline at end of file

changed: [EmreKaratopuk-3] => (item=syslog.json)

TASK [Add grafana A record] ****************************************************

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

RUNNING HANDLER [grafana : Restart grafana] ************************************
--- before
+++ after
@@ -1,4 +1,4 @@
 {
-    "restarted": false,
+    "restarted": true,
     "running": true
 }

changed: [EmreKaratopuk-3]

PLAY [Agama server] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [agama : Create agama volume directory] ***********************************
--- before
+++ after
@@ -1,4 +1,4 @@
 {
     "path": "/opt/agama",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-1]
--- before
+++ after
@@ -1,4 +1,4 @@
 {
     "path": "/opt/agama",
-    "state": "absent"
+    "state": "directory"
 }

changed: [EmreKaratopuk-2]

TASK [agama : Download agama files] ********************************************
changed: [EmreKaratopuk-1] => (item=agama.py)
changed: [EmreKaratopuk-2] => (item=agama.py)
changed: [EmreKaratopuk-2] => (item=Dockerfile)
changed: [EmreKaratopuk-1] => (item=Dockerfile)

TASK [agama : Create agama docker image] ***************************************
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

TASK [agama : Start agama docker container] ************************************
changed: [EmreKaratopuk-2] => (item=None)
changed: [EmreKaratopuk-1] => (item=None)
changed: [EmreKaratopuk-2] => (item=None)
changed: [EmreKaratopuk-1] => (item=None)
changed: [EmreKaratopuk-2] => (item=None)
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1] => (item=None)
changed: [EmreKaratopuk-1]

TASK [agama : List running agama containers] ***********************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [agama : Stop unnecessary agama containers] *******************************

TASK [Add agama A records] *****************************************************

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
changed: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

PLAY [Nginx server] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]

TASK [nginx : Install nginx] ***************************************************
The following additional packages will be installed:
  fontconfig-config fonts-dejavu-core libfontconfig1 libgd3 libjbig0
  libjpeg-turbo8 libjpeg8 libnginx-mod-http-image-filter
  libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libtiff5
  libwebp6 libxpm4 nginx-common nginx-core
Suggested packages:
  libgd-tools fcgiwrap nginx-doc ssl-cert
The following NEW packages will be installed:
  fontconfig-config fonts-dejavu-core libfontconfig1 libgd3 libjbig0
  libjpeg-turbo8 libjpeg8 libnginx-mod-http-image-filter
  libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libtiff5
  libwebp6 libxpm4 nginx nginx-common nginx-core
0 upgraded, 17 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]
The following additional packages will be installed:
  fontconfig-config fonts-dejavu-core libfontconfig1 libgd3 libjbig0
  libjpeg-turbo8 libjpeg8 libnginx-mod-http-image-filter
  libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libtiff5
  libwebp6 libxpm4 nginx-common nginx-core
Suggested packages:
  libgd-tools fcgiwrap nginx-doc ssl-cert
The following NEW packages will be installed:
  fontconfig-config fonts-dejavu-core libfontconfig1 libgd3 libjbig0
  libjpeg-turbo8 libjpeg8 libnginx-mod-http-image-filter
  libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libtiff5
  libwebp6 libxpm4 nginx nginx-common nginx-core
0 upgraded, 17 newly installed, 0 to remove and 263 not upgraded.
changed: [EmreKaratopuk-3]
The following additional packages will be installed:
  fontconfig-config fonts-dejavu-core libfontconfig1 libgd3 libjbig0
  libjpeg-turbo8 libjpeg8 libnginx-mod-http-image-filter
  libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libtiff5
  libwebp6 libxpm4 nginx-common nginx-core
Suggested packages:
  libgd-tools fcgiwrap nginx-doc ssl-cert
The following NEW packages will be installed:
  fontconfig-config fonts-dejavu-core libfontconfig1 libgd3 libjbig0
  libjpeg-turbo8 libjpeg8 libnginx-mod-http-image-filter
  libnginx-mod-http-xslt-filter libnginx-mod-mail libnginx-mod-stream libtiff5
  libwebp6 libxpm4 nginx nginx-common nginx-core
0 upgraded, 17 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]

TASK [nginx : Configure nginx frontend service] ********************************
--- before: /etc/nginx/sites-enabled/default
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp2pif0x09/default.j2
@@ -1,91 +1,20 @@
-##
-# You should look at the following URL's in order to grasp a solid understanding
-# of Nginx configuration files in order to fully unleash the power of Nginx.
-# https://www.nginx.com/resources/wiki/start/
-# https://www.nginx.com/resources/wiki/start/topics/tutorials/config_pitfalls/
-# https://wiki.debian.org/Nginx/DirectoryStructure
-#
-# In most cases, administrators will remove this file from sites-enabled/ and
-# leave it as reference inside of sites-available where it will continue to be
-# updated by the nginx packaging team.
-#
-# This file will automatically load configuration files provided by other
-# applications, such as Drupal or Wordpress. These applications will be made
-# available underneath a path with that package name, such as /drupal8.
-#
-# Please see /usr/share/doc/nginx-doc/examples/ for more detailed examples.
-##
-
-# Default server configuration
-#
 server {
 	listen 80 default_server;
-	listen [::]:80 default_server;
-
-	# SSL configuration
-	#
-	# listen 443 ssl default_server;
-	# listen [::]:443 ssl default_server;
-	#
-	# Note: You should disable gzip for SSL traffic.
-	# See: https://bugs.debian.org/773332
-	#
-	# Read up on ssl_ciphers to ensure a secure configuration.
-	# See: https://bugs.debian.org/765782
-	#
-	# Self signed certs generated by the ssl-cert package
-	# Don't use them in a production server!
-	#
-	# include snippets/snakeoil.conf;
-
-	root /var/www/html;
-
-	# Add index.php to the list if you are using PHP
-	index index.html index.htm index.nginx-debian.html;
-
 	server_name _;
 
+    	
 	location / {
-		# First attempt to serve request as file, then
-		# as directory, then fall back to displaying a 404.
-		try_files $uri $uri/ =404;
+	proxy_pass http://localhost:8001; 
+	proxy_set_header Host $http_host;
 	}
 
-	# pass PHP scripts to FastCGI server
-	#
-	#location ~ \.php$ {
-	#	include snippets/fastcgi-php.conf;
-	#
-	#	# With php-fpm (or other unix sockets):
-	#	fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
-	#	# With php-cgi (or other tcp sockets):
-	#	fastcgi_pass 127.0.0.1:9000;
-	#}
-
-	# deny access to .htaccess files, if Apache's document root
-	# concurs with nginx's one
-	#
-	#location ~ /\.ht {
-	#	deny all;
-	#}
+	
 }
 
+server {
+	listen 8080 default_server;
 
-# Virtual Host configuration for example.com
-#
-# You can move that to a different file under sites-available/ and symlink that
-# to sites-enabled/ to enable it.
-#
-#server {
-#	listen 80;
-#	listen [::]:80;
-#
-#	server_name example.com;
-#
-#	root /var/www/example.com;
-#	index index.html;
-#
-#	location / {
-#		try_files $uri $uri/ =404;
-#	}
-#}
+	location = /stub_status {
+		stub_status;
+	}
+}
\ No newline at end of file

changed: [EmreKaratopuk-2]
--- before: /etc/nginx/sites-enabled/default
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpwn41j9fg/default.j2
@@ -1,91 +1,24 @@
-##
-# You should look at the following URL's in order to grasp a solid understanding
-# of Nginx configuration files in order to fully unleash the power of Nginx.
-# https://www.nginx.com/resources/wiki/start/
-# https://www.nginx.com/resources/wiki/start/topics/tutorials/config_pitfalls/
-# https://wiki.debian.org/Nginx/DirectoryStructure
-#
-# In most cases, administrators will remove this file from sites-enabled/ and
-# leave it as reference inside of sites-available where it will continue to be
-# updated by the nginx packaging team.
-#
-# This file will automatically load configuration files provided by other
-# applications, such as Drupal or Wordpress. These applications will be made
-# available underneath a path with that package name, such as /drupal8.
-#
-# Please see /usr/share/doc/nginx-doc/examples/ for more detailed examples.
-##
-
-# Default server configuration
-#
 server {
 	listen 80 default_server;
-	listen [::]:80 default_server;
-
-	# SSL configuration
-	#
-	# listen 443 ssl default_server;
-	# listen [::]:443 ssl default_server;
-	#
-	# Note: You should disable gzip for SSL traffic.
-	# See: https://bugs.debian.org/773332
-	#
-	# Read up on ssl_ciphers to ensure a secure configuration.
-	# See: https://bugs.debian.org/765782
-	#
-	# Self signed certs generated by the ssl-cert package
-	# Don't use them in a production server!
-	#
-	# include snippets/snakeoil.conf;
-
-	root /var/www/html;
-
-	# Add index.php to the list if you are using PHP
-	index index.html index.htm index.nginx-debian.html;
-
 	server_name _;
 
-	location / {
-		# First attempt to serve request as file, then
-		# as directory, then fall back to displaying a 404.
-		try_files $uri $uri/ =404;
+    
+	location /prometheus {
+		proxy_pass http://localhost:9090;
 	}
 
-	# pass PHP scripts to FastCGI server
-	#
-	#location ~ \.php$ {
-	#	include snippets/fastcgi-php.conf;
-	#
-	#	# With php-fpm (or other unix sockets):
-	#	fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
-	#	# With php-cgi (or other tcp sockets):
-	#	fastcgi_pass 127.0.0.1:9000;
-	#}
+	location /grafana {
+		proxy_pass http://localhost:3001;
+		proxy_set_header Host $http_host;
+	}
 
-	# deny access to .htaccess files, if Apache's document root
-	# concurs with nginx's one
-	#
-	#location ~ /\.ht {
-	#	deny all;
-	#}
+	
 }
 
+server {
+	listen 8080 default_server;
 
-# Virtual Host configuration for example.com
-#
-# You can move that to a different file under sites-available/ and symlink that
-# to sites-enabled/ to enable it.
-#
-#server {
-#	listen 80;
-#	listen [::]:80;
-#
-#	server_name example.com;
-#
-#	root /var/www/example.com;
-#	index index.html;
-#
-#	location / {
-#		try_files $uri $uri/ =404;
-#	}
-#}
+	location = /stub_status {
+		stub_status;
+	}
+}
\ No newline at end of file

changed: [EmreKaratopuk-3]
--- before: /etc/nginx/sites-enabled/default
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp1jn1eogc/default.j2
@@ -1,91 +1,20 @@
-##
-# You should look at the following URL's in order to grasp a solid understanding
-# of Nginx configuration files in order to fully unleash the power of Nginx.
-# https://www.nginx.com/resources/wiki/start/
-# https://www.nginx.com/resources/wiki/start/topics/tutorials/config_pitfalls/
-# https://wiki.debian.org/Nginx/DirectoryStructure
-#
-# In most cases, administrators will remove this file from sites-enabled/ and
-# leave it as reference inside of sites-available where it will continue to be
-# updated by the nginx packaging team.
-#
-# This file will automatically load configuration files provided by other
-# applications, such as Drupal or Wordpress. These applications will be made
-# available underneath a path with that package name, such as /drupal8.
-#
-# Please see /usr/share/doc/nginx-doc/examples/ for more detailed examples.
-##
-
-# Default server configuration
-#
 server {
 	listen 80 default_server;
-	listen [::]:80 default_server;
-
-	# SSL configuration
-	#
-	# listen 443 ssl default_server;
-	# listen [::]:443 ssl default_server;
-	#
-	# Note: You should disable gzip for SSL traffic.
-	# See: https://bugs.debian.org/773332
-	#
-	# Read up on ssl_ciphers to ensure a secure configuration.
-	# See: https://bugs.debian.org/765782
-	#
-	# Self signed certs generated by the ssl-cert package
-	# Don't use them in a production server!
-	#
-	# include snippets/snakeoil.conf;
-
-	root /var/www/html;
-
-	# Add index.php to the list if you are using PHP
-	index index.html index.htm index.nginx-debian.html;
-
 	server_name _;
 
+    	
 	location / {
-		# First attempt to serve request as file, then
-		# as directory, then fall back to displaying a 404.
-		try_files $uri $uri/ =404;
+	proxy_pass http://localhost:8001; 
+	proxy_set_header Host $http_host;
 	}
 
-	# pass PHP scripts to FastCGI server
-	#
-	#location ~ \.php$ {
-	#	include snippets/fastcgi-php.conf;
-	#
-	#	# With php-fpm (or other unix sockets):
-	#	fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
-	#	# With php-cgi (or other tcp sockets):
-	#	fastcgi_pass 127.0.0.1:9000;
-	#}
-
-	# deny access to .htaccess files, if Apache's document root
-	# concurs with nginx's one
-	#
-	#location ~ /\.ht {
-	#	deny all;
-	#}
+	
 }
 
+server {
+	listen 8080 default_server;
 
-# Virtual Host configuration for example.com
-#
-# You can move that to a different file under sites-available/ and symlink that
-# to sites-enabled/ to enable it.
-#
-#server {
-#	listen 80;
-#	listen [::]:80;
-#
-#	server_name example.com;
-#
-#	root /var/www/example.com;
-#	index index.html;
-#
-#	location / {
-#		try_files $uri $uri/ =404;
-#	}
-#}
+	location = /stub_status {
+		stub_status;
+	}
+}
\ No newline at end of file

changed: [EmreKaratopuk-1]

TASK [nginx : Install prometheus-nginx-exporter] *******************************
The following NEW packages will be installed:
  prometheus-nginx-exporter
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]
The following NEW packages will be installed:
  prometheus-nginx-exporter
0 upgraded, 1 newly installed, 0 to remove and 263 not upgraded.
changed: [EmreKaratopuk-3]
The following NEW packages will be installed:
  prometheus-nginx-exporter
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]

TASK [nginx : Start nginx and exporter] ****************************************
ok: [EmreKaratopuk-2] => (item=nginx)
ok: [EmreKaratopuk-3] => (item=nginx)
ok: [EmreKaratopuk-1] => (item=nginx)
changed: [EmreKaratopuk-2] => (item=prometheus-nginx-exporter)
changed: [EmreKaratopuk-3] => (item=prometheus-nginx-exporter)
changed: [EmreKaratopuk-1] => (item=prometheus-nginx-exporter)

RUNNING HANDLER [nginx : Restart nginx] ****************************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-3]
changed: [EmreKaratopuk-1]

RUNNING HANDLER [nginx : Restart nginx-exporter] *******************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-3]
changed: [EmreKaratopuk-1]

PLAY [HAProxy] *****************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [haproxy : Install HAProxy] ***********************************************
The following additional packages will be installed:
  liblua5.3-0
Suggested packages:
  vim-haproxy haproxy-doc
The following NEW packages will be installed:
  haproxy liblua5.3-0
0 upgraded, 2 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]
The following additional packages will be installed:
  liblua5.3-0
Suggested packages:
  vim-haproxy haproxy-doc
The following NEW packages will be installed:
  haproxy liblua5.3-0
0 upgraded, 2 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]

TASK [Add haproxy A records] ***************************************************

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
changed: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)

TASK [haproxy : Add haproxy configuration] *************************************
--- before: /etc/haproxy/haproxy.cfg
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp0k9v6dgy/haproxy.cfg.j2
@@ -1,34 +1,45 @@
 global
-	log /dev/log	local0
-	log /dev/log	local1 notice
-	chroot /var/lib/haproxy
-	stats socket /run/haproxy/admin.sock mode 660 level admin expose-fd listeners
-	stats timeout 30s
-	user haproxy
-	group haproxy
-	daemon
+        log /dev/log    local0
+        log /dev/log    local1 notice
+        chroot /var/lib/haproxy
+        stats socket /run/haproxy/admin.sock mode 660 level admin expose-fd listeners
+        stats timeout 30s
+        user haproxy
+        group haproxy
+        daemon
 
-	# Default SSL material locations
-	ca-base /etc/ssl/certs
-	crt-base /etc/ssl/private
-
-	# See: https://ssl-config.mozilla.org/#server=haproxy&server-version=2.0.3&config=intermediate
-        ssl-default-bind-ciphers ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384
-        ssl-default-bind-ciphersuites TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256
-        ssl-default-bind-options ssl-min-ver TLSv1.2 no-tls-tickets
 
 defaults
-	log	global
-	mode	http
-	option	httplog
-	option	dontlognull
+        log     global
+        mode    http
+        option  httplog
+        option  dontlognull
         timeout connect 5000
         timeout client  50000
         timeout server  50000
-	errorfile 400 /etc/haproxy/errors/400.http
-	errorfile 403 /etc/haproxy/errors/403.http
-	errorfile 408 /etc/haproxy/errors/408.http
-	errorfile 500 /etc/haproxy/errors/500.http
-	errorfile 502 /etc/haproxy/errors/502.http
-	errorfile 503 /etc/haproxy/errors/503.http
-	errorfile 504 /etc/haproxy/errors/504.http
+        errorfile 400 /etc/haproxy/errors/400.http
+        errorfile 403 /etc/haproxy/errors/403.http
+        errorfile 408 /etc/haproxy/errors/408.http
+        errorfile 500 /etc/haproxy/errors/500.http
+        errorfile 502 /etc/haproxy/errors/502.http
+        errorfile 503 /etc/haproxy/errors/503.http
+        errorfile 504 /etc/haproxy/errors/504.http
+
+listen my_ha_frontend
+        bind :88
+
+        
+        server vm1-0 lb-1:8001 check
+        server vm2-0 lb-2:8001 check
+        
+        server vm1-1 lb-1:8002 check
+        server vm2-1 lb-2:8002 check
+        
+        server vm1-2 lb-1:8003 check
+        server vm2-2 lb-2:8003 check
+        
+listen stats
+        bind :9188
+        stats enable
+        stats uri /status
+        stats refresh 5s 

changed: [EmreKaratopuk-2]
--- before: /etc/haproxy/haproxy.cfg
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp0pzvpbcb/haproxy.cfg.j2
@@ -1,34 +1,45 @@
 global
-	log /dev/log	local0
-	log /dev/log	local1 notice
-	chroot /var/lib/haproxy
-	stats socket /run/haproxy/admin.sock mode 660 level admin expose-fd listeners
-	stats timeout 30s
-	user haproxy
-	group haproxy
-	daemon
+        log /dev/log    local0
+        log /dev/log    local1 notice
+        chroot /var/lib/haproxy
+        stats socket /run/haproxy/admin.sock mode 660 level admin expose-fd listeners
+        stats timeout 30s
+        user haproxy
+        group haproxy
+        daemon
 
-	# Default SSL material locations
-	ca-base /etc/ssl/certs
-	crt-base /etc/ssl/private
-
-	# See: https://ssl-config.mozilla.org/#server=haproxy&server-version=2.0.3&config=intermediate
-        ssl-default-bind-ciphers ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384
-        ssl-default-bind-ciphersuites TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256
-        ssl-default-bind-options ssl-min-ver TLSv1.2 no-tls-tickets
 
 defaults
-	log	global
-	mode	http
-	option	httplog
-	option	dontlognull
+        log     global
+        mode    http
+        option  httplog
+        option  dontlognull
         timeout connect 5000
         timeout client  50000
         timeout server  50000
-	errorfile 400 /etc/haproxy/errors/400.http
-	errorfile 403 /etc/haproxy/errors/403.http
-	errorfile 408 /etc/haproxy/errors/408.http
-	errorfile 500 /etc/haproxy/errors/500.http
-	errorfile 502 /etc/haproxy/errors/502.http
-	errorfile 503 /etc/haproxy/errors/503.http
-	errorfile 504 /etc/haproxy/errors/504.http
+        errorfile 400 /etc/haproxy/errors/400.http
+        errorfile 403 /etc/haproxy/errors/403.http
+        errorfile 408 /etc/haproxy/errors/408.http
+        errorfile 500 /etc/haproxy/errors/500.http
+        errorfile 502 /etc/haproxy/errors/502.http
+        errorfile 503 /etc/haproxy/errors/503.http
+        errorfile 504 /etc/haproxy/errors/504.http
+
+listen my_ha_frontend
+        bind :88
+
+        
+        server vm1-0 lb-1:8001 check
+        server vm2-0 lb-2:8001 check
+        
+        server vm1-1 lb-1:8002 check
+        server vm2-1 lb-2:8002 check
+        
+        server vm1-2 lb-1:8003 check
+        server vm2-2 lb-2:8003 check
+        
+listen stats
+        bind :9188
+        stats enable
+        stats uri /status
+        stats refresh 5s 

changed: [EmreKaratopuk-1]

TASK [haproxy : Start HAProxy] *************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Install prometheus-haproxy-exporter] ***************************
The following NEW packages will be installed:
  prometheus-haproxy-exporter
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]
The following NEW packages will be installed:
  prometheus-haproxy-exporter
0 upgraded, 1 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]

TASK [haproxy : Start prometheus-haproxy-exporter] *****************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Configure prometheus-haproxy-exporter] *************************
--- before: /etc/default/prometheus-haproxy-exporter
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmp_87n2x71/prometheus-haproxy-exporter
@@ -2,7 +2,7 @@
 # Due to shell scaping, to pass backslashes for regexes, you need to double
 # them (\\d for \d). If running under systemd, you need to double them again
 # (\\\\d to mean \d), and escape newlines too.
-ARGS=""
+ARGS="--haproxy.scrape-uri='http://localhost:9188/status/;csv'"
 
 # Prometheus-haproxy-exporter supports the following options:
 #
@@ -32,4 +32,4 @@
 #    Valid levels: [debug, info, warn, error, fatal]
 #  --log.format="logger:stderr"
 #    Set the log target and format. Example:
-#    "logger:syslog?appname=bob&local=7" or "logger:stdout?json=true"
+#    "logger:syslog?appname=bob&local=7" or "logger:stdout?json=true"
\ No newline at end of file

changed: [EmreKaratopuk-1]
--- before: /etc/default/prometheus-haproxy-exporter
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpblf2k42_/prometheus-haproxy-exporter
@@ -2,7 +2,7 @@
 # Due to shell scaping, to pass backslashes for regexes, you need to double
 # them (\\d for \d). If running under systemd, you need to double them again
 # (\\\\d to mean \d), and escape newlines too.
-ARGS=""
+ARGS="--haproxy.scrape-uri='http://localhost:9188/status/;csv'"
 
 # Prometheus-haproxy-exporter supports the following options:
 #
@@ -32,4 +32,4 @@
 #    Valid levels: [debug, info, warn, error, fatal]
 #  --log.format="logger:stderr"
 #    Set the log target and format. Example:
-#    "logger:syslog?appname=bob&local=7" or "logger:stdout?json=true"
+#    "logger:syslog?appname=bob&local=7" or "logger:stdout?json=true"
\ No newline at end of file

changed: [EmreKaratopuk-2]

RUNNING HANDLER [haproxy : Restart haproxy] ************************************
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

RUNNING HANDLER [haproxy : Restart prometheus-haproxy-exporter] ****************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

PLAY [Keepalived] **************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : set_fact] ***************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : set_fact] ***************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Install keepalived] *****************************************
The following additional packages will be installed:
  ipvsadm libmysqlclient21 libnl-3-200 libnl-genl-3-200 libsensors-config
  libsensors5 libsnmp-base libsnmp35
Suggested packages:
  heartbeat ldirectord lm-sensors snmp-mibs-downloader
The following NEW packages will be installed:
  ipvsadm keepalived libmysqlclient21 libnl-3-200 libnl-genl-3-200
  libsensors-config libsensors5 libsnmp-base libsnmp35
0 upgraded, 9 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-2]
The following additional packages will be installed:
  ipvsadm libmysqlclient21 libnl-3-200 libnl-genl-3-200 libsensors-config
  libsensors5 libsnmp-base libsnmp35
Suggested packages:
  heartbeat ldirectord lm-sensors snmp-mibs-downloader
The following NEW packages will be installed:
  ipvsadm keepalived libmysqlclient21 libnl-3-200 libnl-genl-3-200
  libsensors-config libsensors5 libsnmp-base libsnmp35
0 upgraded, 9 newly installed, 0 to remove and 262 not upgraded.
changed: [EmreKaratopuk-1]

TASK [keepalived : Create keepalived_script user] ******************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [keepalived : Copy check script for keepalived] ***************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/keepalived/files/keepalived_script
@@ -0,0 +1,2 @@
+#!/bin/bash
+ss -ntl | grep -q ':88 '
\ No newline at end of file

changed: [EmreKaratopuk-1]
--- before
+++ after: /home/starlord/taltech/ica0002/roles/keepalived/files/keepalived_script
@@ -0,0 +1,2 @@
+#!/bin/bash
+ss -ntl | grep -q ':88 '
\ No newline at end of file

changed: [EmreKaratopuk-2]

TASK [keepalived : Copy keepalived config] *************************************
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpus5mxt_6/keepalived.conf.j2
@@ -0,0 +1,31 @@
+global_defs {
+   enable_script_security
+   script_user keepalived_script
+}
+
+vrrp_script check_haproxy {                 
+    script "/home/keepalived_script/keepalived_script" 
+    weight 20                              
+    interval 1               
+}
+vrrp_instance VI_1 {             
+    interface ens3
+    virtual_router_id 51
+    advert_int 1
+    preempt                            
+    
+    priority 90
+    
+    virtual_ipaddress {                     
+        192.168.100.173/24
+    }
+    unicast_peer {
+        
+        
+        192.168.42.173
+                
+                    }
+    track_script {
+        check_haproxy
+    }
+}

changed: [EmreKaratopuk-2]
--- before
+++ after: /home/starlord/.ansible/tmp/ansible-local-544djynczfy/tmpqolsd79_/keepalived.conf.j2
@@ -0,0 +1,31 @@
+global_defs {
+   enable_script_security
+   script_user keepalived_script
+}
+
+vrrp_script check_haproxy {                 
+    script "/home/keepalived_script/keepalived_script" 
+    weight 20                              
+    interval 1               
+}
+vrrp_instance VI_1 {             
+    interface ens3
+    virtual_router_id 51
+    advert_int 1
+    preempt                            
+    
+    priority 100
+    
+    virtual_ipaddress {                     
+        192.168.100.173/24
+    }
+    unicast_peer {
+        
+                
+        
+        192.168.42.47
+                    }
+    track_script {
+        check_haproxy
+    }
+}

changed: [EmreKaratopuk-1]

TASK [keepalived : Start keepalived] *******************************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [keepalived : Download keepalived exporter] *******************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

TASK [keepalived : Create keepalived exporter service] *************************
--- before
+++ after: /home/starlord/taltech/ica0002/roles/keepalived/files/keepalived-exporter.service
@@ -0,0 +1,10 @@
+[Unit]
+Description==Export keepalived stats for prometheus
+After=network-online.target
+
+[Service]
+User=root
+ExecStart=/usr/local/bin/keepalived-exporter-1.2.0.linux-amd64/keepalived-exporter
+
+[Install]
+WantedBy=multi-user.target
\ No newline at end of file

changed: [EmreKaratopuk-1]
--- before
+++ after: /home/starlord/taltech/ica0002/roles/keepalived/files/keepalived-exporter.service
@@ -0,0 +1,10 @@
+[Unit]
+Description==Export keepalived stats for prometheus
+After=network-online.target
+
+[Service]
+User=root
+ExecStart=/usr/local/bin/keepalived-exporter-1.2.0.linux-amd64/keepalived-exporter
+
+[Install]
+WantedBy=multi-user.target
\ No newline at end of file

changed: [EmreKaratopuk-2]

TASK [keepalived : Restart systemctl daemon] ***********************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Start keepalived exporter service] **************************
changed: [EmreKaratopuk-2]
changed: [EmreKaratopuk-1]

RUNNING HANDLER [keepalived : Restart keepalived] ******************************
changed: [EmreKaratopuk-1]
changed: [EmreKaratopuk-2]

PLAY RECAP *********************************************************************
EmreKaratopuk-1            : ok=84   changed=64   unreachable=0    failed=0    skipped=5    rescued=0    ignored=0   
EmreKaratopuk-2            : ok=84   changed=63   unreachable=0    failed=0    skipped=5    rescued=0    ignored=0   
EmreKaratopuk-3            : ok=81   changed=67   unreachable=0    failed=0    skipped=0    rescued=0    ignored=0   

+ ansible-playbook infra.yaml --diff

PLAY [Initial setup] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]

TASK [init : Update APT cache] *************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Download certificates] ********************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [init : Install prometheus node exporter] *********************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [init : Modify rsyslog conf file] *****************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Create backup user] ***********************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]

TASK [init : Add backup server to known hosts] *********************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]

TASK [init : Create restore directory] *****************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [init : Install duplicity] ************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Install dnspython] ************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

PLAY [Bind server] *************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [bind : Install bind9] ****************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [bind : Configure bind9 files] ********************************************
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-3] => (item=None)
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-3] => (item=None)
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-2]

TASK [bind : Configure master zone] ********************************************
skipping: [EmreKaratopuk-1] => (item=istikbal.ek) 
skipping: [EmreKaratopuk-1] => (item=168.192.in-addr.arpa) 
skipping: [EmreKaratopuk-2] => (item=istikbal.ek) 
skipping: [EmreKaratopuk-2] => (item=168.192.in-addr.arpa) 
ok: [EmreKaratopuk-3] => (item=istikbal.ek)
ok: [EmreKaratopuk-3] => (item=168.192.in-addr.arpa)

TASK [bind : Install prometheus-bind-exporter] *********************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [bind : Start bind9 and exporter] *****************************************
ok: [EmreKaratopuk-3] => (item=bind9)
ok: [EmreKaratopuk-2] => (item=bind9)
ok: [EmreKaratopuk-1] => (item=bind9)
ok: [EmreKaratopuk-3] => (item=prometheus-bind-exporter)
ok: [EmreKaratopuk-2] => (item=prometheus-bind-exporter)
ok: [EmreKaratopuk-1] => (item=prometheus-bind-exporter)

TASK [bind : Run handlers] *****************************************************

TASK [Add A records] ***********************************************************
skipping: [EmreKaratopuk-1] => (item={'key': 'backup', 'value': '192.168.42.132'}) 
skipping: [EmreKaratopuk-1] => (item={'key': 'google', 'value': '8.8.8.8'}) 
skipping: [EmreKaratopuk-2] => (item={'key': 'backup', 'value': '192.168.42.132'}) 
skipping: [EmreKaratopuk-2] => (item={'key': 'google', 'value': '8.8.8.8'}) 

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [Add NS records] **********************************************************
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-3) 
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-1) 
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-2) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-3) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-1) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-2) 

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Configure DNS settings for both] *****************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [config-dns : Stop systemd-resolved] **************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [config-dns : Change resolv.conf content] *********************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

PLAY [Prometheus server] *******************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Install Prometheus] *****************************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Adjust Prometheus service] **********************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Add data source VMs] ****************************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Start prometheus] *******************************************
ok: [EmreKaratopuk-3]

TASK [Add prometheus A record] *************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Database server] *********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [mysql : Install mysql] ***************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Listen public] ***************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Start mysql] *****************************************************

TASK [mysql : Install python3-pymysql] *****************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Add agama database] **********************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : MySQL user] ******************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [mysql : Configure mysql exporter credentials] ****************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [mysql : Create mysql exporter user] **************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [mysql : Install prometheus-mysqld-exporter] ******************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [mysql : Export replica status] *******************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Add mysql replication user] **************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [mysql : Configure mysql dynamic variables for replica] *******************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Create backup and restore directories for mysql] *****************
ok: [EmreKaratopuk-2] => (item=mysql)
ok: [EmreKaratopuk-1] => (item=mysql)
ok: [EmreKaratopuk-2] => (item=restore/mysql)
ok: [EmreKaratopuk-1] => (item=restore/mysql)

TASK [mysql : Create mysql backup user] ****************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [mysql : Create backup user credentials to access mysql] ******************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Start mysql and prometheus services] *****************************
ok: [EmreKaratopuk-2] => (item=mysql)
ok: [EmreKaratopuk-1] => (item=mysql)
ok: [EmreKaratopuk-1] => (item=prometheus-mysqld-exporter)
ok: [EmreKaratopuk-2] => (item=prometheus-mysqld-exporter)

TASK [mysql : Create scheduled mysql backup task with cron] ********************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [Add mysql A records] *****************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)

PLAY [influxDB server] *********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Create influxdb directory] ************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Download influxdb] ********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Install influxdb] *********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Configure influxdb] *******************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Activate influxdb] ********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Get telegraf key] *********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Get telegraf source with apt] *********************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Install telegraf from source] *********************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Configure telegraf] *******************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Download influxdb exporter] ***********************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Create influxdb-exporter service] *****************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Restart systemctl daemon] *************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Start prometheus-influxdb-stats-exporter and telegraf] ********
ok: [EmreKaratopuk-3] => (item=prometheus-influxdb-stats-exporter.service)
ok: [EmreKaratopuk-3] => (item=telegraf.service)

TASK [influxdb : Create backup and restore directories for influxdb] ***********
ok: [EmreKaratopuk-3] => (item=influxdb)
ok: [EmreKaratopuk-3] => (item=restore/influxdb)

TASK [influxdb : Create scheduled influxdb backup task with cron] **************
ok: [EmreKaratopuk-3]

TASK [Add influxdb A record] ***************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Docker server] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [docker : Install docker] *************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-3]

TASK [docker : Start docker] ***************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

PLAY [Pinger server] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Install fping] **************************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Create pinger user] *********************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Add pinger source code] *****************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Add pinger service] *********************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Restart systemctl daemon] ***************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Create pinger folder] *******************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Add pinger conf] ************************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Start pinger] ***************************************************
ok: [EmreKaratopuk-3]

PLAY [Grafana server] **********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [grafana : Install Grafana via Docker] ************************************
ok: [EmreKaratopuk-3]

TASK [grafana : Create volume directories] *************************************
ok: [EmreKaratopuk-3] => (item=dashboards)
ok: [EmreKaratopuk-3] => (item=datasources)

TASK [grafana : Copy grafana configs to volume] ********************************
ok: [EmreKaratopuk-3]

TASK [grafana : Copy dashboards config to volume] ******************************
ok: [EmreKaratopuk-3]

TASK [grafana : Copy datasources config to volume] *****************************
ok: [EmreKaratopuk-3]

TASK [grafana : Copy all dashboards to volume] *********************************
ok: [EmreKaratopuk-3] => (item=main.json)
ok: [EmreKaratopuk-3] => (item=mysql.json)
ok: [EmreKaratopuk-3] => (item=syslog.json)

TASK [Add grafana A record] ****************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Agama server] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [agama : Create agama volume directory] ***********************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [agama : Download agama files] ********************************************
ok: [EmreKaratopuk-1] => (item=agama.py)
ok: [EmreKaratopuk-2] => (item=agama.py)
ok: [EmreKaratopuk-1] => (item=Dockerfile)
ok: [EmreKaratopuk-2] => (item=Dockerfile)

TASK [agama : Create agama docker image] ***************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [agama : Start agama docker container] ************************************
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-1]

TASK [agama : List running agama containers] ***********************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [agama : Stop unnecessary agama containers] *******************************

TASK [Add agama A records] *****************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)

PLAY [Nginx server] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [nginx : Install nginx] ***************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [nginx : Configure nginx frontend service] ********************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [nginx : Install prometheus-nginx-exporter] *******************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

TASK [nginx : Start nginx and exporter] ****************************************
ok: [EmreKaratopuk-3] => (item=nginx)
ok: [EmreKaratopuk-2] => (item=nginx)
ok: [EmreKaratopuk-1] => (item=nginx)
ok: [EmreKaratopuk-3] => (item=prometheus-nginx-exporter)
ok: [EmreKaratopuk-1] => (item=prometheus-nginx-exporter)
ok: [EmreKaratopuk-2] => (item=prometheus-nginx-exporter)

PLAY [HAProxy] *****************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [haproxy : Install HAProxy] ***********************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [Add haproxy A records] ***************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)

TASK [haproxy : Add haproxy configuration] *************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Start HAProxy] *************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [haproxy : Install prometheus-haproxy-exporter] ***************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Start prometheus-haproxy-exporter] *****************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Configure prometheus-haproxy-exporter] *************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

PLAY [Keepalived] **************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : set_fact] ***************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : set_fact] ***************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Install keepalived] *****************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Create keepalived_script user] ******************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Copy check script for keepalived] ***************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Copy keepalived config] *************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Start keepalived] *******************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Download keepalived exporter] *******************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Create keepalived exporter service] *************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Restart systemctl daemon] ***********************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Start keepalived exporter service] **************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

PLAY RECAP *********************************************************************
EmreKaratopuk-1            : ok=74   changed=0    unreachable=0    failed=0    skipped=4    rescued=0    ignored=0   
EmreKaratopuk-2            : ok=74   changed=0    unreachable=0    failed=0    skipped=4    rescued=0    ignored=0   
EmreKaratopuk-3            : ok=72   changed=0    unreachable=0    failed=0    skipped=0    rescued=0    ignored=0   

+ ansible all -b -m reboot -a test_command=uptime
EmreKaratopuk-2 | CHANGED => {
    "changed": true,
    "elapsed": 41,
    "rebooted": true
}
EmreKaratopuk-3 | CHANGED => {
    "changed": true,
    "elapsed": 41,
    "rebooted": true
}
EmreKaratopuk-1 | CHANGED => {
    "changed": true,
    "elapsed": 42,
    "rebooted": true
}
+ ansible-playbook infra.yaml --diff

PLAY [Initial setup] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Update APT cache] *************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Download certificates] ********************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Install prometheus node exporter] *********************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Modify rsyslog conf file] *****************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Create backup user] ***********************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Add backup server to known hosts] *********************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Create restore directory] *****************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

TASK [init : Install duplicity] ************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [init : Install dnspython] ************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

PLAY [Bind server] *************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [bind : Install bind9] ****************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [bind : Configure bind9 files] ********************************************
ok: [EmreKaratopuk-3] => (item=None)
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-3] => (item=None)
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-1]

TASK [bind : Configure master zone] ********************************************
skipping: [EmreKaratopuk-1] => (item=istikbal.ek) 
skipping: [EmreKaratopuk-1] => (item=168.192.in-addr.arpa) 
skipping: [EmreKaratopuk-2] => (item=istikbal.ek) 
skipping: [EmreKaratopuk-2] => (item=168.192.in-addr.arpa) 
ok: [EmreKaratopuk-3] => (item=istikbal.ek)
ok: [EmreKaratopuk-3] => (item=168.192.in-addr.arpa)

TASK [bind : Install prometheus-bind-exporter] *********************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [bind : Start bind9 and exporter] *****************************************
ok: [EmreKaratopuk-2] => (item=bind9)
ok: [EmreKaratopuk-1] => (item=bind9)
ok: [EmreKaratopuk-3] => (item=bind9)
ok: [EmreKaratopuk-2] => (item=prometheus-bind-exporter)
ok: [EmreKaratopuk-3] => (item=prometheus-bind-exporter)
ok: [EmreKaratopuk-1] => (item=prometheus-bind-exporter)

TASK [bind : Run handlers] *****************************************************

TASK [Add A records] ***********************************************************
skipping: [EmreKaratopuk-1] => (item={'key': 'backup', 'value': '192.168.42.132'}) 
skipping: [EmreKaratopuk-1] => (item={'key': 'google', 'value': '8.8.8.8'}) 
skipping: [EmreKaratopuk-2] => (item={'key': 'backup', 'value': '192.168.42.132'}) 
skipping: [EmreKaratopuk-2] => (item={'key': 'google', 'value': '8.8.8.8'}) 

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [Add NS records] **********************************************************
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-3) 
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-1) 
skipping: [EmreKaratopuk-1] => (item=EmreKaratopuk-2) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-3) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-1) 
skipping: [EmreKaratopuk-2] => (item=EmreKaratopuk-2) 

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Configure DNS settings for both] *****************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

TASK [config-dns : Stop systemd-resolved] **************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

TASK [config-dns : Change resolv.conf content] *********************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

PLAY [Prometheus server] *******************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Install Prometheus] *****************************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Adjust Prometheus service] **********************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Add data source VMs] ****************************************
ok: [EmreKaratopuk-3]

TASK [prometheus : Start prometheus] *******************************************
ok: [EmreKaratopuk-3]

TASK [Add prometheus A record] *************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Database server] *********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Install mysql] ***************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Listen public] ***************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Start mysql] *****************************************************

TASK [mysql : Install python3-pymysql] *****************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Add agama database] **********************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : MySQL user] ******************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Configure mysql exporter credentials] ****************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Create mysql exporter user] **************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Install prometheus-mysqld-exporter] ******************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Export replica status] *******************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Add mysql replication user] **************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Configure mysql dynamic variables for replica] *******************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Create backup and restore directories for mysql] *****************
ok: [EmreKaratopuk-2] => (item=mysql)
ok: [EmreKaratopuk-1] => (item=mysql)
ok: [EmreKaratopuk-2] => (item=restore/mysql)
ok: [EmreKaratopuk-1] => (item=restore/mysql)

TASK [mysql : Create mysql backup user] ****************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Create backup user credentials to access mysql] ******************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [mysql : Start mysql and prometheus services] *****************************
ok: [EmreKaratopuk-2] => (item=mysql)
ok: [EmreKaratopuk-1] => (item=mysql)
ok: [EmreKaratopuk-2] => (item=prometheus-mysqld-exporter)
ok: [EmreKaratopuk-1] => (item=prometheus-mysqld-exporter)

TASK [mysql : Create scheduled mysql backup task with cron] ********************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [Add mysql A records] *****************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

PLAY [influxDB server] *********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Create influxdb directory] ************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Download influxdb] ********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Install influxdb] *********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Configure influxdb] *******************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Activate influxdb] ********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Get telegraf key] *********************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Get telegraf source with apt] *********************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Install telegraf from source] *********************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Configure telegraf] *******************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Download influxdb exporter] ***********************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Create influxdb-exporter service] *****************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Restart systemctl daemon] *************************************
ok: [EmreKaratopuk-3]

TASK [influxdb : Start prometheus-influxdb-stats-exporter and telegraf] ********
ok: [EmreKaratopuk-3] => (item=prometheus-influxdb-stats-exporter.service)
ok: [EmreKaratopuk-3] => (item=telegraf.service)

TASK [influxdb : Create backup and restore directories for influxdb] ***********
ok: [EmreKaratopuk-3] => (item=influxdb)
ok: [EmreKaratopuk-3] => (item=restore/influxdb)

TASK [influxdb : Create scheduled influxdb backup task with cron] **************
ok: [EmreKaratopuk-3]

TASK [Add influxdb A record] ***************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Docker server] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [docker : Install docker] *************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

TASK [docker : Start docker] ***************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

PLAY [Pinger server] ***********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Install fping] **************************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Create pinger user] *********************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Add pinger source code] *****************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Add pinger service] *********************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Restart systemctl daemon] ***************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Create pinger folder] *******************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Add pinger conf] ************************************************
ok: [EmreKaratopuk-3]

TASK [pinger : Start pinger] ***************************************************
ok: [EmreKaratopuk-3]

PLAY [Grafana server] **********************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]

TASK [grafana : Install Grafana via Docker] ************************************
ok: [EmreKaratopuk-3]

TASK [grafana : Create volume directories] *************************************
ok: [EmreKaratopuk-3] => (item=dashboards)
ok: [EmreKaratopuk-3] => (item=datasources)

TASK [grafana : Copy grafana configs to volume] ********************************
ok: [EmreKaratopuk-3]

TASK [grafana : Copy dashboards config to volume] ******************************
ok: [EmreKaratopuk-3]

TASK [grafana : Copy datasources config to volume] *****************************
ok: [EmreKaratopuk-3]

TASK [grafana : Copy all dashboards to volume] *********************************
ok: [EmreKaratopuk-3] => (item=main.json)
ok: [EmreKaratopuk-3] => (item=mysql.json)
ok: [EmreKaratopuk-3] => (item=syslog.json)

TASK [Add grafana A record] ****************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-3] => (item=EmreKaratopuk-3)

PLAY [Agama server] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [agama : Create agama volume directory] ***********************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [agama : Download agama files] ********************************************
ok: [EmreKaratopuk-2] => (item=agama.py)
ok: [EmreKaratopuk-1] => (item=agama.py)
ok: [EmreKaratopuk-2] => (item=Dockerfile)
ok: [EmreKaratopuk-1] => (item=Dockerfile)

TASK [agama : Create agama docker image] ***************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [agama : Start agama docker container] ************************************
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-2] => (item=None)
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1] => (item=None)
ok: [EmreKaratopuk-1]

TASK [agama : List running agama containers] ***********************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [agama : Stop unnecessary agama containers] *******************************

TASK [Add agama A records] *****************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

PLAY [Nginx server] ************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [nginx : Install nginx] ***************************************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [nginx : Configure nginx frontend service] ********************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-1]

TASK [nginx : Install prometheus-nginx-exporter] *******************************
ok: [EmreKaratopuk-3]
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [nginx : Start nginx and exporter] ****************************************
ok: [EmreKaratopuk-2] => (item=nginx)
ok: [EmreKaratopuk-3] => (item=nginx)
ok: [EmreKaratopuk-1] => (item=nginx)
ok: [EmreKaratopuk-2] => (item=prometheus-nginx-exporter)
ok: [EmreKaratopuk-3] => (item=prometheus-nginx-exporter)
ok: [EmreKaratopuk-1] => (item=prometheus-nginx-exporter)

PLAY [HAProxy] *****************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Install HAProxy] ***********************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [Add haproxy A records] ***************************************************

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)

TASK [dns_record : Add DNS record] *********************************************
ok: [EmreKaratopuk-1] => (item=EmreKaratopuk-3)
ok: [EmreKaratopuk-2] => (item=EmreKaratopuk-3)

TASK [haproxy : Add haproxy configuration] *************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Start HAProxy] *************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [haproxy : Install prometheus-haproxy-exporter] ***************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [haproxy : Start prometheus-haproxy-exporter] *****************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [haproxy : Configure prometheus-haproxy-exporter] *************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

PLAY [Keepalived] **************************************************************

TASK [Gathering Facts] *********************************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : set_fact] ***************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : set_fact] ***************************************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Install keepalived] *****************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Create keepalived_script user] ******************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Copy check script for keepalived] ***************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Copy keepalived config] *************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Start keepalived] *******************************************
ok: [EmreKaratopuk-2]
ok: [EmreKaratopuk-1]

TASK [keepalived : Download keepalived exporter] *******************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Create keepalived exporter service] *************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Restart systemctl daemon] ***********************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

TASK [keepalived : Start keepalived exporter service] **************************
ok: [EmreKaratopuk-1]
ok: [EmreKaratopuk-2]

PLAY RECAP *********************************************************************
EmreKaratopuk-1            : ok=74   changed=0    unreachable=0    failed=0    skipped=4    rescued=0    ignored=0   
EmreKaratopuk-2            : ok=74   changed=0    unreachable=0    failed=0    skipped=4    rescued=0    ignored=0   
EmreKaratopuk-3            : ok=72   changed=0    unreachable=0    failed=0    skipped=0    rescued=0    ignored=0   

+ date
Tue Jan  9 11:24:17 EET 2024