Bugzilla – Attachment 57643 Details for
Bug 17513
koha-create does not set GRANTS correctly
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 17513: Create GRANT for user@localhost in koha-create
Bug-17513-Create-GRANT-for-userlocalhost-in-koha-c.patch (text/plain), 1.56 KB, created by
Marcel de Rooy
on 2016-11-18 13:00:35 UTC
(
hide
)
Description:
Bug 17513: Create GRANT for user@localhost in koha-create
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2016-11-18 13:00:35 UTC
Size:
1.56 KB
patch
obsolete
>From b8bf14b7deb6fe74ac2f39737a84594e07c7d09c Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 27 Oct 2016 14:15:57 +0000 >Subject: [PATCH] Bug 17513: Create GRANT for user@localhost in koha-create >Content-Type: text/plain; charset=utf-8 > >See the bug description for the details. > >Test plan: >Use this script to create a new koha installation, using MariaDB >You should not display >"user koha_kohadev doesn't have enough privilege on database koha_kohadev " > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Confirm that this still works (with MySQL). >--- > debian/scripts/koha-create | 2 ++ > 1 file changed, 2 insertions(+) > >diff --git a/debian/scripts/koha-create b/debian/scripts/koha-create >index a9fe29c..2636675 100755 >--- a/debian/scripts/koha-create >+++ b/debian/scripts/koha-create >@@ -661,6 +661,7 @@ CREATE DATABASE \`$mysqldb\`; > CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; > CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; > GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; >+GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname'; > FLUSH PRIVILEGES; > eof > fi #` >@@ -671,6 +672,7 @@ eof > CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; > CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; > GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; >+GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname'; > FLUSH PRIVILEGES; > eof > fi #` >-- >2.1.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 17513
:
56922
|
56975
| 57643