Firefly III: A personal finances manager

[A Former User]

@thetomester13 said in Firefly III: A personal finances manager:

@murgero I actually haven't used Firefly before this (was waiting for the 'perfect' setup..). Do subsequent imports happen automatically? Or does the user need to trigger it? I know there's a cron that's supposed to run once per day and I believe that's set up properly in the CloudronManifest, but not sure how to test that that is doing its job properly.

@timbo when did you last pull the project's code? That was an issue originally, but should have been solved with some more recent updates.

i just installed the "unstable"-Version from the App Store.

[thetomester13]

@timbo @girish which version is currently packaged as the unstable app on the Store?

[jdaviescoates]

@thetomester13 looks like it's 4.8.2 as per https://cloudron.io/appstatus.html (it also tells you this when you click on Firefly in the app store)

[girish]

@thetomester13 Just noticed that you have already started on some tests. I will get it merged now and also update the package to 5.0.0

[girish]

@thetomester13 I have merged your test branch, thanks for writing the tests! I have published 5.0.0 and moved the app to stable. Do you want to inform the upstream project about this package? Maybe we can add it to https://github.com/firefly-iii/firefly-iii#get-started ?

[thetomester13]

@girish I was going to try and close the loop on some of those automated tests but thanks for crossing the finish line for me there! Glad this can be a nice addition to the Cloudron App Store portfolio! I definitely plan on updating the Firefly III repo to link to the App Store as well.

[A Former User]

i still get the formatting error as stated before though

[girish]

@timbo Yes, I was just updating the package adding the popular locales.

[A Former User]

Sorry for hitting you up again but i still get the problem, even after uninstall and a fresh install with the package being last updated "about 10 minutes" ago. i even made sure that the right locales are installed on my root and rebootet the server.

[girish]

@timbo The locales have to be installed in the app package and not on the server. I just pushed the update now (package version 1.1.0). Can you try on that? Just install a new ff to get the latest package or updates -> check for updates.

[A Former User]

@girish Yes it works now after manually updating again, confirming Package 1.1.0 being installed with the pop locales. Thanks girish for you amazing work!

[jk]

@girish It seems there is still an error in this app.

After adding a recurring transaction, the UI shows the following warning:

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.

After looking into it, I found that the cron job is added in the CloudronManifest.json file. But looking in the application logs, showed nothing about that task actually being run.

So I opened the console, and ran the command manually:

sudo -u www-data php /app/code/artisan firefly-iii:cron

This resulted in an error. Instead of pasting the gigantic stack trace, let me summarize it:

[2020-02-08 00:24:14] local.ERROR: SQLSTATE[08006] [7] invalid port number: "${CLOUDRON_POSTGRESQL_PORT}" (SQL: select * from "recurrences" where "recurrences"."deleted_at" is null order by "active" desc, "title" asc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 7): SQLSTATE[08006] [7] invalid port number: \"${CLOUDRON_POSTGRESQL_PORT}\" (SQL: select * from \"recurrences\" where \"recurrences\".\"deleted_at\" is null order by \"active\" desc, \"title\" asc) at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669)

[stacktrace cut]

[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDOException(code: 7): SQLSTATE[08006] [7] invalid port number: \"${CLOUDRON_POSTGRESQL_PORT}\" at /app/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31)

[stacktrace cut]

[previous exception] [object] (PDOException(code: 7): SQLSTATE[08006] [7] invalid port number: \"${CLOUDRON_POSTGRESQL_PORT}\" at /app/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27)

[stacktrace cut]

Any idea why this fails?

[girish]

Looks like the sudo is missing -E. I will update the package.

[girish]

@jk Pushed an update now to fix it.

[jk]

@girish Thanks. That was fast!

[A Former User]

Is this app only working with LDAP? No open registration? If so, can we change this?

[girish]

@timbo Not yet, can you create an issue at https://git.cloudron.io/cloudron/firefly-iii-app ?