From 89f0452ba17c54045656ee2654a162fd4a96a744 Mon Sep 17 00:00:00 2001 From: Andreas Roussos Date: Thu, 27 Sep 2018 19:05:48 +0300 Subject: [PATCH] Bug 21440: koha-create expects the file passed by $DEFAULTSQL to be in gzip format koha-create contains a call to `zcat` which fails if the file passed as an argument is not in gzip format. This patch fixes the issue by adding the -f flag to the zcat call in koha-create, as per the top-voted answers in the following SE URLs: https://unix.stackexchange.com/a/77309 https://unix.stackexchange.com/a/131944 Test plan: 1) in /etc/koha/koha-sites.conf, set the DEFAULTSQL variable to point to an _uncompressed_ SQL database dump 2) run `koha-create --create-db instance` and notice how it fails with: gzip: /path/to/dump.sql: not in gzip format 3) apply the patch 4) notice the extra line of information "The SQL file can be optionally compressed with gzip" in koha-sites.conf 5) run the `koha-create` command again, this time it should work 6) repeat with DEFAULTSQL pointing to a gzip'd dump, it should work too Signed-off-by: Martin Renvoize Signed-off-by: Chris Cormack Signed-off-by: Nick Clemens (cherry picked from commit f12dabe6ccd9400a4ae744a5d74bbddcd9f7ac95) Signed-off-by: Martin Renvoize --- debian/scripts/koha-create | 2 +- debian/templates/koha-sites.conf | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/debian/scripts/koha-create b/debian/scripts/koha-create index f49a7310c8..90724379ef 100755 --- a/debian/scripts/koha-create +++ b/debian/scripts/koha-create @@ -797,7 +797,7 @@ then if [ -e "$DEFAULTSQL" ] then # Populate the database with default content. - zcat "$DEFAULTSQL" | + zcat -f "$DEFAULTSQL" | sed "s/__KOHASITE__/koha_$name/g" | mysql --host="$mysqlhost" --user="$mysqluser" --password="$mysqlpwd" "$mysqldb" diff --git a/debian/templates/koha-sites.conf b/debian/templates/koha-sites.conf index 34210ac90a..17885f810d 100644 --- a/debian/templates/koha-sites.conf +++ b/debian/templates/koha-sites.conf @@ -17,6 +17,7 @@ OPACSUFFIX="" # # DEFAULTSQL: filename # Specify an SQL file with default data to load during instance creation +# The SQL file can be optionally compressed with gzip # default: (empty) DEFAULTSQL="" -- 2.39.5