Confluence docker:无法连接到mysql

Question

我(仍然)尝试通过docker和docker-mysql文件设置confluence。

当我将confluence作为服务运行时，我可以很好地连接到我的数据库。

​

​

当我尝试通过docker-compose对我的docker-container执行同样的操作时，我得到了：

SQLState - 08S01
com.mysql.jdbc.exceptions.jdbc4.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.

这是我的docker构图：

version: '2'

services:
  confluence:
    image: eugenmayer/confluence:7.4.0
    build:
      context: ./
      args:
        CONFLUENCE_VERSION: 7.4.0
    container_name: confluence
    volumes:
      - confluencedata:/var/atlassian/confluence
    ports:
      - '80:8090'
      - '8091:8091'
    environment:
      - CONFLUENCE_DB_HOST=db
      - CONFLUENCE_DB_PORT=3306
      - CATALINA_OPTS=-Xms256m -Xmx1g
      - CONFLUENCE_PROXY_NAME=
      - CONFLUENCE_PROXY_PORT=
      - CONFLUENCE_PROXY_SCHEME=
      - CONFLUENCE_DELAYED_START=
      # those are preconfigurations so that we do not need to set our DB creds when installing - you can also
      # no use that and do it manually during the interactive installation
      # TODO: even though it lands in the configuration it seems to not really picked up by confluence during the installation
      - CONFLUENCE_CONFIG_PROPERTY1=hibernate.connection.driver_class
      - CONFLUENCE_CONFIG_VALUE1=org.mysql.Driver
      - CONFLUENCE_CONFIG_PROPERTY2=hibernate.connection.password
      - CONFLUENCE_CONFIG_VALUE2=jellyfish
      - CONFLUENCE_CONFIG_PROPERTY3=hibernate.connection.url
      - CONFLUENCE_CONFIG_VALUE3=mysql://confluencedb@db/confluencedb?sessionVariables=tx_isolation='READ-COMMITTED'
      - CONFLUENCE_CONFIG_PROPERTY4=hibernate.connection.username
      - CONFLUENCE_CONFIG_VALUE4=confluencedb
      #- CONFLUENCE_CONFIG_PROPERTY1=confluence.setup.server.id
      #- CONFLUENCE_CONFIG_VALUE1=BDYQ-V8CF-XUYW-DIWK
volumes:
  confluencedata:
    external: false
  postgresqldata:
    external: false

我刚接触docker，我不知道它为什么要这么做。将confluence作为服务运行并不是最好的，至少也是我使用的最后一种手段

下面是db的docker组合：

version: '3.3'
services:
  db:
    image: mysql:5.7
    command: --character-set-server=utf8 --collation-server=utf8_general_ci
    restart: always
    environment:
      MYSQL_DATABASE: bachelorarbeit_database
      # So you don't have to use root, but you can if you like
      MYSQL_USER: horizon
      # You can use whatever password you like
      MYSQL_PASSWORD: 1P@ssw0rt123
      # Password for root access
      MYSQL_ROOT_PASSWORD: P@ssw0rt
      MYSQL_ROOT_USER: root
    ports:
      # <Port exposed> : < MySQL Port running inside container>
      - '3310:3306'

Answer 1

如果你不坚持使用Postgres DB，你可以使用MySQL。如果你可以改变数据库，我可以为你提供一个工作的docker-compose

version: '3.8'

volumes:
  pgdata:

services:
  confluence:
    depends_on:
      - postgres
    image: atlassian/confluence-server:${CONFLUENCE_VERSION:?err}
    volumes:
      - ./data/confluence:/var/atlassian/application-data/confluence:rw,cached
    ports:
      - "127.0.0.1:8090:8090"
      - "127.0.0.1:8091:8091"
    environment:
      - JVM_MINIMUM_MEMORY=1024m
      - JVM_MAXIMUM_MEMORY=1024m
      - JVM_SUPPORT_RECOMMENDED_ARGS=${DEBUG} ${MINIFICATION} ${PLUGIN_TIMEOUT} ${MAIL}
      - ATL_DB_DRIVER=org.postgresql.Driver
      - ATL_DB_TYPE=postgresql
      - ATL_JDBC_URL=jdbc:postgresql://postgres:5432/${DB:?err}
      - ATL_JDBC_USER=${DB_USER:?err}
      - ATL_JDBC_PASSWORD=${DB_PASSWORD:?err}

  postgres:
    image: postgres:${POSTGRES_VERSION:?err}
    volumes:
      - pgdata:/var/lib/postgresql/data:cached
    ports:
      - "127.0.0.1:6543:5432"
    environment:
      - POSTGRES_DB=${DB:?err}
      - POSTGRES_USER=${DB_USER:?err}
      - POSTGRES_PASSWORD=${DB_PASSWORD:?err}

使用的变量存储在docker-compose文件旁边的.env文件中

CONFLUENCE_VERSION=7.7.2
POSTGRES_VERSION=9.6

PLUGIN_TIMEOUT=-Datlassian.plugins.enable.wait=120
#MAIL=-Datlassian.mail.senddisabled=true -Datlassian.mail.fetchdisabled=true -Datlassian.mail.popdisabled=true

DB=confluence772
DB_USER=confdbuser
DB_PASSWORD=passw0rd

postgres和confluence的版本在.env文件中设置。

用docker-compose up -d运行它，用docker-compose stop停止它

您可以使用docker-compose exec --user root confluence /bin/bash在confluence中执行根shell，也可以使用docker-compose exec --user confluence confluence /bin/bash执行普通shell

Answer 2

您为什么要使用3310连接到mysql? 3306是它的标准端口。

Answer 3

在MySQL图像的定义中，有曝光的3310作为DB端口。但是，融合定义提到了3306，而JDBC字符串省略了端口，因此使用相同的端口。

此外，上面关于docker network的评论将使其复杂化。