June 2018 - Koha-bugs - lists.koha-community.org

[Bug 17237] New: Stop koha-create from creating MySQL users without host restriction
by bugzilla-daemon＠bugs.koha-community.org 08 Nov '18

08 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17237 Bug ID: 17237 Summary: Stop koha-create from creating MySQL users without host restriction Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Packaging Assignee: magnus(a)libriotech.no Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net I am trying to tune MySQL using MySQLTuner (http://mysqltuner.com/) When I run it on my Koha server I get a bunch of warnings like this: [!!] User 'koha_x@%' hasn't specific host restriction. [!!] User 'koha_y@%' hasn't specific host restriction. [!!] User 'koha_z@%' hasn't specific host restriction. And in mysql.user I have: | % | koha_x | | % | koha_y | | % | koha_z | | localhost | koha_x | | localhost | koha_y | | localhost | koha_z | The code that creates these users is in koha-create, line 654 an onwards: # Set up MySQL database for this instance. if [ "$op" = create ] then mysql --defaults-extra-file=/etc/mysql/koha-common.cnf <<eof CREATE DATABASE \`$mysqldb\`; CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; FLUSH PRIVILEGES; eof fi #` if [ "$op" = use ] then mysql --defaults-extra-file=/etc/mysql/koha-common.cnf --force <<eof CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; FLUSH PRIVILEGES; eof fi #` Perhaps it is just a lack of imagination, but I can't really think of a use for the @% unrestricted user. Am I missing something, or can we just get rid of it? Or if they are needed in some scenarios, can we be more clever about when we create unrestricted users, so they are only created when needed? -- You are receiving this mail because: You are watching all bug changes.

1 15

[Bug 18385] New: Strange display of tabs in subscription details (OPAC)
by bugzilla-daemon＠bugs.koha-community.org 06 Nov '18

06 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18385 Bug ID: 18385 Summary: Strange display of tabs in subscription details (OPAC) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: veron(a)veron.ch QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Created attachment 61868 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=61868&action=ed… Strange display of tabs in subscription details (OPAC) Tabs do not display correctly in /cgi-bin/koha/opac-serial-issues.pl?biblionumber=nn To reproduce, create a subscription, then display serial in OPAC: Home > Details for [My serial] > Issues for a subscription See screenshot attached. Reproduced with Firefox and IE, same display. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 20521] New: dev installations should run with problematic SQL modes
by bugzilla-daemon＠bugs.koha-community.org 05 Nov '18

05 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20521 Bug ID: 20521 Summary: dev installations should run with problematic SQL modes Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 20229 So far we have bug 17258 (omnibus to list the issue we have with the new default SQL modes), bug 20144 (which fixed our test suite with these modes) and bug 20229. This last one forces the SQL modes to avoid to modify the DBMS configuration and define the SQL modes we support. We should let developers catch the issues and report/fix them. Also Jenkins must alert us if there is a regression with the test suite. I suggest to enable the problematic SQL modes on dev installs. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20229 [Bug 20229] Remove problematic SQL modes -- You are receiving this mail because: You are watching all bug changes.

1 24

[Bug 17218] New: New list add attempt while logged in as dbadmin should be prevented pre-emptively
by bugzilla-daemon＠bugs.koha-community.org 05 Nov '18

05 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17218 Bug ID: 17218 Summary: New list add attempt while logged in as dbadmin should be prevented pre-emptively Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Lists Assignee: gmcharlt(a)gmail.com Reporter: indradg(a)l2c2.co.in QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Right now it allows the Koha db admin login to attempt adding a new list. Only while trying to save it does it inform that it is not possible to do so. This is should be made pre-emptive right after the "+ New list" option is clicked. -- You are receiving this mail because: You are watching all bug changes.

1 27

[Bug 18923] New: Resolve a warn in Biblio::GetCOinSBiblio
by bugzilla-daemon＠bugs.koha-community.org 02 Nov '18

02 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18923 Bug ID: 18923 Summary: Resolve a warn in Biblio::GetCOinSBiblio Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 24

[Bug 15705] New: Notify the user on auto renewing
by bugzilla-daemon＠bugs.koha-community.org 01 Nov '18

01 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15705 Bug ID: 15705 Summary: Notify the user on auto renewing Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Circulation Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Customisable notices must be triggered to tell patrons if the items were renewed and when failed to renew. -- You are receiving this mail because: You are watching all bug changes.

