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@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@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