Bug 13041: Fix add of basket's manager when name contains a single quote
[koha.git] / debian / scripts / koha-restore
blobe8ec053ee07e6bedffdcadf5f0e773cb9de6d5a5
1 #!/bin/sh
3 # koha-restore: restore a Koha site from a dump (from koha-dump)
4 # Copyright 2010 Catalyst IT, Ltd
5 #
6 # This program is free software: you can redistribute it and/or modify
7 # it under the terms of the GNU General Public License as published by
8 # the Free Software Foundation, either version 3 of the License, or
9 # (at your option) any later version.
11 # This program is distributed in the hope that it will be useful,
12 # but WITHOUT ANY WARRANTY; without even the implied warranty of
13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 # GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License
17 # along with this program. If not, see <http://www.gnu.org/licenses/>.
20 set -e
22 # include helper functions
23 if [ -f "/usr/share/koha/bin/koha-functions.sh" ]; then
24 . "/usr/share/koha/bin/koha-functions.sh"
25 else
26 echo "Error: /usr/share/koha/bin/koha-functions.sh not present." 1>&2
27 exit 1
30 # Parse command line.
31 [ "$#" = 2 ] || die "Usage: $0 sqldump configdump"
32 sqldump="$1"
33 configdump="$2"
36 # Verify that no files in the config dump exist on the filesystem.
37 anyexists=no
38 tar -tf "$configdump" |
39 while read x
41 if [ -e "/$x" ]
42 then
43 anyexists=yes
44 echo "ERROR: File exists: /$x" 1>&2
46 done
47 if [ "$anyexists" = yes ]
48 then
49 die "Config dump $configdump has files that exist on the filesystem."
53 # Create user and group.
54 name=$(tar tf "$configdump" |
55 sed -n '/^etc\/koha\/sites\/\([^/]*\)\/$/s//\1/p')
56 username="$name-koha"
57 adduser --no-create-home --disabled-login --gecos "Koha instance $username" \
58 --home "/var/lib/koha/$name" --quiet "$username"
61 # Create dirs. Some of them will be in the tarball, but not all, e.g.,
62 # /var/run and /var/lock.
63 koha-create-dirs "$name"
66 # Unpack tarball.
67 tar -C / -xf "$configdump"
70 # Re-create database and database user.
71 mysqldb="koha_$name"
72 mysqluser="koha_$name"
73 mysqlpwd="$( xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/$name/koha-conf.xml )"
74 zcat "$sqldump" | mysql --defaults-extra-file=/etc/mysql/koha-common.cnf
75 mysql --defaults-extra-file=/etc/mysql/koha-common.cnf <<eof || true
76 DROP USER '$mysqluser';
77 eof
78 mysql --defaults-extra-file=/etc/mysql/koha-common.cnf << eof || true
79 CREATE USER '$mysqluser' IDENTIFIED BY '$mysqlpwd';
80 GRANT ALL PRIVILEGES ON $mysqldb.* TO '$mysqluser';
81 FLUSH PRIVILEGES;
82 eof
83 koha-rebuild-zebra --full "$name"
86 # Restart Apache.
87 /etc/init.d/apache2 restart