[Koha] Fwd: Dead Koha Resuscitation

[David Liddle]

Hello again, Bruce, I had some more thoughts today about your
situation. What are the results of the following commands? Clearly
your installation is incomplete.

dpkg -l koha-common
dpkg -s koha-common

They are similar, in that the first is a summary and the second is
more detailed. For example, one of my systems shows the following with
the first:

~# dpkg -l koha-common
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name           Version      Architecture Description
+++-==============-============-============-===============================================
hi  koha-common    22.05.12-1   all          integrated (physical)
library management system

And the same system shows this with apt:

~# apt policy koha-common
koha-common:
  Installed: 22.05.12-1
  Candidate: 22.05.12-1
  Version table:
 *** 22.05.12-1 500
        500 http://debian.koha-community.org/koha 22.05/main amd64 Packages
        100 /var/lib/dpkg/status

In case you need the commands for grabbing your database:

~# mysql -uroot -p
> show databases;
(take note of KOHA_DB in the table)
> quit
~# mysqldump --databases KOHA_DB > koha_db_dump.sql

If your other configuration files – most of which are in /etc/koha/
and /var/lib/koha/ – are missing, you may be able to copy them from
within the full-drive backup. Some formats are easier to mount and
browse than others. What do you use?

On Mon, May 15, 2023 at 10:35 PM David Liddle <david at liddles.net> wrote:
>
> Bruce, it’s an intriguing problem, since you’ve come from a working system. However, I shouldn’t think about it while I ought to be sleeping. Perhaps others will chime in as the sun works its way across the US. But I do have some more questions:
>
> - What other services are running on that server? Are they all still working correctly?
> - What clues are there in the logs in /var/log/?
> - Is the apt installer working generally, or do you perhaps have a broken Debian installation? Can you update or install other packages successfully?
> - Can you access the database server to do a manual dump of the Koha database?
>
>
> On Mon, May 15, 2023 at 8:51 PM Bruce A. Metcalf <library at augustansociety.org> wrote:
>>
>> On 5/15/23 12:12, David Liddle wrote:
>>
>> > I see now that I overlooked your statement that commands such as
>> > 'koha-dump' are not recognized. Do they appear in the directory
>> > /usr/sbin/?
>>
>>
>> No. Not a single koha- command present in that directory.
>>
>>
>> > Do you have automated Koha backups configured that are available in
>> > /var/spool/koha/{instance}?
>>
>>
>> No, though that would have been smart of me. I don't even have a
>> directory /var/spool/koha, much less /var/spool/koha/instance.
>>
>> Appreciate the effort.
>>
>> Respectfully,
>> / Bruce /
>> Bruce A. Metcalf, Librarian
>> The Augustan Library