im my docker setup I defined a user dedicated for Nextcloud (besides mysqlroot). I’m not an expert in MariaDB but maybe an application is simply not allowed to use root credentials.
try adding Nextcloud DB and Nextcloud user (and use this credentials for NC setup):
hint: you can use environment files like .env - it makes easier to use and change settings - if you use ${NC_MYSQL_PWD} multiple times you only need to change it once in your .env file…
Yup just tried it with the mysql_password variable in the nextcloud container. That didn’t work. Also setting every mysql variable(Host, Password, User and Database) didnt work sadly. Still the same error as above.
From MariaDB 10.6.0, tables that are of the COMPRESSED row format are read-only by default. This is the first step towards removing write support and deprecating the feature.
Sooo. The fix was actually pretty easy for mariadb 10.6.0. @Chartman123 lead me in the right direction.
Adding
command: --innodb-read-only-compressed=OFF
fixes the error. The other stuff that is in the offical docker-compose file isn’t needed for this to be fixed(Not really sure what that does anyway). Thanks for the help!
Hi, can you maybe elaborate on how you fixed this?
I tried to exec into the container and run
mysqld --innodb-read-only-compressed=OFF
but it didn’t work
It basically said: Don’t touch me, you don’t know what your doing!
Or should i just edit some config file withing the volume? (from outside the container?)