[Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

On 5/16/23 15:10, David Liddle wrote:

> Bruce, here are some more suggestions:
> 
> 1. When it comes to the logs, perhaps a command such as these (and
> similar) will reveal when and how something went wrong:
>       grep -inr --include \*.log 'koha-common' /var/log/


Results: Binary file /var/log/daemon.log matches


>       zgrep -in 'koha-common' /var/log/dpkg.log*


This results in many lines like:

/var/log/dpkg.log.10.gz:161:2022-04-29 13:51:36 status unpacked 
koha-common:all 21.05.14-1

And a few like:

/var/log/dpkg.log.10.gz:161:2022-04-29 13:51:36 status unpacked 
koha-common:all 21.05.14-1

/var/log/dpkg.log.1:20:2023-04-12 23:07:03 status half-configured 
koha-common:all 21.11.17-1

/var/log/dpkg.log.1:22:2023-04-12 23:07:04 status half-installed 
koha-common:all 21.11.17-1

Needless to say, I have no idea what these messages mean or how to fix them.


> 2. You should double-check that your installation source file is
> correct, as covered by
> https://wiki.koha-community.org/wiki/Koha_on_Debian#Set_up_package_sources.
> For example, mine shows after the following command:
>       ~# cat /etc/apt/sources.list.d/koha.list
>       deb [signed-by=/usr/share/keyrings/koha-keyring.gpg] > https://debian.koha-community.org/koha 22.05 main


Mine is: deb http://debian.koha-community.org/koha oldoldstable main


> 3. If APT seems to be working, then you could install 'debsums' (apt
> install debsums) and see what it reveals with this command:
>       debsums --all --silent


# /etc/koha# debsums --all --silent
debsums: changed file /etc/koha/zebradb/etc/default.idx (from 
koha-common package)
debsums: changed file /etc/cron.d/koha-common (from koha-common package)
debsums: changed file /etc/koha/zebradb/lang_defs/en/sort-string-utf.chr 
(from koha-common package)
debsums: changed file /etc/default/koha-common (from koha-common package)
debsums: changed file /etc/koha/zebradb/etc/word-phrase-utf.chr (from 
koha-common package)
debsums: changed file /etc/koha/koha-sites.conf (from koha-common package)
debsums: changed file /etc/cron.daily/mlocate (from mlocate package)

plus some unrelated lines of that ilk.


>       dpkg --verify koha-common


root at store:/etc/koha# dpkg --verify koha-common
??5?????? c /etc/cron.d/koha-common
??5?????? c /etc/default/koha-common
??5?????? c /etc/koha/apache-shared-opac.conf
??5?????? c /etc/koha/koha-sites.conf
??5?????? c /etc/koha/zebradb/etc/default.idx
??5?????? c /etc/koha/zebradb/etc/word-phrase-utf.chr
??5?????? c /etc/koha/zebradb/lang_defs/en/sort-string-utf.chr


>       dpkg --audit koha-common


This generates no response.


> Those are going to look for errors in packages and list the
> configuration files that have been altered from their default. It
> listed nicely the files that I already knew I changed for both Koha
> and Apache.
> 4. You may want to try the following commands, too:
>       apt --fix-broken install
>       apt --fix-missing install


Both result in no actions.


> 5. If the Koha installation is incomplete, despite what the system
> seems to report, then you may want to use 'dpkg' to remove
> 'koha-common' and then reinstall with 'apt' according to the
> instructions.
>       dpkg --remove koha-common


root at store:/etc/koha# dpkg --remove koha-common
dpkg: warning: 'ldconfig' not found in PATH or not executable
dpkg: warning: 'start-stop-daemon' not found in PATH or not executable
dpkg: error: 2 expected programs not found in PATH or not executable
Note: root's PATH should usually contain /usr/local/sbin, /usr/sbin and 
/sbin


Aha! my $PATH contains no mention of any sbin directory. Let me see if I 
can add it.

Hmm. My ~/.bashrc file is effectively empty, with all lines commented 
out. It also looks "wrong".


> 6. When it comes to listing the databases, here's what you might expect to see:
> 
> ~# mysql -uroot -p
> Enter password:
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 348
> Server version: 10.5.19-MariaDB-0+deb11u2 Debian 11
> 
> Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
> 
> MariaDB [(none)]> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | koha_library       |
> | mysql              |
> | performance_schema |
> +--------------------+
> 4 rows in set (0.000 sec)
> 
> MariaDB [(none)]> quit
> Bye


This generates:

+--------------------+
| Database           |
+--------------------+
| aug_wiki           |
| augustan           |
| information_schema |
| koha_library       |
| mysql              |
| performance_schema |
+--------------------+

The instance name is "library", so that's the 4th entry. "aug_wiki" is 
from our wiki installation, not sure what "augustan" is.


So, we have some new data, but nothing that shows me what needs to be 
done. I hope someone here can tell me what it is.

Regards,
/ Bruce /
Bruce A. Metcalf, Librarian
The Augustan Library