1 87

[Bug 20182] New: Remove group by clause in search_patrons_to_anonymise
by bugzilla-daemon＠bugs.koha-community.org 01 Nov '18

01 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20182 Bug ID: 20182 Summary: Remove group by clause in search_patrons_to_anonymise Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Test Suite Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: julian.maurice(a)biblibre.com QA Contact: julian.maurice(a)biblibre.com Blocks: 17258 This bug is a continuation of bug 20144 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMNIBUS] MySQL 5.7 -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 20525] New: Add --timezone switch to koha-create
by bugzilla-daemon＠bugs.koha-community.org 01 Nov '18

01 Nov '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20525 Bug ID: 20525 Summary: Add --timezone switch to koha-create Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Now that Koha can be set a timezone on a per-instance basis (bug 20123), we should provide a way to configure it on instance creation time. It should default to empty to keep the current behaviour. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 26

[Bug 18927] New: koha-rebuild-zebra -f -v koha
by bugzilla-daemon＠bugs.koha-community.org 30 Oct '18

30 Oct '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927 Bug ID: 18927 Summary: koha-rebuild-zebra -f -v koha Change sponsored?: --- Product: Koha Version: 17.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs(a)lists.koha-community.org Reporter: jef(a)dias.ie QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Using Debian packages: koha:~# dpkg -l | grep koha ii koha-common 17.05.01-1 all integrated (physical) library management system ii libcgi-session-driver-memcached-perl 0.04-1koha2 all Perl module to allow CGI sessions to be stored in memcache ii libconvert-basen-perl 0.01-1koha1 all perl module for encoding and decoding of base{2,4,8,16,32,64} strings ii libdbix-runsql-perl 0.14-1~koha1 all module to run an SQL file via a DBI handle ii libjson-validator-perl 0.67+dfsg-1~koha1 all module to validate data against a JSON schema ii libmarc-record-perl 2.0.6-1koha1 all Perl extension for handling MARC records ii libmojolicious-perl 6.15+dfsg-1~koha1 all simple, yet powerful, Web Application Framework ii libpdf-fromhtml-perl 0.31-1~koha1 all module to convert HTML documents to PDF ii libpdf-reuse-perl 0.36-1koha1 all Reuse and mass produce PDF documents ii libpdf-writer-perl 0.06-1~koha1 all PDF writer abstraction layer ii libswagger2-perl 0.77-1~koha1 all Perl module for generating, parsing and transforming swagger API documentation ii libtemplate-plugin-htmltotext-perl 0.03-1koha1 all Plugin interface to HTML::FormatText ii libtemplate-plugin-json-escape-perl 0.2-1koha1 all module for embedding JSON strings in Template Toolkit ii libtemplate-plugin-stash-perl 1.006-1~koha1 all Template::Toolkit plugin that exposes the template's stash # koha-rebuild-zebra -f -v koha returns a lot of errors: [...] error retrieving biblio 94540 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94541 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94542 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94543 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94544 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94545 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94546 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94547 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94548 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. error retrieving biblio 94549 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 683, <DATA> line 751. [...] Although the 'use' is clearly defined: use C4::Biblio; specifying the full perl library/function name in those 2 files fixes it: for p in /usr/share/koha/bin/migration_tools/rebuild_zebra.pl /usr/share/koha/lib/C4/Items.pm; do for f in GetMarcFromKohaField GetMarcBiblio GetBiblionumberFromItemnumber TransformKohaToMarc GetFrameworkCode; do sed -i -e "s/$f/C4::Biblio::$f/g" $p done done -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 31

[Bug 17876] New: Show more invoice information in subscription details
by bugzilla-daemon＠bugs.koha-community.org 30 Oct '18

30 Oct '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17876 Bug ID: 17876 Summary: Show more invoice information in subscription details Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com When using the acquisitions and the 'order from subscription' feature, there is an acquisition details block visible on the subscription detail page. This block shows the current order and the amount spent for the last order. In some cases, there are multiple invoices for a serial subscription during the year, for example, if they are paid quarterly. It would be helpful for the library if we could show all 'amounts spend' for the last and current year, to be able to compare and easily spot price changes. It might also be nice to have a 'show all' feature that gives you a complete overview. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7