February 2017 - Koha-bugs - lists.koha-community.org

[Bug 15427] Allow db connections using TLS
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15427 --- Comment #15 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- (In reply to Mirko Tietgen from comment #13) > In the non-TLS file I see a lot of MySQL commands. Like SELECTs. In the TLS > file I don't (actually I see one, not sure why), but mostly "garbage". Yes indeed, it works as intended! -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15427] Allow db connections using TLS
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15427 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #59383|0 |1 is obsolete| | --- Comment #14 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- Created attachment 60467 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=60467&action=ed… Bug 15427 : Enable TLS support for MySQL In summary, changes are: 1) If you have chosen MySQL, Makefile.PL will ask you if you want TLS (default: "no"), and then the locations for CA cert, client cert and client key (reasonable defaults are provided). Settings <tls>, <ca>, <cert> and <key> are added in koha-conf.xml 2) If <tls>yes</tls> in koha-conf.xml, the installer and database connection scripts add the TLS options in both DBI connection strings and mysql command line To test 1/ Apply patch 2/ Check everything still works and db connections are the same as before 3/ Either run Makefile.PL and step through the options or edit your koha-conf.xml to enable TLS 4/ Check db connections are still working Patch provided to me by Dimitris Kamenopoulos and I reformatted it into a git patch, any errors are probably mine Signed-off-by: Mirko Tietgen <mirko(a)abunchofthings.net> Signed-off-by: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15427] Allow db connections using TLS
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15427 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8548] Add callnumber sort option to overdue report
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8548 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA --- Comment #5 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- Aleisha, it seems that there is still code related to the "order" parameter. I guess we should get rid of it as well (search for '$order' in the pl script). -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8548] Add callnumber sort option to overdue report
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8548 Baptiste <baptiste.wojtkowski(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8548] Add callnumber sort option to overdue report
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8548 Baptiste <baptiste.wojtkowski(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #60170|0 |1 is obsolete| | --- Comment #4 from Baptiste <baptiste.wojtkowski(a)biblibre.com> --- Created attachment 60466 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=60466&action=ed… [SIGNED OFF] Bug 8548: Add datatable to circ overdue report, remove sortby filter This patch adds a datatable to the circ overdue report. Since the datatable makes sorting easy, I've also removed the sort by filter on the side. To test: 1) Go to Circulation -> Overdues 2) Notice overdues report shows as datatable 3) Confirm sorting on all columns works 4) Test the Filters and confirm they all still work as expected Sponsored-by: Catalyst IT Signed-off-by: Baptiste Wojtkowski <baptiste.wojtkowski(a)biblibre.com> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 8548] Add callnumber sort option to overdue report
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8548 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart(a)bugs.koha-c | |ommunity.org Status|Signed Off |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13685] Sorting Patron Reading History
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13685 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #60226|0 |1 is obsolete| | --- Comment #16 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- Created attachment 60464 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=60464&action=ed… Bug 13685: Sorting by author in opac reading history opac-readingrecord.pl was actually already set up to do this, the option to sort by author was just not put into the tt file. This patch adds that. To test: 1) Log into OPAC, go to your reading history 2) Confirm that 'Order by author' shows in the dropdown 3) Confirm it works as expected Sponsored-by: Catalyst IT Signed-off-by: Mark Tompsett <mtompset(a)hotmail.com> Signed-off-by: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13685] Sorting Patron Reading History
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13685 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 18145] New: Show name of submitter and reviewer on tags/ review.pl in staff
by bugzilla-daemon＠bugs.koha-community.org 20 Feb '17

20 Feb '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18145 Bug ID: 18145 Summary: Show name of submitter and reviewer on tags/review.pl in staff Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0