Hello Koha my old friend, I've come to upgrade you again. After midnight while the users sleep. Into the server room I'll slowly creep. And the letters of the password Are written on a post-it note It's "billygoat". It's time to do the upgrade. Hello everybody, and especially Mason James who provided a lot of help including some tips I found in the list archives. It took a little longer than I thought it would, mostly because I made frequent backups and made sure everything worked on a scratchmonkey before I tried it on our production. If anyone is interested in how I did it, the steps are below. Please note the significance of "how I did it" in the preceding sentence. There's probably a far, far more sensible way. Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king@medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org I don't know much about being a millionaire, but I'll bet I'd be darling at it. --Dorothy Parker Ubuntu 18.04.5, Koha 20.11.04.000 #echo 'deb http://debian.koha-community.org/koha 21.05 main bionic' | sudo tee /etc/apt/sources.list.d/koha.list #apt-get update #apt-get upgrade 48 upgraded, 0 newly installed, 0 to remove and 5 not upgraded. #apt-get update The following packages have been kept back: koha-common libmojolicious-plugin-openapi-perl libjson-validator-perl libmojolicious-perl ubuntu-advantage- tools #apt-get install libmojolicious-perl (installs) #apt-get install libjson-validator-perl (installs) !at this point, koha-common could be upgraded #apt-get install ubuntu-advantage-tools (installs) #apt-get install libmojolicious-plugin-openapi-perl (installs) # apt-get upgrade The following packages will be upgraded: koha-common # y (Koha version: 21.05.07.000) # do-release-upgrade (chose default options, or “y”) (rebooted) (can't connect to server) # apt autoremove (lots of files removed) # pico /etc/apt/sources.list.d/koha.list (changed bionic to focal) # init 6 # apt-get install koha-common (koha-common installs) (connect to server, go to About Koha page) (Zebra server seems not to be available. Is it started?) # init 6 (Zebra is running) [during one upgrade I got this message:] (There is an error when trying to connect to the message broker (RabbitMQ)) (didn’t happen this time, but here's how I fixed it before) # pico /etc/koha/koha-conf-site.xml.in (change <message_broker> to <message_broker> <hostname>localhost</hostname> <port>61613</port> <username>guest</username> <password>guest</password> <vhost></vhost> </message_broker> # init 6 (Ended with Koha 21.05.07.000, Ubuntu 20.04) -----Original Message----- From: Mason James <mtj@kohaaloha.com> Sent: Thursday, December 09, 2021 10:33 PM To: King, Fred <Fred.King@Medstar.net>; koha <koha@lists.katipo.co.nz> Subject: Re: [EXTERNAL] Re: [Koha] Problem upgrading to 21.05: perlapi-5-24.1 is not available **ATTENTION: This email originated from outside the MedStar Health network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. hi Fred if you are running an "older" version of debian/ubuntu, follow the info on section 2.1.2.3 here... https://urldefense.com/v3/__https://wiki.koha-community.org/wiki/Koha_on_Deb... 2.1.2.3 Support for Koha on older versions of Debian/Ubuntu (Debian 8, Ubuntu 18.04, Ubuntu 16.04) example... $ echo 'deb https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!!D7IIWT... 21.05 main xenial' | sudo tee /etc/apt/sources.list.d/koha.list On 10/12/21 8:46 am, King, Fred wrote:
Hi Mason,
Thanks for the reply! Some of the settings in my Koha setup are considerably different from yours. I should have added that I'm running my instance on a Digital Ocean 64-bit cloud server, and I'm on Ubuntu 18.04, not 20.04 as I thought. Do you think it might be easier for me to set up a fresh instance and export everything from the old system with sqldump? It might be faster, but it would still leave a puzzle...
The upgradable but held back files are these--all of them depend on the mysterious and elusive perlapi-5.24.1:
koha-common/oldstable 21.05.07-1 all [upgradable from: 20.11.04-1] libcryptx-perl/oldstable 0.063-1~bpo9+1 amd64 [upgradable from: 0.059-1~koha2] libmojolicious-plugin-openapi-perl/oldstable 4.98+really2.16-koha1 all [upgradable from: 1.15-1~kohadev1]
Here's what I got, with the //*differences from your settings shown like this*//.
--Fred
# arch x86.64
#lsb_release -a LSB Version: core-9.20170808ubuntu1-noarch:security-9.20170808ubuntu1-noarch //*No LSB modules are available.*// Distributor ID: Ubuntu Description: Ubuntu 18.04.6 LTS //*Ubuntu 20.04.3 LTS*// Release: 18.04 //*20.04*// Codename: bionic
# cat /etc/apt/sources.list.d/koha.list deb http(colon)//debian(dot}koha-community(dot)org/koha 21.05 main
# sudo apt-get update [checking repositories] Fetched 4593 kB in 1s Reading package lists... Done
# apt-cache policy koha-common Installed: 20.11.04.1 //*21.05.07-1*// Candidate: 21.05.07.1 Version table: 21.05.07-1 500 http(colon)//debian(dot)koha-community(dot)org/koha 21.05/main amd64 Packages *** 20.11.04-1 100 //*not in your version*// 100 /var/lib/dpkg/status
# apt-cache policy libyaml-libyaml-perl libyaml-libyaml-perl: Installed: (none) //*0.81+repack-1*// Candidate: 0.76+repack-1~bpo9+1 //*0.81+repack-1*// Version table: 0.76+repack-1~bpo9+1 500 //**** 0.81+repack-1 500*// 500 http(colon)//debian(dot)koha-community(dot)org/koha 21.05/main amd64 Packages 0.69+repack-1 500 //*not in your version*// 500 http(colon)//mirrors(dot)digitalocean(dot)com/ubuntu bionic/main amd64 Packages
Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king@medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: https://urldefense.com/v3/__http://medstarauthors.org__;!!D7IIWT94AA!t 4Un0QseRgkGMFQ7i36ThoCqUEtW84JkXDN7V2xsZIZI3l0vHSK8kr007vUN8Y2SJw$
I don't know much about being a millionaire, but I'll bet I'd be darling at it. --Dorothy Parker
-----Original Message----- From: Mason James <mtj@kohaaloha.com> Sent: Wednesday, December 08, 2021 8:49 PM To: King, Fred <Fred.King@Medstar.net>; koha <koha@lists.katipo.co.nz> Subject: [EXTERNAL] Re: [Koha] Problem upgrading to 21.05: perlapi-5-24.1 is not available
**ATTENTION: This email originated from outside the MedStar Health network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.
hi Fred if you are attempting to upgrade to 21.05/olstable - your 'Candidate' values should match those below...
------------------------ $ arch x86_64
$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 20.04.3 LTS Release: 20.04 Codename: focal
$ cat /etc/apt/sources.list.d/koha.list deb https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!! D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNd yIu3aCg$ 21.05 main
$ sudo apt-get update
$ apt-cache policy koha-common koha-common: Installed: 21.05.07-1 Candidate: 21.05.07-1 <<<<<<<<<< Version table: *** 21.05.07-1 500 500 https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!!D7IIWT... 21.05/main amd64 Packages 100 /var/lib/dpkg/status
$ apt-cache policy libyaml-libyaml-perl libyaml-libyaml-perl: Installed: 0.81+repack-1 Candidate: 0.81+repack-1 <<<<<<<<<< Version table: *** 0.81+repack-1 500 500 https://urldefense.com/v3/__http://archive.ubuntu.com/ubuntu__;!!D7IIWT94AA!... focal/main amd64 Packages 100 /var/lib/dpkg/status 0.76+repack-1~bpo9+1 500 500 https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!! D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNd yIu3aCg$ 21.05/main amd64 Packages
On 9/12/21 5:06 am, King, Fred wrote:
Esteemed Colleagues,
I'm trying to upgrade my Koha instance from 20.11.01.000 to 21.05, or 21.11 if I can't do oldstable. I'm running it on Ubuntu 20.04LTS.
Short description: the upgrade appears to need perlapi-5-24.1, but it's not available.
Long description, my input is in (parentheses); system response is indented in courier: (while upgrading) E: Repository 'https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!!D7IIWT... stable InRelease' changed its 'Codename' value from '20.11' to '21.11' N: This must be accepted explicitly before updates for this repository can be applied. See apt-secure(8) manpage for details. (so I typed: echo 'deb https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!! D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUN d yIu3aCg$ 21.05 main' | sudo tee /etc/apt/sources.list.d/koha.list) (I also tried the above with 21.11) (apt-get install koha-common) koha-common: Depends: libyaml-libyaml-perl but it is not going to be installed E: Unable to correct problems, you have held broken packages. (apt-get install libyaml-libyaml-perl) The following packages have unmet dependencies: libyaml-libyaml-perl : Depends: perlapi-5.24.1 but it is not installable E: Unable to correct problems, you have held broken packages. (apt-get install perlapi-5.24.1) Package perlapi-5-24.1 is not available, but it is referenced to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'perlapi-5.24.1 has no installation candidate (locate perlapi) /usr/share/perl/5.26.1/pod/perlapi.pod (and a few others)
I've searched the Wiki, Google, and elsewhere, but I haven't found an answer. However, I've been working mostly in my basement and have a bad case of Basement Brain. Could someone point me towards a solution?
Thanks,
Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king@medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: https://urldefense.com/v3/__http://medstarauthors.org__;!!D7IIWT94AA! r Ycoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNeqsizdDQ$
I don't know much about being a millionaire, but I'll bet I'd be darling at it. --Dorothy Parker
--------------------------------------------------------------------- - MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopedics, cancer and GI.
IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you.
Help conserve valuable resources - only print this email if necessary.
_______________________________________________
Koha mailing list https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA! r Ycoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNc_Et1D0w$ Koha@lists.katipo.co.nz Unsubscribe: https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listin f o/koha__;!!D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtv V uWM-rFpdUNdGdLLElw$