Page 1 of 1
[ FireflyIII ] Personal finance manager
Posted: 29 Jun 2023, 04:29
by outkastm
About: https://www.firefly-iii.org
Category:
Applicable models: x.64 series
Applicable TOS4: 4.1.27 or later versions -
on request
Applicable TOS5: 5.1.37 or later versions
App download: https://tmnascommunity.eu/download/FireflyIII
Required packages:
apache24
MariaDB
PHP81_okm
App WebUI for additional settings can be accesses at:
TOS4: http(s)://yournasip:port/modules/FireflyIII/www
TOS5: click on
Support & Help from app description inside the App Center
How to manully install this app on TerraMaster application store?
1. Create a database using phpMyAdmin (from MariaDB app)
2. Adapt FireflyIII .env config and fill in the info for the database access (created on step 1)
3. Run these commands in ssh terminal
Code: Select all
cd /usr/local/FireflyIII/bin/FireflyIII
/usr/local/PHP81_okm/sys/bin/php artisan firefly-iii:upgrade-database
/usr/local/PHP81_okm/sys/bin/php artisan firefly-iii:correct-database
/usr/local/PHP81_okm/sys/bin/php artisan firefly-iii:report-integrity
/usr/local/PHP81_okm/sys/bin/php artisan passport:install
You can now access the FireflyIII Web interface and create the first user
Re: [ FireflyIII ] Personal finance manager
Posted: 05 Oct 2023, 22:24
by brunix86
Hi outkastm,
Just a note about the installation of the Firefly III database into MariaDB, regarding the "env" config file:
- Hostname 127.0.0.1 instead of localhost
- Port 3307 instead of 3306
Otherwise, a DB error happens when you launch the SSH commands.
Best Regards
Re: [ FireflyIII ] Personal finance manager
Posted: 09 Oct 2023, 05:33
by outkastm
Indeed, this is described at point 2 on the installation steps.
And here again the guide to create and use the database files created with MariaDB app.
https://tmnascommunity.eu/2022/11/30/ho ... phpmyadmin
Also on the MariaDB app post
https://tmnascommunity.eu/download/mariadb, it is mentioned to always use 127.0.0.1 instead of localhost and port 3307
Re: [ FireflyIII ] Personal finance manager
Posted: 09 Oct 2023, 14:41
by brunix86
Thanks, I see the DB guide now and it's all clear.
Regarding the "recurring transaction" (via cron jobs), I ran the following command from SSH:
Code: Select all
/usr/local/PHP81_okm/sys/bin/php artisan firefly-iii:cron
It worked but after some days I see the following warning into Firefly III:
Code: Select all
Warning! It looks like it has been more than 36 hours since the cron job to support recurring transactions has fired for the last time. Are you sure it has been set up correctly? Please check out the help-pages using the (?)-icon in the top right corner of the page.
How I can correctly enable the Firefly III cron jobs into TNAS?
Is there a way to check which cron jobs are scheduled?
Thanks!
Re: [ FireflyIII ] Personal finance manager
Posted: 12 Oct 2023, 00:04
by brunix86
Hi outkastm,
I found how to correctly enable the recurring transaction via crontabs into TOS 5.1.67 (x86-64 system).
- Open crontabs file using a text editor:
- Append the following line, in order to run crontab each day at 3AM:
Code: Select all
0 3 * * * /usr/local/PHP81_okm/sys/bin/php /usr/local/FireflyIII/bin/FireflyIII/artisan firefly-iii:cron
- Save and exit from the text editor
Now it works fine!
Re: [ FireflyIII ] Personal finance manager
Posted: 12 Oct 2023, 04:09
by outkastm
Much easier to use Cron_okm app for cron jobs. Also because the defined jobs will remain after reboots or TOS updates
https://tmnascommunity.eu/download/cron_okm/
Re: [ FireflyIII ] Personal finance manager
Posted: 12 Oct 2023, 22:56
by brunix86
[at=outkastm post_id=30289 time=1697054968 user_id=2797][/at]
Of course I will try with your suggestion!
Thanks
Re: [ FireflyIII ] Personal finance manager
Posted: 13 Oct 2023, 15:59
by Gremlin
In TOS5.1.nnn you could always use the customizable Scheduled Tasks function that is already built in. Works fine for me.
Re: [ FireflyIII ] Personal finance manager
Posted: 20 Dec 2023, 17:59
by brunix86
Hi, could you kindly add instruction to upgrade the 5.7.18 version to the last one (6.1.0) ?
I see that now is used PHP 8.3 and maybe the database is automatically upgrated.
Or, if you could, update the TOS5 TPK package?
https://docs.firefly-iii.org/how-to/fir ... lf-managed
https://github.com/firefly-iii/firefly- ... ses/latest
https://gist.github.com/JC5/909385c5086 ... e047446d68
Thanks!
Re: [ FireflyIII ] Personal finance manager
Posted: 21 Dec 2023, 06:57
by outkastm
i have to compile PHP 8.3, it will take a while