From 078dc3f32f3544f16add70fe38af80b474cc5bcf 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 --- 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 bcee3994439..6fa40149296 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