Giter Club home page Giter Club logo

sozotown's Introduction

SOZOTOWN

創造社デザイン専門学校
情報セキュリティ管理者資格コース二年
卒業WS_CTF課題対応作品

DEMO

SOZOTOWN_DEMO.gif

Document

  • Git運用資料
    GitHub_operation.pdf
  • FE_画面仕様書
    画面仕様書.pdf
  • FE_画面遷移図
    画面遷移図.pdf
  • DB_ユースケース図
    ユースケース図.pdf
  • DB_ER図
    ER図.pdf
  • DB_テーブル定義書
    テーブル定義書.pdf
  • IF_物理構成図
    物理構成図.pdf
  • IF_論理構成図
    論理構成図.pdf
  • QA_テスト仕様書
    テスト仕様書.pdf

Requirement

  • Frontend
    • HTML / CSS / Javascript
  • Backend
    • PHP(smarty/phpdotenv/valitron/fast-route/faker)
  • Infrastructure
    • Docker(Docker-compose)
      • Apache(modsecurity)
      • Nginx(Proxy)
      • MySQL

Author

  • Project_manager

    • M K ※
  • Project_leader

    • Y C ※
  • Frontend_team

    • S D ※ (Leader)
    • R E
    • S K
    • S T ※
  • Backend_team

    • Y K ※ (Leader)
    • S D ※
    • T N
    • N Y
  • database_team

    • Y F ※ (Leader)
    • M K ※
    • Y K ※
    • R M ※
    • T Y
  • Infrastructure_team

    • R M ※ (Leader)
    • Y C ※
    • Y F ※
  • QualityAssurance_team

    • M K ※ (Leader)
    • M K ※
    • S T ※
    • Y Y

Installation

Single_Server

  1. git clone https://github.com/makoto-kamimura/SOZOTOWN.git
  2. SOZOTOWN/docker/app/src/.env を作成
  3. SOZOTOWN/yml/ にて、docker-compose up -d --build
  4. docker container exec -it sozotown_app_1 bash でappコンテナに入る
  5. php /var/www/html/test/faker.phpでダミーデータ生成
  6. http://localhost:18080で確認

Multiple_Server

WEB_Server

  1. /opt にて、git clone https://github.com/makoto-kamimura/SOZOTOWN.git
  2. SOZOTOWN/docker/app/src/.env を作成
  3. SOZOTOWN/yml/ にて、docker network create db-network, docker network create proxy-network
  4. docker-compose -f docker-compose.app.yml up -d --build
  5. docker container exec -it sozotown_app_1 bash でappコンテナに入る
  6. mkdir /var/www/html/app/templates_cでディレクトリの作成
  7. chmod 777 /var/www/html/app/templates_cで権限変更
  8. php /var/www/html/test/faker.phpでダミーデータ生成
  9. ブラウザで確認

DB_Server

  1. /opt にて、git clone https://github.com/makoto-kamimura/SOZOTOWN.git
  2. SOZOTOWN/yml/ にて、docker network create db-network
  3. docker-compose -f docker-compose.db.yml up -d --build
  4. ブラウザで確認

PROXY_Server

  1. /opt にて、git clone https://github.com/makoto-kamimura/SOZOTOWN.git
  2. SOZOTOWN/yml/ にて、docker network create proxy-network
  3. docker-compose -f docker-compose.proxy.yml up -d --build
  4. ブラウザで確認

MAIL_Server(仮実装)

  1. /opt にて、git clone https://github.com/makoto-kamimura/SOZOTOWN.git
  2. SOZOTOWN/yml/ にて、docker network create mail-network
  3. docker-compose -f docker-compose.mail.yml up -d --build
  4. ブラウザで確認

License

https://choosealicense.com/no-permission/

sozotown's People

Contributors

makoto-kamimura avatar sozotaro avatar

Watchers

 avatar

sozotown's Issues

Not working app

修正が容易でしたらご対応いただければ幸いです。
三点ございます。

  1. docker-compose buildでのエラー1
     ・対象のDockerfile: docker/db/Dockerfile
      M1mac/windows両方でbuildした際に下記のエラーが表示される。
    #5 [2/7] RUN apt-get update
    #5 sha256:76c0a19d880ad15e4e3e7ad6734366bb5e30ed1043dab9ed32283f4d6bfb17dd
    #5 0.455 Get:1 http://security.debian.org/debian-security buster/updates InRelease [65.4 kB]
    #5 0.465 Get:2 http://deb.debian.org/debian buster InRelease [122 kB]
    #5 0.471 Get:3 http://repo.mysql.com/apt/debian buster InRelease [22.1 kB]
    #5 0.502 Get:4 http://deb.debian.org/debian buster-updates InRelease [51.9 kB]
    #5 0.604 Err:3 http://repo.mysql.com/apt/debian buster InRelease
    #5 0.604 The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29
    #5 0.738 Get:5 http://deb.debian.org/debian buster/main amd64 Packages [7906 kB]
    #5 1.081 Get:6 http://security.debian.org/debian-security buster/updates/main amd64 Packages [314 kB]
    #5 1.468 Get:7 http://deb.debian.org/debian buster-updates/main amd64 Packages [8792 B]
    #5 2.672 Reading package lists...
    #5 3.284 W: GPG error: http://repo.mysql.com/apt/debian buster InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29
    #5 3.284 E: The repository 'http://repo.mysql.com/apt/debian buster InRelease' is not signed.
    #5 ERROR: executor failed running [/bin/sh -c apt-get update]: exit code: 100

  2. docker-compose buildでのエラー2
     ・対象のDockerfile: docker/db/Dockerfile
    #7 [3/4] RUN localedef -f UTF-8 -i ja_JP ja_JP.utf8
    #7 sha256:b76452dc008312c89bea5f77d29ec1131f5db6fed89f7960303b04862f9bb5d5
    #7 0.292 failed to set locale!
    #7 0.292 [error] character map file UTF-8' not found: No such file or directory #7 0.292 failed to set locale! #7 0.292 [error] cannot read character map directory /usr/share/i18n/charmaps': No such file or directory
    #7 ERROR: executor failed running [/bin/sh -c localedef -f UTF-8 -i ja_JP ja_JP.utf8]: exit code: 1


[3/4] RUN localedef -f UTF-8 -i ja_JP ja_JP.utf8:


executor failed running [/bin/sh -c localedef -f UTF-8 -i ja_JP ja_JP.utf8]: exit code: 1
Service 'db' failed to build : Build failed

  1. 上記のエラー箇所をコメントアウトし、dockerを立ち上げた際に、アプリを立ち上げたときのエラー

error1

サイトオープン依頼

CTF終了後も、サイト開いておいていただける、と先生からお聞きしていたのですが、
クローズしているようなので、また再開していただけないでしょうか?
よろしくお願いいたします。

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.