Skip to content

DGU-PoliceLab/COMPOSE

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

12 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Step 1. 도컀 이미지 μ„€μΉ˜

도컀 이미지 μ„€μΉ˜λ₯Ό μœ„ν•΄ setup.bat νŒŒμΌμ„ μ‹€ν–‰ν•©λ‹ˆλ‹€.

λ§Œμ•½ setup.bat 파일 μ‹€ν–‰ 쀑 였λ₯˜κ°€ λ°œμƒν•œλ‹€λ©΄ μ•„λž˜ 과정을 λ”°λ¦…λ‹ˆλ‹€.

./images ν΄λ”μ—μ„œ

docker load -i pls-web.tar
docker load -i pls-was.tar
docker load -i pls-mysql.tar
docker load -i pls-redis.tar

μœ„ 과정을 μ™„λ£Œν•œ ν›„, docker images λͺ…λ Ήμ–΄λ₯Ό 톡해 이미지 μ„€μΉ˜λ₯Ό ν™•μΈν•©λ‹ˆλ‹€.

C:\>docker images
REPOSITORY   TAG       IMAGE ID       CREATED          SIZE
web          latest    b74150de491d   46 minutes ago   59.7MB
was          latest    7cc2b9cf4205   56 minutes ago   1.63GB
mysql        latest    7ce93a845a8a   5 days ago       586MB
redis        latest    6c00f344e3ef   2 months ago     116MB

Step 2. 도컀 μ»¨ν…Œμ΄λ„ˆ μ‹€ν–‰

Step 1μ—μ„œ setup.bat μ‹€ν–‰ μ‹œ, λ¬Έμ œμ—†μ΄ μ™„λ£Œλ˜μ—ˆλ‹€λ©΄ 이 단계λ₯Ό κ±΄λ„ˆ λ›Έ 수 μžˆμŠ΅λ‹ˆλ‹€.

도컀 μ»¨ν…Œμ΄λ„ˆ 싀행을 μœ„ν•΄ docker-compose.yml 파일이 μžˆλŠ” ν΄λ”μ—μ„œ μ•„λž˜ λͺ…λ Ήμ–΄λ₯Ό μ‹€ν–‰ν•©λ‹ˆλ‹€.

docker-compose -f docker-compose.yml up -d

μœ„ 과정을 μ™„λ£Œν•œ ν›„, docker ps λͺ…λ Ήμ–΄λ₯Ό 톡해 μ»¨ν…Œμ΄λ„ˆ 싀행을 ν™•μΈν•©λ‹ˆλ‹€.

C:\>docker ps
CONTAINER ID   IMAGE     COMMAND                   CREATED          STATUS          PORTS                                      NAMES
7a4c9a04d5d7   redis     "docker-entrypoint.s…"   30 minutes ago   Up 30 minutes   0.0.0.0:16379->6379/tcp                    pls-redis
ead6a63a0660   web       "/docker-entrypoint.…"   30 minutes ago   Up 30 minutes   0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp   pls-web
3219599e364e   was       "hypercorn run:app -…"   30 minutes ago   Up 30 minutes   0.0.0.0:40000->40000/tcp                   pls-was
43852f418e28   mysql     "docker-entrypoint.s…"   30 minutes ago   Up 30 minutes   33060/tcp, 0.0.0.0:13306->3306/tcp         pls-mysql

Step3. MySQL λ°μ΄ν„°λ² μ΄μŠ€ μ„€μ •

Step 1μ—μ„œ setup.bat μ‹€ν–‰ μ‹œ, λ¬Έμ œμ—†μ΄ μ™„λ£Œλ˜μ—ˆλ‹€λ©΄ 이 단계λ₯Ό κ±΄λ„ˆ λ›Έ 수 μžˆμŠ΅λ‹ˆλ‹€.

μ•„λž˜ λͺ…λ Ήμ–΄λ₯Ό μš°μ„ μ μœΌλ‘œ μ‹œλ„ν•΄λ³΄μ„Έμš”. ν•΄λ‹Ή 과정을 μœ„ν•΄ mysql shell λ˜λŠ” cliκ°€ ν•„μš”ν•  수 μžˆμŠ΅λ‹ˆλ‹€.

mysql -u root -p1q2w3e4r! -P 13306 pls -e "source pls-mysql.sql"

MySQL Workbenchλ₯Ό 톡해 이 μž‘μ—…μ„ μ§„ν–‰ν•©λ‹ˆλ‹€. MySQL Workbench Download

MySQL Workbench에 접속해 연결을 μΆ”κ°€ν•©λ‹ˆλ‹€.

  • Connection Name: pls
  • Hostname: 127.0.0.1 or localhost
  • Port: 13306
  • Username: root

정보 κΈ°μž… ν›„, 우츑 ν•˜λ‹¨ OK λ²„νŠΌμ„ 눌러 연결을 μΆ”κ°€ν•©λ‹ˆλ‹€.

μœ„ κ³Όμ •μ—μ„œ λ§Œλ“€μ—ˆλ˜ pls 연결을 눌러 μ ‘μ†ν•©λ‹ˆλ‹€.

  • Password: 1q2w3e4r!

쒌츑 λ©”λ‰΄μ˜ Administrationνƒ­μ—μ„œ Data Import 메뉴λ₯Ό μ„ νƒν•©λ‹ˆλ‹€.

μ•„λž˜μ™€ 같이 μ„€μ • ν›„, 우츑 ν•˜λ‹¨ Start Import λ²„νŠΌμ„ ν΄λ¦­ν•©λ‹ˆλ‹€.

  • Import Options > Import from Self-Contained File: pls-mysql.sql 경둜
  • Default Schema to be Imported To > Default Target Schema: pls

μœ„ 과정을 μ™„λ£Œν•œ ν›„, pls μŠ€ν‚€λ§ˆμ— cctv, event, location, log ν…Œμ΄λΈ” 생성을 ν™•μΈν•©λ‹ˆλ‹€.

Step 4. WAS μΈμ¦μ„œ μ„€μ •

μ•„λž˜ λͺ…λ Ήμ–΄λ‘œ WAS μ»¨ν…Œμ΄λ„ˆμ— μ ‘μ†ν•©λ‹ˆλ‹€.

docker exec -it pls-was bash

μƒˆλ‘œμš΄ μΈμ¦μ„œ 생성을 μœ„ν•΄ setting.sh νŒŒμΌμ„ μ‹€ν–‰ν•©λ‹ˆλ‹€.

bash setting.sh

exit λͺ…λ Ήμ–΄λ‘œ μ»¨ν…Œμ΄λ„ˆ 접속을 ν•΄μ œν•œ ν›„, μ μš©μ„ μœ„ν•΄ μ»¨ν…Œμ΄λ„ˆλ₯Ό μž¬μ‹œμž‘ν•©λ‹ˆλ‹€.

docker restart pls-was

Step 5. 접속 및 확인

  • WEB μ•ŒλžŒ κΆŒν•œ μ„€μ • νŒμ—…μ΄ 뜨면 ν—ˆμš©ν•΄μ£Όμ„Έμš”.
  • WAS μ»¨ν…Œμ΄λ„ˆ μ‹€ν–‰(μž¬μ‹€ν–‰) ν›„, 30초~1λΆ„κ°„ 접속이 λΆˆκ°€λŠ₯ν•  수 μžˆμŠ΅λ‹ˆλ‹€.
  • API DOCS
  • API DOCS(redoc)

About

This is PoliceLab 2.0 docker compose repository.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published