Consul connect connected but no communicate

[fred-gb]

Hello,

MariaDB installed on backend001 with consul connect enable. I see it in Consul Dashboard.

But I cannot join it with mysql -u root -pXXXXX -h 127.0.0.1

On mariadb container, no problem with my password:

On job test I created:

job "tester" {
  datacenters = ["dc1"]
  region = "global"
  type = "service"
    group "app" {
        task "wait-order" {
            driver = "docker"

            config {
            image = "alpine"
            command = "/bin/sleep"
            args    = ["3600"]
            }
        }

        network {
        mode = "bridge"

        }

        service {
            name = "database-sidecar"

            connect {
                sidecar_service {
                    proxy {
                    upstreams {
                        destination_name = "database"
                        local_bind_port  = 3306
                        }
                    }
                }
            }
        }
    }
}

is connected as you can see, but, when I tried:

I installed mariadb-client on connect-proxy-mariadb hovewer I have this error:

Where I can looking for to find my error?
Thanks

[fred-gb]

I try this:

 consul connect proxy -service mariadb-test -upstream database:3306
==> Consul Connect proxy starting...
    Configuration mode: Flags
               Service: mariadb-test
              Upstream: database => :3306
       Public listener: Disabled

==> Log data will now stream in as it occurs:

    2021-11-24T14:11:54.993Z [INFO]  proxy: Starting listener: listener=127.0.0.1:3306->service:default/database bind_addr=127.0.0.1:3306
    2021-11-24T14:11:55.118Z [INFO]  proxy: Proxy loaded config and ready to serve
    2021-11-24T14:11:55.121Z [INFO]  proxy: Parsed TLS identity: uri=spiffe://cdc8e098-1388-6ce6-ec82-5a5f6d07339f.consul/ns/default/dc/dc1/svc/mariadb-test roots=[pri-dqlq2mm.consul.ca.cdc8e098.consul]

    2021-11-24T14:14:50.769Z [ERROR] proxy.upstream: failed to dial: error="no healthy instances found

And single test return:

 mysql -u root -p -h 127.0.0.1
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 11

in logs:

    2021-11-24T14:14:50.769Z [ERROR] proxy.upstream: failed to dial: error="no healthy instances found

Why?!

[fred-gb]

Dumb… I can get badge for this…

I wrote the wrong service name, database instead real name: mariadb.