November 2017 - 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 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 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 29 Oct '18

29 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

[Bug 19550] New: Add links to related authorities for UNIMARC
by bugzilla-daemon＠bugs.koha-community.org 29 Oct '18

29 Oct '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19550 Bug ID: 19550 Summary: Add links to related authorities for UNIMARC Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: julian.maurice(a)biblibre.com Reporter: julian.maurice(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Links exist in search results for MARC21 but not for UNIMARC. -- You are receiving this mail because: You are watching all bug changes.

1 19

[Bug 19173] New: Make OPAC online payments pluggable
by bugzilla-daemon＠bugs.koha-community.org 28 Oct '18

28 Oct '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19173 Bug ID: 19173 Summary: Make OPAC online payments pluggable Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org While PayPal is fairly universally used worldwide, there is a plethora of online payment system that are far more localized, servicing a single country ( e.g. Bug 18968 ) or even a single city! Instead of adding support for each and every one of these payment options directly into Koha, it makes more sense to add the ability to create online payment plugins. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 26

[Bug 19617] New: Development - Allow partial writeoff
by bugzilla-daemon＠bugs.koha-community.org 27 Oct '18

27 Oct '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19617 Bug ID: 19617 Summary: Development - Allow partial writeoff Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jesse(a)bywatersolutions.com Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Add “Write off selected” button -- You are receiving this mail because: You are watching all bug changes.

1 22