Re: [Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

On 5/18/23 21:35, Hector Gonzalez Jaime wrote:


What does sudo koha-plack --start instancename Do?


root@store:/usr/sbin# koha-plack --start library bash: koha-plack:
command not found

Which seems even more weird. Are the permissions wrong?


You are still missing /usr/sbin in your PATH variable.



That's been added.



The command would have run if you had typed:

/usr/sbin/koha-plack --start library



Let me try:

root@store:/usr/sbin# /usr/sbin/koha-plack --start library
/usr/share/koha/bin/koha-functions.sh: line 285: start-stop-daemon: 
command not found

[ ok ] Starting Plack daemon for library:.

Okay, a step forward, but a new challenge. (Been a lot of that in this 
project!)


Line 285 is:

if start-stop-daemon --pidfile "/var/run/koha/${instancename}/plack.pid" \

File /var/run/koha/library/plack.pid does exist. It contains a 
five-digit number only.


Okay, I'm stuck again!

Thanks again for all the help.

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


your system seems to be in a strange situation, you might want to 
uninstall koha, remove all dependencies, and install it again:


apt-get remove koha-common <- this does not affect your database
or configuration files. apt-get autoremove <- this
deletes every dependency that is no longer needed, which should be a
ton of perl libraries. apt-get install koha-common  <- this
should reinstall koha, and every one of its dependencies.  If your
system has problems, this command would eventually fail.

If this last command fails, I'd like to see the contents of your 
/etc/apt/sources.list file and every file at /etc/apt/sources.list.d




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



___

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Hector Gonzalez Jaime]

On 5/18/23 19:18, Bruce A. Metcalf wrote:

On 5/18/23 17:35, Chris Cormack wrote:


What does
sudo koha-plack --start instancename
Do?



root@store:/home/bruce# koha-plack --start library
bash: koha-plack: command not found

Which I thought was pretty odd, so I went to the /usr/sbin directory, 
and:


root@store:/usr/sbin# ls -l koha-p*
-rwxr-xr-x 1 root root 13538 May 13 23:26 koha-plack

then

root@store:/usr/sbin# koha-plack --start library
bash: koha-plack: command not found

Which seems even more weird. Are the permissions wrong?
You are still missing /usr/sbin in your PATH variable.  You seem to be 
running bash:


export PATH=/sbin:/usr/sbin:$PATH

(bash can do this in one line).  Copy the command exactly, CAPS are 
important here.  Linux does not have the current directory in your PATH, 
which means it will not run a command from the directory you are at 
(this may feel strange if you come from a windows environment, but is 
normal)  The command would have run if you had typed:


/usr/sbin/koha-plack --start library

your system seems to be in a strange situation, you might want to 
uninstall koha, remove all dependencies, and install it again:


apt-get remove koha-common <- this does not affect your database or 
configuration files.
apt-get autoremove <- this deletes every dependency that is 
no longer needed, which should be a ton of perl libraries.
apt-get install koha-common  <- this should reinstall koha, and 
every one of its dependencies.  If your system has problems, this 
command would eventually fail.


If this last command fails, I'd like to see the contents of your 
/etc/apt/sources.list file and every file at /etc/apt/sources.list.d




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


--
Hector Gonzalez
ca...@genac.org

___

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

On 5/18/23 17:35, Chris Cormack wrote:


What does
sudo koha-plack --start instancename
Do?



root@store:/home/bruce# koha-plack --start library
bash: koha-plack: command not found

Which I thought was pretty odd, so I went to the /usr/sbin directory, and:

root@store:/usr/sbin# ls -l koha-p*
-rwxr-xr-x 1 root root 13538 May 13 23:26 koha-plack

then

root@store:/usr/sbin# koha-plack --start library
bash: koha-plack: command not found

Which seems even more weird. Are the permissions wrong?

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Chris Cormack]

What does

sudo koha-plack --start instancename

Do?

Chris 

On 19 May 2023 9:11:04 am NZST, "Bruce A. Metcalf" 
 wrote:
