Alexbelgium repo : 90+ addons

alexbelgium · December 29, 2021, 8:28pm

New addons :

Firefly III : A free and open source personal finance manager
Firefly III Data Importer : Data importer for Firefly III
FlareSolverr : Proxy server to bypass Cloudflare protection

Edit : links updated

poudenes · December 30, 2021, 3:12pm

I installed it but get a error:

In Encrypter.php line 227:
                       
  The MAC is invalid.  
                       
/scripts/99-run.sh: exiting 1

alexbelgium · December 30, 2021, 6:18pm

Hi, are you referring to firefly III? This error means that the APP_KEY does not correspond to the currently stored data. Did you first launch it once, change you APP_KEY, then rebooted? If yes you can’t access your data anymore as it was encrypted on first launch with the APP_KEY you had specified…

poudenes · December 30, 2021, 7:53pm

Sorry, yes. So remove the Addon and reinstall it will solve this?

alexbelgium · December 30, 2021, 9:05pm

Mmh… I fear you need to delete the database too as the encrypted data would be stored here… Or put back the initial APP_KEY if you have it and accept the lower security (the database is still stored locally).

I’ve modified the code so a file named “/config/addons_config/fireflyiii/APP_KEY_BACKUP.txt” will contain all values of APP_KEY entered. That way, if you change it by mistake, you avoid losing all data by being able to recover your key.

poudenes · December 31, 2021, 7:59am

Luckily I just installed it. DB internal. So.when I delete the image and containers I will install and out before I start it a key.

alexbelgium · December 31, 2021, 8:11am

Well dB internal actually means you’ll find it in /config/addons_config/fireflyiii : you don’t need to uninstall the addon only delete this folder!

poudenes · December 31, 2021, 10:30am

Damn, Firefly III looks so great!!! How can this opensource and free… wow

In the importer I see this:

“NORDIGEN_ID”: your Nordigen Client ID
“NORDIGEN_KEY”: your Nordigen Client Secret

What is this?

and this:

“SPECTRE_APP_ID”: your Spectre / Salt Edge Client ID
“SPECTRE_SECRET”: your Spectre / Salt Edge Client secret

i Have a Salt Edge account. Can I use this also to import data into FireFly III?

alexbelgium · January 1, 2022, 1:41pm

Thanks! And happy new year
This might sound lame but the best is that you check the firefly documentation I’m not a user myself! I just added the env variables from the docker image!

poudenes · January 2, 2022, 6:11pm

Is it possible to add this also to FireFly?
So it makes it able to send email as well

MAIL_DRIVER=log
MAIL_HOST=smtp.example.com
MAIL_PORT=587
MAIL_FROM=<my-email>
MAIL_USERNAME=<my-email>
MAIL_PASSWORD=<password>
MAIL_ENCRYPTION=true

Its a Wonderfull application… I linked my bank to it with Nordigen
its so great!

alexbelgium · January 2, 2022, 6:15pm

Hi thanks!

There is just too many env variables, so I prefer not to go this way. But any variable you’ll set in the config.yaml will be exported.

So if you add those values in the config.yaml (so format is “VARIABKE: Value”) it will work directly

Here is the excerpt from the addon readme :

Config.yaml
Additional variables can be set as ENV variables by adding them in the config.yaml in the location defined in your addon options

The complete list of ENV variables can be seen here : https://raw.githubusercontent.com/firefly-iii/firefly-iii/main/.env.example

poudenes · January 2, 2022, 6:34pm

Thanks!!! I will add them manual!

poudenes · January 4, 2022, 9:54pm

@alexbelgium will it be possible to install PHP OpCache also to the container?
See below text was posting on GitHub:

The most effective means to increase performance was to turn on and configure the PHP OpCache , which stores precompiled script bytecode in the memory. This reduced the dashboard loading time from ~10 seconds to ~3 seconds.
I achieved similar performance when using Firefly III in Docker or in a VM on my PC (no PHP optimizations there, however).

github.com/firefly-iii/firefly-iii

Changing the app key (re-encrypting the data in the database)

opened 06:57PM - 05 Jan 18 UTC

closed 04:54AM - 12 Jan 18 UTC

ndandanov

Hey James, Happy New Year! Thank you for creating such a great piece of soft…ware! I am running Firefly III version 4.6.12 and try to migrate from version 4.6.9. #### Description of my issue: I recently installed Firefly III version 4.6.12 using composer on my home server. I am trying to migrate from version 4.6.9 installed via Docker Compose. Unfortunately, during the initial setup of the Docker Compose version, I left the default `SomeRandomStringOf32CharsExactly` key in the `.env` file. I would like to migrate the database to the new version with an appropriate key. However, most of the data therein is encrypted as mentioned [here](https://github.com/firefly-iii/help/wiki/Database-structure). Is there any script to re-encrypt the data in the database with the new key? Something like [this](https://gist.github.com/leonjza/ce27aa7435f8d131d93f) works, but I don't have any experience with PHP to interface it with all encrypted fields in the database. Maybe you have developed such tool for testing purposes? My database is not too big (a couple hundred records in the biggest tables) as I have been using the test installation for the past two months. CSV import/export seems to be somewhat incomplete as a straight export cannot be directly imported afterwards. All fields need manual matching, but some of them do not have a matching type in the drop-down menu. Thanks in advance!

alexbelgium · January 5, 2022, 5:19am

Hi, well in his text he says : “I achieved similar performance when using Firefly III in Docker or in a VM on my PC (no PHP optimizations there, however)” → so I think we already are in the context of maximum performance ?

