Line 0
Link Here
|
0 |
- |
1 |
#!/bin/bash |
|
|
2 |
# |
3 |
# koha-mysqlcheck: run mysqlcheck on the database of the specified Koha instance. |
4 |
# Copyright 2013 Magnus Enger Librioech |
5 |
# Based on koha-mysql, which is 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 |
# Parse command line. |
30 |
if [ $# -lt 1 ]; then |
31 |
die "Usage: $0 [options] instancename" |
32 |
fi |
33 |
|
34 |
# Separate any arguments from the instance name |
35 |
array=($@) |
36 |
len=${#array[@]} |
37 |
name=${array[$len-1]} |
38 |
args=${array[@]:0:$len-1} |
39 |
|
40 |
kohaconfig="/etc/koha/sites/$name/koha-conf.xml" |
41 |
|
42 |
mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )" |
43 |
mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )" |
44 |
mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )" |
45 |
mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )" |
46 |
|
47 |
mysqlcheck --host="$mysqlhost" --user="$mysqluser" --password="$mysqlpass" \ |
48 |
$args "$mysqldb" |