CypherSetup

Host Setup

mkdir -p /opt/cypherpunk/cypherpunk_reddit
cd /opt/cypherpunk/cypherpunk_reddit
ln -s /home/bob/projects/cypherpunk/cypherpunk_reddit/html ./
ln -s /home/bob/projects/cypherpunk/cypherpunk_reddit/archive ./
ln -s /home/bob/projects/cypherpunk/cypherpunk_reddit/config ./

Python Venv

python -m venv .venv
./.venv/bin/activate
pip install mysql-connector-python
pip install jinja2 flask
pip install secp256k1

MariaDB

apt install mariadb-server mariadb-client
sudo mariadb

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

create schema cypunk;

insert into cypunk.user ( username, salty_hash )
  values ('test1', 'saltyhash'),
         ('test2', 'anotherhash')
;