poudenes · January 5, 2022, 10:10am

your right. read the text wrong

p.s. this is the best Add-on you created. Im so happy!!!

alexbelgium · January 5, 2022, 12:12pm

Thanks for the feedback!

poudenes · January 6, 2022, 11:23am

Hi,

Here again… haha

I removed Nextcloud to install it clean (want move from postgres to MariaDB)
I removed the add-on, I removed the info in /share/nextcloud.

Reinstalled the Add-on and start up. I see some issues now:

Nextcloud is not installed - only a limited number of commands are available

There are no commands defined in the "config:system" namespace.

I restarted Nextcloud again but get same issues.

 Add-on version: 23.0.0-8
 You are running the latest version of this add-on.
 System: Home Assistant OS 7.1  (aarch64 / raspberrypi4-64)
 Home Assistant Core: 2021.12.8
 Home Assistant Supervisor: 2021.12.2
-----------------------------------------------------------
 Please, share the above information when looking for help
 or support in, e.g., GitHub, forums
 https://github.com/alexbelgium/hassio-addons
-----------------------------------------------------------
[cont-init.d] 00-banner.sh: exited 0.
[cont-init.d] 01-envfile: executing... 
[cont-init.d] 01-envfile: exited 0.
[cont-init.d] 10-adduser.sh: executing... 
-------------------------------------
          _         ()
         | |  ___   _    __
         | | / __| | |  /  \
         | | \__ \ | | | () |
         |_| |___/ |_|  \__/
Brought to you by linuxserver.io
-------------------------------------
To support LSIO projects visit:
https://www.linuxserver.io/donate/
-------------------------------------
GID/UID
-------------------------------------
User uid:    1000
User gid:    1000
-------------------------------------
[cont-init.d] 10-adduser.sh: exited 0.
[cont-init.d] 20-config: executing... 
[cont-init.d] 20-config: exited 0.
[cont-init.d] 30-keygen.sh: executing... 
[12:20:10] INFO: Using referenced ssl certificates...
... checking if referenced files exist
... adding ssl certs in files
[12:20:11] INFO: ... done
[cont-init.d] 30-keygen.sh: exited 0.
[cont-init.d] 40-config.sh: executing... 
[cont-init.d] 40-config.sh: exited 1.
[cont-init.d] 50-install.sh: executing... 
[cont-init.d] 50-install.sh: exited 0.
[cont-init.d] 60-memcache.sh: executing... 
[12:20:12] INFO: Setting data diretory: /share/nextcloud
[cont-init.d] 60-memcache.sh: exited 0.
[cont-init.d] 90-custom-folders: executing... 
[cont-init.d] 90-custom-folders: exited 0.
[cont-init.d] 99-custom-files: executing... 
[custom-init] no custom files found exiting...
[cont-init.d] 99-custom-files: exited 0.
[cont-init.d] 99-elasticsearch.sh: executing... 
Nextcloud is not installed - only a limited number of commands are available
Full_Text_Search option not set
[cont-init.d] 99-elasticsearch.sh: exited 0.
[cont-init.d] 99-mariadb_discovery.sh: executing... 
[12:20:15] WARNING: MariaDB addon was found! It can't be configured automatically, but you can configure it manually using those values in the initial set-up :
Database user : service
Database password : MYDATABASEPASSWORD
Database name : nextcloud
Host-name : core-mariadb:3306
[cont-init.d] 99-mariadb_discovery.sh: exited 0.
[cont-init.d] 99-ocr.sh: executing... 
Nextcloud is not installed - only a limited number of commands are available
... installing apps : fulltextsearch
Installing OCR
ERROR: unable to select packages:
  tesseract-ocr-nld (no such package):
    required by: world[tesseract-ocr-nld]
ERROR: Not committing changes due to missing repository tags. Use --force-broken-world to override.
[12:20:24] FATAL: Couldn't install OCR lang nld. Please check its format is conform
[cont-init.d] 99-ocr.sh: exited 0.
[cont-init.d] 99-trusted_domains.sh: executing... 
Nextcloud is not installed - only a limited number of commands are available
[12:20:29] INFO: Currently set trusted domains :
Nextcloud is not installed - only a limited number of commands are available
                                                                   
  There are no commands defined in the "config:system" namespace.  
                                                                   
[12:20:30] INFO: No trusted domain set yet. The first one will be set when doing initial configuration
[12:20:30] INFO: Trusted domains set in the configuration. Refreshing domains.
[12:20:30] INFO: ... removing previously added trusted domain (except for first one created)
Nextcloud is not installed - only a limited number of commands are available
                                                                   
  There are no commands defined in the "config:system" namespace.  
                                                                   
[cont-init.d] 99-trusted_domains.sh: exited 1.
[cont-init.d] done.
[services.d] starting services
[services.d] done.

alexbelgium · January 6, 2022, 11:36am

Hi,

That’s totally normal, it just shows that nextcloud is not installed. After first config those will disappear. BTW I introduced a bug in 23.0.0-8 that prevents installation of ocr packages and pushed a 23.0.0-9 that solves it.

poudenes · January 6, 2022, 5:59pm

Thanks. And what about:

There are no commands defined in the "config:system" namespace.

alexbelgium · January 6, 2022, 8:15pm

Exactly the same : the script tells it to execute config commands to perform activities such as updating the ip whitelist, but those commands don’t exist as nextcloud is not configured yet. I could remove those by adding an if then loop that passes the command only if the config is done, but it occurs normally only at first boot and I’m not sure how to easily check if nextcloud basic config is done… Normally as soon as you create your config, all those should disappear and its all green again