Files
HomeAudit/logs/sqlite_to_postgres_migration.log
admin 705a2757c1 Major infrastructure migration and Vaultwarden PostgreSQL troubleshooting
COMPREHENSIVE CHANGES:

INFRASTRUCTURE MIGRATION:
- Migrated services to Docker Swarm on OMV800 (192.168.50.229)
- Deployed PostgreSQL database for Vaultwarden migration
- Updated all stack configurations for Docker Swarm compatibility
- Added comprehensive monitoring stack (Prometheus, Grafana, Blackbox)
- Implemented proper secret management for all services

VAULTWARDEN POSTGRESQL MIGRATION:
- Attempted migration from SQLite to PostgreSQL for NFS compatibility
- Created PostgreSQL stack with proper user/password configuration
- Built custom Vaultwarden image with PostgreSQL support
- Troubleshot persistent SQLite fallback issue despite PostgreSQL config
- Identified known issue where Vaultwarden silently falls back to SQLite
- Added ENABLE_DB_WAL=false to prevent filesystem compatibility issues
- Current status: Old Vaultwarden on lenovo410 still working, new one has config issues

PAPERLESS SERVICES:
- Successfully deployed Paperless-NGX and Paperless-AI on OMV800
- Both services running on ports 8000 and 3000 respectively
- Caddy configuration updated for external access
- Services accessible via paperless.pressmess.duckdns.org and paperless-ai.pressmess.duckdns.org

CADDY CONFIGURATION:
- Updated Caddyfile on Surface (192.168.50.254) for new service locations
- Fixed Vaultwarden reverse proxy to point to new Docker Swarm service
- Removed old notification hub reference that was causing conflicts
- All services properly configured for external access via DuckDNS

BACKUP AND DISCOVERY:
- Created comprehensive backup system for all hosts
- Generated detailed discovery reports for infrastructure analysis
- Implemented automated backup validation scripts
- Created migration progress tracking and verification reports

MONITORING STACK:
- Deployed Prometheus, Grafana, and Blackbox monitoring
- Created infrastructure and system overview dashboards
- Added proper service discovery and alerting configuration
- Implemented performance monitoring for all critical services

DOCUMENTATION:
- Reorganized documentation into logical structure
- Created comprehensive migration playbook and troubleshooting guides
- Added hardware specifications and optimization recommendations
- Documented all configuration changes and service dependencies

CURRENT STATUS:
- Paperless services:  Working and accessible externally
- Vaultwarden:  PostgreSQL configuration issues, old instance still working
- Monitoring:  Deployed and operational
- Caddy:  Updated and working for external access
- PostgreSQL:  Database running, connection issues with Vaultwarden

NEXT STEPS:
- Continue troubleshooting Vaultwarden PostgreSQL configuration
- Consider alternative approaches for Vaultwarden migration
- Validate all external service access
- Complete final migration validation

TECHNICAL NOTES:
- Used Docker Swarm for orchestration on OMV800
- Implemented proper secret management for sensitive data
- Added comprehensive logging and monitoring
- Created automated backup and validation scripts
2025-08-30 20:18:44 -04:00

21 lines
1.5 KiB
Plaintext
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
[2025-08-30 14:51:16] Starting Vaultwarden SQLite to PostgreSQL migration
[2025-08-30 14:51:16] Step 1: Stopping current Vaultwarden service
[2025-08-30 14:51:27] Step 2: Creating migration container
[2025-08-30 14:51:51] Starting Vaultwarden SQLite to PostgreSQL migration
[2025-08-30 14:51:51] Step 1: Stopping current Vaultwarden service
[2025-08-30 14:52:02] Step 2: Creating migration container
[2025-08-30 14:52:14] Starting Vaultwarden SQLite to PostgreSQL migration
[2025-08-30 14:52:14] Step 1: Stopping current Vaultwarden service
[2025-08-30 14:52:24] Step 2: Creating migration container
[2025-08-30 14:52:26] Step 3: Installing pgloader in migration container
[2025-08-30 14:52:47] Step 4: Creating migration script
[2025-08-30 14:52:48] Step 5: Running database migration
[2025-08-30 14:52:48] ERROR: Database migration failed
[2025-08-30 14:53:06] Starting Vaultwarden SQLite to PostgreSQL migration
[2025-08-30 14:53:06] Step 1: Stopping current Vaultwarden service
[2025-08-30 14:53:17] Step 2: Creating migration container
[2025-08-30 14:53:18] Step 3: Installing pgloader in migration container
[2025-08-30 14:53:34] Step 4: Creating migration script
[2025-08-30 14:53:34] Step 5: Running database migration
[2025-08-30 14:53:35] ERROR: Database migration failed