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 |
|