Resolved 48 identified issues across 5 remediation batches: Critical Fixes (2/2 = 100%): - Removed duplicate "System Architec" directory with 4 archived files - Fixed broken PARA Notes wikilinks in 2 Outline.md files High Priority (14/15 = 93%): - Consolidated 10+ duplicate file pairs to canonical locations - Added frontmatter to 30 files in 200-area (now 100% coverage) - Relocated orphaned image with updated reference - Removed security-sensitive file duplicates Medium Priority (32/41 = 78%): - Deleted 4 empty files (0-15 bytes each) - Relocated misplaced files to proper PARA categories - Improved archive organization structure File Changes: - Modified: 33 files (frontmatter + wikilink fixes) - Moved: 16 files (to archive or new locations) - Deleted: 6 files (duplicates after archival) - Created: 25 files (archived copies + documentation) Vault Health Improvement: - Frontmatter coverage: 43% → 75% - Broken wikilinks: 2 → 0 - Duplicate files: 10+ → 0 - Empty files: 4 → 0 - Overall health score: 6.5/10 → 8.5/10 Documentation: - Created comprehensive remediation plan and batch reports in copilot/ - All changes tracked with detailed change reports - No data loss - duplicates archived, not deleted 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
72 lines
1.6 KiB
Markdown
72 lines
1.6 KiB
Markdown
|
|
|
|
```
|
|
create database vaultwarden;
|
|
```
|
|
|
|
|
|
```
|
|
CREATE USER vaultwarden WITH ENCRYPTED PASSWORD 'windysecurity';
|
|
GRANT ALL PRIVILEGES ON DATABASE vaultwarden TO vaultwarden;
|
|
```
|
|
|
|
|
|
```bitwarden.load
|
|
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;
|
|
|
|
```
|
|
|
|
|
|
```.env
|
|
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
|
|
```
|
|
|
|
```admin token
|
|
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'
|
|
```
|