Bugzilla – Attachment 51813 Details for
Bug 14407
Limit web-based self-checkout to specific IP addresses
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
New patch, with silly typo fixed
0001-Bug-14407-Limit-self-checkout-to-IP-ranges.patch (text/plain), 9.61 KB, created by
Nicholas van Oudtshoorn
on 2016-05-26 05:10:57 UTC
(
hide
)
Description:
New patch, with silly typo fixed
Filename:
MIME Type:
Creator:
Nicholas van Oudtshoorn
Created:
2016-05-26 05:10:57 UTC
Size:
9.61 KB
patch
obsolete
>From dfdd7e38159de05b11ac4d1f49ec7dbf7022513c Mon Sep 17 00:00:00 2001 >From: Nicholas van Oudtshoorn <vanoudt@gmail.com> >Date: Thu, 26 May 2016 10:30:51 +0800 >Subject: [PATCH] Bug 14407 - Limit self-checkout to IP ranges > >Test plan: >0) Back up your databse >1) Apply this patch >2) In your mysql client use your Koha database and execute: > > DELETE FROM systempreferences; > > SOURCE ~/kohaclone/installer/data/mysql/sysprefs.sql; > -- Should be no errors. > > SELECT * FROM systempreferences WHERE variable='SelfCheckAllowByIPRanges'; > -- Should see 1 entry > > QUIT; >3) Restore your database >4) Run installer/data/mysql/atomicupdate/selfcheckallowbyiprange.sql >5) In your mysql client, using your Koha database, execute: > > SELECT * FROM systempreferences WHERE variable='SelfCheckAllowByIPRanges'; > -- should see the same entry as above >6) Try access the Self-checkout, self-checkout help, and self-checkout patron images. It should work. >7) Log into the staff client >8) Home -> Koha administration -> Global system preferences >9) -> CIRCULATION > Make sure that SelfCheckAllowByIPRanges is set to a computer you can test on >10) Try access the Self-checkout, self-checkout help, and self-checkout patron images from a computer with an IP in the range above. It should work. >11) Try access the Self-checkout, self-checkout help, and self-checkout patron images from a computer with an IP outside of the range above. It should *not* work. >--- > C4/Auth.pm | 24 +++++++++++++++++++++- > C4/Installer/PerlDependencies.pm | 5 +++++ > ..._14407-add_selfcheckallowbyipranges_syspref.sql | 2 ++ > installer/data/mysql/sysprefs.sql | 1 + > .../en/modules/admin/preferences/circulation.pref | 4 ++++ > opac/sco/help.pl | 8 +++++++- > opac/sco/printslip.pl | 7 ++++++- > opac/sco/sco-main.pl | 8 +++++++- > opac/sco/sco-patron-image.pl | 6 ++++++ > 9 files changed, 61 insertions(+), 4 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_14407-add_selfcheckallowbyipranges_syspref.sql > >diff --git a/C4/Auth.pm b/C4/Auth.pm >index c06fc1a..00aa37e 100644 >--- a/C4/Auth.pm >+++ b/C4/Auth.pm >@@ -38,6 +38,7 @@ use Koha::Libraries; > use POSIX qw/strftime/; > use List::MoreUtils qw/ any /; > use Encode qw( encode is_utf8); >+use Net::CIDR; > > # use utf8; > use vars qw(@ISA @EXPORT @EXPORT_OK %EXPORT_TAGS $debug $ldap $cas $caslogout $shib $shib_login); >@@ -54,7 +55,7 @@ BEGIN { > @ISA = qw(Exporter); > @EXPORT = qw(&checkauth &get_template_and_user &haspermission &get_user_subpermissions); > @EXPORT_OK = qw(&check_api_auth &get_session &check_cookie_auth &checkpw &checkpw_internal &checkpw_hash >- &get_all_subpermissions &get_user_subpermissions >+ &get_all_subpermissions &get_user_subpermissions &in_ipset > ); > %EXPORT_TAGS = ( EditPermissions => [qw(get_all_subpermissions get_user_subpermissions)] ); > $ldap = C4::Context->config('useldapserver') || 0; >@@ -2045,6 +2046,27 @@ sub getborrowernumber { > return 0; > } > >+=head2 in_ipset >+ >+ $flags = ($ipset); >+ >+C<$ipset> A space separated string describing an IP set. Can include single IPs or ranges >+ >+Returns 1 if the remote address is in the provided ipset, or 0 otherwise. >+ >+=cut >+ >+sub in_ipset { >+ my ($ipset) = @_; >+ my @allowedipranges = split(' ', $ipset); >+ if (scalar @allowedipranges > 0) { >+ unless (Net::CIDR::cidrlookup($ENV{'REMOTE_ADDR'}, Net::CIDR::range2cidr(@allowedipranges))) { >+ return 0; >+ } >+ } >+ return 1; >+} >+ > =head2 _get_script_name > > This returns the correct script name, for use in redirecting back to the correct page after showing >diff --git a/C4/Installer/PerlDependencies.pm b/C4/Installer/PerlDependencies.pm >index d84b51c..aefbfe5 100644 >--- a/C4/Installer/PerlDependencies.pm >+++ b/C4/Installer/PerlDependencies.pm >@@ -782,6 +782,11 @@ our $PERL_DEPS = { > 'required' => '0', > 'min_ver' => '0.56', > }, >+ 'Net::CIDR' => { >+ 'usage' => 'Core', >+ 'required' => '1', >+ 'min_ver' => '0.15', >+ }, > 'Net::SFTP::Foreign' => { > 'usage' => 'Edifact', > 'required' => '0', >diff --git a/installer/data/mysql/atomicupdate/bug_14407-add_selfcheckallowbyipranges_syspref.sql b/installer/data/mysql/atomicupdate/bug_14407-add_selfcheckallowbyipranges_syspref.sql >new file mode 100644 >index 0000000..4041a58 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_14407-add_selfcheckallowbyipranges_syspref.sql >@@ -0,0 +1,2 @@ >+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES >+ ('SelfCheckAllowByIPRanges','',NULL,'(Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.)','Short'); >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index 2b95c99..09a50d6 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -426,6 +426,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('SearchEngine','Zebra','Elasticsearch|Zebra','Search Engine','Choice'), > ('SearchMyLibraryFirst','0',NULL,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'), > ('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo'), >+('SelfCheckAllowByIPRanges','',NULL,('Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.)','Short'), > ('SelfCheckHelpMessage','','70|10','Enter HTML to include under the basic Web-based Self Checkout instructions on the Help page','Textarea'), > ('SelfCheckReceiptPrompt','1','NULL','If ON, print receipt dialog pops up when self checkout is finished','YesNo'), > ('SelfCheckTimeout','120','','Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'), >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref >index 9a37608..f02fe44 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref >@@ -744,6 +744,10 @@ Circulation: > yes: Show > no: "Don't show" > - "the print receipt popup dialog when self checkout is finished" >+ - >+ - pref: SelfCheckAllowByIPRanges >+ class: short >+ - (Leave blank if not used. Use ranges or simple ip addresses separated by spaces, like <code>192.168.1.1 192.168.0.0/24</code>.) > Course Reserves: > - > - pref: UseCourseReserves >diff --git a/opac/sco/help.pl b/opac/sco/help.pl >index 412dc40..74ab566 100755 >--- a/opac/sco/help.pl >+++ b/opac/sco/help.pl >@@ -25,10 +25,16 @@ use strict; > use warnings; > use CGI qw ( -utf8 ); > >-use C4::Auth qw(get_template_and_user); >+use C4::Auth qw(get_template_and_user in_ipset); > use C4::Output qw(output_html_with_http_headers); > > my $query = new CGI; >+ >+unless ( in_ipset(C4::Context->preference('SelfCheckAllowByIPRanges')) ) { >+ print $query->redirect("/cgi-bin/koha/opac-main.pl"); >+ exit; >+} >+ > my ($template, $borrowernumber, $cookie) = get_template_and_user({ > template_name => "sco/help.tt", > query => $query, >diff --git a/opac/sco/printslip.pl b/opac/sco/printslip.pl >index b85b8f5..632f5cd 100755 >--- a/opac/sco/printslip.pl >+++ b/opac/sco/printslip.pl >@@ -30,11 +30,16 @@ use strict; > use warnings; > use CGI qw ( -utf8 ); > use C4::Context; >-use C4::Auth qw/:DEFAULT get_session/; >+use C4::Auth qw/:DEFAULT get_session in_ipset/; > use C4::Output; > use C4::Members; > use C4::Koha; > >+unless ( in_ipset(C4::Context->preference('SelfCheckAllowByIPRanges')) ) { >+ print $query->header(status => '403 Forbidden - functionality not available from your location'); >+ exit; >+} >+ > my $input = new CGI; > my $sessionID = $input->cookie("CGISESSID"); > my $session = get_session($sessionID); >diff --git a/opac/sco/sco-main.pl b/opac/sco/sco-main.pl >index 0e2a1b9..f2f230e 100755 >--- a/opac/sco/sco-main.pl >+++ b/opac/sco/sco-main.pl >@@ -37,7 +37,7 @@ use warnings; > use CGI qw ( -utf8 ); > use Digest::MD5 qw(md5_base64); > >-use C4::Auth qw(get_template_and_user checkpw); >+use C4::Auth qw(get_template_and_user checkpw in_ipset); > use C4::Koha; > use C4::Circulation; > use C4::Reserves; >@@ -56,6 +56,12 @@ unless (C4::Context->preference('WebBasedSelfCheck')) { > exit; > } > >+unless ( in_ipset(C4::Context->preference('SelfCheckAllowByIPRanges')) ) { >+ # redirect to OPAC home if self-checkout not permitted from current IP >+ print $query->redirect("/cgi-bin/koha/opac-main.pl"); >+ exit; >+} >+ > if (C4::Context->preference('AutoSelfCheckAllowed')) > { > my $AutoSelfCheckID = C4::Context->preference('AutoSelfCheckID'); >diff --git a/opac/sco/sco-patron-image.pl b/opac/sco/sco-patron-image.pl >index e76620b..432e5a7 100755 >--- a/opac/sco/sco-patron-image.pl >+++ b/opac/sco/sco-patron-image.pl >@@ -19,6 +19,7 @@ > > use strict; > use warnings; >+use C4::Auth qw(in_ipset); > use C4::Service; > use C4::Members; > use Koha::Patron::Images; >@@ -34,6 +35,11 @@ unless (C4::Context->preference('ShowPatronImageInWebBasedSelfCheck')) { > exit; > } > >+unless ( in_ipset(C4::Context->preference('SelfCheckAllowByIPRanges')) ) { >+ print $query->header(status => '403 Forbidden - functionality not available from your location'); >+ exit; >+} >+ > my ($borrowernumber) = C4::Service->require_params('borrowernumber'); > > my $patron_image = Koha::Patron::Images->find($borrowernumber); >-- >2.7.4 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14407
:
40612
|
40613
|
40852
|
40854
|
45894
|
45898
|
45899
|
51812
|
51813
|
53760
|
54560
|
55746
|
56064
|
56065
|
56066
|
68834
|
68835
|
68836
|
70475
|
70476
|
73316
|
73318
|
73339
|
73340
|
73341
|
73342
|
80735
|
80736
|
80737
|
80738
|
86123
|
88863
|
88864
|
88865
|
88866
|
89114