Bugzilla – Attachment 50442 Details for
Bug 16282
Usernames should be case sensitive
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16282 : Setting up the database for case sensitive usernames
Bug-16282--Setting-up-the-database-for-case-sensit.patch (text/plain), 2.86 KB, created by
Chris Cormack
on 2016-04-19 21:09:42 UTC
(
hide
)
Description:
Bug 16282 : Setting up the database for case sensitive usernames
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2016-04-19 21:09:42 UTC
Size:
2.86 KB
patch
obsolete
>From a5f71c0bdbf1bbc4c526755b0e5ee5068b8e26b1 Mon Sep 17 00:00:00 2001 >From: Chris <chrisc@catalyst.net.nz> >Date: Wed, 20 Apr 2016 08:44:06 +1200 >Subject: [PATCH] Bug 16282 : Setting up the database for case sensitive > usernames > >Just adding a syspref > >For upgrade, current behaviour stays the same >For new installs, usernames are now case sensitive >--- > installer/data/mysql/atomicupdate/bug_16282.sql | 1 + > installer/data/mysql/sysprefs.sql | 3 ++- > .../intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref | 6 ++++++ > 3 files changed, 9 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_16282.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_16282.sql b/installer/data/mysql/atomicupdate/bug_16282.sql >new file mode 100644 >index 0000000..87a2c87 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_16282.sql >@@ -0,0 +1 @@ >+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('UsernamesCaseSensitive','0','If ON, usernames are evaluated case sensitively when users are logging in','','YesNo') ; >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index ef4c3f0..9c12c67 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -532,5 +532,6 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('XSLTDetailsDisplay','default','','Enable XSL stylesheet control over details page display on intranet','Free'), > ('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'), > ('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'), >-('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo') >+('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'), >+('UsernamesCaseSensitive','1','','If ON, usernames are evaluated case sensitively when users are logging in','YesNo') > ; >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref >index 22c2b27..9f7bdad 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref >@@ -159,6 +159,12 @@ Patrons: > yes: Do > no: "Don't" > - charge a fee when a patron changes to a category with an enrollment fee. >+ - >+ - Usernames are case sensitive >+ - pref: UsernamesCaseSensitive >+ choices: >+ yes: "Yes" >+ no: "No" > "Norwegian patron database": > - > - pref: NorwegianPatronDBEnable >-- >1.7.10.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 16282
: 50442 |
50443
|
50447