Installation in a docker on unraid

[pixbalance]

Hi,

I am trying to get part-db running on a docker on unraid. Maybe I get some advice.

The Database is "/mnt/user/appdata/partdb/db" but I did not figure out how to set the datebase_url. The app.db is created in the folder but has 0B.

docker run -d --name='partdb' --net='br0' --ip='172.16.0.77' -e TZ="Europe/Berlin" -e HOST_OS="Unraid" -e HOST_HOSTNAME="TAB-HomeServer" -e HOST_CONTAINERNAME="partdb" -e 'TCP_PORT_80'='80' -e 'DATABASE_URL'='sqlite:///%kernel.project_dir%/partdb/db/app.db' -e 'APP_ENV'='docker' -e 'DEFAULT_LANG'='de' -e 'DEFAULT_TIMEZONE'='Europe/Berlin' -e 'BASE_CURRENCY'='EUR' -e 'INSTANCE_NAME'='Part-DB' -e 'ALLOW_ATTACHMENT_DOWNLOADS'='0' -l net.unraid.docker.managed=dockerman -l net.unraid.docker.webui='http://[IP]:[PORT:80]' -l net.unraid.docker.icon='https://github.com/pawelmalak/unraid-templates/blob/master/templates/icons/partdb.png?raw=true' -v '/mnt/cache/appdata/partdb/uploads':'/var/www/html/uploads':'rw' -v '/mnt/cache/appdata/partdb/media':'/var/www/html/public/media':'rw' -v '/mnt/user/appdata/partdb/db':'/var/www/html/var/db':'rw' --restart unless-stopped 'jbtronics/part-db1:latest' da08308028a87770d5ea16dd9c09507108c46b232cba785ae24d49cbaf0459d9

[pixbalance]

btw, I get the error message:

Oops! An Error Occurred
The server returned a "500 Internal Server Error".
Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

[w0hc]

I have (had) it running on Unraid, but my motherboard appears to have died so I'm not able to check right now how I set it up. I am using sqlite rather than an external database, if that helps. Hope to have my new server parts here in a few days to rebuild then I can probably help more.

I get the error 500 quite often, usually when trying to import parts from Digikey.

[w0hc]

Also, I assume you are installing it from Community Apps and not manually?

[pixbalance]

correct. I used the community apps. I assume I still put in the wrong path to the sqlite database...

[w0hc]

I was able to get my box running. Your path is correct, and my database url is:
sqlite:///%kernel.project_dir%/var/db/app.db
Give that a try.

[pixbalance]

if I use
-v '/mnt/user/appdata/partdb/db':'/var/www/html/var/db':'rw

and
sqlite:///%kernel.project_dir%/var/db/app.db

i get another error:

[w0hc]

Here's my database settings from the docker edit page:
Database: /mnt/user/appdata/partdb/db

DATABASE_URL: sqlite:///%kernel.project_dir%/var/db/app.db

[pixbalance]

tried several times and reinstall without success. Thanks.

[w0hc]

Be sure to read the docs here: https://docs.part-db.de/installation/installation_docker.html

Have you ran
docker exec --user=www-data partdb php bin/console doctrine:migrations:migrate
from the Unraid console?

[pixbalance]

I totally missed that. run the line and it is working. :/ THX