Alexbelgium repo : 90+ addons

nickrout · September 20, 2024, 6:35am

After struggling to get Mealie back, I am not updating until I have a clear path. It’s not currently broken for you, so why change anything?

kenobrandt · October 10, 2024, 6:59pm

Hello @alexbelgium . Thank you for your work. I have one question. I use your mealie add-on and it work’s quite well. Could you add ingress support for the mealie instance? Could this easily be done by me if I only have to change some configs?
That would be way easier than for me to mess with SSL files and trying to install duckdns for an add-on next to the nabu casa.

Thank you for your time.

alexbelgium · October 10, 2024, 7:12pm

Hi, the Mealie mess should be sorted I’ve pushed a new version based on nightly 2.0 that should be compatible with all database versions.

alexbelgium · October 10, 2024, 7:15pm

Hi, ingress is super hard to implement and the biggest issue is that Mealie requires a hardcoded url at container creation which is not compatible with the way ingress works.

There is two ways : iframes, or if you feel adventurous you can install GitHub - lovelylain/hass_ingress: Home Assistant ingress feature, add additional ingress panels to your Home Assistant frontend. and try to add it yourself ; I’ve tried and failed up to now! To be fair I haven’t tried in some time but I’ve much less time now so mostly do critical support

alexbelgium · October 10, 2024, 7:17pm

Should be good now - I’ll keep on v2.0 from now on. But make a full HA backup just to be sure! The database from your version is located in the /config of homeassistant, which is not backuped when doing the add-on back-up.

Once the Mealie mess is sorted and people have safely migrated to the new version, I’m implement the new logic for config storage that will allow to have it backuped with the addon

kenobrandt · October 10, 2024, 7:36pm

Thanks for your reply. Sadly I have tried both options and I have failed. ( https://www.reddit.com/r/homeassistant/comments/1g0mgul/home_assistant_mealie_and_the_search_for_a_simple/ )
Now I’ll look for a different approach.

alexbelgium · October 10, 2024, 7:57pm

Hi, here is the initial thread discussing the lack of support for subpaths as ingress needs: Alexbelgium repo : 90+ addons - #332 by kenobrandt. BTW, several official add-ons also don’t support ingress (like bitwarden) in the end it is quite a hack…

If you find a way though I’ll be more than happy to implement it

nickrout · October 11, 2024, 4:16am

There is a Mealie addon floating around that claims to support ingress. If I find it, I’ll post.

Edit: See the discussion here A first class Mealie AddOn (Official or Community)

alexbelgium · October 11, 2024, 5:08am

Thanks! Interesting implementation it’s actually how I do also for my *arr add-ons - I’ll look to implement my *arr logic if this works indeed!

kenobrandt · October 11, 2024, 7:48am

If it actually works it would be grand, because I cant get this (hassio-addons/hassio-mealie-addon at main · krakonos1602/hassio-addons · GitHub) to start and test.

nickrout · October 11, 2024, 8:56am

You have to set up a few things, look at the docs.

ValleBL · October 21, 2024, 10:57am

There is a kinda new Reverse Proxy solution called Zoraxy (GitHub - tobychui/zoraxy: A general purpose HTTP reverse proxy and forwarding tool. Now written in Go!) which I would love to see and use in my Home Assistant installation.
Maybe check this and consider as ann addition to your repo?

alexbelgium · November 3, 2024, 4:14pm

Hi all, ingress for mealie is up please let me know if everything works as expected

alexbelgium · November 3, 2024, 4:16pm

Hi, honestly I have already way too many addons and prefer focusing on maintenance, except for things that I would myself use and especially given there is already strong addons for reverse proxies such as Nginx supported by HA itself. However you could use the portainer addon to run it

kenobrandt · November 7, 2024, 5:39am

Thank you very much. It work’s perfectly for me.

nlsbrng · January 5, 2025, 1:17pm

Hi @alexbelgium, I’ve been using quite a lot of add-ons from your repo, so I’d like to start with a big thanks!

I do have a problem with the Spotweb add-on though. It seems to install well, following the documentation and installing MariaDB as well. It starts fine, only outputting this error:

mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead

ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it

Error : /etc/cont-init.d/90-spotweb exiting 1

The webUI shows the database not existing:

Unable to connect to database:
SQLSTATE[HY000] [1049] Unknown database 'spotweb'


Please make sure your database server is up and running and your connection parameters are set

When I do create the database manually (using database name “spotweb”) it gives the following message:

2025/01/05 09:57:50 [error] 417#417: *11 FastCGI sent in stderr: "PHP message: SpotWeb Exception occured: 42S02: 1146: Table 'spotweb.settings' doesn't exist" while reading response header from upstream, client: 127.0.0.1, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.1.136:8123"

And the webUI shows this message (similar to the one above):

SpotWeb v0.68.38.34 on PHP v8.3.15 crashed object(SqlErrorException)#15 (7) { [“message”:protected]=> string(51) “42S02: 1146: Table ‘spotweb.settings’ doesn’t exist” [“string”:“Exception”:private]=> string(0) “” [“code”:protected]=> int(-1) [“file”:protected]=> string(28) “/app/lib/dbeng/dbeng_pdo.php” [“line”:protected]=> int(70) [“trace”:“Exception”:private]=> array(6) { [0]=> array(5) { [“file”]=> string(28) “/app/lib/dbeng/dbeng_pdo.php” [“line”]=> int(186) [“function”]=> string(4) “exec” [“class”]=> string(9) “dbeng_pdo” [“type”]=> string(2) “->” } [1]=> array(5) { [“file”]=> string(38) “/app/lib/dao/Base/Dao_Base_Setting.php” [“line”]=> int(25) [“function”]=> string(10) “arrayQuery” [“class”]=> string(9) “dbeng_pdo” [“type”]=> string(2) “->” } [2]=> array(5) { [“file”]=> string(60) “/app/lib/services/Settings/Services_Settings_DbContainer.php” [“line”]=> int(29) [“function”]=> string(14) “getAllSettings” [“class”]=> string(16) “Dao_Base_Setting” [“type”]=> string(2) “->” } [3]=> array(5) { [“file”]=> string(22) “/app/lib/Bootstrap.php” [“line”]=> int(218) [“function”]=> string(10) “initialize” [“class”]=> string(29) “Services_Settings_DbContainer” [“type”]=> string(2) “->” } [4]=> array(5) { [“file”]=> string(22) “/app/lib/Bootstrap.php” [“line”]=> int(43) [“function”]=> string(11) “getSettings” [“class”]=> string(9) “Bootstrap” [“type”]=> string(2) “->” } [5]=> array(5) { [“file”]=> string(14) “/app/index.php” [“line”]=> int(19) [“function”]=> string(4) “boot” [“class”]=> string(9) “Bootstrap” [“type”]=> string(2) “->” } } [“previous”:“Exception”:private]=> NULL } 42S02: 1146: Table ‘spotweb.settings’ doesn’t exist

AFAIK there are maybe two problems:

the spotweb database and user are not created
SSL is needed for MariaDB but not set up.

Can you help me out?

Thanks!

alexbelgium · January 10, 2025, 2:40pm

Thanks I’ll adapt the code !

Remco_van_Geel · January 13, 2025, 1:29pm

after a long time running whitout issues do I have a issue now:
/etc/cont-init.d/90-spotweb: line 95: /usr/bin/maria: No such file or directory
cont-init: info: /etc/cont-init.d/90-spotweb exited 127

not starting anymore. my database is an external mariadb database on another machine. It always worked but not now. I don’t know how to fixx to be honest.

alexbelgium · January 13, 2025, 2:11pm

My mistake I wrote “maria” instead of mariadb based on this line mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead ; I’ve pushed a new version now

Remco_van_Geel · January 13, 2025, 2:15pm

Do I have to wait until a buidl proces or is it possible to force/obtain this fix in another way?