March 2018 - Koha-devel - lists.koha-community.org

MariaDB and Auto Increment - it's the good news
by Liz Rea 27 Mar '18

27 Mar '18

I was quite nosing around looking for something else, and came across this: |> Until MariaDB 10.2.3, InnoDB and XtraDB used an auto-increment counter that is stored in memory. When the server restarts, the counter is re-initialized to the highest value used in the table, which cancels the effects of any AUTO_INCREMENT = N option in the table statements. ||| Of course. We knew that. What we didn't know, possibly, was the following: || |> From MariaDB 10.2.4, this restriction has been lifted and AUTO_INCREMENT is persistent.| || Note that this isn't the current package version of mariadb-server for Debian 9, it's lagging behind a bit at 10.1.26. However, the days of auto increment issues, at least for MariaDB, may soon be coming to a close. Information from: https://mariadb.com/kb/en/library/auto_increment/ -- Liz Rea Catalyst.Net Limited Level 6, Catalyst House, 150 Willis Street, Wellington. P.O Box 11053, Manners Street, Wellington 6142 04 803 2265 GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7

3 2

Plack only
by Tomas Cohen Arazi 20 Mar '18

20 Mar '18

I would like to know if you think there's any reason to keep the CGI mode as default in Koha deployments. I think we should make Plack the default. There are some issues, tough. But if we set that goal, we could focus on fixing them. What do you think? -- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F

8 22

Scheduling the Koha Docs Webinar
by Lee Jamison 19 Mar '18

19 Mar '18

Hello everyone! I had planned to send this out earlier (meaning last week) but I figured with hackfest going on it would be something else to remember! I created a Doodle (for those not familiar, an online poll) spanning this week and next (up to March 30th) to get an idea when the majority will be available for. To account for everyone's timezone, I'll leave it up for 24 hours and then go with whichever day/time the most are available! https://doodle.com/poll/bea9ydf2niec2fme Let me know if you have any questions, comments, or suggestions! -- Lee Jamison Automated Library Technician Marywood University 570-961-4586 ldjamison(a)marywood.edu

1 0

Hackfest in Marseille, what you missed and what you'll be see soon in 18.05
by Paul Poulain 16 Mar '18

16 Mar '18

Hello all, So the 2018 hackfest in Marseille is now finished. It was a great week, with a lot of work, a lot of discussion, a lot of fun. The weather was with us, except on thursday, the evenings were full of beer & happyness. Let's summarize what we made... Koha Elastic Search Our hotest topic, for sure 10 patches written and/or signed off. A lot of work on Elastic Search. BULAC want to go live with Koha+ES with 18.05 [Thank you François and Severine, Bulac, Nick, Bywatersolutions, Alex, BibLibre] UNIMARC & bibliographic transition (FRBR): • default frameworks at install updated [thank you François, Roubaix public library] • script written to update all cataloguing frameworks with new MARC records preparing FRBR (IFLA 2017 fields & subfields) [thank you Julian, BibLibre] • zebra indexes definition started, to be finished [thank you François, Roubaix public library] • XSLT to display those new fields still to do FRBR & ReasonableGraph 3 developers from AltSol, a Greek company working on FRBR and a software called ReasonableGraph (see https://reasonablegraph.org/) showed what they made with Koha & MARC data. They'll keep to work on it, the Koha community may hear of them again in the future. Maybe starting with a plugin that can be compared to the Ebsco EDS plugin: instead of searching in Koha, search would be made on ReasonableGraph database, that is fully FRBR compliant, and present results in a "FRBR way" [Thank you Nikos, AltSol] Translation The french team worked and finished to translate 100% of 17.11, the release notes, and most of the documentation. A big effort [Thank you many french librarians !] Coral & Koha<>Coral interface • presentation of Coral 3.0 new features (including the wonderful interface Coral <> EDS) • presentation of Coral setup at Lyon 3 [Thank you Sonia, Lyon 3] • Koha <> Coral interface, what's done, what has to be done [Thank you Matthias, BibLibre] Koha & SCSS [Thank you Owen, ACPL] • Finished the transition to SCSS for the staff client (see http://sass-lang.com/, and http://sebastianpontow.de/css2compass/ and https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19474) patch passed QA now • The transition from LESS to SCSS for the OPAC is done (see https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20427) • Owen introduced us to SCSS. Mana-kb rebase, fixes, tests. One problem detected, not easy to reproduce, still working on it, still highly expected for 18.05 [Thank you Brendan, BywaterSolutions & Alex, BibLibre] Bugzill [Thank you ... too many people to name them !] • 80+ patches tested (44 signed-off, 21 failed, 15 does not apply) • This week, 285 bugs had at least one change (any kind, change by a "hackfester" or not) Various • kohadevbox presentation & installation on some librarian laptops. We now have some librarians able to sign-off patches without using sandboxes ! [thank you Nick, ByWaterSolutions] • Kohala (Koha french usergroup) has scheduled the Symposium (Paris, in June) • On Thursday, it was the "Bokeh hackfest/conference". Bokeh is a library portal software that BibLibre is supporting. 10 new librarians and 4 developers from AFI, BibLibre sister-company joined us to discuss new features, and share their experience with Bokeh, Bokeh+Koha, ... (http://bokeh-library-portal.org for more info about Bokeh) [Thank you https://www.makeitmarseille.com/, our neigbour for hosting this event] • we discovered Emkipop (http://emkipop.fr/) If I forgot something, remind me, please [ I'm an old man, you know, my memory begins to abandon me ;) ] -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

3 2

Call for News: March 2018 Newsletter
by kohanews 14 Mar '18

14 Mar '18

I'm collecting news for the March newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Biblibre Sandboxes with ES
by Fridolin SOMERS 12 Mar '18

12 Mar '18

Hi, I'm please to announce we have build sandboxes with Zebra and ElasticSearch. See https://wiki.koha-community.org/wiki/Sandboxes#BibLibre If help needed please use sandboxes(a)biblibre.com Best regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre - software and system maintainer

2 1

REST API authentication for external clients
by Julian Maurice 02 Mar '18

02 Mar '18

Hi all, As you may know [1], BibLibre is working on an interface between Koha and Coral. To achieve that, Coral uses the Koha REST API. But we are facing a problem that is becoming really blocking : the lack of a proper authentication system for the REST API. At the moment, the only way to authenticate to the API is based on cookies. It works well for client-side javascript inside Koha, but it's not really usable by external clients. Is there someone here who use this API outside of Koha ? If so, how do you authenticate to it ? I think we really need an authentication mechanism other than cookies, so people can actually start using the API. There is bug 13920 [2] that hasn't moved since 8 months. I remember that some people disagreed with this patchset because it is crafting a custom authentication system instead of using some "standard" one (I remember OAuth was mentioned). Do you know of any "standard" auth system that we can implement, or existing Perl libraries we can use ? [1]: http://lists.koha-community.org/pipermail/koha-devel/2017-January/043430.ht… [2]: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13920 -- Julian Maurice <julian.maurice(a)biblibre.com> BibLibre

4 4

Koha Community Newsletter: February 2018
by kohanews 01 Mar '18

01 Mar '18

Fellow Koha users: The Koha Community Newsletter for February 2018 is here: https://koha-community.org/koha-community-newsletter-february-2018/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0