View | Details | Raw Unified | Return to bug 6486
Collapse All | Expand All

(-)a/debian/scripts/koha-mysql (-1 / +40 lines)
Line 0 Link Here
0
- 
1
#!/bin/sh
2
#
3
# koha-mysql: provide an interactive mysql shell set up for the specified
4
#   koha instance.
5
# Copyright 2011  Catalyst IT, Ltd
6
# 
7
# This program is free software: you can redistribute it and/or modify
8
# it under the terms of the GNU General Public License as published by
9
# the Free Software Foundation, either version 3 of the License, or
10
# (at your option) any later version.
11
# 
12
# This program is distributed in the hope that it will be useful,
13
# but WITHOUT ANY WARRANTY; without even the implied warranty of
14
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
15
# GNU General Public License for more details.
16
# 
17
# You should have received a copy of the GNU General Public License
18
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
19
20
set -e
21
22
umask 0077
23
24
die() {
25
    echo "$@" 1>&2
26
    exit 1
27
}
28
29
[ "$#" = 1 ] || die "Usage: $0 instancename"
30
name="$1"
31
kohaconfig="/etc/koha/sites/$name/koha-conf.xml"
32
33
mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )"
34
mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )"
35
mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )"
36
mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )"
37
38
mysql --host="$mysqlhost" --user="$mysqluser" --password="$mysqlpass" \
39
    "$mysqldb"
40

Return to bug 6486