关于码头/维护者的osTicket

Question

我已经尝试让osTicket在码头/维护者上运行了几天了。但这行不通。我创建了自己的模板：

version: '2'

services:
   db:
     image: mysql:5.7
     volumes:
       - db_data:/var/lib/mysql
     restart: always
     environment:
       MYSQL_ROOT_PASSWORD: ${MYSQL_DATABASE_PASSWORD}
       MYSQL_DATABASE: osticket
       MYSQL_USER: osticket
       MYSQL_PASSWORD: osticket_pw_123_!

   osticket:
     image: osticket/osticket
     ports:
       - 80
     restart: always
     environment:
       MYSQL_DB_HOST: db:3306
       MYSQL_USER: osticket
       MYSQL_ROOT_PASSWORD: ***
       MYSQL_PASSWORD: ***
  
volumes:
    osticket_data:

当我在浏览器中调用osTicket容器时，会出现“无法连接到服务器”。

mySQL容器正在运行，并指出：

2022-02-02T14:32:52.779089Z 0 [Note] mysqld: ready for connections.

osTicket容器正在运行，并指出：

Install/Update osTicket
Configuring mail settings
OSTicket cron job is set to run every 5 minutes
Using external MySQL connection
Waiting for database TCP connection to become available...

网络看起来也不错..。

Containers in network:
osticket_osticket_1  172.19.0.3/16
osticket_db_1       172.19.0.2/16

为什么他们找不到对方？为什么osTicket容器没有响应？

非常非常感谢你的帮助！

Answer 1

我的自定义堆栈：

version: '2'

services:
mysql:
image: mysql:5.7
volumes:
- db_data:/var/lib/mysql
restart: always
ports:
- 3306
expose:
- 3306
environment:
MYSQL_ROOT_PASSWORD: myrootpassword
MYSQL_DATABASE: osticket
MYSQL_USER: osticket
MYSQL_PASSWORD: osticket
healthcheck:
test: ["CMD", "mysqladmin" ,"ping", "-h", "localhost"]
timeout: 20s
retries: 10

osticket:
image: osticket/osticket:latest
ports:
- 80
restart: always
depends_on:
mysql:
condition: service_healthy
links:
- mysql:db
environment:
MYSQL_ALLOW_EMPTY_PASSWORD: "yes"
MYSQL_HOST: mysql
MYSQL_PORT: 3306
MYSQL_USER: osticket
MYSQL_PASSWORD: osticket

volumes:
db_data:

看这里：：https://www.bluestonedesign.de/faq/19-software-tools/698-osticket-in-portainer-docker