Readonly database user not working #15697
Labels
Waiting for user feedback
Indicates the Matomo team is waiting for feedback from the author or other users.
Milestone
Comments
|
I can only suppose it fails to create temporary tables on the reader. Not sure how your particular MariaDB version handles this. Maybe there is a setting or maybe it needs upgrading to a different version or so. For now I would recommend you upgrade to the latest Matomo version and see if it works there maybe. This is recommended anyway to be compatible with recent browser changes in case you are using JavaScript tracking. |
Findus23
added
the
Waiting for user feedback
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi, we are using matomo version 3.12.0.
We have recently divide our database into master-slave type clusters.
When we defined
database_readerconfigurations with slave information as below, we gotSQLSTATE[HY000]: General error: 1290 The MariaDB server is running with the --read-only option so it cannot execute this statementerror message.[database]
…
[database_reader]
…
To make things work we define master for both of it.
We can not deactivate readonly option from slave, it wont sync the information with master.
Is there any extra configurations or misconfiguration ?
The text was updated successfully, but these errors were encountered: