Ticket #18: Build backend docker image and using docker compose to connect backend and database

[doquocang]

done: with building back-end image

[doquocang]

learning: about port in docker ls

[doquocang]

[doquocang]

Come up with the idea: how to map Containers inside the same Compose (local) to outside of the Compose For example: map container app-1 (inside compose test) to azuresql (outside compose test):

solution: using port

new Ticket:

map Front end Container and Back end Container

[doquocang]

Comprehend:

• Local network inside of Docker compose:

test-app-1 and test-sql-1 is in the same local network created by Docker, they have the save Gateway

Research about:

• Aliases
• DNSNames
• Bridge
• Ping

[doquocang]

Understand:

• Server port:

-Port that container will listen:

• Host post and mapping:

[doquocang]

Understand:

• Ping to check the connection between container:

[doquocang]

Learning the basic of docker network

[doquocang]

Learning the basic of docker flags (-e, -d, -p, ...)

[doquocang]

Learn and create bridge network:

checking network just created:

inspecting network:

[doquocang]

Create a sql server 2019 container:

check container:

[doquocang]

Import data Get access to root while running container and install

Adding mssql-tools into environment path:

Mount Script folder to Container:

Check mount:

Import database:

Result:

[doquocang]

SQL import error:

[doquocang]

Connect database to External network:

Check network:

or:

[doquocang]

Adjust spring.datasource.url (host name from localhost:1433 to enclave-sql2019:1433) application.properties in server:

[doquocang]

Build a new server image:

[doquocang]

create docker compose with external bridge docker network created before:

[doquocang]

Run docker compose:

[doquocang]

Install ping to check the connection between server and the database:

Install:

Check the connection from server to database:

[doquocang]

Done with fixing the database, turned out the error was about Visual studio limit code line:

[doquocang]

testing the api and database