Docker port of the virtual machine environement devised for the Telecom SudParis' Relational Databases MOOC (originally based on Vagrant). The original project can be found at https://fusionforge.int-evry.fr/projects/moocbdvm/

Install

Before using these containers, you need to install:

• (if you are using Linux) git: Choose your OS on the official website and follow the instructions.
• docker: Installation instructions are available on the official website, simply choose your OS and follow the procedure :).

If your are on Windows or MacOS, the following manipulation needs to be done in the boot2docker VM. To access your vm:

• On MacOS: in a shell, type boot2docker init; boot2docker start; boot2docker ssh
• On Windows, open the "Start boot2docker" shortcut (on your desktop or in the windows menu).

When you have a docker command available, type the following commands to setup the containers:

git clone https://github.com/pfe-asr-2014/moocdbdocker.git
cd moocdbdocker/

You can now pass to the next part: Using these containers !

Using

Build docker images (can be long):

docker build -t tsp-moocdb-postgres tsp-moocdb-postgres/
docker build -t tsp-moocdb-web tsp-moocdb-web/

Launch (the order is important):

docker run -d --name tsp-moocdb-postgres tsp-moocdb-postgres
docker run -d -p 8080:80 --name tsp-moocdb-web --link tsp-moocdb-postgres:tsp-moocdb-postgres tsp-moocdb-web

Use:

• On Linux, visit http://localhost:8080/
• On Windows and OS X, get the host ip with boot2docker ip and visit http://host_ip:8080/ (probably http://192.168.59.103:8080/)
• Login to phpPgAdmin with:
  • pg_reader/tpinfint for read access
  • pg_writer/tpinfint for read/write access

Updating the containers

(for those who wants to play with the latest and greatest)

These manipulations are done in the moocdbdocker (refer to the install to know how to access this directory).

To update your containers, type the followings commands:

git pull

docker build -t tsp-moocdb-postgres tsp-moocdb-postgres/
docker build -t tsp-moocdb-web tsp-moocdb-web/

docker stop tsp-moocdb-postgres tsp-moocdb-web

docker run -d --name tsp-moocdb-postgres tsp-moocdb-postgres
docker run -d -p 8080:80 --name web --link tsp-moocdb-postgres:tsp-moocdb-postgres tsp-moocdb-web

You're ready to play with more awesomeness !

How does it work and how can I update the content

(for those who want to maintain these containers)

All the database stuff is in tsp-moocdb-postgres. This container is based on the official postgresql image which provides a simple way to execute initialization scripts: place a .sh shell script in /docker-entrypoint-initdb.d and it will be executed at creation.

It is exactly how we do it! We just drop the file initdb-setupdb.sh which executes several sql commands and that's all!

So if you want to change the generated schema, all you have to do is to change this initdb-setupdb.sh (or add another one, if you want to separate your logic in several files).

The other container (tsp-moocdb-web) runs the bdsqlwiz PHP application (directory ./appli), PhpPgAdmin and an index for our users. You can update the application easily: just change the content of the directory and you're ready to ship your new content!

Watching Apache logs

docker logs -f tsp-moocdb-web

TODO

• Integrate manual
• Explain how to use it with boot2docker (script)
• Choose a License
• Improve this README (a lot) -> check the embedded 'TODO's
• more…