VRising Database

Dependencies

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