[Fiware-lab-help] Fiware Clooud: Docker swarm: service host is unreachable

[Julian Briggs]

Hi,

I have Fiware Labs Community and Fiware Cloud accounts .

I am deploying a Docker stack to a Docker swarm running on Fiware VMs.
See appended sections of my docker-compose.yaml

Services cannot see each other.
For example the adminer service cannot connect to the mysql service.

>From a shell in the adminer container
/var/www/html $ curl http://mysql:3306
curl: (7) Failed to connect to mysql port 3306 after 3075 ms: *Host is
unreachable*
/var/www/html $

adminer and mysql are both running on the same node: node0

Thanks
best regards
Julian

docker stack deploy -c docker-compose.yml -c docker-compose-mysql.yml -c
docker-compose-nginx.yml --with-registry-auth pvlive

# Docker Compose file for PV_Live: Docker Swarm: mysql and adminer
# Julian Briggs
# 2-feb-2022

version: '3.8'
services:
    mysql:
        cap_add:
          - SYS_NICE  # CAP_SYS_NICE (OK for kompose then kubectl apply)
        command: --default-authentication-plugin=mysql_native_password
        deploy:
          placement:
            constraints: [node.role == manager]
        #Env vars are ignored if you start the container with a data
directory that already contains a database.
        environment:
            MYSQL_ROOT_PASSWORD_FILE: /secrets/mysql_root_password_file
        image: mysql:8.0.27
        secrets:
        - source: mysql-root-password-file
          target: /secrets/mysql_root_password_file
        - source: mysqldefaults-root
          target: /secrets0/mysqldefaults.root
        volumes:
          - db-data:/var/lib/mysql
          - db-logs:/var/log/mysql
    adminer:
        deploy:
          placement:
            constraints: [node.role == manager]
        image: adminer
        labels:
            kompose.service.expose: /
        ports:
        - 8080:8080
secrets:
    mysql-root-password-file:
        file: ./secrets/MYSQL_ROOT_PASSWORD_FILE
    mysqldefaults-root: #needed for database-populate-sh utility
        file: ./secrets/mysqldefaults.root
volumes:
  db-data:
  db-logs:
--
Julian Briggs
Research Software Developer
Sheffield Solar
Physics & Astronomy
University of Sheffield
In line with government advice, I am currently working remotely.
My preferred method of contact is email.
My normal working hours are 9:30-5 Mon-Thu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-lab-help/attachments/20220202/545acebb/attachment.html>