[Bug 42652] New: Add per-account option to allow restricted patrons to retain SIP inet access
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 Bug ID: 42652 Summary: Add per-account option to allow restricted patrons to retain SIP inet access Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@openfifth.co.uk QA Contact: testopia@bugs.koha-community.org This patch adds a new per-account SIP2 configuration flag, `patron_restriction_blocks_inet`, that controls whether a patron with an account restriction (debarment) also has their SIP inet profile blocked. Currently, when a patron is restricted in Koha, the SIP inet field (FID_INET_PROFILE) is set to N. This means online services that use SIP for authentication â such as PC booking systems or printing services â also deny access to the restricted patron. Libraries that want to block a patron from borrowing items but still allow them to use digital services have no way to achieve this. With this flag set to 0/false on a SIP2 account, restricted patrons will receive Y for inet access, allowing them to authenticate to online services, while checkout privileges remain blocked as normal. The default (NULL or true) preserves existing behaviour: restrictions block both checkouts and inet access. Test plan: 1. Apply all patches and run the database update. 2. Go to Administration > SIP2 accounts and edit an account. 3. Confirm the new "Restrictions block internet access" toggle is visible. 4. Create a test patron and apply an account restriction to them. 5. With the toggle unset (default), authenticate the patron via SIP and confirm the patron status response shows charge privileges denied AND inet profile N. 6. Set the toggle to false/disabled for the account and re-authenticate. 7. Confirm the patron status response still shows charge privileges denied but inet profile is now Y. 8. Confirm a non-restricted patron is unaffected. -- 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=42652 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |martin.renvoize@openfifth.c |ity.org |o.uk -- 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=42652 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Comma delimited| |OpenFifth list of Sponsors| |<https://openfifth.co.uk/> Sponsorship status|--- |Sponsored Patch complexity|--- |Small patch -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #1 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 199333 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199333&action=edit Bug 42652: Allow inet access for patrons with restrictions via SIP2 account config A new per-account flag `patron_restriction_blocks_inet` controls whether a patron with an account restriction (debarment) also has their SIP inet profile blocked. When left unset or set to true the existing behaviour is preserved: restrictions block both checkouts and inet access. Setting the flag to false allows restricted patrons to authenticate to online services (PC booking, printing, etc.) via SIP while checkouts remain blocked. Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #2 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 199334 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199334&action=edit Bug 42652: Add patron_restriction_blocks_inet to sip_accounts Adds the new column to the sip_accounts table. NULL (default) preserves existing behaviour; set to 0 to allow restricted patrons to retain inet access via SIP. Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #3 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 199335 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199335&action=edit Bug 42652: Automated Schema Update Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #4 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 199336 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199336&action=edit Bug 42652: Add is_boolean flags and consolidate add_columns in SipAccount schema Add the missing is_boolean flag for patron_restriction_blocks_inet and consolidate the many individual add_columns("+...") calls below the DO NOT MODIFY line into a single block. Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #5 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 199337 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199337&action=edit Bug 42652: Add patron_restriction_blocks_inet to SIP2 account API and UI Exposes the new flag in the SIP2 account configuration UI so librarians can toggle it per account via the admin interface. Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jackie.usher@westsussex.gov | |.uk -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ryan.henderson@openfifth.co | |.uk, | |steven.raith@openfifth.co.u | |k -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 Pedro Amorim (ammopt) <pedro.amorim@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |pedro.amorim@openfifth.co.u | |k Depends on| |41311 --- Comment #6 from Pedro Amorim (ammopt) <pedro.amorim@openfifth.co.uk> --- Adding bug 41311 here as a dependency strictly due to how the atomicupdate is written (AFTER `patron_branchcode_in_ao`). Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41311 [Bug 41311] Add ability for SIP to send patron home library ( branchcode ) in AO field -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #199333|0 |1 is obsolete| | Attachment #199334|0 |1 is obsolete| | Attachment #199335|0 |1 is obsolete| | Attachment #199336|0 |1 is obsolete| | Attachment #199337|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #7 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 204597 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=204597&action=edit Bug 42652: Allow inet access for patrons with restrictions via SIP2 account config A new per-account flag `patron_restriction_blocks_inet` controls whether a patron with an account restriction (debarment) also has their SIP inet privileges blocked. When left unset or set to true the existing behaviour is preserved: restrictions block both checkouts and inet access. Setting the flag to false allows restricted patrons to authenticate to online services (PC booking, printing, etc.) via SIP while checkouts remain blocked. Sponsored-by: OpenFifth <https://openfifth.co.uk/> fix -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #8 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 204598 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=204598&action=edit Bug 42652: Add patron_restriction_blocks_inet to sip_accounts Adds the new column to the sip_accounts table. NULL (default) preserves existing behaviour; set to 0 to allow restricted patrons to retain inet access via SIP. Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #9 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 204599 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=204599&action=edit Bug 42652: Automated Schema Update Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #10 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 204600 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=204600&action=edit Bug 42652: Add is_boolean flags and consolidate add_columns in SipAccount schema Add the missing is_boolean flag for patron_restriction_blocks_inet and consolidate the many individual add_columns("+...") calls below the DO NOT MODIFY line into a single block. Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42652 --- Comment #11 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 204601 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=204601&action=edit Bug 42652: Add patron_restriction_blocks_inet to SIP2 account API and UI Exposes the new flag in the SIP2 account configuration UI so librarians can toggle it per account via the admin interface. Sponsored-by: OpenFifth <https://openfifth.co.uk/> -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org