Breaking: Actual Budget Script (HTTPS / DB Migration / New Structure)

[MickLesk]

ActualBudget Update & Migration Guide

📌 Important: Backup Your Data First

Before updating, export your Actual Budget data to avoid data loss. Follow these steps:

1. Login to your budget and go to More > Settings.
2. Scroll down to Export and click Export Data.
3. Save the file to your computer.

For detailed instructions, see the Backup & Restore Guide.

---

🚀 Key Changes in the New Version

1️⃣ Database Changes

• New database structure, including a password column in auth.
• Migrations are now stored in /opt/actualbudget-data/migrate/.

2️⃣ File Structure Overhaul

• Data moved to /opt/actualbudget-data/.
• Key directories:
  • /opt/actualbudget-data/server-files/
  • /opt/actualbudget-data/user-files/
  • /opt/actualbudget-data/migrations/
  • /opt/actualbudget-data/migrate/
  • /opt/actualbudget-data/config/
• .env is now stored in /opt/actualbudget-data/.

3️⃣ New HTTPS Support

• Supports self-signed certificates.
• Certificates must be renewed manually.

4️⃣ If Issues Persist, Reinstall in a New LXC

• open your Proxmox Main Node and enter:

bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/actualbudget.sh)"

---

🔐 Enabling HTTPS

Generate a Self-Signed Certificate

openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /opt/actualbudget/selfhost.key -out /opt/actualbudget/selfhost.crt

Configure HTTPS

Update .env:

ACTUAL_HTTPS_KEY=/opt/actualbudget/selfhost.key
ACTUAL_HTTPS_CERT=/opt/actualbudget/selfhost.crt

Restart service:

systemctl restart actualbudget

Renew Certificate Manually

openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /opt/actualbudget/selfhost.key -out /opt/actualbudget/selfhost.crt
systemctl restart actualbudget

---

🎯 Summary

✅ Backup before updating (see Backup Guide)
✅ HTTPS supported but needs manual renewal
✅ If update fails, migrate manually or reinstall LXC

[knario]

Muchísimas gracias por el esfuerzo y por todo el trabajo.