From c41bca736e204c33da3da864f8fd74be88daf099 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Sat, 6 Jul 2024 00:38:59 +0000 Subject: [PATCH] Bug 23685: Exclude guided_reports.pl from plack When attempting to export reports in ODS format from Koha, plack can time out Excluding the script from plack is a simple fix until we have a more permanent fix for this issue. To test: 1. Create a report which will generate an enormous number of rows, such as SELECT biblio.* FROM biblio CROSS JOIN biblio b; (add a limit of 10000 or something if you like i.e. SELECT biblio.* FROM biblio CROSS JOIN biblio b limit 10000;) 2. Run the report 3. Apply patch, copy changes to /etc/koha/apache-shared-intranet-plack.conf 4. Restart all the things 5. Download the results in ODS format 6. Confirm the export works as expected Sponsored-by: Waikato Institute of Technology Signed-off-by: David Nind --- debian/templates/apache-shared-intranet-plack.conf | 1 + 1 file changed, 1 insertion(+) diff --git a/debian/templates/apache-shared-intranet-plack.conf b/debian/templates/apache-shared-intranet-plack.conf index bcee399443..6fa4014929 100644 --- a/debian/templates/apache-shared-intranet-plack.conf +++ b/debian/templates/apache-shared-intranet-plack.conf @@ -14,6 +14,7 @@ ProxyPass "/cgi-bin/koha/tools/export.pl" "!" ProxyPass "/cgi-bin/koha/tools/upload-cover-image.pl" "!" ProxyPass "/cgi-bin/koha/svc/cataloguing/metasearch" "!" + ProxyPass "/cgi-bin/koha/reports/guided_reports.pl" "!" ProxyPreserveHost On -- 2.39.2