sorry missed your reply.
ok, I got it up and running but ran into a number of issues so had to set it up on Windows/IiS then.
As you have outlined, with the default docker configs osTicket never connects to the database.
Here's how I got it going:
Install MariaDB container with default settings except I used custom network (192.xxx.xxx.225).
Then login into the containers console session and create a new user and database:
mysql -u root -p
CREATE USER 'osticket'@'192.xxx.xxx.9' IDENTIFIED BY 'password123456';
CREATE DATABASE osticketdb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on osticketdb.* TO 'osticket'@'192.xxx.xxx.9'; flush privileges;
Then install osTicket container with a custom network (192.xxx.xxx.9) and populate with the above details, in my case:
docker run
-d
--name='osTicket'
--net='br0'
--ip='192.xxx.xxx.9'
-e TZ="Europe/London"
-e HOST_OS="Unraid"
-e HOST_HOSTNAME="Tower"
-e HOST_CONTAINERNAME="osTicket"
-e 'TCP_PORT_80'='8080'
-e 'MYSQL_HOST'='192.xxx.xxx.225'
-e 'MYSQL_USER'='osticket'
-e 'MYSQL_DATABASE'='osticketdb'
-e 'MYSQL_PASSWORD'='password123456'
-e 'INSTALL_NAME'='My Helpdesk'
-e 'ADMIN_FIRSTNAME'='xxxxx'
-e 'ADMIN_LASTNAME'='xxxxxx'
-e 'ADMIN_EMAIL'='xxxxxx'
-e 'ADMIN_USERNAME'='Administrator'
-e 'MYSQL_PREFIX'='ost_'
-l net.unraid.docker.managed=dockerman
-l net.unraid.docker.webui='http://[IP]:[PORT:80]'
-l net.unraid.docker.icon='https://raw.githubusercontent.com/loony2392/unraid-templates/master/icons/osticket.png'
-v '/mnt/user/appdata/osticketofficical':'/var/www/src/':'rw' 'osticket/osticket'