[Koha] Fwd: Dead Koha Resuscitation

[Chris Cormack]

Hi Bruce

We've found the problem. 

On 19 May 2023 7:46:58 am NZST, "Bruce A. Metcalf" <library at augustansociety.org> wrote:
>On 5/18/23 14:52, David Liddle wrote:
>
>> Hello, Bruce. You've been good about chasing down the information folks have asked for. I'm sorry that we haven't brought you closer
>> to a solution.
>
>
>I'm no less appreciative of your efforts for that.
>
>
>> I have some follow-up questions:
>> 
>> 1.a. Database. Once you listed the databases, did you exit the mysql prompt and back up the koha_library database with the mysqldump command?
>
>
>Yes, and it appeared to work. I have a 450MB file called backup.sql.
>
>
>> 1.b.Can you use an FTP client such as FileZilla to download such files?
>
>
>I assume so.
>
>
>> 2.a. Path. What is the result of this command? env | grep -i 'path'
>
>
>root at store:/# env | grep -i 'path'
>PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
>
>I am aware that the path should contain several sbin directories, but I
>don't know how to add them.
>
>
>> 2.b. Path. Did you already establish that the Koha commands are or are not installed? ls /usr/sbin/koha*
>
>
>Yes, the usual list of commands is there. This suggests to me that the
>inadequate PATH command is at least part of my problem.
>
>
>> 3. Repository and deb. Did you run "apt update" before running "apt-get install --reinstall koha-common"?
>
>
>Yes. The resultant is:
>
>root at store:/# apt-get update && apt-get install --reinstall koha-common
>[some lines skipped]
>Some packages could not be installed. This may mean that you have
>requested an impossible situation or if you are using the unstable
>distribution that some required packages have not yet been created
>or been moved out of Incoming.
>The following information may help to resolve the situation:
>
>The following packages have unmet dependencies:
> koha-common : Depends: libtest-dbix-class-perl but it is not going to
>be installed
>E: Unable to correct problems, you have held broken packages.
>

This is the issue right here, koha-common can't be installed cleanly because a package it depends on is missing. 

What does
 sudo apt install libtest-dbix-class-perl


Result in? 

Chris 


>
>> The current version is 21.11.20.
>
>
>Right, but I haven't been able to employ any earlier version, either.
>
>
>> Yes, koha-common appears to be running, though maybe I'm reading it wrong. Have you checked the Apache config file for your instance, probably /etc/apache2/sites-available/library.conf
>
>
>There are two links in that file, one for the OPAC and one for admin access.
>
>
>> SSL Certificate information will be important.
>
>
>There is no mention of SSL Certificates in the file.
>
>
>> There are also Apache-related config files in /etc/koha, which I think could have been overwritten in the upgrade; that may or may
>> not be important.
>
>
>There are such files. I don't know what to make of them.
>
>
>> 5. This situation is a good opportunity to research and document the
>> elements on the server that you need to back up manually and download
>> in the event that you need to rebuild the server from scratch. I'm
>> guessing you don't do this work full-time, but having this
>> information written will save you and/or your successor a lot of time
>> when that day comes.
>
>
>Yeah, I should be so lucky as to have someone take over for me! <G> The organization is a non-profit with declining participation.
>
>
>> Is this hosted server just running: 1. the main website (what
>> platform or site-building tool?), 2. a wiki (MediaWiki?), and 3.
>> Koha? That backup will probably come down to the databases you've
>> listed and one or more directories for each service.
>
>
>The virtual server is running an Online Store, a Wiki, and Koha. Minor file storage is all else that's there.
>
>
>What I suspect at this point is that I need to add the sbin directories to the PATH. Can someone point me to a tutorial?
>
>Regards,
>/ Bruce /
>Bruce A. Metcalf, Librarian
>The Augustan Library
>_______________________________________________
>
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha