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 database if not exists cypunk;
drop table if exists cypunk.user;
create table if not exists cypunk.user (
    id int not null primary key auto_increment,
    username varchar(128) not null unique key,
    salty_hash varchar(256) not null
);
drop table if exists cypunk.nostr_user;
create table if not exists cypunk.nostr_user (
    id int not null primary key auto_increment,
    user_id int not null,
    privhex varchar(256) not null
);

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