I feel completely stupid. Tried to use Docker to install (run) an app on my linux machine. I failed. The story should've had a happy ending with localhost:8080/libreplan leading me to libreplan screen. It didn't happen. Is there a nice tutorial about using docker to run apps? It has to be very simple. Something like Docker for Dummies but dumber. Way dumber.
@paladin make sure you’re opening ports (docker run -p 8080 image) and/or your firewall isn’t blocking it
The parameters in this file are correct:
For anyone not familiar with Liquibase, it's a Java library to set up a database schema automatically. It uses a cross-db schema definition language. The setup SQL is the final product of running liquibase (for MySQL).
The mainstream paradigm is that if your liquibase-using program starts up and finds an empty database, it should set it up.
@paladin @blueberry Here's what you would run against a MySQL or MariaDB database to set it up:
It's just plain SQL/DDL, so you just need to run the script against the database. There's a variety of ways to do this. For each database there's a command line utility to run SQL, there's usually a nice GUI tool, and many have a website associated with the database that you can navigate to. There's also some generic tools for this, but I don't know what is good.
@paladin @blueberry That said, there's a good chance that their documentation is misleading about this whole "needing to run a SQL setup script" thing and Liquibase will just handle it for you on startup.
If I were you, I would just clean everything back to square one, run docker-compose again like you did last time, and then just navigate to the site to see if it worked automatically.
If that fails, then go see if the database is the issue and if you need to run that script.
Hi ... I can't work this out... It is like there is always: use docker compose or do it manually ... https://github.com/LibrePlan/docker-images/issues/6
This is my docker compose file:
That said, follow the instructions here: https://cryptpad.fr/code/#/2/code/view/sKjx8Iz3nrlSUoKM0CtggrWAX6zvOtLFt6qNXhsLrSM/
@urusan If I understod correctly I can go with docker compose and use the install.sql file
manually create two containers
Is this so or?
@paladin So, with your current docker-compose file, it's mounting the ./sql folder (which is supposed to have install.sql inside it) into a folder in your database, which will autorun on (first) startup.
./sql is going to be the sql folder inside whatever directory you run `docker-compose up` from.
So, it sounds like you just need to make a sql folder to put the install.sql file into, so it can be mounted properly.
@paladin It's also possible to mount a single file, if you give the full path of the file on both sides of the mount definition:
That would mount just the install.sql file from the current directory into that folder.
@paladin Oh, and yes, both of those are viable options.
Manually creating 2 containers would require install.sql btw.
That said, another option is to make a Dockerfile that loads install.sql permanently into the database image.
I would personally go with docker-compose though.
@paladin By the way, I just noticed your database died. Any idea why it died?
Of particular importance is making sure you fed it the right install.sql. The postgres version is in a different dialect and thus won't be understandable to a MySql database.
MySQL and MariaDB are more common, but also more old fashioned and idiosyncratic. Also, the split is because Oracle acquired MySQL.
Really it doesn't matter all that much though, databases are usually used behind abstraction layers.
@paladin @blueberry MariaDB seems to have a long list of generic db tools https://mariadb.com/kb/en/graphical-and-enhanced-clients/
Also, don't forget the command line tools, especially since they can be scripted.
I saw your post yesterday but was too busy to help properly between work and childcare, but with it being vague I didn't have much to go on.
Let us know if you hit another roadblock. It sounds like you are making good progress though. :)
Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.