YyTUHD6h

1$ debops service/mariadb_server -l mariadb.stefanselbach.com  --skip-tags role::ferm 
2Running Ansible playbook from:
3/home/sgw/.local/share/debops/debops/ansible/playbooks/service/mariadb_server.yml ...
4[DEPRECATION WARNING]: The use of 'include' for tasks has been deprecated. Use 'import_tasks' for static inclusions or 'include_tasks' for dynamic inclusions. This feature will be removed in a future release. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
5[DEPRECATION WARNING]: include is kept for backwards compatibility but usage is discouraged. The module documentation details page may explain more about this rationale.. This feature will be removed in a future release. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
6 [WARNING]: Could not match supplied host pattern, ignoring: debops_mariadb_server
7
8
9PLAY [Manage MariaDB server] *************************************************************************************************************************************************************************************************************************************************************************************************
10
11TASK [Gathering Facts] *******************************************************************************************************************************************************************************************************************************************************************************************************
12ok: [mariadb.stefanselbach.com]
13
14TASK [debops.tcpwrappers : debug] ********************************************************************************************************************************************************************************************************************************************************************************************
15ok: [mariadb.stefanselbach.com] => {
16    "tcpwrappers__dependent_allow": []
17}
18
19TASK [debops.tcpwrappers : Install required packages] ************************************************************************************************************************************************************************************************************************************************************************
20ok: [mariadb.stefanselbach.com] => (item=libwrap0)
21
22TASK [debops.tcpwrappers : Make sure /etc/hosts.allow.d directory exists] ****************************************************************************************************************************************************************************************************************************************************
23ok: [mariadb.stefanselbach.com]
24
25TASK [debops.tcpwrappers : Create /etc/hosts.allow.d/00_ansible] *************************************************************************************************************************************************************************************************************************************************************
26ok: [mariadb.stefanselbach.com]
27
28TASK [debops.tcpwrappers : Divert original /etc/hosts.allow] *****************************************************************************************************************************************************************************************************************************************************************
29changed: [mariadb.stefanselbach.com]
30
31TASK [debops.tcpwrappers : Allow access from Ansible Controller to sshd] *****************************************************************************************************************************************************************************************************************************************************
32ok: [mariadb.stefanselbach.com]
33
34TASK [debops.tcpwrappers : Remove hosts.allow entries if requested] **********************************************************************************************************************************************************************************************************************************************************
35skipping: [mariadb.stefanselbach.com] => (item={u'comment': u'Access from localhost', u'daemon': u'ALL', u'client': [u'127.0.0.0/8', u'::1/128'], u'weight': u'06', u'filename': u'allow_localhost'}) 
36
37TASK [debops.tcpwrappers : Generate hosts.allow entries] *********************************************************************************************************************************************************************************************************************************************************************
38ok: [mariadb.stefanselbach.com] => (item={u'comment': u'Access from localhost', u'daemon': u'ALL', u'client': [u'127.0.0.0/8', u'::1/128'], u'weight': u'06', u'filename': u'allow_localhost'})
39
40TASK [debops.tcpwrappers : Assemble hosts.allow.d] ***************************************************************************************************************************************************************************************************************************************************************************
41ok: [mariadb.stefanselbach.com]
42
43TASK [debops.tcpwrappers : Remove diversion of /etc/hosts.allow] *************************************************************************************************************************************************************************************************************************************************************
44skipping: [mariadb.stefanselbach.com]
45
46TASK [debops.tcpwrappers : Make sure that Ansible local fact directory exists] ***********************************************************************************************************************************************************************************************************************************************
47ok: [mariadb.stefanselbach.com]
48
49TASK [debops.tcpwrappers : Save tcpwrappers local facts] *********************************************************************************************************************************************************************************************************************************************************************
50ok: [mariadb.stefanselbach.com]
51
52TASK [debops.tcpwrappers : Configure access in /etc/hosts.deny] **************************************************************************************************************************************************************************************************************************************************************
53ok: [mariadb.stefanselbach.com]
54
55TASK [debops.secret : Create secret directories on Ansible Controller] *******************************************************************************************************************************************************************************************************************************************************
56
57TASK [debops.mariadb_server : debug] *****************************************************************************************************************************************************************************************************************************************************************************************
58ok: [mariadb.stefanselbach.com] => {
59    "mariadb_server__allow": [
60        "192.168.97.0/24", 
61        "172.20.95.0/24", 
62        "192.168.187.0/24", 
63        "172.32.99.0/24", 
64        "62.40.171.237"
65    ]
66}
67
68TASK [debops.mariadb_server : debug] *****************************************************************************************************************************************************************************************************************************************************************************************
69ok: [mariadb.stefanselbach.com] => {
70    "inventory__lan_list": [
71        "192.168.97.0/24", 
72        "172.20.95.0/24", 
73        "192.168.187.0/24", 
74        "172.32.99.0/24", 
75        "62.40.171.237"
76    ]
77}
78
79TASK [debops.mariadb_server : Check if database server is installed] *********************************************************************************************************************************************************************************************************************************************************
80ok: [mariadb.stefanselbach.com]
81
82TASK [debops.mariadb_server : Add custom APT GPG key] ************************************************************************************************************************************************************************************************************************************************************************
83skipping: [mariadb.stefanselbach.com] => (item=) 
84
85TASK [debops.mariadb_server : Add custom APT repository] *********************************************************************************************************************************************************************************************************************************************************************
86skipping: [mariadb.stefanselbach.com]
87
88TASK [debops.mariadb_server : Install database server packages] **************************************************************************************************************************************************************************************************************************************************************
89ok: [mariadb.stefanselbach.com] => (item=[u'python-mysqldb', u'ssl-cert', u'mariadb-server', u'automysqlbackup'])
90
91TASK [debops.mariadb_server : Add database server user to specified groups] **************************************************************************************************************************************************************************************************************************************************
92ok: [mariadb.stefanselbach.com]
93
94TASK [debops.mariadb_server : Check if MariaDB config directory exists] ******************************************************************************************************************************************************************************************************************************************************
95ok: [mariadb.stefanselbach.com]
96
97TASK [debops.mariadb_server : Ensure MariaDB data directory exists] **********************************************************************************************************************************************************************************************************************************************************
98ok: [mariadb.stefanselbach.com]
99
100TASK [debops.mariadb_server : Configure database client on first install] ****************************************************************************************************************************************************************************************************************************************************
101skipping: [mariadb.stefanselbach.com]
102
103TASK [debops.mariadb_server : Configure database server] *********************************************************************************************************************************************************************************************************************************************************************
104ok: [mariadb.stefanselbach.com]
105
106TASK [debops.mariadb_server : Setup automysqlbackup configuration] ***********************************************************************************************************************************************************************************************************************************************************
107ok: [mariadb.stefanselbach.com]
108
109TASK [debops.mariadb_server : Enable events table backup in mysqldump] *******************************************************************************************************************************************************************************************************************************************************
110ok: [mariadb.stefanselbach.com]
111
112TASK [debops.mariadb_server : Restart database server on first install] ******************************************************************************************************************************************************************************************************************************************************
113skipping: [mariadb.stefanselbach.com]
114
115TASK [debops.mariadb_server : Drop unnecessary root accounts] ****************************************************************************************************************************************************************************************************************************************************************
116ok: [mariadb.stefanselbach.com] => (item=127.0.0.1)
117ok: [mariadb.stefanselbach.com] => (item=::1)
118ok: [mariadb.stefanselbach.com] => (item=mariadb)
119
120TASK [debops.mariadb_server : Update database root password] *****************************************************************************************************************************************************************************************************************************************************************
121ok: [mariadb.stefanselbach.com]
122
123TASK [debops.mariadb_server : Create /root/.my.cnf file with root credentials] ***********************************************************************************************************************************************************************************************************************************************
124ok: [mariadb.stefanselbach.com]
125
126TASK [debops.mariadb_server : Delete anonymous database user] ****************************************************************************************************************************************************************************************************************************************************************
127ok: [mariadb.stefanselbach.com] => (item=mariadb)
128ok: [mariadb.stefanselbach.com] => (item=localhost)
129
130TASK [debops.mariadb_server : Remove test database on first install] *********************************************************************************************************************************************************************************************************************************************************
131skipping: [mariadb.stefanselbach.com]
132
133TASK [debops.mariadb_server : Make sure that local fact directory exists] ****************************************************************************************************************************************************************************************************************************************************
134ok: [mariadb.stefanselbach.com]
135
136TASK [debops.mariadb_server : Save MariaDB local facts] **********************************************************************************************************************************************************************************************************************************************************************
137ok: [mariadb.stefanselbach.com]
138
139TASK [debops.mariadb_server : Re-read local facts if they have been modified] ************************************************************************************************************************************************************************************************************************************************
140skipping: [mariadb.stefanselbach.com]
141
142PLAY RECAP *******************************************************************************************************************************************************************************************************************************************************************************************************************
143mariadb.stefanselbach.com  : ok=28   changed=1    unreachable=0    failed=0   
144
145Drop unnecessary root accounts ------------------------------------------ 3.65s
146Generate hosts.allow entries -------------------------------------------- 2.43s
147Create /etc/hosts.allow.d/00_ansible ------------------------------------ 2.27s
148Setup automysqlbackup configuration ------------------------------------- 2.16s
149Configure database server ----------------------------------------------- 2.14s
150Allow access from Ansible Controller to sshd ---------------------------- 2.03s
151Create /root/.my.cnf file with root credentials ------------------------- 1.94s
152Gathering Facts --------------------------------------------------------- 1.92s
153Save tcpwrappers local facts -------------------------------------------- 1.73s
154Delete anonymous database user ------------------------------------------ 1.57s
155Drop unnecessary root accounts ------------------------------------------ 3.65s
156Generate hosts.allow entries -------------------------------------------- 2.43s
157Create /etc/hosts.allow.d/00_ansible ------------------------------------ 2.27s
158Setup automysqlbackup configuration ------------------------------------- 2.16s
159Configure database server ----------------------------------------------- 2.14s
160Allow access from Ansible Controller to sshd ---------------------------- 2.03s
161Create /root/.my.cnf file with root credentials ------------------------- 1.94s
162Gathering Facts --------------------------------------------------------- 1.92s
163Save tcpwrappers local facts -------------------------------------------- 1.73s
164Delete anonymous database user ------------------------------------------ 1.57s