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