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