Docker

My little page about getting docker to run, done by somebody having no idea what docker is.

Yeah, DAU-docker!

ATTENTION this uses default passwords, and is completely unsecure !!!!

First install docker

Create a database

# no idea what this does, I just pasted it from https://hub.docker.com/_/mysql/
docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:latest

Create a mediawiki

# well probably something like found here https://hub.docker.com/r/synctree/mediawiki/
docker run --name some-mediawiki --link some-mysql:mysql -p 8080:80 -d synctree/mediawiki

firefox http://localhost:8080/
- database host: mysql
- database name: mysql
- table prefix: mw
- username: root
- password: my-secret-pw
- at end of setup you get a LocalSettings.php to download
- this file has to be provided to the docker or put into the container. Seems to be several ways to do it, but none work. So this one works:
cat LocalSettings.php | docker exec -i some-mediawiki sh -c 'cat > /var/www/html/LocalSettings.php'
docker exec -i some-mediawiki chown www-data:www-data /var/www/html/LocalSettings.php
docker exec -i some-mediawiki chmod 444 /var/www/html/LocalSettings.php
firefox http://localhost:8080/index.php

More help: well the usual mediawiki help

Give some configuration stuff

ENGELPORT=80 # on which port the engel system should listen on the main host, if you have a webserver, 80 won't work
ENGELDB=3306 # on which port the mysql of the engelsystem should be visible on the main host
DBPASSWORD="$(openssl rand -base64 9)" # the password for the database (humm... save it it :-)
ENGELPASSWORD="$(openssl rand -base64 9)" # the password for the engelsystem (humm... save it it :-)
DOCKERNAME="engelsystem"
ENGELADMIN="engeladmin" # well just use it

git clone https://github.com/ruep/dockerfile-engel.git
cd dockerfile-engel/
docker build -t engelweb-app . # this takes a long time
docker run --name "$DOCKERNAME" -d -p ${ENGELPORT}:80 -p ${ENGELDB}:3306 -e MYSQL_PASS="$DBPASSWORD" engelweb-app

For some unknown reason the --name parameter is not used and you find yourself with a silly name WTF

# docker ps - ( Die CONTAINER_ID merken... )
# docker exec -i -t "$DOCKERNAME" bash # da stand anstatt engelsystem die containerid
# docker rename containerid "$DOCKERNAME"
docker exec -t "$DOCKERNAME" sed -i 's/-pengel/-p'$DBPASSWORD'/' /engelweb/db/createdb.sh # needed coz db pass hardcoded
docker exec -t "$DOCKERNAME" /engelweb/db/createdb.sh engelsystem engeladmin "$ENGELPASSWORD"
docker exec -t "$DOCKERNAME" sh -c "/usr/bin/mysql -uadmin -p$DBPASSWORD engelsystem < /engelweb/db/install.sql"
docker exec -t "$DOCKERNAME" sh -c "/usr/bin/mysql -uadmin -p$DBPASSWORD engelsystem < /engelweb/db/update.sql"

echo "Please remember the database password: $DBPASSWORD"
echo "Please remember the engelsystem login: ${ENGELADMIN} ${ENGELPASSWORD}"
echo login to http://localhost:$ENGELPORT/ with user 'admin' and password 'asdfasdf'