Seeking Simple Docker Finance Management System reddit / selfhosted ---------------------------------------------------------------------- Jinlaoh_Ger · 2023-10-27 14:47 Hello r/selfhosted, I'm in search of an easy-to-install Docker Finance Management system. I've tried Firefly III and couldn't get it up and running. I then came across Openbudgeteer and encountered the same issue. It's likely that I'm not grasping the instructions correctly, but the Compose files result in errors, and many aspects are unclear or insufficiently described to me. ​ Ideally, I'd like a system that comes with a Docker Compose file, where I can assign my binds to my storage drive and configure my ports, and it just works, because I don't (yet) have that deep knowledge about Docker ;) ---------------------------------------------------------------------- arcadianarcadian · 2023-10-27 15:21 [https://github.com/awesome-selfhosted/awesome-selfhosted#money- budgeting--management](https://github.com/awesome-selfhosted/awesome- selfhosted#money-budgeting--management) I tried SilverStrike which is nice. Firefly is too complex to use imho. ---------------------------------------------------------------------- Jinlaoh_Ger · 2023-10-27 15:45 thx for your reply. is it an "living" Projekt i mean the website is down and the newest issue is from 2022 ... ---------------------------------------------------------------------- arcadianarcadian · 2023-10-27 15:56 SilverStrike ? I didn't notice it was dead. Sorry :) Try Actual, it should be a new project though. ---------------------------------------------------------------------- thekrautboy · 2023-10-27 17:41 Look at Firefly III and Actual Budget. ---------------------------------------------------------------------- Jinlaoh_Ger · 2023-10-27 18:18 I sonst geht Firefly to Work as mentioned in Post 1. Har multiple trys in it and Always got a "whoopsie your Database broke" Error. Actual works in First try as recommend ---------------------------------------------------------------------- Jinlaoh_Ger · 2023-10-27 18:19 Actual was a good Tip. Works in First try. Easy to understand. Thank you. Only Con.... No DARK Mode ---------------------------------------------------------------------- thekrautboy · 2023-10-27 18:43 /r/ihadastroke ---------------------------------------------------------------------- thekrautboy · 2023-10-27 21:29 Here is my complete working Firefly III compose, including MariaDB and the importer. I am using it with Nordigen, if you want to use Spectre instead, or no imports at all, adjust according the to Firefly documentation. Use this only as a basis. The importer To automate the importer, simply add a cronjob on the Docker host to run `docker compose -f /path/to/this/docker-compose.yml up -d firefly- importer` version: "3.3" networks: firefly: name: firefly services: firefly: container_name: firefly hostname: firefly image: fireflyiii/core:latest restart: unless-stopped networks: - firefly ports: - 8082:8080 depends_on: firefly-mariadb: condition: service_healthy environment: ### - SITE_OWNER=username@gmail.com - APP_KEY=ABC # generate with: head /dev/urandom | LC_ALL=C tr -dc 'A-Za-z0-9' | head -c 32 && echo - STATIC_CRON_TOKEN=ABC # generate with: openssl rand -hex 32 - TZ=Europe/Berlin - DEFAULT_LANGUAGE=en_US - DEFAULT_LOCALE=equal - TRUSTED_PROXIES=* - APP_ENV=local - APP_DEBUG=false - LOG_CHANNEL=stdout - APP_LOG_LEVEL=info - AUDIT_LOG_LEVEL=emergency ### db settings - DB_CONNECTION=mysql - DB_HOST=firefly-mariadb - DB_PORT=3306 - DB_DATABASE=firefly - DB_USERNAME=firefly - DB_PASSWORD=firefly ### cookie settings - COOKIE_PATH="/" - COOKIE_DOMAIN= - COOKIE_SECURE=false - COOKIE_SAMESITE=lax ### email settings - MAIL_MAILER=smtp - MAIL_HOST=smtp.gmail.com - MAIL_PORT=465 - MAIL_FROM=username@gmail.com - MAIL_USERNAME=username@gmail.com - MAIL_PASSWORD=ABC - MAIL_ENCRYPTION=ssl - SEND_ERROR_MESSAGE=true - SEND_REPORT_JOURNALS=true ### misc - ENABLE_EXTERNAL_MAP=false - ENABLE_EXTERNAL_RATES=false - MAP_DEFAULT_LAT=51.983333 - MAP_DEFAULT_LONG=5.916667 - MAP_DEFAULT_ZOOM=6 volumes: - ./upload:/var/www/html/storage/upload firefly-importer: container_name: firefly-importer image: fireflyiii/data-importer:latest restart: unless-stopped networks: - firefly ports: - 8083:8080 # after enabling automatic folder import (see below) this port mapping can be removed environment: - TZ=Europe/Berlin - WEB_SERVER=true # set to true to make it import from folder automatically, after you have created and download json config - FIREFLY_III_URL=http://firefly:8080 - VANITY_URL=https://firefly.example.com - FIREFLY_III_ACCESS_TOKEN=ABC - NORDIGEN_SANDBOX=false - NORDIGEN_ID=ABC - NORDIGEN_KEY=ABC - AUTO_IMPORT_SECRET=ABC # generate with: openssl rand -hex 32 - IGNORE_DUPLICATE_ERRORS=false - CAN_POST_AUTOIMPORT=true - CAN_POST_FILES=true - IMPORT_DIR_ALLOWLIST=/import - VERIFY_TLS_SECURITY=true - EXPECT_SECURE_URL=false - APP_NAME=DataImporter - APP_ENV=local - APP_DEBUG=false - LOG_CHANNEL=stdout - LOG_LEVEL=info - TRUSTED_PROXIES=* - ENABLE_MAIL_REPORT=true - MAIL_MAILER=smtp - MAIL_HOST=smtp.gmail.com - MAIL_PORT=465 - MAIL_DESTINATION=username@gmail.com - MAIL_FROM=username@gmail.com - MAIL_FROM_ADDRESS=username@gmail.com - MAIL_USERNAME=username@gmail.com - MAIL_PASSWORD=password - MAIL_ENCRYPTION=ssl volumes: - ./import:/import firefly-mariadb: container_name: firefly-mariadb image: mariadb:11.1.2 restart: unless-stopped networks: - firefly environment: - TZ=Europe/Berlin - MYSQL_ROOT_PASSWORD=firefly - MYSQL_USER=firefly - MYSQL_PASSWORD=firefly - MYSQL_DATABASE=firefly volumes: - /etc/timezone:/etc/timezone:ro - /etc/localtime:/etc/localtime:ro - ./mariadb:/var/lib/mysql healthcheck: test: ["CMD-SHELL", "mariadb-admin --user=$${MYSQL_USER} --password=$${MYSQL_PASSWORD} --host=localhost ping"] ---------------------------------------------------------------------- Jinlaoh_Ger · 2023-10-28 17:26 Thanks !!! it helped a lot, this way it worked way better than with the tings i got from that offical site. I Only have 2 Problems: 1. (and maybe bigger) When i try to Setup "Recurring transactions" there is a big blue Banner with this Msg. "Message: It seems the cron job that is necessary to support recurring transactions has never run. This is of course normal when you have just installed Firefly III, but this should be something to set up as soon as possible. Please check out the help-pages using the (?)-icon in the top right corner of the page." what cron job should i set up can you help with this too ?? 2. (minor) i Tryeed to Bind all Volumes to my Storaage disk but the folders stay empty. is that bc of the missing cron job ?? ---------------------------------------------------------------------- thekrautboy · 2023-10-28 17:35 https://docs.firefly-iii.org/firefly-iii/advanced- installation/cron/#cron-jobs-in-docker