October 2020 - Koha-bugs - lists.koha-community.org

[Bug 8437] Large database backups and large exports from export.pl fail under plack
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=26791 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8437] Large database backups and large exports from export.pl fail under plack
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #109632|0 |1 is obsolete| | --- Comment #46 from David Cook <dcook(a)prosentient.com.au> --- Created attachment 112224 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=112224&action=e… Bug 8437: Exclude export.pl from plack When attempting to download large files from Koha plack can timeout Excluding the script from plack is a simple fix until we have a more permanent fix for this issue. To test: 1 - Try to export your entire DB from Tools->Export 2 - If big enough, it fails 3 - Apply patch, copy changes to /etc/koha/apache-shared-intranet-plack.conf 4 - Restart all the things 5 - Repeat export, it succeeds Signed-off-by: David Cook <dcook(a)prosentient.com.au> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8437] Large database backups and large exports from export.pl fail under plack
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8437] Large database backups and large exports from export.pl fail under plack
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 --- Comment #45 from David Cook <dcook(a)prosentient.com.au> --- (In reply to David Cook from comment #44) > (In reply to Nick Clemens from comment #30) > > Created attachment 109632 [details] [review] [review] > > Bug 8437: Exclude export.pl from plack > > > > When attempting to download large files from Koha plack can timeout > > > > Excluding the script from plack is a simple fix until we have a more > > permanent fix for this > > issue. > > > > To test: > > 1 - Try to export your entire DB from Tools->Export > > 2 - If big enough, it fails > > 3 - Apply patch, copy changes to /etc/koha/apache-shared-intranet-plack.conf > > 4 - Restart all the things > > 5 - Repeat export, it succeeds > > My test plan: > 0. Using koha-testing-docker > 1. cp debian/templates/apache-shared-intranet-plack.conf > /etc/koha/apache-shared-intranet-plack.conf > 2. enable "backup_db_via_tools" in /etc/koha/sites/kohadev/koha-conf.xml > 3. echo 'flush_all' | nc -q 1 memcached 11211 > 4. service apache2 restart > 5. koha-plack --restart kohadev > 6. Go to http://localhost:8081/cgi-bin/koha/tools/export.pl > 7. Note "Unfortunately, no backups are available." > > So that's not going to work... but I have another idea. My test plan: 0. Using koha-testing-docker 1. cp debian/templates/apache-shared-intranet-plack.conf /etc/koha/apache-shared-intranet-plack.conf 2. Point koha-testing-docker at a database with a large number of biblios (e.g. 40,000 biblios) 3. echo 'flush_all' | nc -q 1 memcached 11211 4. restart_all 5. Go to http://localhost:8081/cgi-bin/koha/tools/export.pl 6. Click "Don't export items" 7. Click "Export bibliographic records" 8. Note after about 5 seconds that a download for koha.mrc starts. Perfect. Cheers, Nick. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8437] Large database backups and large exports from export.pl fail under plack
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 --- Comment #44 from David Cook <dcook(a)prosentient.com.au> --- (In reply to Nick Clemens from comment #30) > Created attachment 109632 [details] [review] > Bug 8437: Exclude export.pl from plack > > When attempting to download large files from Koha plack can timeout > > Excluding the script from plack is a simple fix until we have a more > permanent fix for this > issue. > > To test: > 1 - Try to export your entire DB from Tools->Export > 2 - If big enough, it fails > 3 - Apply patch, copy changes to /etc/koha/apache-shared-intranet-plack.conf > 4 - Restart all the things > 5 - Repeat export, it succeeds My test plan: 0. Using koha-testing-docker 1. cp debian/templates/apache-shared-intranet-plack.conf /etc/koha/apache-shared-intranet-plack.conf 2. enable "backup_db_via_tools" in /etc/koha/sites/kohadev/koha-conf.xml 3. echo 'flush_all' | nc -q 1 memcached 11211 4. service apache2 restart 5. koha-plack --restart kohadev 6. Go to http://localhost:8081/cgi-bin/koha/tools/export.pl 7. Note "Unfortunately, no backups are available." So that's not going to work... but I have another idea. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8437] Large database backups and large exports from export.pl fail under plack
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11177|0 |1 is obsolete| | --- Comment #43 from David Cook <dcook(a)prosentient.com.au> --- Comment on attachment 11177 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11177 Bug 8437: variable scoping for tools/export.pl I think that this one is obsolete at this point. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8437] Large database backups and large exports from export.pl fail under plack
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8437 --- Comment #42 from David Cook <dcook(a)prosentient.com.au> --- In any case, I think we do need to solve the immediate problem ASAP, so I'm going to go ahead with Nick's patch. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 26789] New: Need note fields for all sections of circulation rules
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26789 Bug ID: 26789 Summary: Need note fields for all sections of circulation rules Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: cbrannon(a)cdalibrary.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Currently the circulation rules only allow notes for each line in the first table. Perhaps it would be better to have a single, multiline note field for each library at the top, so admin can put in notes for anything on the page. As is, the current note fields are too small for adequate notes, and you can't add notes for other sections of the page. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0

[Bug 7236] Add "Save as RDF" option to the OPAC
by bugzilla-daemon＠bugs.koha-community.org 23 Oct '20

23 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7236 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook(a)prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12656] Send a notice to patrons when their hold was cancelled because it was not picked up
by bugzilla-daemon＠bugs.koha-community.org 22 Oct '20

22 Oct '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12656 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|Academy | --- Comment #14 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- E-Mails, cron and unit tests cannot be tested on a sandbox, so removing the Academy keyword. -- You are receiving this mail because: You are watching all bug changes.

1 0