NOT WORKING - Configuring Master & Slave Database for Matomo

Support & Bugs
1

I am trying to follow the guide on setting up master/slave but I get an error:

the database has master/slave configuration with the definition below in config.ini.php.

[database]
…
[database_reader]
…

The configuration with database_reader which we defined slave server; provided SQLSTATE[HY000]: General error: 1290 The MariaDB server is running with the --read-only option so it cannot execute this statement. So we ended up using master for both.

Why does database_reader user needs to have write access? Are we doing something wrong here?

2

Hi there,

this may be a bug, we haven’t had this issue on MySQL. Maybe you can create a bug report at: http://www.github.com/matomo-org/matomo
it would be great to know exactly which SQL query is causing this error?