Docker Project build document - Oliver-Mustoe/Oliver-Mustoe-Tech-Journal GitHub Wiki

In this page I describe the steps I took to setup a PostgreSQL container database that's contents are displayed on a webpage via a PHP & Apache Web server container.

Code/Github setup

First, on a Windows machine, I used Visual Studios to create the following files in a folder named "Code_for_docker_project"

docker-compose.yml
dockerproj_dirmaker.bash
index.php
SOURCES.txt
Dockerfile
class_to_table.sql
postgresql_apache_setup.bash

I populated each file with the following:
(Some comments might be cut out of the screenshot, GitHub links included with the file names.)

docker-compose.yml - The docker compose file for this project that performs some setup and downloads/builds the needed images.

dockerproj_dirmaker.bash - A bash script that generates the directory structure that the project needs and copies all needed files to it.

index.php - A PHP file that will display results of the created PostgreSQL table in a webpage.

SOURCES.txt - The sources used on the code (no image since this step is a formality not essential to the project working as intended)

Dockerfile - A Dockerfile that takes the php-apache image that I need and performs installation of needed extensions for "index.php" to work when built in the docker-compose file.

class_to_table.sql - A sql file that connects to the created database, creates a table with the needed columns, and inserts some data in to the table.

postgresql_apache_setup.bash - A bash file that creates a network for the two containers to function in, connects them to it, runs a .sql file against the database which creates a table with data, copies needed files to mapped Web server root directory, and opens the needed port.

I stored the code folder in a folder called "SYS265", then added the code to my repository by going to the code section > clicking "Upload Files" > drag the folder into the section and click the green "Commit changes" button.

Install and setup on docker01

(NOTE: What each file does is described above.)

I first installed "git" on docker01 with the command:

sudo apt install git-all

Then I used git to clone the repository with the command:

git clone https://github.com/Oliver-Mustoe/Oliver-Mustoe-Tech-Journal.git

I then moved into the needed directory (Oliver-Mustoe-Tech-Journal/SYS265/Code_for_docker_project) and ran the file "dockerproj_dirmaker.bash" with the command:

bash dockerproj_dirmaker.bash

I then navigated to the newly created directory structure (~/dockerproject) and ran the "docker-compose" file (needs sudo privileges) with the command: