Bugzilla – Attachment 4462 Details for
Bug 6486
Need a quick way to access mysql as the user for a koha instance
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 6486 - add the koha-mysql command
Bug-6486---add-the-koha-mysql-command.patch (text/plain), 2.06 KB, created by
Chris Cormack
on 2011-06-14 21:36:57 UTC
(
hide
)
Description:
Bug 6486 - add the koha-mysql command
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2011-06-14 21:36:57 UTC
Size:
2.06 KB
patch
obsolete
>From 90dc1e27b0489da886179398e46f900826482938 Mon Sep 17 00:00:00 2001 >From: Robin Sheat <robin@catalyst.net.nz> >Date: Thu, 9 Jun 2011 17:00:45 +1200 >Subject: [PATCH] Bug 6486 - add the koha-mysql command > >This lets you get into the mysql session for this library instance >really easily. Probably most useful for developers. > >Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> >--- > debian/scripts/koha-mysql | 40 ++++++++++++++++++++++++++++++++++++++++ > 1 files changed, 40 insertions(+), 0 deletions(-) > create mode 100755 debian/scripts/koha-mysql > >diff --git a/debian/scripts/koha-mysql b/debian/scripts/koha-mysql >new file mode 100755 >index 0000000..fb3fba9 >--- /dev/null >+++ b/debian/scripts/koha-mysql >@@ -0,0 +1,40 @@ >+#!/bin/sh >+# >+# koha-mysql: provide an interactive mysql shell set up for the specified >+# koha instance. >+# Copyright 2011 Catalyst IT, Ltd >+# >+# This program is free software: you can redistribute it and/or modify >+# it under the terms of the GNU General Public License as published by >+# the Free Software Foundation, either version 3 of the License, or >+# (at your option) any later version. >+# >+# This program is distributed in the hope that it will be useful, >+# but WITHOUT ANY WARRANTY; without even the implied warranty of >+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the >+# GNU General Public License for more details. >+# >+# You should have received a copy of the GNU General Public License >+# along with this program. If not, see <http://www.gnu.org/licenses/>. >+ >+set -e >+ >+umask 0077 >+ >+die() { >+ echo "$@" 1>&2 >+ exit 1 >+} >+ >+[ "$#" = 1 ] || die "Usage: $0 instancename" >+name="$1" >+kohaconfig="/etc/koha/sites/$name/koha-conf.xml" >+ >+mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )" >+mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )" >+mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )" >+mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )" >+ >+mysql --host="$mysqlhost" --user="$mysqluser" --password="$mysqlpass" \ >+ "$mysqldb" >+ >-- >1.7.4.1
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 6486
:
4434
|
4435
| 4462 |
4463