[Bug 37919] New: Unable to report on MFA-enabled users
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 Bug ID: 37919 Summary: Unable to report on MFA-enabled users Change sponsored?: --- Product: Koha Version: 23.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: david.roberts@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org As a result of Bug 37508, it isn't possible to use the reports module to identify which users are MFA enabled using e.g. the following SQL which used to work: SELECT p.borrowernumber, p.firstname, p.surname, p.cardnumber, p.branchcode, IF( power(2, 2) & flags, 'yes', 'no' ) as Staff, IF( power(2, 0) & flags, 'yes', 'no' ) as Superlibrarian FROM borrowers p WHERE p.flags > 0 AND p.auth_method = 'password' AND p.dateexpiry > CURDATE() HAVING Staff = 'yes' OR Superlibrarian = 'yes' ORDER BY p.branchcode -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |37508 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37508 [Bug 37508] SQL reports should not show patron password hash if queried -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|23.11 |Main Summary|Unable to report on |Unable to report on patrons |MFA-enabled users |with auth_method password -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Unable to report on patrons |Unable to report on patrons |with auth_method password |with borrowers.auth_method | |password -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |major CC| |aleisha@catalyst.net.nz, | |jonathan.druart@gmail.com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 Brendan Lawlor <blawlor@clamsnet.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |blawlor@clamsnet.org --- Comment #1 from Brendan Lawlor <blawlor@clamsnet.org> --- A workaround for this is to change = to LIKE Change this line: AND p.auth_method = 'password' to: AND p.auth_method LIKE 'passwor' -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au Severity|major |minor -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 --- Comment #2 from David Cook <dcook@prosentient.com.au> --- You could also use: p.auth_method != 'two-factor' -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37919 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |In Discussion --- Comment #3 from David Cook <dcook@prosentient.com.au> --- Tempted to close this one but will leave In Discussion -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org