Generic Docker Environments for Developers

Container List

• MongoDb | https://www.mongodb.com
• MongoExpress | https://github.com/mongo-express/mongo-express
• Microsoft SQL Server 2022 Developer Edition | https://www.microsoft.com/en/sql-server/sql-server-2022
• MySQL | MariaDb 10.6 | https://mariadb.org/
• phpMyAdmin | https://www.phpmyadmin.net/
• PostgreSQL | https://www.postgresql.org/
• pgAdmin | https://www.pgadmin.org/
• DbGate | https://dbgate.org/
• RabbitMQ | https://www.rabbitmq.com/

Prerequisites

• Docker
  • Recommended Docker version 4.33.0
• Windows
  • Set up Linux Containers on Windows 10
  • PowerShell

Windows Useful Links

• Set-ExecutionPolicy

Getting Started

Clone

git clone https://github.com/MuratBudun/GenericDockerEnv.git
cd GenericDockerEnv

chmod +x for Linux / maxOS

chmod +x create-passwords.sh
chmod +x docker-compose.sh

Create Docker Network

docker network create gen_dev_net

Create Passwords

Password file path: ./env/_passwords.env

• Windows

  ./create-passwords.ps1
  

• Linux / macOS

  ./create-passwords.sh

• Manuel Create "_password.env" file in "env" folder.

  MSSQL_SA_PASSWORD=
  MONGO_ROOT_PASSWORD=
  MYSQL_ROOT_PASSWORD=
  POSTGRES_PASSWORD=
  RABBITMQ_PASSWORD=
  

Recreate Passwords

Important

This process will cause you to lose your data.

MySQL, PostgreSQL and Microsoft SQL Server 2022 keep passwords in the ./volumes directory.

These programs will not work when you re-create your password. You can activate new passwords by deleting the relevant program data from the volumes folder.

Before doing this, close the running applications with the ".\docker-compose.ps1 all down" command.

Linux / macOS "./docker-compose.sh all down"

Password file path: ./env/_passwords.env

• Windows

  ./create-passwords.ps1 o
  

• Linux / macOS

  ./create-passwords.sh o

How To Use

Windows PowerShell

Useage:

• Options and Actions

  Actions: up | down
  Options: all | dbgate | mongo | mysql |  mssql2022 | postgres
  

• Windows

  .\docker-compose.ps1 <Option> <Action>
  

• Linux / macOS

  .\docker-compose.sh <Option> <Action>

Examples:

• Windows

  .\docker-compose.ps1 all up        
  .\docker-compose.ps1 all down
  .\docker-compose.ps1 dbgate up
  

• Linux / macOS

  .\docker-compose.sh all up        
  .\docker-compose.sh all down
  .\docker-compose.sh dbgate up
  

• Docker CLI

  docker compose -f ./compose/docker-compose-dbgate.yml --env-file ./env/_passwords.env --env-file ./env/dbgate.env up -d
  

Important

Make sure your docker version supports multiple --env-file

Recommended Docker version 4.33.0

DbGate

http://localhost:8082

Microsoft SQL Server 2022 Developer Edition

Connection

• Server: localhost
• Port: 1466
• Internal Port: 1433
• User: sa
• Password: {MSSQL_SA_PASSWORD}

Example Connection String

Data Source=localhost,1466;Initial Catalog=master;User ID=sa;Password={MSSQL_SA_PASSWORD};

Note

The MSSQL_SA_PASSWORD variable is in the ./env/_passwords.env file. If you cannot find the ./env/_passwords.env file, repeat the password creation step.

MongoDb and Mongo Express

Connection

• Server: localhost
• Port: 27170
• Internal Port: 27017
• User: root
• Password: {MONGO_ROOT_PASSWORD}

Example Connection String

mongodb://root:{MONGO_ROOT_PASSWORD}@localhost:27170

Note

The MONGO_ROOT_PASSWORD variable is in the ./env/_passwords.env file. If you cannot find the ./env/_passwords.env file, repeat the password creation step.

Mongo Express

• http://localhost:8081
• user: admin
• password: {MONGO_ROOT_PASSWORD}

MySQL and phpMyAdmin

Connection

• Server: localhost
• Port: 6603
• Internal Port: 3306
• User: root
• Password: {MYSQL_ROOT_PASSWORD}

Note

The MYSQL_ROOT_PASSWORD variable is in the ./env/_passwords.env file. If you cannot find the ./env/_passwords.env file, repeat the password creation step.

phpMyAdmin

http://localhost:8084

PostgreSQL

Connection

• Server: localhost
• Port: 5234
• Internal Port: 5432
• User: postgres
• Password: {POSTGRES_PASSWORD}

Note

The POSTGRES_PASSWORD variable is in the ./env/_passwords.env file. If you cannot find the ./env/_passwords.env file, repeat the password creation step.

pgAdmin

• http://localhost:8083
• email: pgadmin@gen-env.com
• password: {POSTGRES_PASSWORD}

RabbitMQ

Connection

• Server: localhost
• Port: 5672
• Internal Port: 5672
• User: rmq-admin
• Password: {RABBITMQ_PASSWORD}

Management

• http://localhost:15672
• user: rmq-admin
• password: {RABBITMQ_PASSWORD}