Lanic0r Posted December 27, 2023 Share Posted December 27, 2023 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. Quote Link to comment
fergalc Posted January 3 Share Posted January 3 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? Quote Link to comment
Lanic0r Posted January 4 Author Share Posted January 4 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? Quote Link to comment
Lanic0r Posted January 4 Author Share Posted January 4 == 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) Quote Link to comment
fergalc Posted January 23 Share Posted January 23 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' Quote Link to comment
Recommended Posts
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.