December 27, 20232 yr Hello, i would like to try out the Docker "oSTICKET" by acharles21. I cant get the Docker to work. Can someone explain me how to do it? I tried everything out but it seems like it isnt working with the mariadb or another Database Docker.
January 3, 20242 yr On 12/27/2023 at 6:41 PM, Lanic0r said: Hello, i would like to try out the Docker "oSTICKET" by acharles21. I cant get the Docker to work. Can someone explain me how to do it? I tried everything out but it seems like it isnt working with the mariadb or another Database Docker. I've got it working. Where is breaking down for you?
January 4, 20242 yr Author Wow, now im tense. Which docker you use for the database? What do you have written in the Docker config of osticket? MYSQL HOSTNAME: <- what do you have written in here? Do you have an tutorial for me?
January 4, 20242 yr Author == MANUAL INTERVENTION MAY BE REQUIRED IF UPGRADING FROM 1.16.3 OR EARLIER == 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... Waited for 15 seconds... Waited for 30 seconds... Waited for 45 seconds... Waited for 60 seconds... Waited for 75 seconds... Waited for 90 seconds... Waited for 105 seconds... Waited for 120 seconds... Waited for 135 seconds... Waited for 150 seconds... Waited for 165 seconds... Waited for 180 seconds... i dont know why he cant connect to the database. I tried only Port 3307 (Port mariadb) at MYSQL_Hostname and 192.xxx.xxx.xxx:3307 (Port mariadb)
January 23, 20242 yr 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'
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.