Hi Bruce We've found the problem. On 19 May 2023 7:46:58 am NZST, "Bruce A. Metcalf" <library@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@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha