UNRAID code: 'ERR_INVALID_URL', input: '/appdata/db/db.sqlite' using mysql
Hi, newcomer here.
I can't get the container to work on unraid with theses parameters (mysql db & authentik for oidc)
I'm getting an error 500 with those logs (last pic)
I use manrw's template and deleted blanks variables.
Solution:Jump to solution
Hey @Theosusan
The current version does not support mariadb, some parts may work but I would generally not use mariadb for now. The orm we are using has it in the backlog for v1, but I can not give you an ETA...
6 Replies
Thank you for submitting a support request.
Depending on the volume of requests, our team should get in contact with you shortly.
⚠️ Please include the following details in your post or we may reject your request without further comment: - Log (See https://homarr.dev/docs/community/faq#how-do-i-open-the-console--log) - Operating system (Unraid, TrueNAS, Ubuntu, ...) - Exact Homarr version (eg. 0.15.0, not latest) - Configuration (eg. docker-compose, screenshot or similar. Use ``your-text`` to format) - Other relevant information (eg. your devices, your browser, ...)
Frequently Asked Questions | Homarr documentation
Can I install Homarr on a Raspberry Pi?
I'm using this image https://github.com/homarr-labs/homarr/pkgs/container/homarr/338927035?tag=v1.0.1 and of course this directory is empty but I can't tell why it's still looking for db.sqlite
Fixed it myself by deleting all env variables and starting from scratch. Maybe there was an error in the template i'm using..
Now my logs are flooded with this but it's seems to work even so
2025-01-18T09:44:35.019Z error: Failed to run job 'mediaServer': Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(select coalesce(json_arrayagg(json_array(
items_integrations.item_id, it...' at line 1
2025-01-18T09:44:35.019Z error: Failed to run job 'downloads': Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(select coalesce(json_arrayagg(json_array(items_integrations.item_id, it...' at line 1
2025-01-18T09:44:35.020Z error: Failed to run job 'dnsHole': Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(select coalesce(json_arrayagg(json_array(items_integrations.item_id, it...' at line 1
2025-01-18T09:44:35.020Z error: Failed to run job 'healthMonitoring': Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(select coalesce(json_arrayagg(json_array(items_integrations.item_id, it...' at line 1
2Solution
Hey @Theosusan
The current version does not support mariadb, some parts may work but I would generally not use mariadb for now. The orm we are using has it in the backlog for v1, but I can not give you an ETA
Thanks for the response, i didn't see anywhere that mysql won't work on the documentation :/ I'll mark my issue as done then
Mysql works, but mariadb has a little diffrent language
Your server is a MariaDB server