[ FireflyIII ] Personal finance manager

[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

[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

[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

[brunix86]

{L_BUTTON_AT}outkastm

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!

[brunix86]

Hi outkastm,
I found how to correctly enable the recurring transaction via crontabs into TOS 5.1.67 (x86-64 system).

1. Open crontabs file using a text editor:

   Code: Select all

   vi /etc/crontabs/root

2. 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

3. Save and exit from the text editor

Now it works fine!

[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/

[brunix86]

[at=outkastm post_id=30289 time=1697054968 user_id=2797][/at]

Of course I will try with your suggestion!
Thanks

[Gremlin]

In TOS5.1.nnn you could always use the customizable Scheduled Tasks function that is already built in. Works fine for me.

[brunix86]

{L_BUTTON_AT}outkastm

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!

[outkastm]

i have to compile PHP 8.3, it will take a while