The problem is, that even if the Mariadb database is fully running, reachable and loggable from ip 192.168.0.200, the haproxy 192.168.0.199 not correctly proxy requests to 192.168.0.200 with this error:
fatal: [localhost]: FAILED! => {"attempts": 6, "changed": false, "cmd": ["docker", "exec", "mariadb", "mysql", "-h", "192.168.0.199", "-P", "3307", "-u", "root", "-pRJQAihupg9j8iVEdD3FstlFt6lAH61Hlwb6ZARSA", "-e", "show databases;"], "delta": "0:00:00.157388", "end": "2022-02-03 23:06:00.035050", "msg": "non-zero return code", "rc": 1, "start": "2022-02-03 23:05:59.877662", "stderr": "ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11", "stderr_lines": ["ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11"], "stdout": "", "stdout_lines": []}
Inventory is the basic all-in-one with internal and external ips set, internal+external+backend tls enabled too
The problem is, that even if the Mariadb database is fully running, reachable and loggable from ip 192.168.0.200, the haproxy 192.168.0.199 not correctly proxy requests to 192.168.0.200 with this error:
fatal: [localhost]: FAILED! => {"attempts": 6, "changed": false, "cmd": ["docker", "exec", "mariadb", "mysql", "-h", "192.168.0.199", "-P", "3307", "-u", "root", "-pRJQAihupg9j8 iVEdD3FstlFt6lA H61Hlwb6ZARSA" , "-e", "show databases;"], "delta": "0:00:00.157388", "end": "2022-02-03 23:06:00.035050", "msg": "non-zero return code", "rc": 1, "start": "2022-02-03 23:05:59.877662", "stderr": "ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11", "stderr_lines": ["ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11"], "stdout": "", "stdout_lines": []}
Inventory is the basic all-in-one with internal and external ips set, internal+ external+ backend tls enabled too
Thank you for your answers!
PS: inventory file in the attachments