https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39322 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |39301 --- Comment #3 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- (In reply to David Nind from comment #2)
I had a go at testing, but I'm not sure about a couple of items in the test plan:
1. Step 1 - .."none kept for pseudonymization": How do you do this? Or is this only shown for the attribute once pseudonymization is enabled (the "Keep for pseudonymization" field)?
Correct, it only shows when pseudonymization is available
2. Step 7: How do I tell this? The output from running the command is listed at the end.
For statistics, I checked out a couple of items and checked them back in. Is this sufficient?
Testing notes (using KTD): 1. Generate a password in KTD from the shell: htpasswd -bnBC 10 "" password | tr -d ':\n' | sed 's/$2y/$2a/' 2. Edit /etc/koha/sites/kohadev/koha-conf.xml 3. Add an entry before the </config>: <bcrypt_settings>whateverstep1generated</bcrypt_settings> 4. Restart everything: restart_all
Output from step 6 ------------------
perl misc/maintenance/pseudonymize_statistics.pl -v -c --before 2026-01-01 Searching for statistics before 2026-01-01 SELECT COUNT( * ) FROM `statistics` `me` WHERE ( `datetime` <= ? ): '2026-01-01' 4 statistics found SELECT COUNT( * ) FROM `pseudonymized_transactions` `me` WHERE ( `datetime` <= ? ): '2026-01-01' SELECT COUNT( * ) FROM `statistics` `me` WHERE ( `datetime` <= ? ): '2026-01-01' SELECT `me`.`datetime`, `me`.`branch`, `me`.`value`, `me`.`type`, `me`.`other`, `me`.`itemnumber`, `me`.`itemtype`, `me`.`location`, `me`.`borrowernumber`, `me`.`ccode`, `me`.`categorycode`, `me`.`interface` FROM `statistics` `me` WHERE ( `datetime` <= ? ): '2026-01-01' INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, "register_name":null,"id":null}', '{"statistic":{"itemtype":"BK","interface":"intranet","type":"issue", "borrowernumber":5,"value":0,"location":"GEN","branch":"CPL","itemnumber": 578,"datetime":"2025-03-16 20:58:50","categorycode":"PT","ccode":"REF","other":""}}', NULL, '2025-03-16T21:05:29', 'default', '1', NULL, 'new', 'pseudonymize_statistic' INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, "register_name":null,"id":null}', '{"statistic":{"type":"return","itemtype":"BK","interface":"intranet", "value":0,"location":"GEN","branch":"CPL","borrowernumber":5,"datetime": "2025-03-16 20:58:55","categorycode":"PT","itemnumber":578,"ccode":"REF","other":""}}', NULL, '2025-03-16T21:05:29', 'default', '1', NULL, 'new', 'pseudonymize_statistic' INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, "register_name":null,"id":null}', '{"statistic":{"ccode":"REF","other":"","categorycode":"PT","datetime":"2025- 03-16 20:59:07","itemnumber":296,"value":0,"location":"GEN","branch":"CPL", "borrowernumber":23,"type":"issue","itemtype":"BK","interface":"intranet"}}', NULL, '2025-03-16T21:05:29', 'default', '1', NULL, 'new', 'pseudonymize_statistic' INSERT INTO `background_jobs` ( `borrowernumber`, `context`, `data`, `ended_on`, `enqueued_on`, `queue`, `size`, `started_on`, `status`, `type`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ): NULL, '{"cardnumber":null,"interface":"commandline","shibboleth":null,"desk_name": null,"flags":null,"number":null,"desk_id":null,"branch":null,"surname":"CLI", "firstname":"CLI","branchname":null,"register_id":null,"emailaddress":null, "register_name":null,"id":null}', '{"statistic":{"categorycode":"PT","datetime":"2025-03-16 20:59:15","itemnumber":296,"ccode":"REF","other":"","type":"return", "interface":"intranet","itemtype":"BK","branch":"CPL","value":0,"location": "GEN","borrowernumber":23}}', NULL, '2025-03-16T21:05:29', 'default', '1', NULL, 'new', 'pseudonymize_statistic' SELECT COUNT( * ) FROM `statistics` `me` WHERE ( `datetime` <= ? ): '2026-01-01' 4 statistics pseudonymized
Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39301 [Bug 39301] pseudonymize_statistics.pl script generates too many background jobs -- You are receiving this mail because: You are watching all bug changes.