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

1. Docker Compose file for PV_Live: Docker Swarm: mysql and adminer
2. Julian Briggs
3. 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

__________________________________________________________________________________________

You can get more information about our cookies and privacy policies on the following links:

• https://fiware-legal.readthedocs.io/en/latest/PersonalDataProtectionPolicy.html
• https://fiware-legal.readthedocs.io/en/latest/FIWARECookiesPolicy.html

fiware-lab-help mailing list
fiware-lab-help@lists.fiware.org

To unsubscribe from fiware-lab-help mailing list, go to the information page of the list at:
https://lists.fiware.org/listinfo/fiware-lab-help

[Created via e-mail received from: Julian Briggs <julian.briggs@sheffield.ac.uk>]