0

I've been trying to get osTicket running on Docker / Portainer for a few days now. But it won't work. I created my own template:

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:

When I call the osTicket container in the browser, "Could not connect to the server" appears.

The mySQL container is running and says:

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

The osTicket container is running and says:

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...

The network looks good too...

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

Why can't they find each other? Why is the osTicket container not responding?

Many, many thanks for your help!

BlueStone
  • 11
  • 4

1 Answers1

0

My Custom Stack:

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:

[Look here:] [1]: https://www.bluestonedesign.de/faq/19-software-tools/698-osticket-in-portainer-docker

BlueStone
  • 11
  • 4