>On 5/18/23 16:51, Chris Cormack wrote:
>
>> Ok, so I think now you can try seeing if you have the koha commands back
>> 
>> does sudo koha-list  work and list your instance?
>
>
>Yes and yes.
>
>
>> If so, you might want to run a koha-dump...
>
>
>Done. Seems to have worked.
>
>
>> ...  then try restarting all the Koha services
>
>
>Okay, not sure how to do this, so I just rebooted the server. The other 
>services came back up, but not Koha.
>
>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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

On 5/18/23 16:51, Chris Cormack wrote:


Ok, so I think now you can try seeing if you have the koha commands back

does sudo koha-list  work and list your instance?



Yes and yes.



If so, you might want to run a koha-dump...



Done. Seems to have worked.



...  then try restarting all the Koha services



Okay, not sure how to do this, so I just rebooted the server. The other 
services came back up, but not Koha.


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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Chris Cormack]

Hi Bruce

Oh yes! That's right, way back in 2013 eh?

Ok, so I think now you can try seeing if you have the koha commands back

does sudo koha-list  work and list your instance?

If so, you might want to run a koha-dump  then try restarting all the 
Koha services


Chris

Chris
On 19/05/23 08:48, Bruce A. Metcalf wrote:

On 5/18/23 15:53, Chris Cormack wrote:

Hi Bruce


I Chris. I remember meeting you in Reno!


We've found the problem.


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?


root@store:/etc/koha# apt install libtest-dbix-class-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
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:
  libtest-dbix-class-perl : Depends: libdata-uuid-perl (>= 1.215)
E: Unable to correct problems, you have held broken packages


So, I did:
root@store:/etc/koha# apt install libdata-uuid-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer 
required:

   libossp-uuid16
Use 'sudo apt autoremove' to remove it.
The following packages will be REMOVED:
   libossp-uuid-perl libsoap-lite-perl libxmlrpc-lite-perl
The following NEW packages will be installed:
   libdata-uuid-perl
0 upgraded, 1 newly installed, 3 to remove and 1 not upgraded.
Need to get 24.8 kB of archives.
After this operation, 833 kB disk space will be freed. etc.


Now when I do:
root@store:/etc/koha# apt install libtest-dbix-class-perl
It all seems to run correctly.


And when I enter:
root@store:/etc/koha# apt install koha-common
That too seems to run correctly.


But still no love for the OPAC or admin interface.

Feels like good progress though. What next?

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


--
Kaihuawaere Matihiko (he/him)
Kāi Tahu, Kāti Māmoe, Waitaha
Catalyst.Net Limited - Expert Open Source Solutions
027 4500789
chr...@catalyst.net.nz
___

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

On 5/18/23 15:53, Chris Cormack wrote:

Hi Bruce


I Chris. I remember meeting you in Reno!


We've found the problem.


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?


root@store:/etc/koha# apt install libtest-dbix-class-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
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:
 libtest-dbix-class-perl : Depends: libdata-uuid-perl (>= 1.215)
E: Unable to correct problems, you have held broken packages


So, I did:
root@store:/etc/koha# apt install libdata-uuid-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
  libossp-uuid16
Use 'sudo apt autoremove' to remove it.
The following packages will be REMOVED:
  libossp-uuid-perl libsoap-lite-perl libxmlrpc-lite-perl
The following NEW packages will be installed:
  libdata-uuid-perl
0 upgraded, 1 newly installed, 3 to remove and 1 not upgraded.
Need to get 24.8 kB of archives.
After this operation, 833 kB disk space will be freed. etc.


Now when I do:
root@store:/etc/koha# apt install libtest-dbix-class-perl
It all seems to run correctly.


And when I enter:
root@store:/etc/koha# apt install koha-common
That too seems to run correctly.


But still no love for the OPAC or admin interface.

Feels like good progress though. What next?

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

On 5/18/23 15:52, Hector Gonzalez Jaime wrote:

