Install

Create user and set password

useradd -m -s /bin/bash oskar
passwd oskar
su oskar

Sudo privileges for oskar

usermod -aG sudo oskar

Change to user oskar and switch to home directory

su oskar
cd ~

Install required packages

sudo apt update
sudo apt install nginx build-essential libssl-dev libffi-dev python3-dev python3-venv mariadb-server sqitch npm

Clone repo

git clone https://github.com/kamkalian/reparaturcafe3.git
cd reparaturcafe3

Configure nginx

sudo cp nginx_conf/reparaturcafe.conf /etc/nginx/sites-available/reparaturcafe.conf
sudo cp nginx_conf/proxy_forward.conf /etc/nginx/snippets/proxy_forward.conf 

Modify /etc/nginx/repataturcafe.conf for your domain and ssh keys.

Activate config and restart nginx

sudo ln -s /etc/nginx/sites-available/reparaturcafe.conf /etc/nginx/sites-enabled/
sudo systemctl restart nginx 

if config file contains errors check with:

sudo nginx -t

Configuring MariaDB

sudo mysql_secure_installation

Open mariadb terminal for the next steps:

sudo mariadb

Create database 'reparaturcafe' and 'sqitch'

create database reparaturcafe;
create database sqitch;

Create database user with all privileges for database 'reparaturcafe' and 'sqitch'

create user 'oskar'@localhost identified by 'password';
grant all privileges on reparaturcafe.* to 'oskar'@localhost;
grant all privileges on sqitch.* to 'oskar'@localhost;
flush privileges;
exit;

Create database tables

Execute the folowing command as root:

sqitch deploy db:mysql:reparaturcafe

Create first user

python create_user.py

Getting started

Install venv and required modules

python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

Create SSL certificates

sudo .venv/bin/certbot --certonly --nginx

Write the correct path of ssl cert files to nginx conf.

Create .env

Specify the following variables: DB_MYSQL_HOST=localhost DB_MYSQL_PORT=3306 DB_MYSQL_DATABASE=reparaturcafe DB_MYSQL_USER=oskar DB_MYSQL_PASSWORD= NEXT_PUBLIC_API_URL= SECRET_KEY= ALGORITHM=HS256 ACCESS_TOKEN_EXPIRE_MINUTES=1445

Install npm modules

npm install

Install pm2 and generate startup script

sudo npm install -g pm2

For Developement

Start development server

npm run dev

Start api

.venv/bin/uvicorn --reload --port 8000 --app-dir "/home/oskar/reparaturcafe3/" api.main:app

For Production

Build gui

npm install

Start app and api via pm2

pm2 start npm -- start
pm2 start ".venv/bin/uvicorn --reload --port 8000 --app-dir '/home/oskar/reparaturcafe3/' api.main:app" --name fastapi

Save pm2 process list

pm2 save

Sqitch

Create migration files (for deploy, revert, verify)

sqitch add tasks -n 'Creates tasks table.'

Deploy change:

sqitch deploy db:mysql:reparaturcafe

Rebase

sqitch rebase db:mysql:reparaturcafe --onto users