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

[Bug 12628] reports/cat_issues_top.pl incorrect checkout range query
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12628 Arthur Suzuki <arthur.suzuki(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|gmcharlt(a)gmail.com |arthur.suzuki(a)biblibre.com CC| |arthur.suzuki(a)biblibre.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 25607] New: Wrong behaviour about perl versions in list-deps
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25607 Bug ID: 25607 Summary: Wrong behaviour about perl versions in list-deps Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net To reproduce: ` docker run --volume=/home/tcohen/git/koha:/koha -ti debian:stretch bash apt update apt install apt-file wget gnupg wget -q -O- https://debian.koha-community.org/koha/gpg.asc | apt-key add - echo 'deb http://deb.debian.org/debian stretch-backports main' > /etc/apt/sources.list.d/stretch-backports.list echo 'deb http://debian.koha-community.org/koha stable main' > /etc/apt/sources.list.d/koha.list apt update apt-install libmodern-perl-perl libcpan-meta-perl libmodule-cpanfile-perl apt-file update cd /koha PERL5LIB=. perl debian/update-control ` The result is not correct for perl-modules and maybe libperl -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5

[Bug 11974] Enable non-default unix socket location for database connections.
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974 --- Comment #33 from David Cook <dcook(a)prosentient.com.au> --- Nevermind... the problem was Memcached. As soon as I cleared Memcached, the new koha-conf.xml settings were taken up, and now Koha is using the Unix socket instead of the TCP socket. So now I'm curious... Olli-Antti Kivilahti, why are you using a MySQL socket in a path that your local MySQL client library doesn't know? -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 25715] New: Cookie “CGISESSID” will be soon rejected
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25715 Bug ID: 25715 Summary: Cookie “CGISESSID” will be soon rejected Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Testing something else I noticed this warning in the console: Cookie “CGISESSID” will be soon rejected because it has the “sameSite” attribute set to “none” or an invalid value, without the “secure” attribute. To know more about the “sameSite“ attribute, read https://developer.mozilla.org/docs/Web/HTTP/Headers/Set-Cookie/SameSite Filing so we can check if changes need to be made. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 11974] Enable non-default unix socket location for database connections.
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974 --- Comment #32 from David Cook <dcook(a)prosentient.com.au> --- Ok this is actually pretty interesting. It looks like DBD::mysql was provided by a stable OS package, so it was already compiled presumably against the Mariadb libraries provided on the system. So that's... interesting. Looks like mysql_real_connect is the thing doing the heavy lifting... https://metacpan.org/source/DVEEDEN/DBD-mysql-4.050/dbdimp.c#L2107 According to https://github.com/mariadb-corporation/mariadb-connector-c/blob/3.1/CMakeLi…, the default client socket is /tmp/mysql.sock. I guess it's possible that OpenSuse compile the mysql-server and mysql-client packages with a new default of /var/run/mysql/mysql.sock. Looks like they overrode it in http://download.opensuse.org/source/distribution/leap/15.0/repo/oss/src/mar… and http://download.opensuse.org/source/distribution/leap/15.0/repo/oss/src/mar… But that should mean that DBD::mysql was compiled with the same overriden socket address... Especially since the spec file in http://download.opensuse.org/source/distribution/leap/15.0/repo/oss/src/per… requires the libmariadb-devel which is created by that mariadb-connector-c source package... Bizarre... I imagine this isn't useful for most people, but maybe it's similar to Olli-Antti Kivilahti's issue. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14315] Slow checkouts, caused by many 'special_holidays' definitions
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14315 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |RESOLVED Resolution|--- |DUPLICATE --- Comment #13 from Martin Renvoize <martin.renvoize(a)ptfs-europe.com> --- *** This bug has been marked as a duplicate of bug 25723 *** -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 18519] New: Add ability to skip irrelevant dates in Koha::Calendar
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18519 Bug ID: 18519 Summary: Add ability to skip irrelevant dates in Koha::Calendar Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org We've seen occurrences of fines.pl and overdue_notices.pl slowing down when there are a large number of (usually old) entries in special_holidays table. Apparently, we're checking each candidate day against the whole fines calendar -- this is unnecessary, as both fines and overdue notices are are bounded; we only need to check the calendar enteries between the current day and the relevant letter delay (for overdue notices) or between the day the item went overdue and the current day (for fines). If we could pass in a start and end date, we could eliminate this overhead. -- You are receiving this mail because: You are watching all bug changes.

1 13

[Bug 14315] Slow checkouts, caused by many 'special_holidays' definitions
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14315 Bug 14315 depends on bug 18519, which changed state. Bug 18519 Summary: Add ability to skip irrelevant dates in Koha::Calendar https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18519 What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |RESOLVED Resolution|--- |DUPLICATE -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11974] Enable non-default unix socket location for database connections.
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974 --- Comment #31 from David Cook <dcook(a)prosentient.com.au> --- Interestingly enough on OpenSUSE "lsof" isn't working even with v4.91. That's confusing. For tcpdump I had to do: tcpdump -i lo 'port 3306' And yeah I'm using Mariadb on OpenSuse which uses the socket at /var/run/mysql/mysql.sock instead of /var/run/mysqld/mysqld.sock. DBD::mysql doesn't seem to be able to detect it. Seeing libraries for both mysql and mariadb... wondering what DBD::mysql got compiled against. I only see headers for mariadb but the "mysql" client which is really the mariadb client uses /var/run/mysql/mysql.sock by default... I imagine that's probably causing some havoc. Symlinking isn't a brilliant option here since /run and /var/run are mounted on a tmpfs file system. I think I could change the socket location in my /etc/my.cnf file. That's probably the easiest thing without messing around with MySQL/Mariadb client libraries and re-compiling DBD::mysql... -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11974] Enable non-default unix socket location for database connections.
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '20

17 Jun '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11974 --- Comment #30 from David Cook <dcook(a)prosentient.com.au> --- Oh beautiful... have a library on Koha 19.11 on Ubuntu 18.04 with MySQL 5.7 and it's using the Unix socket even when localhost:3306 is defined in koha-conf.xml. Very cool. Confirmed using tcpdump and "lsof +E /var/run/mysqld/mysqld.sock" which shows that starman and rebuild_zebra.pl are using the Unix socket. (Note I think that lsof command will only work on lsof v4.89+. You can use "ss -p -x | less" too but it's a pain tracing the inode numbers). -- You are receiving this mail because: You are watching all bug changes.

1 0