On 5/18/23 13:46, Bruce A. Metcalf wrote:

On 5/18/23 14:52, David Liddle wrote:


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.


with these commands:

PATH=/sbin:/usr/sbin:$PATH
export PATH



Okay, that seems to have worked. Still no love from apt-get install 
--reinstall koha-common though.



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 unchanged after the PATH correction.


You should try:  apt-get dist-upgrade which would install the 
missing dependencies.



This seems hopeful:

root@store:/etc/koha# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following NEW packages will be installed:
  libmoosex-types-perl libsub-exporter-formethods-perl
The following packages have been kept back:
  koha-common
The following packages will be upgraded:
  koha python-ipaddress
2 upgraded, 2 newly installed, 0 to remove and 1 not upgraded. ... etc.

I am concerned by the koha-common being kept back though.



  Also apt-get -f install should fix that too.



No change from that.

... and still no OPAC or admin access.


Curiously:

root@store:/etc/koha# apt upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
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:
 libossp-uuid-perl : Conflicts: libdata-uuid-perl
E: Broken packages

Suggestions?


Thanks all for the continuing effort.

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Chris Cormack]

Hi Bruce

We've found the problem. 

On 19 May 2023 7:46:58 am NZST, "Bruce A. Metcalf" 
 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!  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
___

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Hector Gonzalez Jaime]

On 5/18/23 13:46, Bruce A. Metcalf 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.


with these commands:

PATH=/sbin:/usr/sbin:$PATH
export PATH

Assuming you are using some variant of /bin/sh

You might edit your .bashrc and add that at the end of the file, and 
login again, or use "source ~/.bashrc " to process the file in your session.





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.




You should try:  apt-get dist-upgrade which would install the 
missing dependencies.  Also apt-get -f install should fix that too.




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


--
Hector Gonzalez
ca...@genac.org

___

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

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.



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

Re: [Koha] Fwd: Dead Koha Resuscitation

[David Liddle]

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 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?
1.b.Can you use an FTP client such as FileZilla to download such files?
2.a. Path. What is the result of this command?
  env | grep -i 'path'
2.b. Path. Did you already establish that the Koha commands are or are
not installed?
  ls /usr/sbin/koha*
3. Repository and deb. Did you run "apt update" before running
"apt-get install --reinstall koha-common"? The current version is
21.11.20. See https://koha-community.org/koha-21-11-20-released/
4. Status and Apache. 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?
SSL Certificate information will be important. 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.
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. 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.

On Thu, May 18, 2023 at 4:21 PM Bruce A. Metcalf
 wrote:
>
> On 5/16/23 15:31, Hector Gonzalez Jaime wrote:
>
> >> Can I buy a clue about how to run mysqldump?
> >
> > you can make a backup wich mysqldump like this:
> >
> > mysqldump -u root -p --all-databases > backup.sql
> >
> > you can reinstall koha-common by issuing this command:
> >
> > sudo apt-get install --reinstall koha-common
>
>
> Aha! Here's a failure:
>
> root@store:/home/bruce# apt-get install --reinstall koha-common
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> 0 upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 0 not
> upgraded.
> Need to get 42.7 MB of archives.
> After this operation, 0 B of additional disk space will be used.
> Err:1 http://debian.koha-community.org/koha oldoldstable/main i386
> koha-common all 21.11.19-1
>404  Not Found [IP: 67.220.127.145 80]
> E: Failed to fetch
> http://debian.koha-community.org/koha/pool/main/k/koha/koha-common_21.11.19-1_all.deb
>   404  Not Found [IP: 67.220.127.145 80]
> E: Unable to fetch some archives, maybe run apt-get update or try with
> --fix-missing?
>
>
> This makes it look like the oldoldstable repository is broken?
>
>
> > Have you tried to backup your koha instance with "koha_dump" ?
>
>
> This command is missing.
>
> Thanks again for the ideas. Any clue about the failure above could be
> crucial.
>
> 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
___

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Bruce A. Metcalf]

