Since version 21.1, the following message may appear in System Health:
The read-only user is a new feature of 21.1 and optional. In the future we will adjust the message if necessary. Currently you can ignore it or create the read-only user. This is used for running the following reports.
-
Live tables
-
CSV/PDF export
-
Chart export
-
FTP export
Under Administration > System > Basic settings > System you can set a limit in the area "Acceleration / limitations" in the field "Cancel query report".
Attached are our instructions from development on how to enable this for externally hosted instances:
1. create a read-only user
CREATE USER '{READ_ONLY_DB_USERNAME}'@'{HOST}' IDENTIFIED BY '{PASSWORD}';
GRANT SELECT ON {XENTRAL_DATABASE_NAME}.* TO {READ_ONLY_DB_USERNAME}@'{HOST}';
FLUSH PRIVILEGES;
2. add database-credentionals to conf/user.inc.php
$this->WFdbreadonlyuser='{READ_ONLY_DB_USERNAME}';
$this->WFdbreadonlypass='{PASSWORD}';
3. run php upgradedbonly.php or update xentral via update.php.
Then you should see the message "Readonly User activated" in the System Health module.
You can find more information in our manual: