如何从Dockerized Spring Boot应用程序连接Docker DB？

Question

我是码头工具的初学者，并尝试学习，但我很难被卡住。

当我仅从docker-compose.yml运行DB并直接从IDE运行 dockerdeneme 的弹簧应用程序，然后它连接到db，没问题。但是，当我尝试从docker-compose.yml文件运行时，该应用程序无法连接到db。我的docker-compose.yml文件是：

version: '3.9'

services:
  mysql:
    platform: linux/amd64
    image: mysql:8
    container_name: mysqlcustomerdb
    domainname: nishcustomer
    hostname: localhost
    ports:
      - '3306:3306'
    volumes:
      - ~/apps/mysql:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=1234
      - MYSQL_PASSWORD=1234
      - MYSQL_DATABASE=mysqlcustomerdb
      - DATABASE_HOST=mysqlcustomerdb
      - MYSQL_ROOT_HOST=%
      - lower_case_table_names=1
      - init-connect='GRANT CREATE USER ON . TO 'root'@'%';FLUSH PRIVILEGES;'

  dockerdeneme:
    container_name: dockerdeneme
    domainname: nishcustomer
    hostname: localhost
    image: dockerdeneme
    build: ./
    ports:
      - '8080:8080'
    environment:
      - MYSQL_ROOT_PASSWORD=1234
      - MYSQL_PASSWORD=1234
      - MYSQL_USER=root
      - MYSQL_DATABASE=mysqlcustomerdb
    depends_on:
      - mysql
volumes:
  cache:
    driver: local

docker ps的结果是：

CONTAINER ID   IMAGE           COMMAND                  CREATED             STATUS             PORTS                               NAMES
fb0037e10702   mysql:8         "docker-entrypoint.s…"   22 seconds ago      Up 21 seconds      0.0.0.0:3306->3306/tcp, 33060/tcp   mysqlcustomerdb

的应用程序。

spring.datasource.url=jdbc:mysql://localhost:3306/mysqlcustomerdb
spring.datasource.username=root
spring.datasource.password=1234
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

如果我从IDE运行以下应用程序

2022-04-14 21:28:56.106  INFO 1 --- [           main] c.e.d.DockerdenemeApplication            : Starting DockerdenemeApplication v0.0.1-SNAPSHOT using Java 11.0.14.1 on localhost with PID 1 (/app.jar started by root in /)

2022-04-14 21:28:56.107  INFO 1 --- [           main] c.e.d.DockerdenemeApplication            : No active profile set, falling back to 1 default profile: "default"

2022-04-14 21:28:56.467  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.

2022-04-14 21:28:56.493  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 21 ms. Found 1 JPA repository interfaces.

2022-04-14 21:28:57.024  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)

2022-04-14 21:28:57.037  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]

2022-04-14 21:28:57.037  INFO 1 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.60]

2022-04-14 21:28:57.105  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext

2022-04-14 21:28:57.105  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 937 ms

2022-04-14 21:28:57.250  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...

2022-04-14 21:28:57.256  WARN 1 --- [           main] com.zaxxer.hikari.util.DriverDataSource  : Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.

2022-04-14 21:28:58.334 ERROR 1 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.


com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]

我想我在端口映射或主机名/域名中做错了什么，但我被卡住了。

有人可以告诉我我在做什么错，端口或主机名等吗？

Answer 1

Localhost不适用于Docker-Compose应用程序。作为摘要，请使用主机或配置良好的Docker网络的IP。检查：

• https://stackoverflow.com/a/a/52213178/39577754

请特别注意： extra_hosts ：

• 如何通过docker将API与Web Spa连接

在这里，您有类似的Docker-Compose和MySQL和WordPress：

• https://github.com/usil/wordpress-docker/blob/blob/master/master/docker-compose.yml