View | Details | Raw Unified | Return to bug 5511
Collapse All | Expand All

(-)a/installer/data/mysql/sysprefs.sql (-2 / +2 lines)
Lines 372-377 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
372
('SelfCheckTimeout','120','','Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),
372
('SelfCheckTimeout','120','','Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),
373
('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
373
('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
374
('SeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings','Choice'),
374
('SeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings','Choice'),
375
('SessionRestrictionByIP','1','Check for Change in Remote IP address for Session Security . Disable when remote ip address changes frequently.','','YesNo'),
375
('SessionStorage','mysql','mysql|Pg|tmp','Use database or a temporary file for storing session data','Choice'),
376
('SessionStorage','mysql','mysql|Pg|tmp','Use database or a temporary file for storing session data','Choice'),
376
('ShelfBrowserUsesCcode','1','0','Use the item collection code when finding items for the shelf browser.','YesNo'),
377
('ShelfBrowserUsesCcode','1','0','Use the item collection code when finding items for the shelf browser.','YesNo'),
377
('ShelfBrowserUsesHomeBranch','1','1','Use the item home branch when finding items for the shelf browser.','YesNo'),
378
('ShelfBrowserUsesHomeBranch','1','1','Use the item home branch when finding items for the shelf browser.','YesNo'),
Lines 472-477 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
472
('XSLTDetailsDisplay','default','','Enable XSL stylesheet control over details page display on intranet','Free'),
473
('XSLTDetailsDisplay','default','','Enable XSL stylesheet control over details page display on intranet','Free'),
473
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
474
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
474
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
475
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
475
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
476
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
476
('SessionRestrictionByIP','1','Check for Change in Remote IP address for Session Security . Disable when remote ip address changes frequently.','','YesNo');
477
;
477
;
(-)a/installer/data/mysql/updatedatabase.pl (-7 / +9 lines)
Lines 9576-9588 if ( CheckVersion($DBversion) ) { Link Here
9576
$DBversion = "3.18.00.000";
9576
$DBversion = "3.18.00.000";
9577
if ( CheckVersion($DBversion) ) {
9577
if ( CheckVersion($DBversion) ) {
9578
    print "Upgrade to $DBversion done (3.18.0 release)\n";
9578
    print "Upgrade to $DBversion done (3.18.0 release)\n";
9579
}
9579
    SetVersion($DBversion);
9580
9581
$DBversion = "3.18.00.001";
9582
if ( CheckVersion($DBversion) ) {
9583
    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SessionRestrictionByIP','1','Check for Change in  Remote IP address for Session Security. Disable when remote ip address changes frequently.','','YesNo')");
9584
    print "Upgrade to $DBversion done (Bug 5511 - SessionRestrictionByIP)";
9585
    SetVersion ($DBversion);
9586
}
9580
}
9587
9581
9588
$DBversion = "3.19.00.000";
9582
$DBversion = "3.19.00.000";
Lines 9614-9619 if ( CheckVersion($DBversion) ) { Link Here
9614
    SetVersion ($DBversion);
9608
    SetVersion ($DBversion);
9615
}
9609
}
9616
9610
9611
9612
$DBversion = "3.19.00.XXX";
9613
if ( CheckVersion($DBversion) ) {
9614
    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SessionRestrictionByIP','1','Check for Change in  Remote IP address for Session Security. Disable when remote ip address changes frequently.','','YesNo')");
9615
    print "Upgrade to $DBversion done (Bug 5511 - SessionRestrictionByIP)";
9616
    SetVersion ($DBversion);
9617
}
9618
9617
=head1 FUNCTIONS
9619
=head1 FUNCTIONS
9618
9620
9619
=head2 TableExists($table)
9621
=head2 TableExists($table)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref (-2 / +1 lines)
Lines 69-75 Administration: Link Here
69
              choices:
69
              choices:
70
                  yes: Enable
70
                  yes: Enable
71
                  no: "Disable"
71
                  no: "Disable"
72
            - Check for Change in Remote IP address for Session Security. Disable when remote ip address changes frequently.
72
            - check for change in remote IP address for session security. Disable only when remote IP address changes frequently.
73
        # PostgreSQL is supported by CGI::Session but not by Koha.
73
        # PostgreSQL is supported by CGI::Session but not by Koha.
74
        -
74
        -
75
            - Store login session information
75
            - Store login session information
76
- 

Return to bug 5511