Files
windyboy daf4aa3dfa Add P.A.R.A. methodology documentation and restructure Personal folder
- Created Methodology.md to outline the P.A.R.A. system and its components.
- Added Outline.md for a structured overview of P.A.R.A. content.
- Documented PKM content organization decisions in PKM-Consolidation-Decision.md.
- Introduced Workflows.md to explain practical applications of P.A.R.A. in work scenarios.
- Moved sensitive information to security-sensitive folder and restructured the Personal folder to align with P.A.R.A. principles.
- Archived backup files including Matrix Me.md and TTG Cookies.md.
- Implemented a comprehensive refactor of the Personal folder to improve organization and security.
2025-12-29 15:37:17 +08:00

1.6 KiB

create database vaultwarden;
CREATE USER vaultwarden WITH ENCRYPTED PASSWORD 'windysecurity';
GRANT ALL PRIVILEGES ON DATABASE vaultwarden TO vaultwarden;
LOAD DATABASE
     FROM sqlite:///opt/vaultwarden/vw-data/db.sqlite3
     INTO postgresql://vaultwarden:windysecurity@localhost:5432/vaultwarden

WITH include drop, create tables, create indexes, reset sequences
EXCLUDING TABLE NAMES LIKE '__diesel_schema_migrations'
ALTER SCHEMA 'main' RENAME TO 'public'
;

pgloader bitwarden.load
-- Grant usage and create permissions on the public schema
GRANT USAGE ON SCHEMA public TO vaultwarden;
GRANT CREATE ON SCHEMA public TO vaultwarden;

-- Optionally, grant all permissions on the public schema
GRANT ALL ON SCHEMA public TO vaultwarden;

-- Transfer ownership of the public schema to vaultwarden (optional)
ALTER SCHEMA public OWNER TO vaultwarden;

DOMAIN="https://auth.wsvc.info/"
DATABASE_URL=postgresql://vaultwarden:windysecurity@172.18.0.1:5432/vaultwarden
SMTP_HOST=smtp.windy.me
SMTP_FROM=<vnet@windy.me>
SMTP_PORT=587
SMTP_SECURITY=starttls
SMTP_USERNAME=vnet@windy.me
SMTP_PASSWORD=windyboy2006
i8aHqBZvgTjCoHKRqMqHxmbFs3JFwWnrzPuub09sUnYKTfwZ7m1VCKXABlSxRkJ6
echo -n "VjoM4sndg4.8uCzPmodH" | argon2 "$(openssl rand -base64 32)" -e -id -k 19456 -t 2 -p 1
$argon2id$v=19$m=19456,t=2,p=1$eXhRMTBiVXRjR2pFalpRYStCQys1SmtkaGVONTFJWm9HQmNMVDg2ZGlkVT0$ssdf1xrdTwXP7S7xoRiams1R3nGeSS3dkuKcPD/sO90
ADMIN_TOKEN='$argon2id$v=19$m=65540,t=3,p=4$d3Pa5o/TrvEhaVvj/bypWSnBqIFjU/rqkRV+Th7KmHU$ZDwdhqyIrTTvnAsIAUURjN3t3bgNWJfEh8Mv2cY0gUs'