- Koha - lists.katipo.co.nz

Rebuild database / clean install
by Father Vlasie 11 Aug '22

11 Aug '22

Hello everyone! I would like to migrate to a new Koha installation. On my current install I am seeing a lot of errors (mostly, I think, due to using cpan to install perl modules which means I often have the wrong versions :( ). I also have some auto-increment related problems in the DB. I am thinking of doing a fresh install and moving the Koha data over. However, all of the tutorials I have found recommend doing a mysqldump and then slurping that into the new DB. If I want to avoid bringing DB problems along from the old install will that method not be problematic? Is there a way to export the data to a different format and rebuild the SQL from that? (Maybe the export command under admin>tools?) I have not seen any documentation regarding my concept of a clean install hence my decision to write to the list. Thank you in advance for any feedback or suggestions! Father Vlasie

2 1

koha-US General Meeting reminder: Wednesday, August 10, 2022
by Jennifer Marlatt 10 Aug '22

10 Aug '22

The next koha-US general meeting is *tomorrow, *Wednesday, August 10, 2022. When: 8:30a PT / 11:30a ET (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+March+Gen…> ) Where: https://us02web.zoom.us/j/648572897?pwd=TUpsRE1TYlFPWWxTWFl4TVovSTJ3Zz09 Agenda: https://docs.google.com/document/d/1w0XoXCGBr_I89WGMM4WsEZibxjDuxr5ERuHZIkf… If you have additional topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Jennifer Marlatt koha-US Secretary secretary(a)koha-us.org

1 0

Overdue Notice
by Ma. Victoria H. Silva-Manuel 09 Aug '22

09 Aug '22

Hi. How to send overdue notice every day until the item is returned to us? Thanks.

2 1

Koha API issue
by Dibyendra Hyoju 07 Aug '22

07 Aug '22

Hi everyone, We are trying to access Koha data using Koha API from a different system. We are using the Angular JS V2 library to access Koha API. While accessing the API, we encountered a CORS error stating "Access to XMLHttpRequest at " http://opac.tucl.edu.np:81/api" from origin "http://localhost:4200" has been blocked by CORS policy. The detail of the error is provided in the screenshot below. We have also tried to set the value for the AccessControlAllowOrigin system preference with the value "http://localhost:4200". As it didn't resolve the issue, we also set the preference value as an asterisk '*'. However, we still encountered the same error. [image: error_2022-08-06_17-38-43-985.jpg] If anyone had already resolved this kind of issue earlier, please share your experience. We would highly appreciate it. Thank you. -- Regards, Dibyendra Hyoju

2 1

Re: [Koha] n-Tier deployment of Koha
by dcook＠prosentient.com.au 05 Aug '22

05 Aug '22

Hi Admire, You'll probably have more luck asking on the dev listserv: koha-devel(a)lists.koha-community.org. However, I'll try to offer some insight here. I'm also CCing in Mengu who has probably the biggest horizontally scaled out Koha in the world. Off the top of my head, technically you could have a load balancer in front of multiple Koha application servers. You'd want to make sure that the cronjobs are only running on 1 application server though. You also would probably want to use an external Elasticsearch cluster since Zebra would be a bottleneck. In theory, you could use a multi-master MySQL/MariaDB database cluster, but I don't know if anyone has done that (and I'd be concerned about the "eventual consistency" of multi-master setups). If you wanted to a master-replica cluster, you'd need to patch Koha to allow for read-only connections (for things like the Reports module); at the moment, Koha can only use 1 read/write database connection. You'd also need to move your RabbitMQ server to an external server which is problematic with the koha-common package at the moment (but there are ways). (Note: I may be missing another horizontal scaling issue, but these are what come to mind at the moment. You might need to use a network share for some file system resources in /var/koha/* but I can't recall off the top of my head.) It would be much easier to scale vertically. I'd suggest you do some analysis to see where your key pain points are. - Out of the box, Koha only uses 2 Starman/Plack workers, so if it's a case where your Koha is overwhelmed by legitimate traffic, I'd recommend adding more Starman/Plack workers via koha-conf.xml (if you have the CPU and RAM to spare). - If your Koha is slow, you might want to look at your database's I/O performance as well. Using quality SSDs can make a huge difference for database driven applications. (Note also that having MySQL/MariaDB on an external server is a common practice but technically speaking it does add some latency to database transactions which you wouldn't have if you ran MySQL/MariaDB on the same server and used Unix sockets. For very large Koha databases, we've noticed that having an external DB server adds too much latency.) - If you're getting a lot of traffic, you should check to see how much traffic is from bots. You might need to implement something like fail2ban to block bots that put too much load on your system. Typically, I find when Koha is overwhelmed, it's due to bots. (You can experiment with a robots.txt file to help with this but it's not a completely effective solution.) There's lots of things to explore. In the long-term I'd love to make Koha easier to scale horizontally (and ideally deploy as a load-balanced containerized application) but there's work to do and not much demand for it from libraries, so I don't think it's a priority for devs at the moment, unfortunately. Anyway, I hope that helps! David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- Message: 10 Date: Wed, 27 Jul 2022 16:28:12 +0100 From: Admire Mutsikiwa <amutsikiwa(a)uzlib.uz.ac.zw> To: koha(a)lists.katipo.co.nz Subject: [Koha] n-Tier deployment of Koha Message-ID: <CAD4nctbymX-UfziZr67h-4p4O0GBPapecRCXfc=obHtmiFt0VQ(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" My Koha implementation is sometimes overwhelmed as it is a two-tier implementation with a database on one server and a Koha application on another server. I am wondering if it is possible to have a 3 or 4 tier deployment architecture, with for instance, having a load balancer, koha application server and a clustered MySQL/Mariadb implementation. Kind Regards, -- *The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential, and/or privileged material. If you are not the intended recipient of this message, be aware that any use, review, retransmission, distribution, reproduction or any action taken in reliance upon this message is strictly prohibited. If you received this in error, please contact the sender and delete the material from all computers*

4 4

Re: [Koha] [Koha-devel] Dependency problem when installing Koha 21.11.10 on Debian 11
by Michael Kuhn 05 Aug '22

05 Aug '22

Hi Mason You wrote: >> Do you maybe have any hint how to find out what could be the problem >> with the failing configuration of package "rabbitmq-server"? > > try reinstalling rabbitmq-server first, then installing koha-common > > # apt purge rabbitmq-server koha-common > # apt install rabbitmq-server > # apt install koha-common > > > note the 'Status' value when rabbitmq is running correctly > > root@deb11:# systemctl status rabbitmq-server.service > * rabbitmq-server.service - RabbitMQ Messaging Server > Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; > enabled; vendor pre> > Active: active (running) since Thu 2022-08-04 13:21:32 UTC; 2min > 56s ago > Main PID: 5844 (beam.smp) > Status: "Initialized" <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< > Tasks: 86 (limit: 2190) > Memory: 75.3M > CPU: 11.458s > CGroup: /system.slice/rabbitmq-server.service > |-5844 /usr/lib/erlang/erts-11.1.8/bin/beam.smp -W w -K > true -A 64 -MBas> > |-5944 erl_child_setup 65536 > |-5994 inet_gethost 4 > `-5995 inet_gethost 4 > >> >> Did anyone out there successfully install either Koha 21.11.10 or >> Koha 22.05.03 on a new machine with Debian GNU/Linux 11? > > yes, i confirmed that both versions install ok on deb11 I just purged both packages, then tried to install "rabbitmq-server": root@bib-katalog:~# apt install rabbitmq-server Reading package lists... Done Building dependency tree... Done Reading state information... Done The following packages were automatically installed and are no longer required: at daemon docbook-xml docbook-xsl fontconfig fonts-dejavu fonts-dejavu-extra gettext graphviz gsfonts icu-devtools idzebra-2.0 idzebra-2.0-common idzebra-2.0-doc idzebra-2.0-utils libalgorithm-c3-perl libalgorithm-checkdigits-perl libann0 libany-uri-escape-perl libanyevent-http-perl libanyevent-perl libapache-logformat-compiler-perl libapache2-mpm-itk libappconfig-perl libarchive-extract-perl libarchive-zip-perl libarray-utils-perl libasync-interrupt-perl libauth-googleauth-perl libauthen-cas-client-perl libb-debug-perl libb-hooks-endofscope-perl libb-hooks-op-check-perl libbarcode-code128-perl libbiblio-endnotestyle-perl libbit-vector-perl libbusiness-isbn-data-perl libbusiness-isbn-perl libbusiness-issn-perl libbytes-random-secure-perl libcache-memcached-fast-perl libcache-memcached-fast-safe-perl libcache-memcached-perl libcairo2 libcapture-tiny-perl libcarp-assert-more-perl libcarp-assert-perl libcarp-clan-perl libcdt5 libcgi-compile-perl libcgi-emulate-psgi-perl libcgi-session-driver-memcached-perl libcgi-session-perl libcgraph6 libclass-accessor-chained-perl libclass-accessor-grouped-perl libclass-accessor-perl libclass-adapter-perl libclass-c3-componentised-perl libclass-c3-perl libclass-c3-xs-perl libclass-data-inheritable-perl libclass-factory-util-perl libclass-inspector-perl libclass-isa-perl libclass-load-perl libclass-load-xs-perl libclass-makemethods-perl libclass-mix-perl libclass-returnvalue-perl libclass-singleton-perl libclass-tiny-perl libclass-unload-perl libclass-xsaccessor-perl libclone-choose-perl libconfig-any-perl libconfig-general-perl libconfig-tiny-perl libcontext-preserve-perl libconvert-base32-perl libconvert-binhex-perl libcookie-baker-perl libcookie-baker-xs-perl libcrypt-cbc-perl libcrypt-eksblowfish-perl libcrypt-jwt-perl libcrypt-random-seed-perl libcrypt-rc4-perl libcrypt-rijndael-perl libcryptx-perl libcurry-perl libdata-dumper-concise-perl libdata-ical-perl libdata-optlist-perl libdata-page-perl libdate-calc-perl libdate-calc-xs-perl libdate-manip-perl libdatetime-event-ical-perl libdatetime-event-recurrence-perl libdatetime-format-builder-perl libdatetime-format-ical-perl libdatetime-format-mail-perl libdatetime-format-mysql-perl libdatetime-format-strptime-perl libdatetime-format-w3cdtf-perl libdatetime-locale-perl libdatetime-perl libdatetime-set-perl libdatetime-timezone-perl libdatrie1 libdbd-mock-perl libdbd-pg-perl libdbd-sqlite3-perl libdbix-class-perl libdbix-class-schema-loader-perl libdbix-runsql-perl libdevel-argnames-perl libdevel-callchecker-perl libdevel-caller-perl libdevel-cover-perl libdevel-globaldestruction-perl libdevel-lexalias-perl libdevel-overloadinfo-perl libdevel-partialdump-perl libdevel-stacktrace-ashtml-perl libdevel-stacktrace-perl libdevel-symdump-perl libdigest-bubblebabble-perl libdigest-perl-md5-perl libdist-checkconflicts-perl libdynaloader-functions-perl libemail-abstract-perl libemail-address-perl libemail-address-xs-perl libemail-date-format-perl libemail-date-perl libemail-messageid-perl libemail-mime-contenttype-perl libemail-mime-encodings-perl libemail-mime-perl libemail-sender-perl libemail-simple-perl libemail-stuffer-perl libeval-closure-perl libevent-2.1-7 libex-monkeypatched-perl libexception-class-perl libexpat1-dev libexporter-tiny-perl libfcgi-procmanager-perl libfile-pushd-perl libfile-sharedir-perl libfile-slurp-perl libfilesys-notify-simple-perl libfl2 libfont-ttf-perl libfreezethaw-perl libgd-barcode-perl libgd-perl libgmp-dev libgmpxx4ldbl libgnutls-dane0 libgnutls-openssl27 libgnutls28-dev libgnutlsxx28 libgraph-perl libgraphics-colornames-perl libgraphics-magick-perl libgraphicsmagick-q16-3 libgraphite2-3 libgraphviz-perl libgravatar-url-perl libgts-0.7-5 libgts-bin libguard-perl libgvc6 libgvpr2 libharfbuzz0b libhash-merge-perl libhash-multivalue-perl libheap-perl libhtml-lint-perl libhtml-scrubber-perl libhtml-tidy-perl libhttp-entity-parser-perl libhttp-headers-fast-perl libhttp-multipartparser-perl libhttp-oai-3.27-perl libhttp-parser-xs-perl libhttp-server-simple-perl libice6 libicu-dev libidn2-dev libidzebra-2.0-0 libidzebra-2.0-dev libidzebra-2.0-mod-alvis libidzebra-2.0-mod-dom libidzebra-2.0-mod-grs-marc libidzebra-2.0-mod-grs-regx libidzebra-2.0-mod-grs-xml libidzebra-2.0-mod-safari libidzebra-2.0-mod-text libidzebra-2.0-modules libimage-png-libpng-perl libimage-size-perl libimport-into-perl libio-all-perl libio-multiplex-perl libio-pty-perl libio-string-perl libio-stringy-perl libipc-run-perl libipc-shareable-perl libjcode-pm-perl libjson-maybexs-perl liblab-gamut1 liblibrary-callnumber-lc-perl liblingua-en-findnumber-perl liblingua-en-inflect-number-perl liblingua-en-inflect-perl liblingua-en-inflect-phrase-perl liblingua-en-number-isordinal-perl liblingua-en-tagger-perl liblingua-en-words2nums-perl liblingua-ispell-perl liblingua-pt-stemmer-perl liblingua-stem-fr-perl liblingua-stem-it-perl liblingua-stem-perl liblingua-stem-ru-perl liblingua-stem-snowball-da-perl liblingua-stem-snowball-perl liblist-moreutils-perl liblist-moreutils-xs-perl liblocale-currency-format-perl liblocale-po-perl liblocale-xgettext-perl liblog-any-perl liblog-dispatch-perl liblog-log4perl-perl libltdl7 libmail-sendmail-perl libmarc-charset-perl libmarc-file-mij-perl libmarc-record-perl libmarc-xml-perl libmath-random-isaac-perl libmath-random-isaac-xs-perl libmath-random-mt-perl libmemoize-expirelru-perl libmime-lite-perl libmime-tools-perl libmime-types-perl libmodern-perl-perl libmodule-bundled-files-perl libmodule-cpanfile-perl libmodule-implementation-perl libmodule-pluggable-perl libmodule-refresh-perl libmodule-runtime-conflicts-perl libmodule-runtime-perl libmojo-jwt-perl libmoo-perl libmoose-perl libmoosex-markasmethods-perl libmoosex-nonmoose-perl libmoox-types-mooselike-perl libmro-compat-perl libnamespace-autoclean-perl libnamespace-clean-perl libnet-cidr-perl libnet-dns-perl libnet-dns-sec-perl libnet-ip-perl libnet-netmask-perl libnet-oauth2-authorizationserver-perl libnet-server-perl libnet-server-ss-prefork-perl libnet-sftp-foreign-perl libnet-stomp-perl libnet-z3950-simpleserver-perl libnet-z3950-zoom-perl libnumber-format-perl libole-storage-lite-perl libopenoffice-oodoc-perl libp11-kit-dev libpackage-deprecationmanager-perl libpackage-stash-perl libpackage-stash-xs-perl libpackage-variant-perl libpadwalker-perl libpango-1.0-0 libpangocairo-1.0-0 libpangoft2-1.0-0 libparallel-forkmanager-perl libparams-classify-perl libparams-util-perl libparams-validate-perl libparams-validationcompiler-perl libparse-recdescent-perl libpath-class-perl libpathplan4 libpdf-api2-perl libpdf-api2-xs-perl libpdf-fromhtml-perl libpdf-reuse-barcode-perl libpdf-reuse-perl libpdf-table-perl libpdf-writer-perl libperl4-corelibs-perl libpixman-1-0 libplack-middleware-logwarn-perl libplack-middleware-reverseproxy-perl libplack-perl libpod-coverage-perl libpod-parser-perl libposix-atfork-perl libposix-strftime-compiler-perl libpq5 libreadonly-perl libref-util-perl libref-util-xs-perl libschedule-at-perl libscope-guard-perl libsearch-elasticsearch-perl libsereal-decoder-perl libsereal-encoder-perl libserver-starter-perl libset-infinite-perl libset-object-perl libsm6 libsms-send-perl libsnowball-norwegian-perl libsnowball-swedish-perl libspecio-perl libspiffy-perl libspreadsheet-parseexcel-perl libspreadsheet-writeexcel-perl libsql-abstract-perl libsql-translator-perl libstream-buffered-perl libstrictures-perl libstring-crc32-perl libstring-random-perl libstring-toidentifier-en-perl libsub-exporter-perl libsub-exporter-progressive-perl libsub-identify-perl libsub-install-perl libsub-quote-perl libsub-uplevel-perl libsuper-perl libsys-cpu-perl libsys-hostname-long-perl libtasn1-6-dev libtasn1-doc libtcl8.6 libtemplate-perl libtemplate-plugin-gettext-perl libtemplate-plugin-htmltotext-perl libtemplate-plugin-json-escape-perl libtemplate-plugin-stash-perl libtest-deep-perl libtest-exception-perl libtest-longstring-perl libtest-mockmodule-perl libtest-mockobject-perl libtest-mocktime-perl libtest-pod-perl libtest-sharedfork-perl libtest-strict-perl libtest-tcp-perl libtest-warn-perl libtest-www-mechanize-perl libtest-yaml-valid-perl libtext-aligner-perl libtext-autoformat-perl libtext-bidi-perl libtext-csv-encoded-perl libtext-csv-perl libtext-csv-xs-perl libtext-german-perl libtext-pdf-perl libtext-recordparser-perl libtext-reform-perl libtext-table-perl libtext-tabulardisplay-perl libtext-unidecode-perl libtext-vfile-asdata-perl libtext-wrapper-perl libthai-data libthai0 libthrowable-perl libtidy5deb1 libtie-ixhash-perl libtime-fake-perl libtype-tiny-perl libtype-tiny-xs-perl libunbound8 libunicode-map-perl libuniversal-can-perl libuniversal-isa-perl libuniversal-require-perl liburi-escape-xs-perl libuuid-perl libvariable-magic-perl libwebpmux3 libwebservice-ils-perl libwmf0.2-7 libwrap0-dev libwww-csrf-perl libwww-form-urlencoded-perl libwww-form-urlencoded-xs-perl libwww-mechanize-perl libxaw7 libxcb-render0 libxcb-shm0 libxml-dumper-perl libxml-filter-buffertext-perl libxml-libxml-perl libxml-libxslt-perl libxml-rss-perl libxml-sax-writer-perl libxml-simple-perl libxml-twig-perl libxml-writer-perl libxml-xpath-perl libxml-xpathengine-perl libxml2-dev libxml2-utils libxmu6 libxrender1 libxslt1-dev libxslt1.1 libxstring-perl libxt6 libyaml-perl libyaz-dev libyaz5 memcached nettle-dev pwgen sgml-base sgml-data starman tcl tcl-dev tcl8.6 tcl8.6-dev x11-common xml-core xmlstarlet xsltproc yaz zlib1g-dev Use 'apt autoremove' to remove them. The following NEW packages will be installed: rabbitmq-server 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B/15.1 MB of archives. After this operation, 15.9 MB of additional disk space will be used. Selecting previously unselected package rabbitmq-server. (Reading database ... 69923 files and directories currently installed.) Preparing to unpack .../rabbitmq-server_3.8.9-3_all.deb ... Unpacking rabbitmq-server (3.8.9-3) ... Setting up rabbitmq-server (3.8.9-3) ... Created symlink /etc/systemd/system/multi-user.target.wants/rabbitmq-server.service -> /lib/systemd/system/rabbitmq-server.service. Progress: [ 60%] [##################################........................] As you can see the process is stuck at 60%, then pauses for a while and eventually shows the same output as before, moaning about some no further defined "dpkg: error processing package rabbitmq-server": Job for rabbitmq-server.service failed because the control process exited with error code. See "systemctl status rabbitmq-server.service" and "journalctl -xe" for details. invoke-rc.d: initscript rabbitmq-server, action "start" failed. * rabbitmq-server.service - RabbitMQ Messaging Server Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Thu 2022-08-04 16:31:04 CEST; 10ms ago Process: 425660 ExecStart=/usr/lib/rabbitmq/bin/rabbitmq-server (code=exited, status=1/FAILURE) Main PID: 425660 (code=exited, status=1/FAILURE) CPU: 7.554s Aug 04 16:31:04 bib-katalog.sintiundroma.de systemd[1]: rabbitmq-server.service: Failed with result 'exit-code'. Aug 04 16:31:04 bib-katalog.sintiundroma.de systemd[1]: Failed to start RabbitMQ Messaging Server. Aug 04 16:31:04 bib-katalog.sintiundroma.de systemd[1]: rabbitmq-server.service: Consumed 7.554s CPU time. dpkg: error processing package rabbitmq-server (--configure): installed rabbitmq-server package post-installation script subprocess returned error exit status 1 Processing triggers for man-db (2.9.4-2) ... Errors were encountered while processing: rabbitmq-server needrestart is being skipped since dpkg has failed E: Sub-process /usr/bin/dpkg returned an error code (1) Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

The Terrific Every-Other-Thursday Training Video S2E22 - SQL: Drilldowns - From One Report to Another
by BRANNON, CHRISTOPHER 04 Aug '22

04 Aug '22

Open this report. Now open that one. Now fill in all the same info again. Now use some of the info from the last report and use it in this one. (Silent screams go through my head.) Oh, wait! I can tell this report to run another report!!!! And it can fill in all the parameters for me! (Glorious cheering now takes the place of the screams in my head.) Great! Gives me time for some coffee. Oh, wait. The coffee maker is broken. (Resume screaming.) https://youtu.be/kMg3sZTqppQ Christopher Brannon koha-US Vice President

1 0

Re: [Koha] [Koha-devel] Dependency problem when installing Koha 21.11.10 on Debian 11
by Michael Kuhn 04 Aug '22

04 Aug '22

Hi Michael Thanks fpr your answer! Unfortunately I'm not able to figure out the problem. "journalctl -xe" and "systemctl status rabbitmq-server.service" both seem to show a working rabbitmq-server, but when trying to finish the installation of package "koha-common" it fails with the same error as before: # journalctl -xe ░░ up or be started at any later time. ░░ ░░ Startup of the manager took 238830 microseconds. Aug 04 09:07:14 bib-katalog.sintiundroma.de systemd[1]: Started User Manager fo> ░░ Subject: A start job for unit user(a)1000.service has finished successfully ░░ Defined-By: systemd ░░ Support: https://www.debian.org/support ░░ ░░ A start job for unit user(a)1000.service has finished successfully. ░░ ░░ The job identifier is 87146. Aug 04 09:07:14 bib-katalog.sintiundroma.de systemd[1]: Started Session 40 of u> ░░ Subject: A start job for unit session-40.scope has finished successfully ░░ Defined-By: systemd ░░ Support: https://www.debian.org/support ░░ ░░ A start job for unit session-40.scope has finished successfully. ░░ ░░ The job identifier is 87212. Aug 04 09:07:14 bib-katalog.sintiundroma.de sudo[312293]: koha : TTY=pts/0 > Aug 04 09:07:14 bib-katalog.sintiundroma.de sudo[312293]: pam_unix(sudo:session> Aug 04 09:07:14 bib-katalog.sintiundroma.de su[312294]: (to root) koha on pts/0 Aug 04 09:07:14 bib-katalog.sintiundroma.de su[312294]: pam_unix(su-l:session):> # systemctl status rabbitmq-server.service ● rabbitmq-server.service - RabbitMQ Messaging Server Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; enabled; vend> Active: activating (start) since Thu 2022-08-04 09:11:43 CEST; 4s ago Main PID: 313407 (beam.smp) Tasks: 90 (limit: 9510) Memory: 54.3M CPU: 2.952s CGroup: /system.slice/rabbitmq-server.service ├─313407 /usr/lib/erlang/erts-11.1.8/bin/beam.smp -W w -K true -A > ├─313509 erl_child_setup 65536 ├─313566 inet_gethost 4 └─313567 inet_gethost 4 Aug 04 09:11:43 bib-katalog.sintiundroma.de systemd[1]: Starting RabbitMQ Messa> Here I am trying to finish the installation. It is the same if I only try to (finish to) install "koha-common" and/or "mariadb-server". In the past this always worked without any problems. # apt-get install koha-common mariadb-server Reading package lists... Done Building dependency tree... Done Reading state information... Done koha-common is already the newest version (22.05.03-1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Do you want to continue? [Y/n] Y Setting up rabbitmq-server (3.8.9-3) ... Job for rabbitmq-server.service failed because the control process exited with error code. See "systemctl status rabbitmq-server.service" and "journalctl -xe" for details. invoke-rc.d: initscript rabbitmq-server, action "start" failed. * rabbitmq-server.service - RabbitMQ Messaging Server Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Thu 2022-08-04 09:16:53 CEST; 20ms ago Process: 314689 ExecStart=/usr/lib/rabbitmq/bin/rabbitmq-server (code=exited, status=1/FAILURE) Main PID: 314689 (code=exited, status=1/FAILURE) CPU: 6.436s Aug 04 09:16:53 bib-katalog.sintiundroma.de systemd[1]: rabbitmq-server.service: Consumed 6.436s CPU time. dpkg: error processing package rabbitmq-server (--configure): installed rabbitmq-server package post-installation script subprocess returned error exit status 1 dpkg: dependency problems prevent configuration of koha-common: koha-common depends on rabbitmq-server; however: Package rabbitmq-server is not configured yet. dpkg: error processing package koha-common (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: rabbitmq-server koha-common needrestart is being skipped since dpkg has failed E: Sub-process /usr/bin/dpkg returned an error code (1) The following command gives the same error: # dpkg --configure rabbitmq-server Setting up rabbitmq-server (3.8.9-3) ... Job for rabbitmq-server.service failed because the control process exited with error code. See "systemctl status rabbitmq-server.service" and "journalctl -xe" for details. invoke-rc.d: initscript rabbitmq-server, action "start" failed. * rabbitmq-server.service - RabbitMQ Messaging Server Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Thu 2022-08-04 09:33:47 CEST; 8ms ago Process: 319999 ExecStart=/usr/lib/rabbitmq/bin/rabbitmq-server (code=exited, status=1/FAILURE) Main PID: 319999 (code=exited, status=1/FAILURE) CPU: 7.157s dpkg: error processing package rabbitmq-server (--configure): installed rabbitmq-server package post-installation script subprocess returned error exit status 1 Errors were encountered while processing: rabbitmq-server In the files "/var/log/daemon.log" and "/var/log/daemon.log" the following can be seen. Apparently the RabbitMQ Messaging server fails during the configuration process and then tries to start several times but unsuccessfully. Thus the configuration stays incomplete and the installation of "koha-common" cannot be finished. Aug 4 09:38:38 bib-katalog systemd[1]: Starting RabbitMQ Messaging Server... Aug 4 09:39:13 bib-katalog systemd[1]: rabbitmq-server.service: Main process exited, code=exited, status=1/FAILURE Aug 4 09:39:13 bib-katalog systemd[1]: rabbitmq-server.service: Failed with result 'exit-code'. Aug 4 09:39:13 bib-katalog systemd[1]: Failed to start RabbitMQ Messaging Server. Aug 4 09:39:13 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 4.505s CPU time. Aug 4 09:39:23 bib-katalog systemd[1]: rabbitmq-server.service: Scheduled restart job, restart counter is at 1359. Aug 4 09:39:23 bib-katalog systemd[1]: Stopped RabbitMQ Messaging Server. Aug 4 09:39:23 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 4.505s CPU time. Aug 4 09:39:23 bib-katalog systemd[1]: Starting RabbitMQ Messaging Server... Aug 4 09:39:58 bib-katalog systemd[1]: rabbitmq-server.service: Main process exited, code=exited, status=1/FAILURE Aug 4 09:39:58 bib-katalog systemd[1]: rabbitmq-server.service: Failed with result 'exit-code'. Aug 4 09:39:58 bib-katalog systemd[1]: Failed to start RabbitMQ Messaging Server. Aug 4 09:39:58 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 3.872s CPU time. Aug 4 09:40:09 bib-katalog systemd[1]: rabbitmq-server.service: Scheduled restart job, restart counter is at 1360. Aug 4 09:40:09 bib-katalog systemd[1]: Stopped RabbitMQ Messaging Server. Aug 4 09:40:09 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 3.872s CPU time. Aug 4 09:40:09 bib-katalog systemd[1]: Starting RabbitMQ Messaging Server... Aug 4 09:40:44 bib-katalog systemd[1]: rabbitmq-server.service: Main process exited, code=exited, status=1/FAILURE Aug 4 09:40:44 bib-katalog systemd[1]: rabbitmq-server.service: Failed with result 'exit-code'. Aug 4 09:40:44 bib-katalog systemd[1]: Failed to start RabbitMQ Messaging Server. Aug 4 09:40:44 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 4.508s CPU time. Aug 4 09:40:55 bib-katalog systemd[1]: rabbitmq-server.service: Scheduled restart job, restart counter is at 1361. Aug 4 09:40:55 bib-katalog systemd[1]: Stopped RabbitMQ Messaging Server. Aug 4 09:40:55 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 4.508s CPU time. Aug 4 09:40:55 bib-katalog systemd[1]: Starting RabbitMQ Messaging Server... Aug 4 09:41:30 bib-katalog systemd[1]: rabbitmq-server.service: Main process exited, code=exited, status=1/FAILURE Aug 4 09:41:30 bib-katalog systemd[1]: rabbitmq-server.service: Failed with result 'exit-code'. Aug 4 09:41:30 bib-katalog systemd[1]: Failed to start RabbitMQ Messaging Server. Aug 4 09:41:30 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 4.051s CPU time. Aug 4 09:41:40 bib-katalog systemd[1]: rabbitmq-server.service: Scheduled restart job, restart counter is at 1362. Aug 4 09:41:40 bib-katalog systemd[1]: Stopped RabbitMQ Messaging Server. Aug 4 09:41:40 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 4.051s CPU time. Aug 4 09:41:40 bib-katalog systemd[1]: Starting RabbitMQ Messaging Server... Aug 4 09:42:16 bib-katalog systemd[1]: rabbitmq-server.service: Main process exited, code=exited, status=1/FAILURE Aug 4 09:42:16 bib-katalog systemd[1]: rabbitmq-server.service: Failed with result 'exit-code'. Aug 4 09:42:16 bib-katalog systemd[1]: Failed to start RabbitMQ Messaging Server. Aug 4 09:42:16 bib-katalog systemd[1]: rabbitmq-server.service: Consumed 4.523s CPU time. Do you maybe have any hint how to find out what could be the problem with the failing configuration of package "rabbitmq-server"? Did anyone out there successfully install either Koha 21.11.10 or Koha 22.05.03 on a new machine with Debian GNU/Linux 11? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch Am 03.08.22 um 19:46 schrieb Michael Hafen: > The "rabbitmq-server" service is not starting for some reason. Since it > doesn't successfully start, the package manager considers it as not > installed correctly; and since koha-common depends on it, the package > manager doesn't do anything with koha-common. > The output from the package manager mentions trying "journalctl -xe" to > see why the "rabbitmq-server" isn't starting. Once you figure out the > problem there and get it fixed, the rest of the package install process > should go smoothly. > > On Wed, Aug 3, 2022 at 8:34 AM Michael Kuhn <mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch>> wrote: > > Hi > > Meanwhile I have also tried to install Koha 22.05.03 (instead of Koha > 21.11.10) on a new machine with Debian 11 but it gave me the same error > concerning package "rabbitmq-server". > > Is it really true that it is not possible to install these two > revisions > on Debian 11? > > Best wishes: Michael > -- > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz > T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> > > > > Am 03.08.22 um 14:50 schrieb Michael Kuhn: > > Hi > > > > I've just run into problems when trying to install Koha 21.11.10 > on a > > newly installed machine with Debian GNU/Linux 11. > > > > 1. This is the content of file "/etc/apt/sources.list.d/koha.list": > > > > deb http://debian.koha-community.org/koha > <http://debian.koha-community.org/koha> 21.11 main > > > > 2. When starting the installation of Koha "apt-get update" gave: > > > > OK:1 http://asi-fs-n.contabo.net/debian > <http://asi-fs-n.contabo.net/debian> bullseye InRelease > > OK:2 http://asi-fs-n.contabo.net/debian > <http://asi-fs-n.contabo.net/debian> bullseye-updates InRelease > > OK:3 http://security.debian.org/debian-security > <http://security.debian.org/debian-security> bullseye-security InRelease > > Holen:4 http://debian.koha-community.org/koha > <http://debian.koha-community.org/koha> 21.11 InRelease [69,8 kB] > > Holen:5 http://debian.koha-community.org/koha > <http://debian.koha-community.org/koha> 21.11/main amd64 Packages > > [25,6 kB] > > Es wurden 95,4 kB in 1 s geholt (93,2 kB/s). > > Paketlisten werden gelesen… Fertig > > > > 2. Unfortunately the installation of Koha ended with the following: > > > > ... > > Fehler traten auf beim Bearbeiten von: > > rabbitmq-server > > koha-common > > needrestart is being skipped since dpkg has failed > > E: Sub-process /usr/bin/dpkg returned an error code (1) > > > > 3. However, now "apt-get update" only gives: > > > > OK:1 http://asi-fs-n.contabo.net/debian > <http://asi-fs-n.contabo.net/debian> bullseye InRelease > > OK:2 http://asi-fs-n.contabo.net/debian > <http://asi-fs-n.contabo.net/debian> bullseye-updates InRelease > > OK:3 http://security.debian.org/debian-security > <http://security.debian.org/debian-security> bullseye-security InRelease > > OK:4 http://debian.koha-community.org/koha > <http://debian.koha-community.org/koha> 21.11 InRelease > > Paketlisten werden gelesen… Fertig > > > > 4. When trying to complete the installation the following errors > appear: > > > > $ sudo apt-get install koha-common > > Reading package lists... Done > > Building dependency tree... Done > > Reading state information... Done > > koha-common is already the newest version (21.11.10-1). > > 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. > > 2 not fully installed or removed. > > After this operation, 0 B of additional disk space will be used. > > Do you want to continue? [Y/n] > > Setting up rabbitmq-server (3.8.9-3) ... > > Job for rabbitmq-server.service failed because the control process > > exited with error code. > > See "systemctl status rabbitmq-server.service" and "journalctl > -xe" for > > details. > > invoke-rc.d: initscript rabbitmq-server, action "start" failed. > > * rabbitmq-server.service - RabbitMQ Messaging Server > > Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; > > enabled; vendor preset: enabled) > > Active: activating (auto-restart) (Result: exit-code) since > Wed > > 2022-08-03 14:30:23 CEST; 11ms ago > > Process: 3343 ExecStart=/usr/lib/rabbitmq/bin/rabbitmq-server > > (code=exited, status=1/FAILURE) > > Main PID: 3343 (code=exited, status=1/FAILURE) > > CPU: 5.506s > > > > Aug 03 14:30:23 bib-katalog.sintiundroma.de > <http://bib-katalog.sintiundroma.de> systemd[1]: > > rabbitmq-server.service: Failed with result 'exit-code'. > > Aug 03 14:30:23 bib-katalog.sintiundroma.de > <http://bib-katalog.sintiundroma.de> systemd[1]: Failed to start > > RabbitMQ Messaging Server. > > Aug 03 14:30:23 bib-katalog.sintiundroma.de > <http://bib-katalog.sintiundroma.de> systemd[1]: > > rabbitmq-server.service: Consumed 5.506s CPU time. > > dpkg: error processing package rabbitmq-server (--configure): > > installed rabbitmq-server package post-installation script > subprocess > > returned error exit status 1 > > dpkg: dependency problems prevent configuration of koha-common: > > koha-common depends on rabbitmq-server; however: > > Package rabbitmq-server is not configured yet. > > > > dpkg: error processing package koha-common (--configure): > > dependency problems - leaving unconfigured > > Errors were encountered while processing: > > rabbitmq-server > > koha-common > > E: Sub-process /usr/bin/dpkg returned an error code (1) > > > > 5. How can I complete this incomplete installation? > > > > Best wishes: Michael > > > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.koha-community.org > <mailto:Koha-devel@lists.koha-community.org> > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > <https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel> > website : https://www.koha-community.org/ > <https://www.koha-community.org/> > git : https://git.koha-community.org/ <https://git.koha-community.org/> > bugs : https://bugs.koha-community.org/ > <https://bugs.koha-community.org/> > > > > -- > Michael Hafen > Washington County School District Technology Department > Systems Analyst >

1 0

Dependency problem when installing Koha 21.11.10 on Debian 11
by Michael Kuhn 04 Aug '22

04 Aug '22

Hi I've just run into problems when trying to install Koha 21.11.10 on a newly installed machine with Debian GNU/Linux 11. 1. This is the content of file "/etc/apt/sources.list.d/koha.list": deb http://debian.koha-community.org/koha 21.11 main 2. When starting the installation of Koha "apt-get update" gave: OK:1 http://asi-fs-n.contabo.net/debian bullseye InRelease OK:2 http://asi-fs-n.contabo.net/debian bullseye-updates InRelease OK:3 http://security.debian.org/debian-security bullseye-security InRelease Holen:4 http://debian.koha-community.org/koha 21.11 InRelease [69,8 kB] Holen:5 http://debian.koha-community.org/koha 21.11/main amd64 Packages [25,6 kB] Es wurden 95,4 kB in 1 s geholt (93,2 kB/s). Paketlisten werden gelesen… Fertig 2. Unfortunately the installation of Koha ended with the following: ... Fehler traten auf beim Bearbeiten von: rabbitmq-server koha-common needrestart is being skipped since dpkg has failed E: Sub-process /usr/bin/dpkg returned an error code (1) 3. However, now "apt-get update" only gives: OK:1 http://asi-fs-n.contabo.net/debian bullseye InRelease OK:2 http://asi-fs-n.contabo.net/debian bullseye-updates InRelease OK:3 http://security.debian.org/debian-security bullseye-security InRelease OK:4 http://debian.koha-community.org/koha 21.11 InRelease Paketlisten werden gelesen… Fertig 4. When trying to complete the installation the following errors appear: $ sudo apt-get install koha-common Reading package lists... Done Building dependency tree... Done Reading state information... Done koha-common is already the newest version (21.11.10-1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Do you want to continue? [Y/n] Setting up rabbitmq-server (3.8.9-3) ... Job for rabbitmq-server.service failed because the control process exited with error code. See "systemctl status rabbitmq-server.service" and "journalctl -xe" for details. invoke-rc.d: initscript rabbitmq-server, action "start" failed. * rabbitmq-server.service - RabbitMQ Messaging Server Loaded: loaded (/lib/systemd/system/rabbitmq-server.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Wed 2022-08-03 14:30:23 CEST; 11ms ago Process: 3343 ExecStart=/usr/lib/rabbitmq/bin/rabbitmq-server (code=exited, status=1/FAILURE) Main PID: 3343 (code=exited, status=1/FAILURE) CPU: 5.506s Aug 03 14:30:23 bib-katalog.sintiundroma.de systemd[1]: rabbitmq-server.service: Failed with result 'exit-code'. Aug 03 14:30:23 bib-katalog.sintiundroma.de systemd[1]: Failed to start RabbitMQ Messaging Server. Aug 03 14:30:23 bib-katalog.sintiundroma.de systemd[1]: rabbitmq-server.service: Consumed 5.506s CPU time. dpkg: error processing package rabbitmq-server (--configure): installed rabbitmq-server package post-installation script subprocess returned error exit status 1 dpkg: dependency problems prevent configuration of koha-common: koha-common depends on rabbitmq-server; however: Package rabbitmq-server is not configured yet. dpkg: error processing package koha-common (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: rabbitmq-server koha-common E: Sub-process /usr/bin/dpkg returned an error code (1) 5. How can I complete this incomplete installation? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

ILL backends - Libris YAML error
by Fairlamb, Christina 03 Aug '22

03 Aug '22

Hello all, I'm having an issue with the Libris ILL install and wondered if anyone could help. I get a 500 error going to the ILL requests -> new request (Libris). This is the error I see in plack-error.log after the first attempt after an update or reboot: Can't locate YAML/Syck.pm in @INC (you may need to install the YAML::Syck module) (@INC contains: /usr/share/koha/lib /usr/share/koha/installer /usr/share/koha/lib/installer /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl) at /usr/share/koha/lib/Koha/Illbackends/Libris/Base.pm line 23. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Illbackends/Libris/Base.pm line 23. Compilation failed in require at /usr/share/koha/lib/Koha/Illrequest.pm line 320. And these two lines appear in every further attempt to get on the page: Attempt to reload Koha/Illbackends/Libris/Base.pm aborted. Compilation failed in require at /usr/share/koha/lib/Koha/Illrequest.pm line 320. I added Freeform first, and that works fine. I followed the basic instructions on the Koha ILL backends page and the additional instructions for Libris on the github page for configuration. Kind Regards Christina

2 1