Hi everyone,
I’m trying to setup Vikunja on an AmberPRO via docker (I’m a noob at it, first experience), but I just can’t make it work. Even with the default docker-compose.yml from the wiki (here), I keep getting this:
2025-05-02 8:07:12 151 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
Sometimes alternated by this error:
2025-05-02 8:07:22 156 [Warning] Aborted connection 156 to db: 'unconnected' user: 'unauthenticated' host: '192.168.144.3' (This connection closed normally without authentication)
The frontend keeps restarting and I can’t do anything. I found a similar thread that suggested to switch to postgres or sqlite, but:
With Postgres, the .yml creates only the database, which runs but I have no frontend.
With sqlite, everything works.. but after a while the frontend randomly stops, with no errors in the logs for the db or the frontend. I should also add that this seems to happen faster if I use Vikunja.. If I don’t, the frontend seems to run for quite more time without any issue, even though it stops in the end. On the other hand, the db never stops working.
In all three cases I’m using the .yml configuration provided in the official wiki, modified accordingly. Below you can see the last one I’m using. Any ideas?
version: "3"
services:
vikunja:
image: vikunja/vikunja
environment:
VIKUNJA_SERVICE_JWTSECRET: <a super secure random secret>
VIKUNJA_SERVICE_PUBLICURL: http://192.168.68.70
# Note the default path is /app/vikunja/vikunja.db.
# This config variable moves it to a different folder so you can use a volume and
# store the database file outside the container so state is persisted even if the container is destroyed.
VIKUNJA_DATABASE_PATH: /db/vikunja.db
ports:
- 3456:3456
volumes:
- ./files:/app/vikunja/files
- ./db:/db
restart: unless-stopped
db:
image: mariadb:10
command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
environment:
MYSQL_ROOT_PASSWORD: supersecret
MYSQL_USER: vikunja
MYSQL_PASSWORD: changeme
MYSQL_DATABASE: vikunja
volumes:
- ./db:/var/lib/mysql
restart: unless-stopped
healthcheck:
test: ["CMD-SHELL", "mysqladmin ping -h localhost -u $$MYSQL_USER --password=$$MYSQL_PASSWORD"]
interval: 2s
start_period: 30s
Also in my setup this is exposed via Caddy reverse proxy (did not mention it in attached configs) and all ports exposed here are banned on firewall level.
@executed thank you, but the problem just disappeared in the same way it appeared I restarted my AmberPRO and now Vikunja is up and running, 7 days and going.. well, it works, so I guess it’s fine? lol.