In our matomo instance, we have two errors in the system check:
Both
CREATE TEMPORARY TABLES
and
LOAD DATA INFILE
seem to be not set.
But if I check in MariaDB itself:
±-----------------------------------------------------------------------------------------------------+
| Grants for matomo@% |
±-----------------------------------------------------------------------------------------------------+
| GRANT FILE ON . TO matomo@% IDENTIFIED BY PASSWORD 'x’ |
| GRANT ALL PRIVILEGES ON matomo. TO matomo@% |
±-----------------------------------------------------------------------------------------------------+
Everything is looking fine…?
Can you help me fixing this error?
We have 200k visits per month, so I guess it would be very helpful to get it to work.
Matomo and MariaDB are each running in their own containers in our on prem k8s.
So I checked everything again, it still is not working.
I get the same error on commandline and in the browser.
The MySQL User (matomo) hass all privileges needed.
The Folders in Matomo have been setup the right way.
The only thing I dont get: Do both the MySQL and the Matomo instance need to be on the same system?
Since I’m running it in k8s, they are running in different pods, and dont share any volume for files…?
No (and on high traffic it is advised to have separate servers).
But is seems the other user in the GitHub issue mentioned above did not get any solution:
I think I’ll just have to accept that this one server can’t run php console --no-ansi -n diagnostics:run without an inexplicable error – I’ll simply have to work around this.
If you have any further info, you can ask directly in the GutHub issue, as bx80 is really more a technical guy than I am…