Suddenly getting permissions errors in MariaDB

I am running mariadb in portainer so that I can have all of my Kodi devices share a database. I've been doing this for years without a problem.

Last week my kodi devices stopped working - whenever there was any kind of access to the library the app would crash. In my experience this is often the result of an issue with the shared db so I checked there first. Sure enough, I could not access it via an SQL viewer. I then went to portainer and saw this error:

 -1 }">2022-08-27 15:27:11+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.5+maria~focal started.
 -1 }">2022-08-27 15:27:11+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
 -1 }">error: exec: "/usr/local/bin/docker-entrypoint.sh": stat /usr/local/bin/docker-entrypoint.sh: permission denied
 -1 }">2022-08-27 15:27:17+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.5+maria~focal started.
 -1 }">2022-08-27 15:27:17+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
 -1 }">error: exec: "/usr/local/bin/docker-entrypoint.sh": stat /usr/local/bin/docker-entrypoint.sh: permission denied
 -1 }">2022-08-27 15:27:23+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.5+maria~focal started.
 -1 }">2022-08-27 15:27:23+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

From what I've read online this isn't necessarily specific to mariadb as it is often a docker issue. I saw some threads instructing me to uninstall and reinstall docker. I did this in the OMV UI and it didn't seem to help. Other people have recommended various commands be run - I am a little nervous to run them. Any help would be greatly appreciated!

I don't know if this is related or not but I also noticed that my mumble chat service is also no longer working. All of my other containers seem to be fine - SABNzbd, Radarr, Sonarr, etc, as I can access them via their port number in the browser and they are functioning correctly.

 -1 }">2022-08-28T13:44:53.095 <docker-entrypoint> INFO - Exit signal received, commencing shutdown
 -1 }">2022-08-28T13:44:54.937 <docker-entrypoint> INFO - Entrypoint script version 1.1.0
 -1 }">2022-08-28T13:44:54.941 <docker-entrypoint> INFO - Entrypoint functions version 1.1.0
 -1 }">2022-08-28T13:44:54.945 <docker-entrypoint> INFO - Entrypoint running with UID 0 (root)
 -1 }">2022-08-28T13:44:54.951 <docker-entrypoint> INFO - GID/UID for murmur are unchanged: GID=999, UID=999
 -1 }">2022-08-28T13:44:54.954 <docker-entrypoint> INFO - Insuring murmur.ini setup for container
 -1 }">2022-08-28T13:44:54.978 <docker-entrypoint> WARN - SSL: missing '/opt/murmur/cert/privkey.pem', murmur will use self-signed SSL certificate
 -1 }">2022-08-28T13:44:54.982 <docker-entrypoint> WARN - SSL: missing '/opt/murmur/cert/fullchain.pem', murmur will use self-signed SSL certificate
 -1 }">2022-08-28T13:44:54.986 <docker-entrypoint> INFO - Ensuring permissions are correct before continuing - 'chown -R murmur:murmur /opt/murmur'
 -1 }">2022-08-28T13:44:54.989 <docker-entrypoint> INFO - Running recursive 'chown' on Docker overlay2 storage is **really** slow. This may take a bit.
 -1 }">2022-08-28T13:44:54.994 <docker-entrypoint> EXEC - /opt/murmur/murmur.x86  -fg -v -ini /opt/murmur/config/murmur.ini
 -1 }">Failed to set initial capabilities
 -1 }"><X>2022-08-28 13:44:55.092 SSL: OpenSSL version is 'OpenSSL 1.0.2k  26 Jan 2017'
 -1 }"><W>2022-08-28 13:44:55.092 Initializing settings from /opt/murmur/config/murmur.ini (basepath /opt/murmur/config)
 -1 }"><W>2022-08-28 13:44:55.192 MetaParams: TLS cipher preference is "<redacted>"
 -1 }"><C>2022-08-28 17:44:55.192 Successfully switched to uid 999
 -1 }"><C>2022-08-28 17:44:55.192 Failed to set initial capabilities

Zitat von chente

My answer is not going to help you with your problem, I don't know how to solve it, sorry.

But an alternative way and that will not give you errors to synchronize kodi databases is to use Jellyfin as an addon within kodi.

https://jellyfin.org/docs/general/clients/kodi.html

You will get the same result, synchronized database, with less headaches. I don't know if this could apply in your case and you will probably have to rescan your database the first time. As an added bonus it will allow you to use your server's GPU (if present) to transcode video and run kodi on RPI3 and watch HEVC seamlessly.

Thank you so much for taking the time to post. It is kind of ironic that you posted what you did because I had been considering dropping the shared database idea to go with something else. I actually only need the watched state. I have been using trakt for a long time for my ratings but one of the downsides to Trakt is that - to the best of my understanding - if you turn on sync it will try to sync the current status of the libraries on both ends. I generally delete a movie once I have finished watching it so I would only want it to send the watch status to trakt and NOT sync the libraries.

As for the rest of the functionality - it looks fairly redundant with Plex (which I use when streaming externally) so I don't think I would need it. Would it be overkill for just syncing watch status between devices?