Group Name: Mao Mao
Section: 7
Team Mates:
- Muhammad Hanif Faiq Bin Mazlan 2221773
- Mohamad Qays Bin Mohamad Ibrahim 2010901
- Fill name and matric no
- You are allowed to have 3 group members. Exception is allowed IFF (if and only if) you are allowed to have 4 group members if you are a multinational or a multigender group.
- When you complete the project, make sure to submit the repository link of your cloned project. Make sure all the files are as what you aspect in your repository.
- Answer all questions in the README.md, in your own repository. Either use the online VSCode, terminal or github to edit. Answers are expected where you see Fill answer here.
- Learn how to use markdown. https://www.w3schools.io/file/markdown-introduction/
-
First thing you need in doing this project is to have a github account. Make sure to sign up at https://www.github.com
-
The second thing you need is to fork the OS project repository in your own github account.
- Go to https://github.com/joeynor/OSProject and click fork to copy the project into your own repository
- Make sure that the new fork is now in your own repository
Questions:
- What is the link of the fork OSProject in your repository. (1 mark)(https://github.com/qaysibrahim01/OSProject).
- How many files and folders are in this repository. (1 mark) 2 folder and 1 file.
- The next thing that we will be doing is exploring codespaces. First of all, read about codespaces https://docs.github.com/en/codespaces/overview#what-is-a-codespace
- Then go to the link https://github.com/codespaces and we shall start a new codespace.
- Click on New codespace.
- Choose your own OSProject repository to start your codespace.
- Once you have created you codespace, you will see the following. You might already be familiar with this, since it will look similar to VSCode.
- You will see the README file file. One is a preview of how it looks like on the web, and the other is the editing view in markdown language.
- Edit the README file. Make sure you have your group details correct, ie, group name, section and team members along with their matric IDs.
- Once you have finish editing, click File->Save or ctrl-s to save it.
- After saving, you will notice an M or U next to your file. You will need to commit any changes, whenever you make changes so that it is uploaded to the github repository.
- Click on the source control, hint: its on the left side panel, and it will list down the files that have been modified or updated. Click on commit. It will then ask you "Would you like to stage all your changes and commit them directly?" Just say yes, and a new tab will appear. Type a message to log what you have done, and click on the check mark.
- After that, sync the changes to the main repository.
- Make sure to commit and sync your files to the main repository, or else, your work will be lost since it is not saved into the main repository when you submit your project.
Questions:
- What is default OS used to run the virtual environment for codespaces. (1 mark) The default OS is Ubuntu Linux.
- What are the two options of ram, disk and vcpu configuration you can have in running codespaces . (1 mark) The two options are:
- 2-core CPU, 4GB RAM, 32GB disk
- 4-core CPU, 8GB RAM, 64GB disk
- Why must we commit and sync our current work on source control? (1 mark) Committing and syncing ensures that changes are saved to the main repository. Without committing and syncing, changes remain local and will be lost if the codespace is deleted or reset.
- Look at the TERMINAL tab. Explore and run commands according to the questions below.
- You can include your answers as images, or cut and paste the output here. If you are cutting and pasting your answers, wrap your answers in the codeblock clause in markdown. For example, if i run the command whoami the the output would look like the one below.
@joeynor ➜ /workspaces/OSProject (main) $ whoami
codespaceQuestions:
Look at the TERMINAL tab. Run the following commands and provide the output here.
- Run the command pwd . (1 mark)
/workspaces/OSProject.- Run the command cat /etc/passwd . (1 mark)
root:x:0:0:root:/root:/bin/bash
daemon:x:1:1:daemon:/usr/sbin:/usr/sbin/nologin
bin:x:2:2:bin:/bin:/usr/sbin/nologin
sys:x:3:3:sys:/dev:/usr/sbin/nologin
sync:x:4:65534:sync:/bin:/bin/sync
games:x:5:60:games:/usr/games:/usr/sbin/nologin
man:x:6:12:man:/var/cache/man:/usr/sbin/nologin
lp:x:7:7:lp:/var/spool/lpd:/usr/sbin/nologin
mail:x:8:8:mail:/var/mail:/usr/sbin/nologin
news:x:9:9:news:/var/spool/news:/usr/sbin/nologin
uucp:x:10:10:uucp:/var/spool/uucp:/usr/sbin/nologin
proxy:x:13:13:proxy:/bin:/usr/sbin/nologin
www-data:x:33:33:www-data:/var/www:/usr/sbin/nologin
backup:x:34:34:backup:/var/backups:/usr/sbin/nologin
list:x:38:38:Mailing List Manager:/var/list:/usr/sbin/nologin
irc:x:39:39:ircd:/var/run/ircd:/usr/sbin/nologin
gnats:x:41:41:Gnats Bug-Reporting System (admin):/var/lib/gnats:/usr/sbin/nologin
nobody:x:65534:65534:nobody:/nonexistent:/usr/sbin/nologin
_apt:x:100:65534::/nonexistent:/usr/sbin/nologin
systemd-timesync:x:101:101:systemd Time Synchronization,,,:/run/systemd:/usr/sbin/nologin
systemd-network:x:102:103:systemd Network Management,,,:/run/systemd:/usr/sbin/nologin
systemd-resolve:x:103:104:systemd Resolver,,,:/run/systemd:/usr/sbin/nologin
messagebus:x:104:105::/nonexistent:/usr/sbin/nologin
codespace:x:1000:1000::/home/codespace:/bin/bash
sshd:x:105:65534::/run/sshd:/usr/sbin/nologin.- Run the command df . (1 mark)
Filesystem 1K-blocks Used Available Use% Mounted on
overlay 32847680 10705568 20448012 35% /
tmpfs 65536 0 65536 0% /dev
shm 65536 8 65528 1% /dev/shm
/dev/root 30298176 13577404 16704388 45% /vscode
/dev/sdc1 46127956 18672436 25079944 43% /tmp
/dev/loop7 32847680 10705568 20448012 35% /workspaces.- Run the command du . (1 mark)
8 ./.git/refs/heads
4 ./.git/refs/tags
12 ./.git/refs/remotes/origin
16 ./.git/refs/remotes
32 ./.git/refs
68 ./.git/hooks
8 ./.git/info
4 ./.git/lfs/tmp
8 ./.git/lfs
4 ./.git/branches
8 ./.git/objects/74
8 ./.git/objects/fa
12 ./.git/objects/af
8 ./.git/objects/83
8 ./.git/objects/96
8 ./.git/objects/c0
8 ./.git/objects/93
12 ./.git/objects/17
8 ./.git/objects/24
8 ./.git/objects/1b
8 ./.git/objects/d8
12 ./.git/objects/14
12 ./.git/objects/70
8 ./.git/objects/0b
8 ./.git/objects/2b
8 ./.git/objects/47
8 ./.git/objects/cd
12 ./.git/objects/44
12 ./.git/objects/72
8 ./.git/objects/e9
8 ./.git/objects/71
12 ./.git/objects/64
16 ./.git/objects/fb
8 ./.git/objects/a3
8 ./.git/objects/0d
8 ./.git/objects/c3
12 ./.git/objects/f9
12 ./.git/objects/2e
8 ./.git/objects/7b
8 ./.git/objects/04
8 ./.git/objects/91
12 ./.git/objects/62
12 ./.git/objects/3d
12 ./.git/objects/1c
8 ./.git/objects/f6
8 ./.git/objects/b6
8 ./.git/objects/4f
12 ./.git/objects/f0
8 ./.git/objects/fe
4 ./.git/objects/info
8 ./.git/objects/e8
8 ./.git/objects/8d
8 ./.git/objects/eb
8 ./.git/objects/41
12 ./.git/objects/29
8 ./.git/objects/19
8 ./.git/objects/e7
8 ./.git/objects/f7
8 ./.git/objects/fc
8 ./.git/objects/4b
8 ./.git/objects/b2
8 ./.git/objects/20
8 ./.git/objects/ab
12 ./.git/objects/73
8 ./.git/objects/52
8 ./.git/objects/c6
1828 ./.git/objects/pack
8 ./.git/objects/86
16 ./.git/objects/e5
8 ./.git/objects/58
8 ./.git/objects/f2
8 ./.git/objects/a4
12 ./.git/objects/6e
8 ./.git/objects/49
8 ./.git/objects/ce
8 ./.git/objects/fd
8 ./.git/objects/81
12 ./.git/objects/3f
8 ./.git/objects/4a
16 ./.git/objects/a6
12 ./.git/objects/bf
8 ./.git/objects/b9
8 ./.git/objects/3a
12 ./.git/objects/ff
12 ./.git/objects/b5
12 ./.git/objects/d2
8 ./.git/objects/60
8 ./.git/objects/cb
2552 ./.git/objects
8 ./.git/logs/refs/heads
12 ./.git/logs/refs/remotes/origin
16 ./.git/logs/refs/remotes
28 ./.git/logs/refs
36 ./.git/logs
2736 ./.git
1972 ./images
4732 ..- Run the command ls . (1 mark)
README.md images.- Run the command ls -asl . (1 mark)
total 40
4 drwxrwxrwx+ 4 codespace root 4096 Jan 31 14:01 .
4 drwxr-xrwx+ 5 codespace root 4096 Jan 31 14:01 ..
4 drwxrwxrwx+ 9 codespace root 4096 Jan 31 14:01 .git
24 -rw-rw-rw- 1 codespace root 21645 Jan 31 14:09 README.md
4 drwxrwxrwx+ 2 codespace root 4096 Jan 31 14:01 images.- Run the command free -h . (1 mark)
total used free shared buff/cache available
Mem: 7.7Gi 1.4Gi 174Mi 62Mi 6.2Gi 6.0Gi
Swap: 0B 0B 0B.- Run the command cat /proc/cpuinfo . (1 mark)
processor : 0
vendor_id : AuthenticAMD
cpu family : 25
model : 1
model name : AMD EPYC 7763 64-Core Processor
stepping : 1
microcode : 0xffffffff
cpu MHz : 3026.941
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm constant_tsc rep_good nopl tsc_reliable nonstop_tsc cpuid extd_apicid aperfmperf pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 movbe popcnt aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy svm cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw topoext invpcid_single vmmcall fsgsbase bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 xsaves clzero xsaveerptr rdpru arat npt nrip_save tsc_scale vmcb_clean flushbyasid decodeassists pausefilter pfthreshold v_vmsave_vmload umip vaes vpclmulqdq rdpid fsrm
bugs : sysret_ss_attrs null_seg spectre_v1 spectre_v2 spec_store_bypass srso
bogomips : 4890.85
TLB size : 2560 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : AuthenticAMD
cpu family : 25
model : 1
model name : AMD EPYC 7763 64-Core Processor
stepping : 1
microcode : 0xffffffff
cpu MHz : 3030.377
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
apicid : 1
initial apicid : 1
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm constant_tsc rep_good nopl tsc_reliable nonstop_tsc cpuid extd_apicid aperfmperf pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 movbe popcnt aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy svm cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw topoext invpcid_single vmmcall fsgsbase bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 xsaves clzero xsaveerptr rdpru arat npt nrip_save tsc_scale vmcb_clean flushbyasid decodeassists pausefilter pfthreshold v_vmsave_vmload umip vaes vpclmulqdq rdpid fsrm
bugs : sysret_ss_attrs null_seg spectre_v1 spectre_v2 spec_store_bypass srso
bogomips : 4890.85
TLB size : 2560 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management:.- Run the command top and type q to quit. (1 mark)
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 codespa+ 20 0 1136 640 640 S 0.0 0.0 0:00.04 docker-init
7 codespa+ 20 0 7236 1792 1792 S 0.0 0.0 0:00.01 sleep
115 root 20 0 12196 3480 2560 S 0.0 0.0 0:00.00 sshd
993 root 20 0 1983260 80076 53120 S 0.0 1.0 0:00.16 dockerd
1000 root 20 0 1872580 46852 30336 S 0.0 0.6 0:00.41 containerd
2084 codespa+ 20 0 2616 1408 1408 S 0.0 0.0 0:00.00 sh
2168 root 20 0 2616 1408 1408 S 0.0 0.0 0:00.01 sh
2948 codespa+ 20 0 2624 1664 1664 S 0.0 0.0 0:00.01 sh
2957 codespa+ 20 0 11.3g 102604 46592 S 0.0 1.3 0:04.28 node.- Run the command uname -a. (1 mark)
Linux codespaces-187414 6.5.0-1025-azure #26~22.04.1-Ubuntu SMP Thu Jul 11 22:33:04 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux.- What is the available free memory in the system. (1 mark) 6.0Gi
- What is the available disk space mounted on /workspace. (1 mark) 20448012
- Name the version and hardware architecture of the linux Virtual environment. (1 mark)
Linux codespaces-187414 6.5.0-1025-azure #26~22.04.1-Ubuntu SMP- What is the difference between ls vs ls -asl. (1 mark) ls: Lists the files and directories in the current directory. ls -asl: Provides a detailed listing including file sizes, permissions, ownership, and inode numbers, with the total block count displayed at the top.
- What is the TLB size of the Virtual CPU. (1 mark) 2560 4K pages
- What is the CPU speed of the Virtual CPU. (1 mark) 3026.941 MHz
- What is the top running process that consumes the most CPU cycles. (1 mark) node with PID 2957
- At the terminal, run a linux instance. By typing the following command.
docker pull debian
docker run --detach -it debian
- This will run the debian container. To check if the debian container is running, type
@joeynor ➜ /workspaces/OSProject (main) $ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f65be1987f84 debian "bash" 4 minutes ago Up 4 minutes romantic_jackson- Keep note of the name used by your container, this is usually given random names unless you specify your own name. Now run a bash command on the container. Make sure you use the name of your container instead of the one shown here.
docker exec -i -t romantic_jackson /bin/bash- Create a file on the container. First you must make sure you are in the bash command prompt of the container. The container is new, and does not have any software other than the debian OS. To create a new file, you will need an editor installed. In the bash shell of the container, run the package manager apt-get to install nano text editor.
root@f65be1987f84:~# apt-get update
root@f65be1987f84:~# apt-get install nano
root@f65be1987f84:~# cd /root
root@f65be1987f84:~# nano helloworld.txt-
Edit your helloworld.txt, create your messsage and save by typing ctrl-X. Once saved, explore using the container to see where the file is located. Then exit the shell, by typing exit.
-
Stop the container and run docker ps -a, and restart the container again. Is your file in the container still available?
@joeynor ➜ /workspaces/OSProject (main) $ docker stop romantic_jackson
@joeynor ➜ /workspaces/OSProject (main) $ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f65be1987f84 debian "bash" 19 minutes ago Exited (137) 18 seconds ago romantic_jackson
@joeynor ➜ /workspaces/OSProject (main) $ docker restart romantic_jackson- Stop the container and delete the container. What happened to your helloworld.txt?
@joeynor ➜ /workspaces/OSProject (main) $ docker stop romantic_jackson
@joeynor ➜ /workspaces/OSProject (main) $ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f65be1987f84 debian "bash" 19 minutes ago Exited (137) 18 seconds ago romantic_jackson
@joeynor ➜ /workspaces/OSProject (main) $ docker rm romantic_jacksonQuestions:
- Are files in the container persistent. Why not?. (1 mark) No, files in the container are not persistent because containers are generally temporary. When the container stops or deleted the files inside will also be lost.
- Can we run two, or three instances of debian linux? . (1 mark) Yes and each instances would be isolated and run independently.
- In the previous experiment, you might have notice that containers are not persistent. To make storage persistent, you will need to mount them. At the terminal, create a new directory called myroot, and run a instance of debian linux and mount myroot to the container. Find out the exact path of my root, and mount it as the root folder in the debian container.
- Create a file in /root on the container, the files should also appear in myroot of your host VM.
@joeynor ➜ /workspaces/OSProject (main) $ mkdir myroot
@joeynor ➜ /workspaces/OSProject (main) $ cd myroot/
@joeynor ➜ /workspaces/OSProject/myroot (main) $ pwd
/workspaces/OSProject/myroot
@joeynor ➜ /workspaces/OSProject/myroot (main) $ docker run --detach -it -v /workspaces/OSProject/myroot:/root debianQuestions:
- Check the permission of the files created in myroot, what user and group is the files created in docker container on the host virtual machine? . (2 mark) By default, files created in the myroot directory from the container will be owned by the root user and group on the host machine.
- Can you change the permission of the files to user codespace. You will need this to be able to commit and get points for this question. (2 mark)
//use sudo and chown
@AreNap33 ➜ /workspaces/OSProject/myroot (main) $ sudo chown -R codespace:codespace myroot
*** Yes, I can ***
- Create a directory called webpage in your host machine
- Inside the directory, create a page index.html, with any content you would like
- Then, run the apache webserver and mount the webpage directory to it. Hint:
## the -p 8080:80 flag points the host port 8080 to the container port 80
docker run --detach -v /workspaces/OSProject/webpage:/usr/local/apache2/htdocs/ -p 8080:80 httpd- If it works, codespace will trigger a port assignment and provide a URL for you to access your webpage like the one below.
-
You can also see the Port in the PORTS tab, next to the terminal tab.
-
You can then access your website by adding an index.html towards the end of your url link, like the one below.
Questions:
- What is the permission of folder /usr/local/apache/htdocs and what user and group owns the folder? . permission: drwxr-xr-x, user: root, group: root
@qaysibrahim01 ➜ /workspaces/OSProject (main) $ docker exec beautiful_stonebraker ls -ld /usr/local/apache2/htdocs
drwxrwxrwx+ 2 1000 1000 4096 Jan 25 16:15 /usr/local/apache2/htdocs- What port is the apache web server running. (1 mark) Port 80.
- What port is open for http protocol on the host machine? (1 mark) Port open is 8080.
- In docker, you can create your own private networks where you can run multiple services, in this part, we will create two networks, one called bluenet and the other is rednet
- Run the docker create network to create you networks like the ones below
## STEP 1:
## Create Networks ##
docker network create bluenet
docker network create rednet`
## STEP 2: (automatically running)
## Create (1) Container in background called "c1" running busybox image ##
docker run -itd --net bluenet --name c1 busybox sh
docker run -itd --net rednet --name c2 busybox shQuestions:
-
Describe what is busybox and what is command switch --name is for? . (2 mark) BusyBox is a lightweight Linux distribution providing essential Unix utilities. The --name switch assigns a custom name to a container instead of using a default random name.
-
Explore the network using the command
docker network ls, show the output of your terminal. (1 mark)
@qaysibrahim01 ➜ /workspaces/OSProject (main) $ docker network ls
NETWORK ID NAME DRIVER SCOPE
13e55bf34c93 bluenet bridge local
526a2a81306a bridge bridge local
43a8c262a631 host host local
273ee879dcdf none null local
804bdc00626e rednet bridge local- Using
docker inspect c1anddocker inspect c2inscpect the two network. What is the gateway of bluenet and rednet.? (1 mark)
"Gateway": "172.18.0.1" # bluenet
"Gateway": "172.19.0.1" # rednet- What is the network address for the running container c1 and c2? (1 mark) Fill answer here.
Container c1 (bluenet): IP Address: 172.18.0.2 Subnet: 172.18.0.0/16
Container c2 (rednet): IP Address: 172.19.0.2 Subnet: 172.19.0.0/16.- Using the command
docker exec c1 ping c2, which basically tries to do a ping from container c1 to c2. Are you able to ping? Show your output . (1 mark) Fill answer here.
@qaysibrahim01 ➜ /workspaces/OSProject (main) $ docker exec c1 ping c2
ping: bad address 'c2'- Let's try this again by creating a network to bridge the two containers in the two subnetworks
docker network create bridgenet
docker network connect bridgenet c1
docker network connect bridgenet c2
docker exec c1 ping c2
Questions:
- Are you able to ping? Show your output . (1 mark) yes
PING c2 (172.20.0.3): 56 data bytes
64 bytes from 172.20.0.3: seq=0 ttl=64 time=0.186 ms
64 bytes from 172.20.0.3: seq=1 ttl=64 time=0.078 ms
64 bytes from 172.20.0.3: seq=2 ttl=64 time=0.099 ms
64 bytes from 172.20.0.3: seq=3 ttl=64 time=0.093 ms
--- c2 ping statistics ---
4 packets transmitted, 4 packets received, 0% packet loss
round-trip min/avg/max = 0.078/0.114/0.186 ms- What is different from the previous ping in the section above? (1 mark) The difference is that by connecting both containers to the bridgenet network, they can now communicate with each other, unlike before, when they were isolated in separate networks (bluenet and rednet).
This guide will help you set up a simple Node.js website that retrieves a random row from a MySQL database. Both the MySQL server and the Node.js server will run in separate Docker containers on two separate networks. Your job is to make it work by making the two containers in two separate network bridged together.
Create a Docker network to for the two containers. For mysql, call it mysqlnet for nodejs call it nodejsnet .
Run a MySQL container on the created network.
docker run --name mysql-container --network mysqlnet -e MYSQL_ROOT_PASSWORD=rootpassword -e MYSQL_DATABASE=mydatabase -e MYSQL_USER=myuser -e MYSQL_PASSWORD=mypassword -d mysql:latest-
Create a directory for your Node.js application and initialize it.
mkdir nodejs-app cd nodejs-app npm init -y npm install express mysql -
Create a file named
index.jswith the following content:const express = require('express'); const mysql = require('mysql'); const app = express(); const port = 3000; // Create a MySQL connection const connection = mysql.createConnection({ host: 'mysql-container', user: 'myuser', password: 'mypassword', database: 'mydatabase' }); // Connect to MySQL connection.connect((err) => { if (err) { console.error('Error connecting to MySQL:', err); return; } console.log('Connected to MySQL'); }); // Define a route to get a random row app.get('/random', (req, res) => { const query = 'SELECT * FROM mytable ORDER BY RAND() LIMIT 1'; connection.query(query, (err, results) => { if (err) { console.error('Error executing query:', err); res.status(500).send('Server Error'); return; } res.json(results[0]); }); }); // Start the server app.listen(port, () => { console.log(`Server running at http://localhost:${port}`); });
-
Create a Dockerfile for the Node.js application:
# Use the official Node.js image FROM node:14 # Create and change to the app directory WORKDIR /usr/src/app # Copy application dependency manifests to the container image COPY package*.json ./ # Install production dependencies RUN npm install # Copy local code to the container image COPY . . # Run the web service on container startup CMD [ "node", "index.js" ]
-
Build the Docker image for the Node.js application.
docker build -t nodejs-app . -
Run the Node.js container on the same network as the MySQL container.
docker run --name nodejs-container --network nodejsnet -p 3000:3000 -d nodejs-app
You can now test the setup by accessing the Node.js application in your browser or using a tool like curl:
curl http://localhost:3000/randomMake sure you have created the mytable table and populated it with some data in your MySQL database for the above steps to work correctly.
You can use the following SQL commands to create and populate the table (run these commands in the MySQL container):
CREATE TABLE mytable (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
value VARCHAR(255) NOT NULL
);
INSERT INTO mytable (name, value) VALUES ('example1', 'value1'), ('example2', 'value2'), ('example3', 'value3');You have now set up a Node.js application in a Docker container on nodejsnet netowrk and a MySQL database in another Docker container on mysqlnet network. Now bridge the two network together.
Questions:
- What is the output of step 5 above, explain the error? (1 mark) The output is a server error. The reason is that the network connection between the nodejs-container and mysql-container has not been established.
@qaysibrahim01 ➜ /workspaces/OSProject (main) $ curl http://localhost:3000/random
Server Error- Show the instruction needed to make this work. (1 mark)
docker network connect mysqlnet nodejs-container
Check the MySQL connection in the index.js
Make sure mytable is created and populated in MySQL
Restart both containers:
docker restart mysql-container
docker restart nodejs-container- Make sure to commit all changes on your source control, and make sure your source control is sync to the repository.
- Check your repository link, to see if all the files and answers are included in the repository.
- Submit through italeem, by providing the link to your repository.
- Due by AS STATED IN ITALEEM SYSTEM





