Bugzilla – Attachment 79954 Details for
Bug 21082
OverDrive authentication method no longer supported
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 21082: Database updates
Bug-21082-Database-updates.patch (text/plain), 6.54 KB, created by
ByWater Sandboxes
on 2018-10-04 17:32:42 UTC
(
hide
)
Description:
Bug 21082: Database updates
Filename:
MIME Type:
Creator:
ByWater Sandboxes
Created:
2018-10-04 17:32:42 UTC
Size:
6.54 KB
patch
obsolete
>From d58ab07a79e0ab6a5cc5e12bcaec1edd113feed8 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Tue, 17 Jul 2018 13:50:43 +0000 >Subject: [PATCH] Bug 21082: Database updates > >https://bugs.koha-community.org/show_bug.cgi?id=2108 > >Signed-off-by: Sandy Allgood <sandy.allgood@citruslibraries.org> > >Signed-off-by: Sandy Allgood <sandy.allgood@citruslibraries.org> >--- > ..._21082-add_option_for_overdrive_patron_auth.perl | 16 ++++++++++++++++ > installer/data/mysql/kohastructure.sql | 12 ++++++++++++ > installer/data/mysql/sysprefs.sql | 1 + > .../modules/admin/preferences/enhanced_content.pref | 21 +++++++++++++++++---- > 4 files changed, 46 insertions(+), 4 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_21082-add_option_for_overdrive_patron_auth.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_21082-add_option_for_overdrive_patron_auth.perl b/installer/data/mysql/atomicupdate/bug_21082-add_option_for_overdrive_patron_auth.perl >new file mode 100644 >index 0000000000..8d3742f2c0 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_21082-add_option_for_overdrive_patron_auth.perl >@@ -0,0 +1,16 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ $dbh->do('DROP TABLE IF EXISTS branches_overdrive'); >+ $dbh->do( q| >+ CREATE TABLE IF NOT EXISTS branches_overdrive ( >+ `branchcode` VARCHAR( 10 ) NOT NULL , >+ `authname` VARCHAR( 255 ) NOT NULL , >+ PRIMARY KEY (`branchcode`) , >+ CONSTRAINT `branches_overdrive_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE >+ ) ENGINE = INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |); >+ $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverDriveAuthname', '', 'Authname for OverDrive Patron Authentication, will be used as fallback if individual branch authname not set', NULL, 'Free');"); >+ $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverDriveWebsiteID','', 'WebsiteID provided by OverDrive', NULL, 'Free');"); >+ $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverDrivePasswordRequired','', 'Does the library require passwords for OverDrive SIP authentication', NULL, 'YesNo');"); >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 21082 - Add overdrive patron auth method)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 95c36175d2..60277e743a 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -272,6 +272,18 @@ CREATE TABLE `branches` ( -- information about your libraries or branches are st > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >+-- Table structure for table `branches_overdrive` >+-- >+ >+DROP TABLE IF EXISTS `branches_overdrive`; >+CREATE TABLE IF NOT EXISTS branches_overdrive ( >+ `branchcode` VARCHAR( 10 ) NOT NULL , >+ `authname` VARCHAR( 255 ) NOT NULL , >+ PRIMARY KEY (`branchcode`) , >+ CONSTRAINT `branches_overdrive_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+ >+-- > -- Table structure for table `browser` > -- > DROP TABLE IF EXISTS `browser`; >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index bc7af05dd8..71313a9594 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -420,6 +420,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('OverDriveClientKey','','Client key for OverDrive integration','30','Free'), > ('OverDriveClientSecret','','Client key for OverDrive integration','30','YesNo'), > ('OverDriveLibraryID','','Library ID for OverDrive integration','','Integer'), >+('OverDrivePasswordRequired','',NULL,'Does the library require passwords for OverDrive SIP authentication','YesNo'), > ('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'), > ('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'), > ('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'), >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref >index 2d283ccc23..03fb7fc482 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref >@@ -351,6 +351,14 @@ Enhanced Content: > - pref: OverDriveClientSecret > - . > - >+ - "Authenticate using OverDrive website id #" >+ - pref: OverDriveWebsiteID >+ - . >+ - >+ - "Authenticate using OverDrive Authname" >+ - pref: OverDriveAuthName >+ - "(will be used as fallback if individual branch authname not set <a href=\"/cgi-bin/koha/admin/overdrive.pl\">here</a>)." >+ - > - "Show items from the OverDrive catalog of library #" > - pref: OverDriveLibraryID > - . >@@ -359,10 +367,15 @@ Enhanced Content: > choices: > yes: Enable > no: "Don't enable" >- - users to access their OverDrive circulation history, and circulate items. >- - If you enable access, you must register auth return url of >- - http(s)://my.opac.hostname/cgi-bin/koha/external/overdrive/auth.pl >- - with OverDrive. >+ - users to access their OverDrive circulation history, and circulate items.<br /> >+ - A password is >+ - pref: OverDrivePasswordRequired >+ choices: >+ yes: Required >+ no: Not required >+ - for user access to OverDrive. <br /> >+ - If you enable access you must have a SIP connection registered with >+ - OverDrive for patron authentication against Koha > RecordedBooks: > - > - Include RecordedBooks availability information with the client secret >-- >2.11.0
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 21082
:
77053
|
77054
|
77055
|
77056
|
79792
|
79793
|
79794
|
79795
|
79894
|
79954
|
79955
|
79956
|
79957
|
79985
|
79986
|
79987