View | Details | Raw Unified | Return to bug 5509
Collapse All | Expand All

(-)a/debian/control (-1 / +1 lines)
Lines 25-31 Build-Depends: libalgorithm-checkdigits-perl, Link Here
25
 libdbi-perl,
25
 libdbi-perl,
26
 libdigest-sha-perl | perl,
26
 libdigest-sha-perl | perl,
27
 libemail-date-perl,
27
 libemail-date-perl,
28
 libfile-temp-perl | perl-modules,
29
 libgd-barcode-perl,
28
 libgd-barcode-perl,
30
 libgd-gd2-noxpm-perl | libgd-gd2-perl,
29
 libgd-gd2-noxpm-perl | libgd-gd2-perl,
31
 libgraphics-magick-perl,
30
 libgraphics-magick-perl,
Lines 92-97 Depends: ${misc:Depends}, ${koha:Depends}, Link Here
92
 mysql-client,
91
 mysql-client,
93
 pwgen,
92
 pwgen,
94
 tinymce2, 
93
 tinymce2, 
94
 xmlstarlet,
95
 yaz
95
 yaz
96
Suggests: mysql-server
96
Suggests: mysql-server
97
Homepage: http://koha-community.org/
97
Homepage: http://koha-community.org/
(-)a/debian/control.in (+1 lines)
Lines 22-27 Depends: ${misc:Depends}, ${koha:Depends}, Link Here
22
 mysql-client,
22
 mysql-client,
23
 pwgen,
23
 pwgen,
24
 tinymce2, 
24
 tinymce2, 
25
 xmlstarlet,
25
 yaz
26
 yaz
26
Suggests: mysql-server
27
Suggests: mysql-server
27
Homepage: http://koha-community.org/
28
Homepage: http://koha-community.org/
(-)a/debian/scripts/koha-dump (-4 / +4 lines)
Lines 40-49 echo "Dumping Koha site $name:" Link Here
40
40
41
41
42
# Dump database.
42
# Dump database.
43
mysqlhost="$(sed -n '/.*<hostname>\(.*\)<\/hostname>.*/s::\1:p' $kohaconfig)"
43
mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )"
44
mysqldb="$(sed -n '/.*<database>\(.*\)<\/database>.*/s::\1:p' $kohaconfig)"
44
mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )"
45
mysqluser="$(sed -n '/.*<user>\(.*\)<\/user>.*/s::\1:p' $kohaconfig | tail -n1)"
45
mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )"
46
mysqlpass="$(sed -n '/.*<pass>\(.*\)<\/pass>.*/s::\1:p' $kohaconfig)"
46
mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )"
47
dbdump="/var/spool/koha/$name/$name-$date.sql.gz"
47
dbdump="/var/spool/koha/$name/$name-$date.sql.gz"
48
echo "* DB to $dbdump"
48
echo "* DB to $dbdump"
49
mysqldump --databases --host="$mysqlhost" \
49
mysqldump --databases --host="$mysqlhost" \
(-)a/debian/scripts/koha-dump-defaults (-4 / +6 lines)
Lines 27-34 kohaconfig="/etc/koha/sites/$name/koha-conf.xml" Link Here
27
date="$(date +%Y-%m-%d)"
27
date="$(date +%Y-%m-%d)"
28
28
29
29
30
mysqldb="$(sed -n '/.*<database>\(.*\)<\/database>.*/s::\1:p' $kohaconfig)"
30
mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )"
31
mysqluser="$(sed -n '/.*<user>\(.*\)<\/user>.*/s::\1:p' $kohaconfig | tail -n1)"
31
mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )"
32
mysqlpass="$(sed -n '/.*<pass>\(.*\)<\/pass>.*/s::\1:p' $kohaconfig)"
32
mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )"
33
mysqldump --databases --user="$mysqluser" --password="$mysqlpass" "$mysqldb" |
33
mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )"
34
mysqldump --databases --host="$mysqlhost" --user="$mysqluser" \
35
    --password="$mysqlpass" "$mysqldb" |
34
    sed "s/$name/__KOHASITE__/g"
36
    sed "s/$name/__KOHASITE__/g"
(-)a/debian/scripts/koha-restore (-2 / +1 lines)
Lines 69-75 tar -C / -xf "$configdump" Link Here
69
# Re-create database and database user.
69
# Re-create database and database user.
70
mysqldb="koha_$name"
70
mysqldb="koha_$name"
71
mysqluser="koha_$name"
71
mysqluser="koha_$name"
72
mysqlpwd="$(sed -n '/.*<pass>\(.*\)<\/pass>.*/s//\1/p' /etc/koha/sites/$name/koha-conf.xml)"
72
mysqlpwd="$( xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/$name/koha-conf.xml )"
73
zcat "$sqldump" | mysql --defaults-extra-file=/etc/mysql/koha-common.cnf
73
zcat "$sqldump" | mysql --defaults-extra-file=/etc/mysql/koha-common.cnf
74
mysql --defaults-extra-file=/etc/mysql/koha-common.cnf <<eof || true
74
mysql --defaults-extra-file=/etc/mysql/koha-common.cnf <<eof || true
75
DROP USER '$mysqluser';
75
DROP USER '$mysqluser';
76
- 

Return to bug 5509