Setting up mySQL/mariadb for osTicket on unRAID docker.
I am having some issues setting up a osTicket docker that requires mySQL or mariadb to be running. I've tried to have either container running at the same time but I must have configured something wrong, or just not configured it correctly.
106 Replies
have you ckecked this video? https://youtu.be/fb72g7qurKc?si=EXE0U4-3Wyr2B6ui
Jiansen Lu
YouTube
Install OSticket in localhost with XAMPP
XAMPP:
https://www.apachefriends.org/download.html
OSticket download:
http://osticket.com/editions
Installation
http://osticket.com/wiki/Installation
1) C:\xampp\php\php.ini
uncomment
extension=php_imap.dll
2) go to (replace localhost:8080 to your web server name)
http://localhost:8080/phpmyadmin/
create MySQL database and user
3) upzip ostick...
if you're setting it up for production, I would recommend not using xampp.
if it's just to play with or test then it's fine
I is mainly for small family use, I think it would be interesting to have a system like this so my friends and family can ask me for help. Purely just for fun.
I have not tried this nor seen this video, I'll give it a look.
then xampp might work for you
yeah, xampp is easier to use for test env stuff, but I've had countless databases get corrupted from its shenanigans
and also the database password being root by default lol
I think it's root@localhost with no pass by default :P
o wait it's not root, it's blank even worse
every fivem server ever uses xampp. I keep having to tell my clients to stop lol
which alternatives do you suggest
I am only familiar with xampp
just straight up mariadb
xampp uses an outdated version of maria, so running maria in docker or installed as a service is best
I think I set up databases for dart using mariadb in 2023
but I am not sure
I did all using codes on the terminal
yeah, I normally just install maria on linux so that's the ez pz way
That sounds... quite unsecure.
it is indeed 😂
like I said, xampp is kinda shit lol
but it's root@localhost so, not that bad as long as you don't open it to external connections
So it is likely that I just did not configure maria properly?
So good for testing, bad for internet. Got it.
uhh
id imagine it was a docker network issue
exactly
docker likes to use the internal docker network, so you gotta tell it to allow outside connections
:nerd_dog:☝️I sure do love my applications to run unsecure with no password and exposed to the internet
specially if you have sensitive information
I haven't used docker too much because it confuses me sometimes
-# I should figure it out soon
I think I like working with databases more than I like programming with python
I'm more of a hardware tech, all this docker this and unraid that is just becasue I wanted to have more space for my nas but I didn't want to be forced to use the same sized drives.
So, I don't really know anything. My buddy explained IPv4 and IPv6 the other day and that is when I learned it's all still just 8bit..byte?
Like I know the purpose of it but he works in IT so he explained the whole backend nonsense
😵💫
it is a skill many don't have to explain things in a way people will understand and not go into too much detail lol
the thing about ipv4 is that it can only hold up to 4.3 billion accesses, that's why they created ipv6 which can handle 16 undecillion adresses
Yes, which is a word I've not heard of till that day LMAO
I don't think that humanity will ever reach this number of addresses lol
-# unless i get involved
and every byte = 8 bits btw
ipv4 is 32 bits so 4 bytes
ipv6 is 128 bits so 16 bytes
now I wonder why did they skip ipv5
also what're you using docker for?
osticket doesn't have an official docker image
It has a, fork on the unraid community apps tab. Is there another simple ticket app that you'd recommend that does have official docker image?
This is something I made my coworker think of the other day.
you need it to use docker?
It's easier if it's in a docker container. I could technically run it in a VM. I didn't necessarily want to go through all that extra effort though.
hmm, maybe this is the official one
did you put the mysql info in the env vars
I did not, it had entries for it in the docker builder.
https://hub.docker.com/r/osticket/osticket#quick-start
yeah just make sure the osticket container has the mysql info in its env
I'll give that a run tomorrow.
:keking:
Can I run multiple applications to a single mySQL database?
I checked and basically when they created the ipv5 they used 32 bits again, so it would be the same thing as ipv4, so instead of modifing it they just ignored and jumped to ipv6 lol
one maria container can run multiple databses
We figured the same thing, insider testing and rather than remaking it. They made something new.. and now its hexadecimal
:AngryCry:
i wouldn't put multiple apps in one db tho
does it lower the performance?
not that im aware of, unless it's got tons of reads / writes
Just for neatness of data, or personal preference?
organization and security
Or is it more, severe where if something for some reason. Breaks the DB, goodbye everything.
you def dont want one table for one app and another table for a different one.
if they're all in the same db, if one app gets breached or leaks data, it can involve everything else too
vs one db per app, they each have their own users, passwords, perms, etc
This approach is better, the only downside is if the admin forgets the passwords 😂
hey thats what the root user is for :kek:
So can mariadb run multiple databases in a way that would be secure? Or would you reckon running a VM to have dedicated to just running different db?
I completly forgot lol
smart guy
that Maria guy is very smart
yeah you can run one maria install with several db's. each db gets its own user and pass, so its more secure that way
can even restrict it so the IP of one app can access one db but not the other
just make sure you set the user perms right.
you can make one user have access to everything, like root, but that's not wise
if you're still learning mysql and how databases work, take a look at heidi or phpmyadmin
I will give that a look, I'll try setting up MariaDB again. I do greatly appreciate both of your time, patience, and effort.
I do have one more thing to say though, @Bulaxa.
I've been learning JS for discord botting.
interesting
botting as in making a discord bot or self botting
:sus:
Discord bot, I aint no tos breaker
:anerd:
:kek:
I know a skid who does self botting
but I don't talk to him since june
i like JS, TS is better tho
I only bring it up due to the anti Java pfp :irlwtf:
Worry not, JS is not even close to Java in suckness
all my homies hate java
js and java are def not the same :P
All the stuff I learn is purely for fun. My career is RF Technican, which is all hands on and none of it relies on ANYTHING I choose to learn in my free time LMAO.
btw I gotta check if there is any IDE for JS that points out when you forget a semi-colon or comma
Oh, I sort of assumed that they were. :wat:
vscode
what kinda rf, 5g?
it does????
i sure hope so
Vscode my beloved
I remember struggling with it in 2023
:(((((
maybe they updated
pretty sure its always done it
shit it can even do lua
I believe the Samsung run 5G, but the stuff that I work on is 3G & 4G LTE. Most of it is retired from around where 5G is being installed. Then sent to places without cell service.
relevant meme
Real and accurate
Except its all a bunch of old men going bald
literally my last roomie lmao
she does the cad shit for planning new towers and then goes out to the sites for stuff
Based
I don't know if I wish to have a roomie, since it can be luck based
giant booba
yeah ive had good and bad roomies
Is this because of the CAD designing?
idk maybe she designed them in cad
she jokes that the 5g made her trans tho
:laughs:
I'd believe it.
Did you guys know that NOKIA, also makes radio heads?
Did you also know that they do not hold the same quality as their phones and are, in fact, giant pieces of shit?
lmao
i have heard
why did people stop using flip phones
they are so cool
they're starting to use em again
Samsung us
Galaxy Z Flip7 | AI Flip Phone | Samsung US | Samsung US
Flip into style and performance with Galaxy Z Flip7—featuring a 50MP selfie camera, a sleek, durable design, and the most powerful Galaxy AI tools yet.
Oh yeah, tower cad trans giant boob roommate
her wife got a news article about her boobs 😭
WHAAAAAT
:flabbergasted:
🤣
I am looking forward to buy a simple flip phone when my samsung breaks, I am tired of it falling from my pockets
anime high school student mode
i studied wifi so im the exact inverse
:brainless:
i know a bit about rf and a lot about networking
i could study rf if i wanted to, i kinda do want to
but it wouldn't help me with my education or work prospects much
I know more about troubleshooting and the ins and outs of components than I do actual RF theory.
All I know is RF fucking despises being contained
It wishes to be free
And will destroy anything and everything to be free
"fuck you man, CURSE OF FARADAY CAGE :jail:"
what kind of NAS are you using? i hope it's not Synology :cringe:
Home built, used to be UGREEN. Now it's a Intel i5-10500T
Running unRAID
Because oh my god I hate being forced to purchase the same size drives
The UGREEN NAS is actually sitting on the floor not too far from me now. Its just bone dry and left for scraps now.
Sadly I bought the two bay model, and not something with more bays.
Also yes, the peerless ass ass in is the only thing I had laying around
sunset_digital_team
Зяглядывай в тгк 👾
Там ещё больше контента...
#айтимемы #SunsetIT #java #python #вебразработка #итмемы #javavspython #мемы
Likes
101493
Instagram
:bigkek: