https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39322
David Nind <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from David Nind <[email protected]> --- 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)? 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 -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
