after upgrading from IcingaWeb 2.11.4 to 2.12, I get this message under “Migrations”:
It seems that the currently used database user does not have the required privileges to execute the CREATE, SELECT, INSERT, UPDATE, DELETE, DROP, ALTER, CREATE VIEW, INDEX, EXECUTE SQL commands. Please provide an alternative user that has the appropriate credentials to resolve this issue.`
The user does have all this privileges on the icingaweb-db (show grants returns “ALL PRIVILEGES”). The only difference I can recognize is that
select * from INFORMATION_SCHEMA.SCHEMA_PRIVILEGES; shows a privilege_type called “EXECUTE”, not “EXECUTE SQL”.
Database Server is MariaDB 10.11.4
Maybe a small incompatibility?