Hi,
After updating from OMV3 to 4 a few days ago i noticed that my kodi box could not longer access the MySQL server on my nas. All local apps and services (nextcloud for example) still worked fine.
I tried resetting settings in the plugin, switching the bind adress from 0.0.0.0 to the local adress and back, disabling and enabling the server through the plugin but nothing worked.
Then i noticed that the mariadb server was still running even tho i switched it off (nextcloud was still working fine) and no log entries for stopping or starting the server.
I then tried to restart the maria db server from ssh (service mariadb restart) and this finally did the trick. Now i can access the mysql server again from other machines on my network.
I have 2 files in /etc/mysql/mariadb.conf.d/ that seem to control the server settings:
50-server.cnf and openmediavault-mysql.cnf
The first one has the default bind adress set (127.0.0.1) and the other one holds the mysql plugin settings.
Is there a bug in the plugin? Or maybe something got screwed up in my upgrade from omv 3 to 4?
I also got the following warning yesterday:
/etc/cron.daily/logrotate:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
error: error running shared postrotate script for '/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log '
run-parts: /etc/cron.daily/logrotate exited with return code 1
My MySQL Server doesnt seem to have the "debian-sys-main" user in its config (according to the MyWebSQL interface)
Maybe this is related as well?