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
_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to