Bug 24272: add check_sysprefs_cache.pl
authorNick <nick@bywatersolutions.com>
Thu, 19 Dec 2019 03:20:36 +0000 (03:20 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Mon, 25 Jan 2021 15:08:37 +0000 (16:08 +0100)
commit5a1e18efd87c34ef9f158c4a6f663d30ab3a4e43
tree14a93cd7b64c740bd78a03a3c41e6d5dc80f2dc2
parent6f6010cd208044ea1cacc08dfe67c497b8d1b627
Bug 24272: add check_sysprefs_cache.pl

This script ensure that no sysprefs have been changed directly in the database and/or
that the cache has not become corrupted. We have occasionally seen this happen on production sites

To test:
1 - In the staff interface go to Administration
2 - Search for system preference 'IntranetUserJS'
3 - Add content to the syspref:
    console.log('Hi!');
4 - On the command line launch mysql
    sudo koha-mysql kohadev
5 - Alter the syspref directly
    UPDATE systempreferences SET value = "console.log('Bye!');" WHERE variable = 'IntranetUserJS';
6 - run the script
    perl misc/maintenance/check_syspref_cache.pl
7 - You are warned about the altered system preference

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit de5527f37d898e756cac4d8ed9de63c6576c1241)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
misc/maintenance/check_syspref_cache.pl [new file with mode: 0755]