Skip to content
This repository has been archived by the owner on Aug 14, 2023. It is now read-only.

Latest commit

 

History

History
147 lines (109 loc) · 4.43 KB

README.md

File metadata and controls

147 lines (109 loc) · 4.43 KB

VRising Database

Dependencies

Vue 3 Vite Nginx Go Postgres

Links

---- Linux related ----

Frontend

  • npm i
  • npm run build
  • sudo systemctl restart nginx.service

Nginx Config path /etc/nginx/sites-available:

  • vrising-academy.info prod
server {
    # WWW redirect
    if ($host ~* www\.(.*)) {
        set $host_without_www $1;
        rewrite ^(.*)$ http://$host_without_www$1 permanent;
    }

    root /home/academy/VRisingAcademySite/frontend/dist;

    index index.html index.htm;
    server_name vrising-academy.info; # managed by Certbot

    error_page 404 /index.html;

    location / {
        try_files $uri $uri/ =404;
    }

    location /api {
        proxy_pass http://localhost:8087;
    }

    error_log /var/log/nginx/nginx-error.log;
    access_log /var/log/nginx/nginx-access.log;


    listen [::]:443 ssl ipv6only=on; # managed by Certbot
    listen 443 ssl; # managed by Certbot
    ssl_certificate /etc/letsencrypt/live/vrising-academy.info/fullchain.pem; # managed by Certbot
    ssl_certificate_key /etc/letsencrypt/live/vrising-academy.info/privkey.pem; # managed by Certbot
    include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot
    ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot


}

server {
    if ($host = vrising-academy.info) {
        return 301 https://$host$request_uri;
        } # managed by Certbot


        listen 80 ;
        listen [::]:80 ;
        server_name vrising-academy.info;
        return 404; # managed by Certbot


}

dev.vrising-academy.info dev

server {
    # WWW redirect
    if ($host ~* www\.(.*)) {
        set $host_without_www $1;
        rewrite ^(.*)$ http://$host_without_www$1 permanent;
    }

    root /home/academy/VRisingAcademySite-dev/frontend/dist;

    index index.html index.htm;
    server_name dev.vrising-academy.info; # managed by Certbot

    error_page 404 /index.html;

    location / {
        try_files $uri $uri/ =404;
    }

    location /api {
        proxy_pass http://localhost:4047;
    }

    error_log /var/log/nginx/nginx-error.log;
    access_log /var/log/nginx/nginx-access.log;


    listen [::]:443 ssl; # managed by Certbot
    listen 443 ssl; # managed by Certbot
    ssl_certificate /etc/letsencrypt/live/vrising-academy.info/fullchain.pem; # managed by Certbot
    ssl_certificate_key /etc/letsencrypt/live/vrising-academy.info/privkey.pem; # managed by Certbot
    include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot
    ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot

}

server {
    if ($host = dev.vrising-academy.info) {
        return 301 https://$host$request_uri;
        } # managed by Certbot


        server_name dev.vrising-academy.info;

        listen 80 ;
        listen [::]:80 ;
        return 404; # managed by Certbot


}

Backend

  • go build main.go
  • systemctl restart academy-go-server prod
  • systemctl restart academy-go-server-dev dev

GOLang server is launched as systemd daemon (service). Path to service: /etc/systemd/system/academy-go-server It should be COMPILED with go build and placed into directory /home/academy/VRisingAcademySite as main Possible to change the directory by editing ExecStart in systemd service

Commands related to go server

To enable (Add go server as systemd service): systemctl enable academy-go-server To disable (Disable go server as systemd service): systemctl disable academy-go-server To start GO server: systemctl start academy-go-server To stop GO server: systemctl stop academy-go-server

Database

  • sudo su postgrest
  • psql
  • \c vrisingdb prod
  • \c vrisingdb_dev dev