@@ -, +, @@ --- debian/scripts/koha-mysql | 40 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 40 insertions(+), 0 deletions(-) create mode 100755 debian/scripts/koha-mysql --- a/debian/scripts/koha-mysql +++ a/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 . + +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" + --