View difference between Paste ID: zFfLuMV6 and T9NeTnJF

-====
+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.
+
-====
+###
 ### Assume basic installation of Alpine Linux, openssh server installed and setup, a non-root user created and added to /etc/sudoers, bash installed
-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 mariadb mariadb-client mariadb-connector-c-dev jpeg-dev exiv2-dev boost-dev libxml2-dev libxslt-dev freetype-dev
+
 ## 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
 
-echo 'export PATH="/home/app/.pyenv/bin:$PATH"' >> ~/.bashrc
+## This is needed for the pip stage later on
-echo 'eval "$(pyenv init -)"' >> ~/.bashrc
+ln -s /usr/lib/libboost_python37.so /usr/lib/libboost_python3.so
-echo 'eval "$(pyenv virtualenv-init -)"' >> ~/.bashrc
+
-bash
+## Create user under which throat is installed and switch to it.
-pyenv install 3.5.7
+
-pyenv virtualenv 3.5.7 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:
 ##
-mysqladmin -u root password "P@ssword"
+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"
-CREATE USER 'throat'@localhost IDENTIFIED BY 'P@ssword';
+
 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
 
-bash
+##
 ## [P] For Postgresql:
 ##
 apk add --no-cache postgresql postgresql-client postgresql-dev
-#set DB_USER to throat
+sudo su - postgres
-#set DB_PASSWD to P@ssword
+psql
-#set DB_NAME to throat (or whatever was created, default is phuks)
+
 CREATE USER throat PASSWORD 'Pass1234';
-cd scripts
+GRANT ALL PRIVILEGES ON DATABASE throat TO throat;
-./install.py
+
-cd ..
+## [P] end
 
-#socketio.run(app, debug=True, host='0.0.0.0')
+##
 ## [S] For SQLite:
-# to run: ./wsgi.py
+##
-# find IP of your machine, visit: http://<ip address>:5000
+
-# username: admin, password: adminadmin
+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