On 5/16/23 15:31, Hector Gonzalez Jaime wrote:


Can I buy a clue about how to run mysqldump?


you can make a backup wich mysqldump like this:

mysqldump -u root -p --all-databases > backup.sql

you can reinstall koha-common by issuing this command:

sudo apt-get install --reinstall koha-common



Aha! Here's a failure:

root@store:/home/bruce# apt-get install --reinstall koha-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 0 not 
upgraded.

Need to get 42.7 MB of archives.
After this operation, 0 B of additional disk space will be used.
Err:1 http://debian.koha-community.org/koha oldoldstable/main i386 
koha-common all 21.11.19-1

  404  Not Found [IP: 67.220.127.145 80]
E: Failed to fetch 
http://debian.koha-community.org/koha/pool/main/k/koha/koha-common_21.11.19-1_all.deb 
 404  Not Found [IP: 67.220.127.145 80]
E: Unable to fetch some archives, maybe run apt-get update or try with 
--fix-missing?



This makes it look like the oldoldstable repository is broken?



Have you tried to backup your koha instance with "koha_dump" ?



This command is missing.

Thanks again for the ideas. Any clue about the failure above could be 
crucial.


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

[Koha] Allowing cross-origin scripting. Anyone doing that?

[Raymund Delahunty]

We have been asked to allow interactive activities, where students can interact 
with the OPAC with the application Libwizard (from Springshare) embedded. I 
understand Libwizard can offer a number of experiences including a quiz-type 
one or a guided learning one. Our Koha server has been configured to decline 
CORS (cross-origin scripting requests) by default, and our support company is 
wary of switching it on, and our university cyber security folk are... less 
than enthusiastic as this stage too. Has anyone enabled CORS in such as way as 
we are being asked to? Apparently one (safer?) option would be to set up a 
secondary domain, with the CORS security mechanism (plus a few other things) 
disabled. Before we even our support company about that I thought I'd ask if 
anyone has done what we are being asked to do?

.

This email and any attachments are intended solely for the addressee and may 
contain confidential information. If you are not the intended recipient of this 
email and/or its attachments you must not take any action based upon them and 
you must not copy or show them to anyone. Please send the email back to us and 
immediately and permanently delete it and its attachments. Where this email is 
unrelated to the business of University of the Arts London or of any of its 
group companies the opinions expressed in it are the opinions of the sender and 
do not necessarily constitute those of University of the Arts London (or the 
relevant group company). Where the sender's signature indicates that the email 
is sent on behalf of UAL Short Courses Limited the following also applies: UAL 
Short Courses Limited is a company registered in England and Wales under 
company number 02361261. Registered Office: University of the Arts London, 272 
High Holborn, London WC1V 7EY
___

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

Re: [Koha] Koha offline circulation

[Katrin Fischer]

Hi,

just a typo on my part. pending_offline_operations is correct.

Katrin

On 17.05.23 05:08, Сычев Игорь Алексеевич wrote:

Hello!
Thank you for the answer!
I don't have a pending_offline_transactions table, but there is a 
pending_offline_operations. Did you want to talk about her?

Good Luck!

Igor A. Sychev
Tomsk Polytechnic University
https://lib.tpu.ru

-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Sunday, May 14, 2023 4:38 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha offline circulation

Hi,

I am not aware of a limit, but 13.000 could be a little much.

The transactions are stored in the pending_offline_transactions database table. 
Usually they are cleaned up by processing them. Maybe you want to backup the 
table and try with a few transactions first to see how that goes. Or try it out 
on a demo or test installation.

Hope this helps,

Katrin

___

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

___

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

Re: [Koha] Error while editing item on migrated instance

[DHIM IT]

It was my fault. Please ignore.


Am 18.05.23, 10:49 schrieb "Koha im Auftrag von DHIM IT" 
mailto:koha-boun...@lists.katipo.co.nz> im 
Auftrag von itmana...@dhi-moskau.org >:


Dear colleagues,


