Vikunja with local mysql

[choreutes]

I’m trying to setup a vikunja instance on my server. Since the server has mariadb running anyway for a nextcloud instance, I figured that using the mysql backend made the most sense. However, it seems that I’m running into authentication issues with this setup. My guess is that this is due to vikunja running under a dynamic systemd user instead of a permanent system user which the mysql socket authentication cannot authenticate. This might also be totally off the mark, I don’t have much experience with database servers yet.

Has anyone here managed to get a similar setup to work? Or am I the only one trying this madness? I’m using the current stable branch (nixos-25.11) updated last week.

[TLATER]

@choreutes

My guess is that this is due to vikunja running under a dynamic systemd user instead of a permanent system user which the mysql socket authentication cannot authenticate.

That’s a pretty good guess. The solution to this problem is to add the dynamic user to a group with SupplementaryGroups. If the socket remains invisible, you may need to add it to the visible paths with ReadWritePaths, or do some fenangling with systemd socket passing via file descriptors that most services seem incapable of supporting.