Docker compose

ssh -i J9C110T.pem [[email protected]](mailto:[email protected])
sudo apt update
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo apt install apt-transport-https ca-certificates curl software-properties-common
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu bionic stable"
sudo apt update
sudo apt install docker-ce
sudo systemctl status docker
sudo curl -L https://github.com/docker/compose/releases/download/v2.21.0/docker-compose-`uname -s`-`uname -m` -o /usr/local/bin/docker-compose
sudo ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose
docker-compose --version
sudo usermod -aG docker $USER

Nginx, SSL

sudo apt install nginx
sudo systemctl status nginx
sudo vi /etc/nginx/sites-available/hpdp.conf
server {
        location / {
                proxy_pass http://127.0.0.1:3000;
                proxy_buffer_size          128k;
                proxy_buffers              4 256k;
                proxy_busy_buffers_size    256k;

                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header Host $http_host;
        }

        location /api {
                proxy_pass http://127.0.0.1:8080;

                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header Host $http_host;
                proxy_set_header Connection '';
                proxy_http_version 1.1;
								proxy_buffering off;
								chunked_transfer_encoding off;
        }
        location /articles {
                proxy_pass http://127.0.0.1:8000;

                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header Host $http_host;
        }
        location /bc {
                proxy_pass http://127.0.0.1:3334/;
                proxy_set_header Host $host;
                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header Upgrade $http_upgrade;
                proxy_set_header Connection "upgrade";
								proxy_set_header X-NginX-Proxy true;
        }

#       listen [::]:443 ssl ipv6only=on; # managed by Certbot
        listen 443 ssl; # managed by Certbot
        server_name j9c110.p.ssafy.io;

        ssl_certificate /etc/letsencrypt/live/j9c110.p.ssafy.io/fullchain.pem;
        ssl_certificate_key /etc/letsencrypt/live/j9c110.p.ssafy.io/privkey.pem;
        include /etc/letsencrypt/options-ssl-nginx.conf;
        ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem;
}

server {
        if ($host = j9c110.p.ssafy.io) {
                return 301 https://$host$request_uri;
        }

        listen 80;
#       listen [::]:80;
        server_name j9c110.p.ssafy.io;
        return 404;
# 심볼릭 링크 연결
sudo ln -s /etc/nginx/sites-available/hpdp.conf /etc/nginx/sites-enabled/hpdp.conf
# 재실행 -> hpdp.conf 파일 변경 시 재실행 해야함!!
sudo systemctl restart nginx

# 심볼릭 링크 제거(필요할 때 사용)
sudo rm /etc/nginx/sites-enabled/hpdp.conf
sudo apt-get install letsencrypt
sudo apt-get install python3-certbot-nginx
sudo certbot --nginx
> [email protected]
> a
> y
> j9c110.p.ssafy.io
> 2

MySQL

# mysql 설치
sudo apt install mysql-server
# mysql 상태 확인 -> running 이어야 함!!
sudo systemctl status mysql
# 외부 접속 허용하기
# bind-address 값을 0.0.0.0으로 설정 <- 해킹 위험 있을 수 있음!!
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
# mysql 재실행
sudo service mysql restart
# docker container로 올리기
# mysql_db라는 이름으로 root 계정 1q2w3e4r 비번 3305 포트로 올림
# mysql:latest <- docker로 이미지 풀 받아오는 과정을 거치지 않고 바로 가능
docker run --name mysql_db -e MYSQL_ROOT_PASSWORD=1q2w3e4r -d -p 3305:3306 mysql:latest
docker start mysql_db
# docker container에 있는 mysql에 접속
docker exec -it mysql_db bash
# root 계정 접속
mysql -u root -p
# 비번 입력
1q2w3e4r
# hpdp 사용자 만들어주고 권한 주기
use mysql;
create user 'hpdp'@'localhost' identified with mysql_native_password by '1q2w3e4r';
flush privileges;
create database hpdp; -> use hpdp;
grant all privileges on hpdp.all to 'hpdp'@'localhost';