I migrated koha db to a new server with fresh installed instance. Everything 
working fine. I have only one error while editing items:




[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st 
execute failed: The user specified as a definer ('root'@'%') does not exist at 
/usr/share/koha/lib/Koha/Object.pm line 170


Does anybody know what can I do to solve it?


KOHA 22.05
Debian 11


Mit besten Grüßen
IT-Manager
Eugen Bastron


___


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




___

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

[Koha] Problem Sharing Lists on Koha

[Ms. Naveen Ali]

Dear All, 

I am using Koha 22.05.06.000 

I was trying to share Koha Lists created on OPAC using the "Share list" Option. 
The following URL is used: 
https://myServer/cgi-bin/koha/opac-shareshelf.pl?op=invite=13 
And email send failure is reported in the "message_queue" table with 
"failure_code" as SENDMAIL 

Then I tried the using the "Send List" Option 
The following URL is used: 
https://eakl.neduet.edu.pk/cgi-bin/koha/opac-sendshelf.pl?shelfid=13 
And email is sent successfully. 

First of all I would like to know what are the requirements of "Share list" 
option so that I do not get the SENDMAIL failure. I want to use this option as 
it allows me to customize the "SHARE_INVITE" and "ACCEPT_INVITE" notice. 
Also I have not been able to find any information about this option in the 
manual 
https://koha-community.org/manual//22.05/en/html/lists.html#viewing-lists . The 
"Share List" option is not shown there. 

Secondly, if the option is no longer available, how can I customize the message 
being sent in the email using the "Send List" Option. 

Thank you very much for your time. 

With best regards, 

Naveen Ali 

ITM-JE (EAKL) 
Inst Representative for 
HEC Digital Library Resources. 
NEDUET, Karachi. 


___

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

Re: [Koha] Error while editing item on migrated instance

[Mohamad F Barham]

in your koha conf file

check your database connection settings , and make sure the user have access to 
koha database


hence: create new db user with  access and edit the following,  the user not 
created as migrated not installed


mysql
 
 
 
 
 



Mohamad Barham

System Engineer | Information Technology Department

Birzeit University

P.O.Box. 14, Birzeit, Palestine

Tel: + 970 22982012 | Mob: +970 597 861929 | Ext: 5616

mbar...@birzeit.edu | www.birzeit.edu






From: Koha  on behalf of DHIM IT 

Sent: Thursday, May 18, 2023 10:48 AM
To: koha@lists.katipo.co.nz 
Subject: [Koha] Error while editing item on migrated instance

Dear colleagues,

I migrated koha db to a new server with fresh installed instance. Everything 
working fine. I have only one error while editing items:


[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st 
execute failed: The user specified as a definer ('root'@'%') does not exist at 
/usr/share/koha/lib/Koha/Object.pm line 170

Does anybody know what can I do to solve it?

KOHA 22.05
Debian 11

Mit besten Grüßen
IT-Manager
Eugen Bastron

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
~~
The information contained in this communication is intended solely for the use 
of the individual or entity to whom it is addressed and others authorized to 
receive it. It may contain confidential or legally privileged information. If 
you are not the intended recipient you are hereby notified that any disclosure, 
copying, distribution or taking any action in reliance on the contents of this 
information is strictly prohibited and may be unlawful. If you have received 
this communication in error, please notify us immediately by responding to this 
email and then delete it from your system. The University is neither liable for 
the proper and complete transmission of the information contained in this 
communication nor for any delay in its receipt.
~~
___

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

[Koha] Error while editing item on migrated instance

[DHIM IT]

Dear colleagues,

I migrated koha db to a new server with fresh installed instance. Everything 
working fine. I have only one error while editing items:


[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st 
execute failed: The user specified as a definer ('root'@'%') does not exist at 
/usr/share/koha/lib/Koha/Object.pm line 170

Does anybody know what can I do to solve it?

KOHA 22.05
Debian 11

Mit besten Grüßen
IT-Manager
Eugen Bastron

___

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