Throat Install Guide, base Alpine Linux 3.10 multi-db

Title: Throat Install Guide, base Alpine Linux 3.10 multi-db

###
### Assume basic installation of Alpine Linux, openssh server installed and setup, a non-root user created and added to /etc/sudoers, bash installed
###

## Switch to root and  install dependencies
sudo su -
apk add --no-cache git bash build-base libffi-dev openssl-dev bzip2-dev zlib-dev readline-dev sqlite-dev curl bash bash-doc bash-completion redis npm jpeg-dev exiv2-dev boost-dev libxml2-dev libxslt-dev freetype-dev

## This is needed for the pip stage later on
ln -s /usr/lib/libboost_python37.so /usr/lib/libboost_python3.so

## Create user under which throat is installed and switch to it.
adduser --disabled-password --gecos "" -s /bin/bash app
su - app

## Setup pyenv
curl -L https://github.com/pyenv/pyenv-installer/raw/master/bin/pyenv-installer | bash
echo 'export PATH="/home/app/.pyenv/bin:$PATH"' >> ~/.profile
echo 'eval "$(pyenv init -)"' >> ~/.profile
echo 'eval "$(pyenv virtualenv-init -)"' >> ~/.profile
exit

### Database-related setup, pick your poison

##
## [M] For MySQL/MariaDB:
##
apk add --no-cache mariadb mariadb-client mariadb-connector-c-dev
mysql_install_db --user=mysql --datadir=/var/lib/mysql
rc-service mariadb start
mysqladmin -u root password "Pass1234"
rc-update add mariadb default
mysql -u root -p
CREATE DATABASE throat;
CREATE USER 'throat'@localhost IDENTIFIED BY 'Pass1234';
GRANT ALL PRIVILEGES ON throat.* TO 'throat'@localhost;
exit
## [M] end

##
## [P] For Postgresql:
##
apk add --no-cache postgresql postgresql-client postgresql-dev
sudo su - postgres
psql
CREATE DATABASE throat;
CREATE USER throat PASSWORD 'Pass1234';
GRANT ALL PRIVILEGES ON DATABASE throat TO throat;
exit
## [P] end

##
## [S] For SQLite:
##

apk add --no-cache sqlite

## [S] end

## Start redis and add to startup
rc-service redis start
rc-update add redis default

## Switch back to app and install python and set virtualenv
su - app
pyenv install 3.6.8
pyenv virtualenv 3.6.8 app

## Download throat, build css, assign dir to aforementioned virtualenv
git clone https://phab.phuks.co/source/throat.git
cd throat
npm install
npm run build
pyenv local app

## Upgrade pip, get requirements
pip install --upgrade pip
pip install -r requirements.txt

##
## [S] For SQLite:
##
sqlite3 throat.db
.quit
## [S] end


## Create and modify config
cp example.config.py config.py
nano config.py

##
## Database connection configuration
##

# [M] For MySQL/MariaDB:
DATABASE = {
    'host': 'localhost',
    'name': 'throat',
    'engine': 'MySQLDatabase',
    'charset': 'utf8mb4',
    'user': 'throat',
    'password': 'Pass1234',
}
# [M] end

# [P] For Postgresql:
DATABASE = {
    'host': 'localhost',
    'name': 'throat',
    'engine': 'PostgresqlDatabase',
    'user': 'throat',
    'password': 'Pass1234',
    'autorollback': True
}
# [P] end

# [S] For SQLite:
DATABASE = {
    'name': '/home/app/throat/throat.db',
    'engine': 'SqliteDatabase',
}
# [S] end

#----------

## Setup database
scripts/migrate.py

## to be able to access it from outside localhost...
nano wsgi.py
#add ", host='0.0.0.0'" to "socketio.run(app, debug=True)" inside parentheses

## to run: ./wsgi.py
## find IP of your machine (ifconfig), visit: http://<ip address>:5000

## Create an account for admin, close wsgi, then run:
scripts/admins.py --add admin

## To add created subs to defaults:
scripts/defaults.py -a subname