Re: [Koha] Elasticsearch in Debian 12

[Mason James]

hi Ricardo

On 21/10/23 6:08 am, Ricardo Vargas wrote:

Hi all, I have a Debian 12, with 16 GB of RAM and koha installed by
packages, I have tried to configure it with Elasticsearch but it always
sends the error of problems when indexing, it does not advance.


what's the specific error?


In Debian 10 and Debian 11 it indexes without problems, has anyone
configured Elasticsearch with Debian 12?


what Koha and ES versions are you successfully using in debian 11?

what Koha and ES versions are you unsuccessfully using in debian 12?


cheers, Mason
___

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

Re: [Koha] Koha not compatible with Plesk Control Panel?

[Mason James]

hi Alessandro


El lun, 2 oct 2023 10:18, Alessandro Tedesco mailto:alessandro.tedesco...@gmail.com>> escribió:

Hi Mason,

thanks for the reply.

If I may, I would ask a further question.

If I install Koha 21.11 (which requires libmojolicious-perl 8.x) and then
upgrade to Koha 22.11 on an infrastructure that does not allow installing
libmojolicious-perl 9.x, what happens?


i think you'll get an error saying that koha-common 22.11 can't install, as 
there is a conflict with a dependant package (javascript-common) and plesk



Can Koha 22.11 also work with libmojolicious-perl 8.x? Or will the
koha-common version 22.11 package attempt to install libmojolicious-perl
9.x and, failing to install it, will result in a broken installation of
Koha?


hmm no... koha 22.05 and higher now require libmojo 9.x

___

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

Re: [Koha] Koha not compatible with Plesk Control Panel?

[Mason James]

On 28/09/23 10:31 pm, Alessandro Tedesco wrote:

Hi Mason,

as per my previous message, I'm trying to understand why I am able to install the Koha 
21.11 version on "Ubuntu 22.04.3 LTS (jammy) + Plesk Obsidian 18.0.55" (even 
though the 21.11 version also depends on libmojolicious-perl).

What I saw was that:
---
# apt info koha-common | grep Depends
[For 23.05] Depends: ... libmojolicious-perl ...
[For 22.11] Depends: ... libmojolicious-perl ...
[For 22.05] Depends: ... libmojolicious-perl (>= 6.0) ...
[For 21.11] Depends: ... libmojolicious-perl (>= 6.0) ...
---
Is it possible that - despite I am in Ubuntu jammy - the libmojolicious-perl 
(declared >= 6.0) required by koha-common (for the Koha 21.11 version), is 
installed in the libmojolicious-perl (8.33+dfsg-1) version (for Ubuntu focal): 
version that doesn't require javascript-common dependency?
While all other koha-common packages (for the newer Koha versions) always try 
to install the libmojolicious-perl (9.22+dfsg-1) version?

Thanks and Kind Regards
Alessandro


hi Alessandro

koha 21.11 depends on the older 8.x version of libmojolicious-perl, and is 
incompatible with the newer 9.x version of libmojolicious-perl

___

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

Re: [Koha] Koha not compatible with Plesk Control Panel?

[Mason James]

On 26/09/23 8:27 pm, Alessandro Tedesco wrote:

Hi Mason,

thank you so much for checking and replying to this issue.

 >perhaps you could log a support ticket/bug with plesk?
I have already open a post in the Plesk Forum, but it seems that for the moment 
they won't fix this issues:
https://talk.plesk.com/threads/a-fix-for-javascript-common-package-incompatibility-with-plesk.371562/
 
<https://talk.plesk.com/threads/a-fix-for-javascript-common-package-incompatibility-with-plesk.371562/>

However, can you confirm that the "javascript-common package" was introduced 
since the 22.05 Release? (I am able to install Koha  21.11 in the VPS running Ubuntu with 
Plesk without problems).


hiya,

even koha 21.11 still depends on libmojolicious-perl - so your success with 
koha 21.11 is probably due to installing on an older ubuntu version (focal?), 
rather than an older koha version

try installing koha on ubuntu focal/20.04, which wont have a javascript-common 
dependency :)




Another question: is anyone using (or can recommend) a control panel for Debian 
(or Ubuntu) that doesn't cause conflicts with Koha (maybe DirectAdmin?)

Thanks and Kind Regards
Alessandro


Il giorno mar 26 set 2023 alle ore 07:20 Mason James mailto:m...@kohaaloha.com>> ha scritto:

hi Alessandro

the bad news is that koha-common depends on libmojolicious-perl,
   which depends on libjs-bootstrap4,
    which depends on libjs-popper.js,
     which depends on javascript-common


https://packages.debian.org/bookworm/libmojolicious-perl 
<https://packages.debian.org/bookworm/libmojolicious-perl>


perhaps you could log a support ticket/bug with plesk?


cheers, Mason


On 25/09/23 11:00 am, Alessandro Tedesco wrote:
 > Hello everyone,
 >
 > I am trying to install the current stable release of Koha on a VPS (OS
 > Ubuntu 22.04.1) managed with the Plesk Control Panel.
 >
 > However, it seems that Koha is not compatible with Plesk.
 >
 > Below the error generated after launching the installation
 > ---
 > # sudo apt-get install koha-common
 > Reading package lists... Done
 > Building dependency tree... Done
 > 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:
 > psa : Conflicts: javascript-common but 11+nmu1 is to be installed
 > E: Error, pkgProblemResolver::Resolve generated breaks, this may be 
caused
 > by held packages.
 > ---


note you have a problem with the psa and javascript-common
 >
 > I have found that Plesk is not compatible with the javascript-common
 > package required by Koha (https://
 > 
talk.plesk.com/threads/cant-install-prometheus-together-with-plesk-on-debian-bullseye.367321/#post-917570
 
<http://talk.plesk.com/threads/cant-install-prometheus-together-with-plesk-on-debian-bullseye.367321/#post-917570>
 > ).
 >
 > However, it's strange because last year I installed Koha without problems
 > on a VPS with Plesk...maybe the javascript-common package in the latest
 > versions of Koha?
 >
 > Does anyone experience the same issues?
 >
 > Thanks and Kind Regards
 > Alex
 > ___
 >
 > Koha mailing list http://koha-community.org <http://koha-community.org>
 > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
 > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
<https://lists.katipo.co.nz/mailman/listinfo/koha>



--
*Alessandro Tedesco, Ph.D.*
CREAtive COMmunication STUDIO


___

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

Re: [Koha] Koha not compatible with Plesk Control Panel?

[Mason James]

hi Alessandro

the bad news is that koha-common depends on libmojolicious-perl,
 which depends on libjs-bootstrap4,
  which depends on libjs-popper.js,
   which depends on javascript-common


https://packages.debian.org/bookworm/libmojolicious-perl


perhaps you could log a support ticket/bug with plesk?


cheers, Mason


On 25/09/23 11:00 am, Alessandro Tedesco wrote:

Hello everyone,

I am trying to install the current stable release of Koha on a VPS (OS
Ubuntu 22.04.1) managed with the Plesk Control Panel.

However, it seems that Koha is not compatible with Plesk.

Below the error generated after launching the installation
---
# sudo apt-get install koha-common
Reading package lists... Done
Building dependency tree... Done
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:
psa : Conflicts: javascript-common but 11+nmu1 is to be installed
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused
by held packages.
---



note you have a problem with the psa and javascript-common


I have found that Plesk is not compatible with the javascript-common
package required by Koha (https://
talk.plesk.com/threads/cant-install-prometheus-together-with-plesk-on-debian-bullseye.367321/#post-917570
).

However, it's strange because last year I installed Koha without problems
on a VPS with Plesk...maybe the javascript-common package in the latest
versions of Koha?

Does anyone experience the same issues?

Thanks and Kind Regards
Alex
___

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] Koha update being kept back on Ubuntu 18.04 bionic

[Mason James]

On 14/06/23 12:28 am, Giuseppe Angilella wrote:

Hi,

I am currently using Koha 22.11.06 on Ubuntu 18.04

Recently, "sudo apt upgrade" kept an available update for Koha "on hold".

Is it possible to perform the upgrade nonetheless? Is it recommended, or will 
it cause problems (i.e., the new version of Koha will still be compatible with 
Ubuntu 10.04)?

My /etc/apt/sources.list.d/koha.list reads:

deb http://debian.koha-community.org/koha stable main bionic

Any advice or comment will be appreciated, many thanks!

Regards,

Giuseppe.

___

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



hi Giuseppe

the new 'stable' koha 23.05 does not support ubuntu 18.04/bionic, because koha 
needs
a newer version of weasyprint that bionic does not support

 
https://wiki.koha-community.org/wiki/System_requirements_and_recommendations#Koha_23.05


the easy fix is to upgrade to ubuntu 20.04 or 22.04 :)


also ubuntu 18.04 support has recently stopped,  
https://ubuntu.com//blog/18-04-end-of-standard-support

___

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

[Koha] Koha 23.05 packages are available 

[Mason James]

kia ora community,

the latest Koha 23.05 packages are available

an installation guide is below...
  https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason
___

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

Re: [Koha] Koha upgrade error

[Mason James]

hi folks

the new package should fix this problem 


On 30/05/23 12:23 am, Tomas Cohen Arazi wrote:

We are about to roll a new package with that fixed. Thanks for reporting.

El lun, 29 may 2023 a las 8:11, Daniel F. Twum ()
escribió:








 Upgrade to 22.11.05.010 [10:48:17]: Bug 33489 - Add indices to
default patron search fields
 ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed:
BLOB/TEXT column 'middle_name' used in key specification without a key
length at /usr/share/koha/lib/C4/Installer.pm line 743



--
8181 Robinson Jefferson Drive
APT 410
Elkridge, Maryland 21075-7271
USA

1 (404) 369-3966

--


http://www.mobilelinux.net





___

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] Koha 22.11.05 released

[Mason James]

hi Thomas

this should be fixed in the latest 22.11.06 package


On 27/05/23 11:06 pm, Mason James wrote:

hi Thomas

this looks like a regression, introduced by bug 33167

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33167


On 27/05/23 7:02 am, Thomas Sycko-Miller wrote:

I'm getting a similar error when trying to view biblio details in staff
client:

[Fri May 26 13:54:25.843357 2023] [proxy:error] [pid 2474] (2)No such file
or directory: AH02454: http: attempt to connect to Unix domain socket
/var/run/koha/library/plack.sock (localhost) failed
[Fri May 26 13:54:25.843460 2023] [proxy_http:error] [pid 2474] [client
999.999.999.999:55178] AH01114: HTTP: failed to make connection to backend:
httpd-UDS

--


On Fri, May 26, 2023 at 1:28 PM Hector Gonzalez Jaime 
wrote:


Hello, thanks for all the hard work!

I just tried this version on a development server, and get a 500 error
trying to check overdue fines, this is in the logs:

"GET /intranet/circ/branchoverdues.pl HTTP/1.1" 500

Template process failed: undef error - : filter not found at
/usr/share/koha/lib/C4/Templates.pm line 127.

It worked well with 22.11.05, and got broken with 22.11.06


On 5/26/23 09:00, Renvoize, Martin wrote:

Hello, Bonjour, Kia ora,

The Koha community is pleased to announce the release of version

22.11.05.


This is a security and bugfix maintenance release, including 160

bugfixes!


Full release notes are available here:
https://koha-community.org/koha-22-11-06-released/

This is our last release as the stable branch maintainers, with the
community heading into the next cycle imminently. However, 22.11.x will

be

in the capable hands of Pedro and Matt for the next cycle having been

voted

in as the oldstable maintainers 

Thanks to anybody involved! 


Martin Renvoize, MPhys (Hons)

Head of Development and Community Engagement



E: martin.renvo...@ptfs-europe.com

P: +44 (0) 1483 378728

M: +44 (0) 7725 985636

www.ptfs-europe.com
___

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


___

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] Koha 22.11.05 released

[Mason James]

hi Thomas

this looks like a regression, introduced by bug 33167

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33167


On 27/05/23 7:02 am, Thomas Sycko-Miller wrote:

I'm getting a similar error when trying to view biblio details in staff
client:

[Fri May 26 13:54:25.843357 2023] [proxy:error] [pid 2474] (2)No such file
or directory: AH02454: http: attempt to connect to Unix domain socket
/var/run/koha/library/plack.sock (localhost) failed
[Fri May 26 13:54:25.843460 2023] [proxy_http:error] [pid 2474] [client
999.999.999.999:55178] AH01114: HTTP: failed to make connection to backend:
httpd-UDS

--


On Fri, May 26, 2023 at 1:28 PM Hector Gonzalez Jaime 
wrote:


Hello, thanks for all the hard work!

I just tried this version on a development server, and get a 500 error
trying to check overdue fines, this is in the logs:

"GET /intranet/circ/branchoverdues.pl HTTP/1.1" 500

Template process failed: undef error - : filter not found at
/usr/share/koha/lib/C4/Templates.pm line 127.

It worked well with 22.11.05, and got broken with 22.11.06


On 5/26/23 09:00, Renvoize, Martin wrote:

Hello, Bonjour, Kia ora,

The Koha community is pleased to announce the release of version

22.11.05.


This is a security and bugfix maintenance release, including 160

bugfixes!


Full release notes are available here:
https://koha-community.org/koha-22-11-06-released/

This is our last release as the stable branch maintainers, with the
community heading into the next cycle imminently. However, 22.11.x will

be

in the capable hands of Pedro and Matt for the next cycle having been

voted

in as the oldstable maintainers 

Thanks to anybody involved! 


Martin Renvoize, MPhys (Hons)

Head of Development and Community Engagement



E: martin.renvo...@ptfs-europe.com

P: +44 (0) 1483 378728

M: +44 (0) 7725 985636

www.ptfs-europe.com
___

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


___

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] Koha 22.11.05 released

[Mason James]

hi Hector

this problem tests OK for me, on a 22.11.06 KTD instance


some suggestions...

1/ switch your language to 'en', and test problem again

2/ manually rebuild your koha languages, and test problem again


  $ sudo koha-translate --list
  en
  fr-FR


  $ sudo koha-translate -v --update en
  $ sudo koha-translate -v --update fr-FR



On 27/05/23 5:27 am, Hector Gonzalez Jaime wrote:

Hello, thanks for all the hard work!

I just tried this version on a development server, and get a 500 error trying 
to check overdue fines, this is in the logs:

"GET /intranet/circ/branchoverdues.pl HTTP/1.1" 500

Template process failed: undef error - : filter not found at 
/usr/share/koha/lib/C4/Templates.pm line 127.

It worked well with 22.11.05, and got broken with 22.11.06


On 5/26/23 09:00, Renvoize, Martin wrote:

Hello, Bonjour, Kia ora,

The Koha community is pleased to announce the release of version 22.11.05.

This is a security and bugfix maintenance release, including 160 bugfixes!

Full release notes are available here:
https://koha-community.org/koha-22-11-06-released/

This is our last release as the stable branch maintainers, with the
community heading into the next cycle imminently. However, 22.11.x will be
in the capable hands of Pedro and Matt for the next cycle having been voted
in as the oldstable maintainers 

Thanks to anybody involved! 


Martin Renvoize, MPhys (Hons)

Head of Development and Community Engagement



E: martin.renvo...@ptfs-europe.com

P: +44 (0) 1483 378728

M: +44 (0) 7725 985636

www.ptfs-europe.com
___

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] Upgrading from 19.11.29.000 to latest

[Mason James]

hi Steve

i've updated the wiki with a link

https://wiki.koha-community.org/wiki/Koha_on_Debian#MySQL_and_MariaDB


On 27/04/23 10:14 am, Steve Nickerson wrote:

Thank you Mason!   I’ll be honest I thought Stretch (9) was the latest, which I 
now realize is not correct.  I’ll work on upgrading to Debian 11 I guess :)

Is the conversion from MySQL to MariaDB documented anywhere?
--
*From:* Mason James 
*Sent:* Tuesday, April 25, 2023 11:21:13 PM
*To:* Steve Nickerson ; 'koha' 

*Subject:* Re: [Koha] Upgrading from 19.11.29.000 to latest
hi Steve

try upgrading to the latest debian version, then attempt a koha upgrade

debian 9 is not supported by debian - or koha-stable (22.11)

https://wiki.debian.org/LTS <https://wiki.debian.org/LTS>
https://wiki.koha-community.org/wiki/System_requirements_and_recommendations#Koha_22.11
 
<https://wiki.koha-community.org/wiki/System_requirements_and_recommendations#Koha_22.11>


its also recommended to run mariadb rather than mysql

https://packages.debian.org/bullseye/mariadb-server 
<https://packages.debian.org/bullseye/mariadb-server>


cheers, Mason

On 25/04/23 9:26 am, Steve Nickerson wrote:

Does anyone have any thoughts on this at all?  I'm stuck not being able to
upgrade this environment unfortunately.

  


Cheers!

Steve

  


From: Steve Nickerson 
Sent: Friday, March 24, 2023 12:21 AM
To: 'koha' 
Subject: Upgrading from 19.11.29.000 to latest

  


I've upgraded my OS from Jessie to Stretch, and am now trying to upgrade a
Koha Debian package install from 19.11.29.000 to the latest, but the schema
upgrade fails with this:

  


* Upgrade to 22.06.00.077 [23:48:59]:
ERROR: {UNKNOWN}: Can't use an undefined value as a subroutine reference at
/usr/share/koha/lib/C4/Installer.pm line 737. at
/usr/share/koha/lib/C4/Installer.pm line 739

  


I've searched Bugzilla and don't' seem to find anything similar.   Anyone
have any idea what might cause this?  Missing some package perhaps?

  


Cheers!

Steve

  


___

Koha mailing list  http://koha-community.org <http://koha-community.org>
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
<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] Upgrading from 19.11.29.000 to latest

[Mason James]

hi Steve

try upgrading to the latest debian version, then attempt a koha upgrade

debian 9 is not supported by debian - or koha-stable (22.11)

 https://wiki.debian.org/LTS
 
https://wiki.koha-community.org/wiki/System_requirements_and_recommendations#Koha_22.11


its also recommended to run mariadb rather than mysql

 https://packages.debian.org/bullseye/mariadb-server


cheers, Mason

On 25/04/23 9:26 am, Steve Nickerson wrote:

Does anyone have any thoughts on this at all?  I'm stuck not being able to
upgrade this environment unfortunately.

  


Cheers!

Steve

  


From: Steve Nickerson 
Sent: Friday, March 24, 2023 12:21 AM
To: 'koha' 
Subject: Upgrading from 19.11.29.000 to latest

  


I've upgraded my OS from Jessie to Stretch, and am now trying to upgrade a
Koha Debian package install from 19.11.29.000 to the latest, but the schema
upgrade fails with this:

  


*   Upgrade to 22.06.00.077 [23:48:59]:
ERROR: {UNKNOWN}: Can't use an undefined value as a subroutine reference at
/usr/share/koha/lib/C4/Installer.pm line 737. at
/usr/share/koha/lib/C4/Installer.pm line 739

  


I've searched Bugzilla and don't' seem to find anything similar.   Anyone
have any idea what might cause this?  Missing some package perhaps?

  


Cheers!

Steve

  


___

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] Can't connect to local MySQL server through socket

[Mason James]

hi Eugen

you probably have a config problem with your 'koha' instance


does the following command succeed?
 
 $ sudo koha-mysql koha




On 17/04/23 7:25 pm, DHIM IT wrote:

Dear Collogues,

for two weeks I get an every 2-5 minute error from the cron below. I can run 
the commands from the cron without a problem. Also, I can connect to my 
database without a problem. Any ideas?


Best regards,
Eugen Bastron


DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by 
"/usr/share/koha/bin/cronjobs/process_message_queue.pl"

/etc/cron.hourly/koha-common:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by 
"/usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl"
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI 
connect('database=koha_koha;host=localhost;port=3306','koha_koha',...) failed: 
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' 
(111) at /usr/share/koha/lib/Koha/Database.pm line 91. at 
/usr/share/koha/lib/Koha/Database.pm line 139
koha: 111 status returned by "/usr/share/koha/bin/cronjobs/automatic_checkin.pl"



___

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 500 with dpkg returned an error code (1)

[Mason James]

hi Aida,

what does the following command say?

$ sudo koha-mysql library -e  ' select value from systempreferences where variable = 
"version" '
++
| value  |
++
| 21.1117000 |  <
++




On 11/04/23 1:24 am, libr...@ssst.edu.ba wrote:

Hello all,

I keep coming up against error 500 when trying to add a record (no matter which 
framework I try to use or whether it's via a Z39.50 server or manual entry) as 
well as when going to the About Koha page in the staff interface. When I opened 
the terminal, there were 2 updates to be applied so I ran the update but it 
does not work. Here is the entire output:

2 updates can be applied immediately.
To see these additional updates run: apt list --upgradable

Enable ESM Apps to receive additional future security updates.
See https://ubuntu.com/esm or run: sudo pro status


Last login: Mon Apr 10 11:34:09 2023 from 10.1.3.133
root@koha:~# apt list --upgradable
Listing... Done
distro-info-data/jammy-updates 0.52ubuntu0.3 all [upgradable from: 
0.52ubuntu0.2]
grub-efi-amd64-bin/jammy-updates 2.06-2ubuntu14.1 amd64 [upgradable from: 
2.06-2ubuntu10]
grub-efi-amd64-signed/jammy-updates 1.187.3~22.04.1+2.06-2ubuntu14.1 amd64 
[upgradable from: 1.182~22.04.1+2.06-2ubuntu10]
grub-efi-amd64/jammy-updates 2.06-2ubuntu14.1 amd64 [upgradable from: 
2.06-2ubuntu10]
shim-signed/jammy-updates 1.51.3+15.7-0ubuntu1 amd64 [upgradable from: 
1.51+15.4-0ubuntu9]
root@koha:~# apt-get update
Hit:1 http://ba.archive.ubuntu.com/ubuntu jammy InRelease
Hit:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:3 http://ba.archive.ubuntu.com/ubuntu jammy-backports InRelease
Hit:4 http://ba.archive.ubuntu.com/ubuntu jammy-security InRelease
Hit:5 http://debian.koha-community.org/koha stable InRelease
Reading package lists... Done
W: http://debian.koha-community.org/koha/dists/stable/InRelease: Key is stored 
in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the DEPRECATION 
section in apt-key(8) for details.
root@koha:~# apt-get upgrade
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Calculating upgrade... Done
The following packages will be upgraded:
   distro-info-data grub-efi-amd64 grub-efi-amd64-bin grub-efi-amd64-signed
   shim-signed
5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 3,699 kB of archives.
After this operation, 5,861 kB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 
distro-info-data all 0.52ubuntu0.3 [5,258 B]
Get:2 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 
grub-efi-amd64 amd64 2.06-2ubuntu14.1 [47.1 kB]
Get:3 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 
grub-efi-amd64-signed amd64 1.187.3~22.04.1+2.06-2ubuntu14.1 [1,388 kB]
Get:4 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 
grub-efi-amd64-bin amd64 2.06-2ubuntu14.1 [1,591 kB]
Get:5 http://ba.archive.ubuntu.com/ubuntu jammy-updates/main amd64 shim-signed 
amd64 1.51.3+15.7-0ubuntu1 [667 kB]
Fetched 3,699 kB in 0s (13.8 MB/s)
Preconfiguring packages ...
(Reading database ... 152607 files and directories currently installed.)
Preparing to unpack .../distro-info-data_0.52ubuntu0.3_all.deb ...
Unpacking distro-info-data (0.52ubuntu0.3) over (0.52ubuntu0.2) ...
Preparing to unpack .../grub-efi-amd64_2.06-2ubuntu14.1_amd64.deb ...
Unpacking grub-efi-amd64 (2.06-2ubuntu14.1) over (2.06-2ubuntu10) ...
Preparing to unpack 
.../grub-efi-amd64-signed_1.187.3~22.04.1+2.06-2ubuntu14.1_amd64.deb ...
Unpacking grub-efi-amd64-signed (1.187.3~22.04.1+2.06-2ubuntu14.1) over 
(1.182~22.04.1+2.06-2ubuntu10) ...
Preparing to unpack .../grub-efi-amd64-bin_2.06-2ubuntu14.1_amd64.deb ...
Unpacking grub-efi-amd64-bin (2.06-2ubuntu14.1) over (2.06-2ubuntu10) ...
Preparing to unpack .../shim-signed_1.51.3+15.7-0ubuntu1_amd64.deb ...
Unpacking shim-signed (1.51.3+15.7-0ubuntu1) over (1.51+15.4-0ubuntu9) ...
Setting up koha-common (22.11.03-1) ...
Upgrading database schema for library
DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't 
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't 
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
Use of uninitialized value in numeric lt (<) at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 78.
DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at 
/usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist at 
/usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't 
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't 
exist 

Re: [Koha] Upgrade Schema Issue

[Mason James]

hi Taimoor,

what koha version are you upgrading from/to?


what does the following command say?

$ sudo koha-mysql library -e  ' select value from systempreferences where variable = 
"version" '
++
| value  |
++
| 21.1117000 |  <
++



On 12/04/23 3:18 pm, Taimoor Memon wrote:

Hello everyone,
I'm facing an issue in the upgradation of Koha, terminal is executing the
following error:

DBD::mysql::st execute failed: Table 'koha_library.systempreferences'
doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st execute failed: Table 'koha_library.systempreferences'
doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
Use of uninitialized value in numeric lt (<) at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 78.
DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at
/usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist
at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
Undefined subroutine ::DropAllForeignKeys called at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 86.




___

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

Re: [Koha] Upgrade to 21.11 Fails

[Mason James]

On 15/03/23 11:22 am, Bruce A. Metcalf wrote:

On 3/14/23 01:05, Mason James wrote:

On 14/03/23 5:53 pm, Mason James wrote:

On 13/03/23 5:13 am, Bruce A. Metcalf wrote:

On 3/12/23 10:34, Katrin Fischer wrote:



There is a log3perl.conf file in my /etc/koha/sites/(instance)/ directory, and 
it looks just like the one suggested.

Perhaps it's something else. Any other ideas?



hi Bruce

did you restart koha? - specifically after you upgraded?

  /etc/init.d/koha-common restart


did the following error stop?
 
  AH01215: Configuration not defined at /usr/share/perl5/Log/Log4perl/Config.pm line 579.: /usr/share/koha/intranet/cgi-bin/mainpage.pl



do you have new errors in your log files?
___

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

Re: [Koha] Upgrade to 21.11 Fails

[Mason James]

On 15/03/23 11:22 am, Bruce A. Metcalf wrote:

On 3/14/23 01:05, Mason James wrote:

On 14/03/23 5:53 pm, Mason James wrote:

On 13/03/23 5:13 am, Bruce A. Metcalf wrote:

On 3/12/23 10:34, Katrin Fischer wrote:



There is a log3perl.conf file in my /etc/koha/sites/(instance)/ directory, and 
it looks just like the one suggested.

Perhaps it's something else. Any other ideas?



hi Bruce

did you restart koha? - specifically after you upgraded?

  /etc/init.d/koha-common restart


did the following error stop?
 
  AH01215: Configuration not defined at /usr/share/perl5/Log/Log4perl/Config.pm line 579.: /usr/share/koha/intranet/cgi-bin/mainpage.pl



do you have new errors in your log files?
___

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

Re: [Koha] Upgrade to 21.11 Fails

[Mason James]

On 14/03/23 5:53 pm, Mason James wrote:

On 13/03/23 5:13 am, Bruce A. Metcalf wrote:

On 3/12/23 10:34, Katrin Fischer wrote:


the internal server error will resolve to something more meaningful in
the logs. Check your logs on the server for the full error message.



I've looked at the tail of all logs in /var/log/koha/(instance)/, but most are 
empty and the others don't give me any meaning.

One example, intranet-error.log gives:

[Sun Mar 12 09:18:00.882412 2023] [cgi:error] [pid 25446] [client 
185.224.128.17:41784] AH01215: Configuration not defined at 
/usr/share/perl5/Log/Log4perl/Config.pm line 579.: 
/usr/share/koha/intranet/cgi-bin/mainpage.pl

I've viewed both files listed, but not being a programmer, I can't see what 
might be wrong with them.


To review, an upgrade to 21.11 (OldOldStable) and Debian 10 results in 
[Internal Server Error] screens.


hi Bruce
the short version is that your koha instance is probably missing a 
log4perl.conf file

a simple way to correct the problem would be to create a new instance, then 
copy the missing log4perl.conf file from the new instance

then do a search/replace on instance_name, in the file




here is an example of a log4perl.conf file - please search/replace it, as 
required :)



# cat /etc/koha/sites/tp3/log4perl.conf

log4perl.logger.intranet = WARN, INTRANET
log4perl.appender.INTRANET=Log::Log4perl::Appender::File
log4perl.appender.INTRANET.filename=/var/log/koha/tp3/intranet-error.log
log4perl.appender.INTRANET.mode=append
log4perl.appender.INTRANET.layout=PatternLayout
log4perl.appender.INTRANET.layout.ConversionPattern=[%d] [%p] %m %l%n
log4perl.appender.INTRANET.utf8=1

log4perl.logger.opac = WARN, OPAC
log4perl.appender.OPAC=Log::Log4perl::Appender::File
log4perl.appender.OPAC.filename=/var/log/koha/tp3/opac-error.log
log4perl.appender.OPAC.mode=append
log4perl.appender.OPAC.layout=PatternLayout
log4perl.appender.OPAC.layout.ConversionPattern=[%d] [%p] %m %l%n
log4perl.appender.OPAC.utf8=1

log4perl.logger.z3950 = WARN, Z3950
log4perl.appender.Z3950=Log::Log4perl::Appender::File
log4perl.appender.Z3950.filename=/var/log/koha/tp3/z3950-error.log
log4perl.appender.Z3950.mode=append
log4perl.appender.Z3950.layout=PatternLayout
log4perl.appender.Z3950.layout.ConversionPattern=[%d] [%p] %m %l%n
log4perl.appender.Z3950.utf8=1

log4perl.logger.api = WARN, API
log4perl.appender.API=Log::Log4perl::Appender::File
log4perl.appender.API.filename=/var/log/koha/tp3/api-error.log
log4perl.appender.API.mode=append
log4perl.appender.API.layout=PatternLayout
log4perl.appender.API.layout.ConversionPattern=[%d] [%p] %m %l%n
log4perl.appender.API.utf8=1

log4perl.logger.sip = DEBUG, SIP
log4perl.appender.SIP=Log::Log4perl::Appender::File
log4perl.appender.SIP.filename=/var/log/koha/tp3/sip.log
log4perl.appender.SIP.mode=append
log4perl.appender.SIP.layout=PatternLayout
log4perl.appender.SIP.layout.ConversionPattern=[%d] [%P] [%p] %m %l%n
log4perl.appender.SIP.utf8=1


log4perl.logger.plack-opac = WARN, PLACKOPAC
log4perl.appender.PLACKOPAC=Log::Log4perl::Appender::File
log4perl.appender.PLACKOPAC.filename=/var/log/koha/tp3/plack-opac-error.log
log4perl.appender.PLACKOPAC.mode=append
log4perl.appender.PLACKOPAC.layout=PatternLayout
log4perl.appender.PLACKOPAC.layout.ConversionPattern=[%d] [%p] %m
log4perl.appender.PLACKOPAC.utf8=1

log4perl.logger.plack-api = WARN, PLACKAPI
log4perl.appender.PLACKAPI=Log::Log4perl::Appender::File
log4perl.appender.PLACKAPI.filename=/var/log/koha/tp3/plack-api-error.log
log4perl.appender.PLACKAPI.mode=append
log4perl.appender.PLACKAPI.layout=PatternLayout
log4perl.appender.PLACKAPI.layout.ConversionPattern=[%d] [%p] %m
log4perl.appender.PLACKAPI.utf8=1

log4perl.logger.plack-intranet = WARN, PLACKINTRANET
log4perl.appender.PLACKINTRANET=Log::Log4perl::Appender::File
log4perl.appender.PLACKINTRANET.filename=/var/log/koha/tp3/plack-intranet-error.log
log4perl.appender.PLACKINTRANET.mode=append
log4perl.appender.PLACKINTRANET.layout=PatternLayout
log4perl.appender.PLACKINTRANET.layout.ConversionPattern=[%d] [%p] %m
log4perl.appender.PLACKINTRANET.utf8=1

___

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

Re: [Koha] Upgrade to 21.11 Fails

[Mason James]

On 13/03/23 5:13 am, Bruce A. Metcalf wrote:

On 3/12/23 10:34, Katrin Fischer wrote:


the internal server error will resolve to something more meaningful in
the logs. Check your logs on the server for the full error message.



I've looked at the tail of all logs in /var/log/koha/(instance)/, but most are 
empty and the others don't give me any meaning.

One example, intranet-error.log gives:

[Sun Mar 12 09:18:00.882412 2023] [cgi:error] [pid 25446] [client 
185.224.128.17:41784] AH01215: Configuration not defined at 
/usr/share/perl5/Log/Log4perl/Config.pm line 579.: 
/usr/share/koha/intranet/cgi-bin/mainpage.pl

I've viewed both files listed, but not being a programmer, I can't see what 
might be wrong with them.


To review, an upgrade to 21.11 (OldOldStable) and Debian 10 results in 
[Internal Server Error] screens.


hi Bruce
the short version is that your koha instance is probably missing a 
log4perl.conf file

a simple way to correct the problem would be to create a new instance, then 
copy the missing log4perl.conf file from the new instance

then do a search/replace on instance_name, in the file


___

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

Re: [Koha] Background job / Staging MARC import stuck at 0%

[Mason James]

hi Michael

here is some debugging info, section 1.1
 https://wiki.koha-community.org/wiki/REST_API_Debug

On 4/03/23 12:14 pm, Michael Brown wrote:


Could this possibly be a similar problem? Should I try force-downgrading
JSON::Validator and/or Mojolicious? Is there any debugging I can do of
the Koha::REST::V1 module?



___

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

Re: [Koha] How do I upgrade to Koha 22.11?

[Mason James]

hi Dimitrios
try the following guide...

2.3 Upgrading Koha
  https://wiki.koha-community.org/wiki/Koha_on_Debian#Upgrading_Koha


On 31/01/23 4:08 am, Δημήτρης Δαλαγιώργος wrote:

Hi,

I've got Koha 22.05.04.000 running on a virtual machine
with Linux  4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64

I used to run sudo apt-get update and then sudo apt-get upgrade to get koha
upgraded to the newest version. Now it doesn't work or I'm forgetting
something.

How do I upgrade my koha installation to the latest version?

Dimitrios Dalagiorgos
3rd High School of Kozani
Greece
___

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] debian OS image cd or dvd - which one to be used?

[Mason James]

hi Satish

if you choose a minimal OS install, it makes no difference which installation 
image you choose


On 16/01/23 7:03 pm, SATISH wrote:

Hi,
Regarding installation of Operating System (Debian for Koha)  what is the
difference between using
cd image or dvd image.
I understand that the DVD image has a complete set of packages whereas
NetInst CD image has only a limited number of packages required to boot
into installation.

I follow wiki pages and other various blogs for installation.
However, I would like to know, selecting cd or dvd really helps koha or
maintenance of the system? because I am going to use the packages method of
installation for koha.  Kindly advise.

--
*Satish MV*
Librarian - Govt. Engineering College
Opp. Dairy Circle, B.M.Road, Hassan 573 201
Karnataka, INDIA
Mobile: +91 9449765737
___

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] Koha packages are available 

[Mason James]

kia ora community,

the latest Koha packages are available

an installation guide is below...
https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason
___

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

Re: [Koha] [Koha-devel] Koha 22.05.04: Can't locate Koha/Script.pm in @INC

[Mason James]

On 29/10/22 12:34 am, Michael Kuhn wrote:

Hi David and Indranil

Thank you very much, this works!

Interestingly addin variable PERL5LIB was never before necessary when I ran 
"bulkmarcimport.pl" (and I do this a lot).

Best wishes: Michael


hi Michael

i think it's always been necessary to have the PERL5LIB set correctly
___

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

[Koha] Koha packages are available 

[Mason James]

kia ora community,

the latest Koha packages are available

an installation guide is below...
https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason
___

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

Re: [Koha] Problem upgrading RabbitMQ / Erlang

[Mason James]

On 29/09/22 3:03 am, Isabel Pineda wrote:
> Hi Mason.
>
> Just one more question. After removing the PackageCloud repository, the 
output of the command 'apt policy rabbitmq-server erlang-base' is now
>
> rabbitmq-server:
>   Installed: 3.10.7-1
>   Candidate: 3.10.7-1
>   Version table:
>  *** 3.10.7-1 100
> 100 /var/lib/dpkg/status
>  3.9.13-1 500
> 500 http://asi-fs-d.contabo.net/ubuntu jammy/main amd64 Packages
> 500 http://asi-fs-d.contabo.net/ubuntu jammy/main i386 Packages
>
> Can the missing 500 entry for rabbitmq-server 3.10.7-1 be a problem?

hmm, its probably not a problem

> What other repository for rabbitmq-server can I use apart from Package Cloud?

it seems Package Cloud does not currently support ubuntu 22.04/jammy
 https://www.rabbitmq.com/install-debian.html

you should use the debian/ubuntu repositories, or a mirror like contabo
 https://packages.ubuntu.com/jammy/rabbitmq-server


___

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

Re: [Koha] Problem upgrading RabbitMQ / Erlang

[Mason James]

On 28/09/22 8:32 pm, Mason James wrote:



delete problematic repo file
   rm /apt/source.list.d/problematic-repo.list



perhaps take a backup of the file before deleting :)
___

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

Re: [Koha] Problem upgrading RabbitMQ / Erlang

[Mason James]

On 28/09/22 2:57 am, Isabel Pineda wrote:

Hi Mason. The output is:

rabbitmq-server:
   Installed: 3.10.7-1
   Candidate: 3.11.0-1
   Version table:
  3.11.0-1 500
 500 https://packagecloud.io/rabbitmq/rabbitmq-server/ubuntu jammy/main 
a   
 md64 Packages
 500 https://packagecloud.io/rabbitmq/rabbitmq-server/ubuntu jammy/main 
i   
 386 Packages



hi Isabel
your system has a problematic version of 'rabbitmq-server', installed from a 
non-offical repository called 'packagecloud.io'

you will need to delete the file in /apt/sources.list.d/* that adds the 
'packagecloud.io' repo


locate the file using the following command
  1/ grep -irl  packagecloud.io  /etc/apt/sources.list.d/

delete problematic repo file
   rm /apt/source.list.d/problematic-repo.list


  2/ apt update

install downgraded 22.05/jammy version from ubuntu repo
  3/ apt install rabbitmq-server=3.9.13-1

  4/ apt install koha-common

___

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

Re: [Koha] Problem upgrading RabbitMQ / Erlang

[Mason James]

hi Isabel
can you paste the output of the following command

$ apt policy rabbitmq-server erlang-base

rabbitmq-server:
  Installed: 3.9.13-1
  Candidate: 3.9.13-1
  Version table:
 *** 3.9.13-1 500
    500 http://archive.ubuntu.com/ubuntu jammy/main amd64 Packages
    100 /var/lib/dpkg/status
erlang-base:
  Installed: 1:24.2.1+dfsg-1
  Candidate: 1:24.2.1+dfsg-1
  Version table:
 *** 1:24.2.1+dfsg-1 500
    500 http://archive.ubuntu.com/ubuntu jammy/main amd64 Packages
    100 /var/lib/dpkg/status


On 27/09/22 2:47 am, Isabel Pineda wrote:

Hi.

I am runing Koha on Ubuntu 22.04 and I have got the problem that RabbitMQ cannot be 
upgraded because of unmet dependencies  (Erlang). It seems that I have got an older 
version of Erlang (1.24) and Rabbitmq requires version 1.25. The problem is that I cannot 
update Erlang. The error message is "The repository 
'http://binaries.erlang-solutions.com/debian jammy Release' does not have a release 
file".

Have you got a recommendation?

Thank you
Isabel Pineda
___

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] Koha support for Debian 9 ends

[Mason James]

kia ora community,

debian ended support for debian 9 (stretch) on June 30, 2022

 https://wiki.debian.org/LTS
 https://www.debian.org/releases/stretch/


so, we recommend you upgrade any debian 9 Koha systems to debian 10 or 11

cheers, Mason
___

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

Re: [Koha] Record display turns completely blank

[Mason James]

hi Mickey
it is unlikely to be an XSLT error, as an XSLT problem would be consistently 
broken

i would suggest preparing a test system to upgrade to koha 21.11 (or higher), 
and see if your problem is fixed


On 8/09/22 2:14 pm, 吳宣億 wrote:

Hi, thanks for the suggestion.


We checked the log and there doesn't seem to be any errors. If xslt is the 
problem wouldn't the display stay broken instead of only being broken from time 
to time?


We are going to try to install on a different server to see if the problem will 
fix itself.



吳宣億 ∣ 臺大圖書館系統資訊組
106臺北市羅斯福路四段一號
Mickey Wu
National Taiwan University Library IT Services Department
No.1 Sec.4, Roosevelt Rd., Taipei, Taiwan
Tel. 02-33664573
hsuan...@ntu.edu.tw

寄件者: Hugo Agud Andreu 
寄件日期: 2022年9月7日 下午 05:43:50
收件者: 吳宣億; koha@lists.katipo.co.nz
主旨: RE: [Koha] Record display turns completely blank

Hi

This is probably because a mistke in xslt template... if you check koha logs, 
probably koha will complain abou the xslt file


Hugo Agud - Orex Digital

www.orex.es<http://www.orex.es> - 
Linkedin<https://www.linkedin.com/company/orex-digital/>

Innovando para ayudar a las bibliotecas a alcanzar el siguiente nivel
<https://orex.es/productos/orex-analytics/>



Director




Passeig Comte Vilardaga, 118 3-3  08980 -Sant Feliu de Llobregat - Tel: 933 856 138   
ha...@orex.es<mailto:ha...@orex.es> · http://www.orex.es/





No imprima este mensaje a no ser que sea necesario. Una tonelada de papel 
implica la tala de 15 árboles y el consumo de 250.000 litros de agua.





Aviso de confidencialidad

Este mensaje y sus archivos adjuntos van dirigidos exclusivamente a su 
destinatario, pudiendo contener información confidencial sometida a secreto 
profesional. No está permitida su reproducción o distribución sin la 
autorización expresa de Orex Digital, S.L. Si usted no es el destinatario final 
por favor elimínelo e infórmenos por esta vía.



En cumplimiento de lo establecido en el Reglamento General de Protección de 
Datos (RGPD) (UE) 2016/679 y a la Ley Orgánica 3/2018, de 5 de diciembre, de 
Protección de Datos de Carácter Personal y Garantía de los Derechos Digitales 
(LOPD-GDD), le informamos que tratamos sus datos personales con la finalidad de 
responder a su solicitud de información, realizar la gestión administrativa 
derivada de nuestra relación comercial o contractual, así como enviarle 
comunicaciones comerciales sobre nuestros productos y servicios.



La legitimación será en base a un interés legítimo, por ejecución de un 
contrato y/o por consentimiento, en algunos casos. Los datos proporcionados se 
conservarán mientras se mantenga la relación contractual o durante los años 
necesarios para cumplir con las obligaciones legales. Los datos no se cederán a 
terceros salvo en los casos en que exista una obligación legal o sea necesario 
para la ejecución de un contrato. No se tomarán decisiones automatizadas que 
puedan causar un efecto jurídico significativo, salvo que se haya recabado 
previamente el consentimiento.



Asimismo, le informamos de la posibilidad de ejercer los siguientes derechos 
sobre sus datos personales: derecho de acceso, rectificación, supresión u 
olvido, limitación, oposición, portabilidad y a retirar el consentimiento 
prestado. Para ello podrá enviar un email a: i...@orex.es, adjuntando copia de 
su DNI.



Además, el interesado puede dirigirse a la Autoridad de Control en materia de 
Protección de Datos competente (AEPD, en España) para obtener información 
adicional o presentar una reclamación.



Datos identificativos:

Orex Digital, S.L., B64500945, Paseo Conde de Vilardaga 118, 3-3 - 08980 - Sant 
Feliu de Llobregat - BARCELONA, 933856138



De: Koha  en nombre de 吳宣億 

Enviado: miércoles, 7 de septiembre de 2022 7:34
Para: koha@lists.katipo.co.nz 
Asunto: [Koha] Record display turns completely blank

寄件者: 吳宣億
寄件日期: 2022年9月6日 下午 01:47
收件者: Mason James; koha@lists.katipo.co.nz
主旨: RE: [Koha] Record display turns completely blank


Hi Mason,


We are using:

Koha 20.05
Ubuntu 20.04.1 LTS


We have checked Peril which seems to be fine and caching is indeed working.



吳宣億 ∣ 臺大圖書館系統資訊組
106臺北市羅斯福路四段一號
Mickey Wu
National Taiwan University Library IT Services Department
No.1 Sec.4, Roosevelt Rd., Taipei, Taiwan
Tel. 02-33664573
hsuan...@ntu.edu.tw
________
寄件者: Mason James 
寄件日期: 2022年9月6日 上午 11:42:40
收件者: 吳宣億; koha@lists.katipo.co.nz
主旨: Re: [Koha] Record display turns completely blank

hi Mickey
what are your OS and Koha versions?


On 26/08/22 6:32 pm, 吳宣億 wrote:

Hi,


Occasionally when we view/create/edit a record, the record page will not 
display properly, all the field will turn blank, any update to the record just 
pauses and we need to wait from minutes to hours before it fixes itself and the 
record to be displayed normally again. It h

Re: [Koha] Koha upgrade error from 1905 to 21.11

[Mason James]

hi Sunita
you seem to have a problem with OpenAPI, perhaps installed via CPAN?


follow this guide... https://wiki.koha-community.org/wiki/REST_API_Debug

take a look at the following section
  1.4 Check 3 API packages are not installed via CPAN



On 14/09/22 11:01 pm, Sunita Barve wrote:

I wanted to upgrade my koha to latest version.
While upgrading when I ran upgrade directly it threw error hence ?I tried
upgrading from 19.05 to 19.11 then from 19.11 to 20.11 then from 20.11 to
21.11 there were no errors and upgrade was successful. Before upgrading to
20.11 I had installed Mojolicious::Plugin::OpenAPI and then ran upgrades of
20.11 and 21.11.

1. I am unable to see my libraries name in under Global System Preferences
under libraries option.
2. We are unable to circulate books through RFId and I found error as
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'koha-ncl.issuingrules" does not exist.
3. Here are my latest log entries in intranet-error.log
[Wed Sep 14 16:15:40.809002 2022] [cgi:error] [pid 3589] [client
172.16.3.14:33246] AH01215: [2022-09-14 16:15:40.80837] [3608] [error]
[pFebfFcy8Vis] Can't use an undefined value as an ARRAY reference at
/usr/local/share/perl/5.26.1/Mojolicious/Plugin/OpenAPI.pm line 296.:
/usr/share/koha/api/v1/app.pl, referer:
http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
[Wed Sep 14 16:15:40.809064 2022] [cgi:error] [pid 3589] [client
172.16.3.14:33246] AH01215: : /usr/share/koha/api/v1/app.pl, referer:
http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
[Wed Sep 14 16:15:40.809293 2022] [cgi:error] [pid 3589] [client
172.16.3.14:33246] AH01215: Can't use an undefined value as an ARRAY
reference at /usr/local/share/perl/5.26.1/Mojolicious/Plugin/OpenAPI.pm
line 296.: /usr/share/koha/api/v1/app.pl, referer:
http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
[Wed Sep 14 16:15:40.841776 2022] [cgi:error] [pid 3589] [client
172.16.3.14:33246] End of script output before headers: app.pl, referer:
http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl
[Wed Sep 14 16:15:42.531300 2022] [cgi:error] [pid 3589] [client
172.16.3.14:33246] AH01215: Use of uninitialized value in string eq at
/usr/share/koha/lib/C4/Context.pm line 784.:
/usr/share/koha/intranet/cgi-bin/errors/500.pl, referer:
http://kohaadmin.ncl.res.in/cgi-bin/koha/admin/branches.pl

4. I have tried to uninstall koha-common and changed my koha.list to
following

deb http://debian.koha-community.org/koha 21.11 main bionic

I then reinstalled koha-common but no luck.

Can someone help.

with reg

Sunita Barve, Ph. D.
Head, KRC/Library
CSIR-National Chemical Laboratory
Dr, Homi Bhaba Road
Pune 411008, INDIA
Email :sunitaba...@gmail.com ; sa.ba...@ncl.res.in
http://sunitabarve.googlepages.com
___

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] Record display turns completely blank

[Mason James]

hi Mickey
what are your OS and Koha versions?


On 26/08/22 6:32 pm, 吳宣億 wrote:

Hi,


Occasionally when we view/create/edit a record, the record page will not 
display properly, all the field will turn blank, any update to the record just 
pauses and we need to wait from minutes to hours before it fixes itself and the 
record to be displayed normally again. It happens from time to time and really 
impacts our workflow.

This is the screenshot of what it looks when it happens:

https://www.lib.ntu.edu.tw/AR/images/example.jpg


Anyone else experienced this? What could be the cause and what are potential 
solutions?




Mickey Wu
National Taiwan University Library IT Services Department
No.1 Sec.4, Roosevelt Rd., Taipei, Taiwan
Tel. 02-33664573
hsuan...@ntu.edu.tw
___

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] [Koha-devel] Dependency problem when installing Koha 21.11.10 on Debian 11

[Mason James]

On 4/08/22 2:34 am, Michael Kuhn wrote:
> Hi
>
> Meanwhile I have also tried to install Koha 22.05.03 (instead of Koha 21.11.10) on a 
new machine with Debian 11 but it gave me the same error concerning package 
"rabbitmq-server".
>
> Is it really true that it is not possible to install these two revisions on 
Debian 11?
>
> Best wishes: Michael

hi Michael
i often use docker to confirm that koha installs successfully

you can use the following transcript to confirm it is possible to install...

--
mason@xen1:~$ docker run -it debian:11
root@104f8750cb71:/# apt-get update
root@104f8750cb71:/# apt-get -y install ca-certificates wget gnupg2 dialog 
apt-utils sudo
root@104f8750cb71:/# wget -q -O- https://debian.koha-community.org/koha/gpg.asc 
| sudo apt-key add -
root@104f8750cb71:/# echo 'deb http://debian.koha-community.org/koha 22.05 
main' | sudo tee /etc/apt/sources.list.d/koha.list
root@104f8750cb71:/# apt-get update


root@104f8750cb71:/# apt-get -y install koha-common
...
Setting up koha-common (22.05.03-1) ...
...
root@2941ef956ace:/# echo $?
0


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

root@104f8750cb71:/# apt policy rabbitmq-server
rabbitmq-server:
  Installed: 3.8.9-3
  Candidate: 3.8.9-3
  Version table:
 *** 3.8.9-3 500
    500 http://deb.debian.org/debian bullseye/main amd64 Packages
    100 /var/lib/dpkg/status

root@2941ef956ace:/# exit
exit
mason@xen1:~$
--

___

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

Re: [Koha] /server-status?auto

[Mason James]

On 29/07/22 2:05 pm, Keith Sorbo wrote:

My server is getting hit once a second from 127.0.0.1 on the url
/server-status?auto

What is hitting the server? It is clearly internal.


hi Keith

i'm not sure what is hitting your server, but it is not koha

you possibly have a local monitoring tool that's causing the requests, and is 
not identifying itself
___

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

[Koha] Koha packages are available 

[Mason James]

kia ora community,

the latest Koha packages are available

an installation guide is below...
  https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason
___

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

Re: [Koha] Site user lacks priviledges for koha-dump

[Mason James]

aah... if you look at koha-create, it simply assigns ALL privs

so that's the easier fix :)

mysql> GRANT ALL PRIVILEGES ON `koha_dev1`.* TO `koha_dev1`@`localhost`;
mysql> FLUSH PRIVILEGES;


On 12/07/22 3:16 pm, Mason James wrote:

hi Keith

the following command shows the user's privs, for an instance called 'dev1'...
 mysql> SHOW GRANTS FOR 'koha_dev1'@'localhost'\G


the following command grants the required privs...
 mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, 
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, 
CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `koha_dev1`.* TO 
`koha_dev1`@`localhost`;


you'll need to replace 'dev1' with your instance's name



On 12/07/22 7:34 am, Keith Sorbo wrote:

I haven't yet figured out what privileges are needed.

On Mon, Jul 11, 2022 at 1:27 PM Evan Stewart 
wrote:


Hi Keith,

Thanks for the confirmation.  I'm surprised too that the Koha install
didn't get the higher privileges for the DB tables.  That's why I thought
it might be a Linux root issue because my Koha install gave privileges to
root for all MariaDB tables.

Were you able to solve the problem by granting more privileges to the
mysql user?

-Evan

On Mon, Jul 11, 2022 at 8:48 AM Keith Sorbo  wrote:


Thanks, Evan,

I am already running as root.

I looked at the script and it pulls the mysql username and password from
the library koha-config.xml.

I am rather surprised that during installation, the koha system did not
give sufficient grants to this user.

Keith

On Sun, Jul 10, 2022 at 11:28 PM Evan Stewart 
wrote:


Hi Keith,

Try using "sudo" with the command and include the instance name of the
library (For example, my library instance is named "catalog"). Sudo gives
your account the extra admin privileges it needs to run the command.

Anytime I run this command I type it as:

sudo koha-dump catalog

When prompted, I enter my Linux user account password because it has
sudo privileges.

If you don't know your library instance name, then run the command:

sudo koha-list

Your instance name (or instances if multiple are installed) will be
listed.

-Evan Stewart
Africa's Hope, USA

On Sun, Jul 10, 2022 at 8:43 PM Keith Sorbo  wrote:


I am attempting to move my library instance to a new server using the
koha-dump command

When I run the command, I get

Error: 'Access denied; you need (at least one of) the PROCESS
privilege(s)
for this operation' when trying to dump tablespaces

How can I correct this?

Keith
___

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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Site user lacks priviledges for koha-dump

[Mason James]

hi Keith

the following command shows the user's privs, for an instance called 'dev1'...
 mysql> SHOW GRANTS FOR 'koha_dev1'@'localhost'\G


the following command grants the required privs...
 mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, 
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, 
CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `koha_dev1`.* TO 
`koha_dev1`@`localhost`;


you'll need to replace 'dev1' with your instance's name



On 12/07/22 7:34 am, Keith Sorbo wrote:

I haven't yet figured out what privileges are needed.

On Mon, Jul 11, 2022 at 1:27 PM Evan Stewart 
wrote:


Hi Keith,

Thanks for the confirmation.  I'm surprised too that the Koha install
didn't get the higher privileges for the DB tables.  That's why I thought
it might be a Linux root issue because my Koha install gave privileges to
root for all MariaDB tables.

Were you able to solve the problem by granting more privileges to the
mysql user?

-Evan

On Mon, Jul 11, 2022 at 8:48 AM Keith Sorbo  wrote:


Thanks, Evan,

I am already running as root.

I looked at the script and it pulls the mysql username and password from
the library koha-config.xml.

I am rather surprised that during installation, the koha system did not
give sufficient grants to this user.

Keith

On Sun, Jul 10, 2022 at 11:28 PM Evan Stewart 
wrote:


Hi Keith,

Try using "sudo" with the command and include the instance name of the
library (For example, my library instance is named "catalog"). Sudo gives
your account the extra admin privileges it needs to run the command.

Anytime I run this command I type it as:

sudo koha-dump catalog

When prompted, I enter my Linux user account password because it has
sudo privileges.

If you don't know your library instance name, then run the command:

sudo koha-list

Your instance name (or instances if multiple are installed) will be
listed.

-Evan Stewart
Africa's Hope, USA

On Sun, Jul 10, 2022 at 8:43 PM Keith Sorbo  wrote:


I am attempting to move my library instance to a new server using the
koha-dump command

When I run the command, I get

Error: 'Access denied; you need (at least one of) the PROCESS
privilege(s)
for this operation' when trying to dump tablespaces

How can I correct this?

Keith
___

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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Debian koha-common_22.05.02-1_all.deb package dependencies conflict

[Mason James]

aah, ok
we recently removed the 'libmarc-file-xml-perl' package, as it became redundant

try the following commands...

 $ sudo apt remove libmarc-file-xml-perl
 $ sudo apt install koha-common


On 7/07/22 2:01 pm, Ska Man wrote:

Mason, we are currently running Koha version 22.05.00.

Scott


On Jul 6, 2022, at 8:51 PM, Mason James  wrote:

hi Scott
what koha version are you upgrading from?

i'm assuming 22.05.00 or 22.05.01?



On 7/07/22 5:03 am, skaman...@gmail.com wrote:
I am running an up-to-date version of Debian Buster.  Doing a routine "apt
update" today and I encountered the following package upgrade for
koha-common (koha-common_22.05.02-1_all.deb) that appears to have surfaced
in the past for others.

  
  
:[user]# apt upgrade -y


...

Preconfiguring packages ...

/tmp/koha-common.config.kjvlf5: 49: koha-list: not found

..

Unpacking libmarc-xml-perl (1.0.5-1) ...

dpkg: error processing archive
/tmp/apt-dpkg-install-E4Zp2O/1-libmarc-xml-perl_1.0.5-1_all.deb (--unpack):

trying to overwrite '/usr/bin/marc2xml', which is also in package
libmarc-file-xml-perl 1.0.5-1~koha+1



Errors were encountered while processing:

/tmp/apt-dpkg-install-sNNjK2/1-libmarc-xml-perl_1.0.5-1_all.deb

E: Sub-process /usr/bin/dpkg returned an error code (1)

  
  
 From past bug reports it appears there is a libmarc-xml-perl package in both

the Debian repo and the Koha repo.

  
I tried putting an apt hold on libmarc-xml-perl and then completing the apt

upgrade, but this breaks my koha system.  So, I'm unable to upgrade
koha-common at present.

  
Any suggestions to fix this would be helpful.


  
Scott Leafe


Scriptel Ministries

___

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] Debian koha-common_22.05.02-1_all.deb package dependencies conflict

[Mason James]

hi Scott
what koha version are you upgrading from?

i'm assuming 22.05.00 or 22.05.01?


On 7/07/22 5:03 am, skaman...@gmail.com wrote:

I am running an up-to-date version of Debian Buster.  Doing a routine "apt
update" today and I encountered the following package upgrade for
koha-common (koha-common_22.05.02-1_all.deb) that appears to have surfaced
in the past for others.

  

  


:[user]# apt upgrade -y

...

Preconfiguring packages ...

/tmp/koha-common.config.kjvlf5: 49: koha-list: not found

..

Unpacking libmarc-xml-perl (1.0.5-1) ...

dpkg: error processing archive
/tmp/apt-dpkg-install-E4Zp2O/1-libmarc-xml-perl_1.0.5-1_all.deb (--unpack):

trying to overwrite '/usr/bin/marc2xml', which is also in package
libmarc-file-xml-perl 1.0.5-1~koha+1



Errors were encountered while processing:

/tmp/apt-dpkg-install-sNNjK2/1-libmarc-xml-perl_1.0.5-1_all.deb

E: Sub-process /usr/bin/dpkg returned an error code (1)

  

  


 From past bug reports it appears there is a libmarc-xml-perl package in both
the Debian repo and the Koha repo.

  


I tried putting an apt hold on libmarc-xml-perl and then completing the apt
upgrade, but this breaks my koha system.  So, I'm unable to upgrade
koha-common at present.

  


Any suggestions to fix this would be helpful.

  


Scott Leafe

Scriptel Ministries

___

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] Koha packages are available 

[Mason James]

kia ora community,

the latest Koha packages are available (sorry for the late email)

an installation guide is below...
  https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason
___

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

Re: [Koha] How to update database from command line

[Mason James]

hi Keith
try the following command...

 $ sudo koha-upgrade-schema mykoha


On 1/07/22 2:03 pm, Keith Sorbo wrote:

What is the proper way to update my database from the command line?

When I run from the web interface, it times out and leaves me with an error
in my database.

Thanks.
___

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] After Koha update and auto_increment_fix database won't start

[Mason James]

try adding to line to the following file... then restart
  /etc/mysql/mariadb.conf.d/50-server.cnf


I followed the instructions in 
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solution
Probably I did something wrong when I added the line
  init-file=/var/lib/mysql/init-file_koha_fix.sql
at /etc/mysql/my.cnf. The instruction says to find the [mysqld] section in the 
file, but in my my.cnf file there is only one line that says:
!includedir /etc/mysql/conf.d


___

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

Re: [Koha] Difficulty installing

[Mason James]

this looks like your problem...
https://forums.raspberrypi.com/viewtopic.php?t=245073

try the following commands...

 $ sudo apt-get update --allow-releaseinfo-change
 $ sudo apt-get install koha-common



On 24/06/22 3:45 am, C.S. Hayward wrote:

Regarding your first question, stable version of Koha, and Debian 10.

Regarding your second email, did you mean "sudo apt-get install koha-common"?

Where is the preferred Koha pastebin? I've placed terminal output at 
https://cjshayward.com/wp-content/project/koha-attempt.txt because it may be 
long enough to break the 40k post size limit.


Br. C.S. Hayward

--- Original Message ---
On Wednesday, June 22nd, 2022 at 10:52 PM, Mason James  
wrote:



hi C.S

what version of koha are you installing? on what version of linux?


On 22/06/22 1:30 am, C.S. Hayward wrote:


On trying to install koha-common per 
https://wiki.koha-community.org/wiki/Koha_on_Debian:

E: Failed to fetch 
http://mirrors.linode.com/debian/pool/main/g/graphviz/libcdt5_2.40.1-6_amd64.deb:
 404 Not Found [IP: 2a01:7e00:1::b24f:af37 80]
E: Unable to fetch some packages; try '-o APT::Get::Fix-Missing=true' to 
continue with missing packages

root@technoluddites:~# aptitude -o APT::Get::Fix-Missing=true
root@technoluddites:~# cd /etc/koha
-bash: cd: /etc/koha: No such file or directory

When I ran the aptitude -o command, it pulled up a Lynx-style character 
graphics windowing system that looked somewhat complex.

If I should be using the windowing system, how can I fix missing dependencies?

Thanks,

Br. C.S. Hayward
___

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] Difficulty installing

[Mason James]

i'm assuming you are running deb10/buster

try the following 2 commands...

 $ sudo apt-get update
 $ sudo install koha-common


On 23/06/22 2:52 pm, Mason James wrote:

hi C.S

what version of koha are you installing? on what version of linux?


On 22/06/22 1:30 am, C.S. Hayward wrote:

On trying to install koha-common per 
https://wiki.koha-community.org/wiki/Koha_on_Debian:

E: Failed to fetch 
http://mirrors.linode.com/debian/pool/main/g/graphviz/libcdt5_2.40.1-6_amd64.deb:
 404  Not Found [IP: 2a01:7e00:1::b24f:af37 80]
E: Unable to fetch some packages; try '-o APT::Get::Fix-Missing=true' to 
continue with missing packages

root@technoluddites:~# aptitude -o APT::Get::Fix-Missing=true
root@technoluddites:~# cd /etc/koha
-bash: cd: /etc/koha: No such file or directory

When I ran the aptitude -o command, it pulled up a Lynx-style character 
graphics windowing system that looked somewhat complex.

If I should be using the windowing system, how can I fix missing dependencies?


Thanks,



Br. C.S. Hayward
___

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] Difficulty installing

[Mason James]

hi C.S

what version of koha are you installing? on what version of linux?


On 22/06/22 1:30 am, C.S. Hayward wrote:

On trying to install koha-common per 
https://wiki.koha-community.org/wiki/Koha_on_Debian:

E: Failed to fetch 
http://mirrors.linode.com/debian/pool/main/g/graphviz/libcdt5_2.40.1-6_amd64.deb:
 404  Not Found [IP: 2a01:7e00:1::b24f:af37 80]
E: Unable to fetch some packages; try '-o APT::Get::Fix-Missing=true' to 
continue with missing packages

root@technoluddites:~# aptitude -o APT::Get::Fix-Missing=true
root@technoluddites:~# cd /etc/koha
-bash: cd: /etc/koha: No such file or directory

When I ran the aptitude -o command, it pulled up a Lynx-style character 
graphics windowing system that looked somewhat complex.

If I should be using the windowing system, how can I fix missing dependencies?


Thanks,



Br. C.S. Hayward
___

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] [Koha-devel] Getting Koha 19.11 web installer when installing Koha 20.11.19

[Mason James]

hi Michael
oops, sorry about that

you can run the following commands to fix the problem...

 $ sudo apt-get update
 $ sudo apt-get upgrade koha-common

 $ sudo apt-cache show koha-common | grep Version
 Version: 20.11.19-3


On 4/06/22 4:56 am, Michael Kuhn wrote:

Hi

Today I was installing Koha 20.11.19 on a completely new virtual host using 
Debian 11.

 $ sudo cat /etc/apt/sources.list.d/koha.list
 deb http://debian.koha-community.org/koha 20.11 main
 $ sudo apt-get update
 $ sudo apt-cache show koha-common | grep Version
 Version: 20.11.19-1
 $ sudo apt-get install koha-common mariadb-server

In the output I see lines like:

 Get:16 http://debian.koha-community.org/koha 20.11/main amd64 
libcache-memcached-fast-safe-perl all 0.06-1~koha1 [7,410 B]
 Get:22 http://debian.koha-community.org/koha 20.11/main amd64 
libhttp-oai-3.27-perl all 3.27-1~koha+1 [92.7 kB]
 Get:16 http://debian.koha-community.org/koha 20.11/main amd64 
libcache-memcached-fast-safe-perl all 0.06-1~koha1 [7,410 B]
 Get:22 http://debian.koha-community.org/koha 20.11/main amd64 
libhttp-oai-3.27-perl all 3.27-1~koha+1 [92.7 kB]
 Get:36 http://debian.koha-community.org/koha 20.11/main amd64 
libmojolicious-perl all 9.90+really8.12-koha1 [794 kB]
 Get:75 http://debian.koha-community.org/koha 20.11/main amd64 
libjson-validator-perl all 5.99+really3.14-koha1 [54.2 kB]
 Get:85 http://debian.koha-community.org/koha 20.11/main amd64 
libmojolicious-plugin-openapi-perl all 5.99+really2.16-koha1 [57.1 kB]
 Get:88 http://debian.koha-community.org/koha 20.11/main amd64 
libpdf-fromhtml-perl all 0.31-1~koha1 [102 kB]
 Get:98 http://debian.koha-community.org/koha 20.11/main amd64 
libtemplate-plugin-htmltotext-perl all 0.03-1koha1 [6,134 B]
 Get:99 http://debian.koha-community.org/koha 20.11/main amd64 koha-common all 
20.11.19-1 [34.5 MB]
 Preparing to unpack .../523-koha-common_20.11.19-1_all.deb ...
 Unpacking koha-common (20.11.19-1) ...
 Setting up koha-common (20.11.19-1) ...

However after the installation when calling the web installer it annoyingly greets me 
saying "Welcome to the Koha 19.11 web installer"!

Can someone please explain what is going wrong here?

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha-devel mailing list
koha-de...@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/


___

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

[Koha] Koha 22.05 packages are available 

[Mason James]

kia ora community,

the latest Koha 22.05 packages are available

an installation guide is below...
  https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason


On 28/05/22 11:41 am, Fridolin SOMERS wrote:

Hello everyone 珞

The Koha community is proud to announce the release of Koha 22.05.00.

It is a major release, that comes with 6 new features, 239 enhancements, 360 
bugfixes 者

The full release notes are available here:
https://koha-community.org/koha-22-05-released/

Debian packages should be available soon 

It has been a great pleasure to be your captain for this 6 months journey.
Best regards 邏



___

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

Re: [Koha] How to upgrade?

[Mason James]

hi Toni
what does the output from the following command say?

$ sudo apt update && apt policy koha-common


On 3/05/22 8:00 pm, Toni Afandi wrote:

I am trying to upgrade my koha version from 20.11.11.000 to the latest
updated version with this commands :

$ sudo apt-get update

$ sudo apt-get upgrade$ sudo apt-get update
$ sudo apt-get upgrade

But after I ran those commands, I saw no changes. It is still version
20.11.11.000.
What am I doing wrong?

My koha was installed  with instructions in
https://wiki.koha-community.org/wiki/Koha_on_Debian

Thank you in advance,

*Toni Afandi*
*Librarian*
*(Southeast Asia Bible Seminary)*
___

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] Koha releases are available 

[Mason James]

kia ora community,

the latest Koha packages are available

an installation guide is below...
https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason
___

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

Re: [Koha] Initial difficulties installing Koha via packages per wiki instructions

[Mason James]

hi C.S

you can confirm the package was installed ok using the following command...

 $ dpkg -s koha-common | grep Status
 Status: install ok installed


you can ignore the following line, its a common systemd warning...
 'Failed to enable unit: Unit /run/systemd/generator.late/koha-common.service 
is transient or generated.'


On 13/04/22 5:39 am, C.S. Hayward wrote:

I've attemptedly run through the installation script, and it appeared to run to 
completion, but with errors. A script, run through a Linux 'cat -v', was too 
large to post to the list but is available online at 
https://cjshayward.com/wp-content/project/script-expanded.txt.

How much or little success is reflected in that?

--- Original Message ---
On Friday, April 8th, 2022 at 10:32 AM, Tomas Cohen Arazi 
 wrote:



Oh you mentioned Jessie, which is unsupported entirely. Go for Buster and 
higher.
El vie, 8 abr 2022 13:31, C.S. Hayward  escribió:


I have tried to install Koha from the command line on a Jessie VPS, and have 
run into errors relating to certificates.

I would appreciate any help; a copy-paste of my first attempt is as follows:

Linux technoluddites.org 4.19.0-9-amd64 #1 SMP Debian 4.19.118-2+deb10u1 
(2020-06-07) x86_64

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
You have new mail.
Last login: Wed Apr 6 16:20:33 2022 from 73.147.143.7
root@technoluddites:~# echo 'deb http://debian.koha-community.org/koha stable 
main' | sudo tee /etc/apt/sources.list.d/koha.list
deb http://debian.koha-community.org/koha stable main
root@technoluddites:~# aptitude update
Get: 1 http://mirrors.linode.com/debian-security buster/updates InRelease [65.4 
kB]
Get: 2 http://mirrors.linode.com/debian buster-updates InRelease [51.9 kB]
Get: 3 http://mirrors.linode.com/debian buster InRelease [122 kB]
Get: 4 http://debian.koha-community.org/koha stable InRelease [69.8 kB]
Err http://debian.koha-community.org/koha stable InRelease
The following signatures couldn't be verified because the public key is not 
available: NO_PUBKEY 3C9356BBA2E41F10
Ign https://packages.sury.org/php buster InRelease
Err https://packages.sury.org/php buster Release
Certificate verification failed: The certificate is NOT trusted. The 
certificate chain uses expired certificate. Could not handshake: Error in the 
certificate verification. [IP: 195.181.164.178 443]
Fetched 309 kB in 2s (199 kB/s)
E: Repository 'http://mirrors.linode.com/debian-security buster/updates 
InRelease' changed its 'Suite' value from 'stable' to 'oldstable'
E: Repository 'http://mirrors.linode.com/debian buster-updates InRelease' 
changed its 'Suite' value from 'stable-updates' to 'oldstable-updates'
E: Repository 'http://mirrors.linode.com/debian buster InRelease' changed its 
'Suite' value from 'stable' to 'oldstable'
W: GPG error: http://debian.koha-community.org/koha stable InRelease: The 
following signatures couldn't be verified because the public key is not 
available: NO_PUBKEY 3C9356BBA2E41F10
E: The repository 'http://debian.koha-community.org/koha stable InRelease' is 
not signed.
E: The repository 'https://packages.sury.org/php buster Release' no longer has 
a Release file.
E: Failed to download some files
W: Failed to fetch http://mirrors.linode.com/debian/dists/buster/InRelease:
W: Failed to fetch 
http://mirrors.linode.com/debian-security/dists/buster/updates/InRelease:
W: Failed to fetch 
http://mirrors.linode.com/debian/dists/buster-updates/InRelease:
W: Failed to fetch 
http://debian.koha-community.org/koha/dists/stable/InRelease: The following 
signatures couldn't be verified because the public key is not available: 
NO_PUBKEY 3C9356BBA2E41F10
W: Failed to fetch https://packages.sury.org/php/dists/buster/Release: 
Certificate verification failed: The certificate is NOT trusted. The 
certificate chain uses expired certificate. Could not handshake: Error in the 
certificate verification. [IP: 195.181.164.178 443]
E: Some index files failed to download. They have been ignored, or old ones 
used instead.

root@technoluddites:~# $ echo 'deb http://debian.koha-community.org/koha 21.11 
main' | sudo tee /etc/apt/sources.list.d/koha.list
-bash: $: command not found
root@technoluddites:~# echo 'deb http://debian.koha-community.org/koha 21.11 
main' | sudo tee /etc/apt/sources.list.d/koha.list
deb http://debian.koha-community.org/koha 21.11 main
root@technoluddites:~# aptitude update
Get: 1 http://debian.koha-community.org/koha 21.11 InRelease [69.8 kB]
Err http://debian.koha-community.org/koha 21.11 InRelease
The following signatures couldn't be verified because the public key is not 
available: NO_PUBKEY 3C9356BBA2E41F10
Get: 2 http://mirrors.linode.com/debian buster InRelease [122 kB]
Get: 3 http://mirrors.linode.com/debian-security 

Re: [Koha] Database upgrade problems from KOHA 19.05 to KOHA 21.11

[Mason James]

hi Harald

try the following commands...

$ sudo /etc/init.d/memcached restart
$ sudo koha-upgrade-schema myinstance

if it fails, it should show some errors


On 31/03/22 11:15 pm, Harald Schaefer wrote:

Dear all,

now I am promoted from a plain KOHA user to the system administrator of the 
computer hosting a KOHA installation of a railway museum in Germany.

My first task was to upgrade the system from Ubuntu 16.04 to 20.04 and 
upgrading the KOHA system. I have tried this first twice on some local copies. 
In the test runs the database upgrade works fine.

In the update run of the production system it stops at this point:

Upgrade to 20.12.00.049  [19:01:13]: Bug 28108 - Move action logs 'SERIAL 
CLAIM' and 'ACQUISITION CLAIM' to a new 'CLAIMS' module
Upgrade to 20.12.00.050  [19:01:13]: Bug 28108 - Add new systempreference 
OpacHiddenItemsHidesRecord
Upgrade to 21.05.00.000  [19:01:13]: Koha 21.05.00 release

Log started: 2022-03-29  19:04:34 # some other program

In thetest runs it continues

Upgrade to 21.05.00.000  [17:49:33]: Koha 21.05.00 release
Upgrade to 21.06.00.000  [17:49:33]: Increase DBRev for 21.06
    Run, rabbit run. 
   Dig that hole, forget the sun,
   And when at last the work is done
   Don't sit down it's time to dig another one.

Is there any way to continue the database upgrade? I have other applications 
running on the system and I do not want to start the complete upgrade process 
again.

It seems that the not executed scripts are in 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs

Basically the upgraded KOHA is running.

Best regards Harald



___

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

[Koha] Koha releases are available 

[Mason James]

kia ora community,

the latest Koha packages are available

installation guide is below...
 https://wiki.koha-community.org/wiki/Koha_on_Debian


cheers, Mason
___

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

[Koha] Switching Koha to ElasticSearch... any problems?

[Mason James]

hi Folks
does anyone have any experience running Koha with ES?

i've done some basic testing (on 20.11) - it seems to work well and its speed 
is impressive! (濾 + )

- is it generally safe to run in production?
- any major problems, or missing areas of functionality?


any advice or info would be welcomed

cheers, Mason
___

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

Re: [Koha] Timeout Errors During Installation of Koha 21.11

[Mason James]

hi Charles

it looks like a general 'internet is glitchy' problem
you could try editing your /etc/apt/sources.list file - to use a japan mirror 
(or other)

https://www.debian.org/mirror/
https://www.debian.org/mirror/list
http://ftp.jp.debian.org/debian/


dont forget to run 'apt-get update' after you change mirrors :)


On 10/03/22 1:53 pm, Charles Kelley wrote:

Hello, all!

 In the last few days, I have tried to install Koha v. 21.11. In
response to the command

# apt-get install koha-common

 At the end of installing Koha, we see timeout errors or plugin errors;
see below.

Failed to fetch
http://deb.debian.org/debian/pool/main/g/gcc-10/g%2b%2b-10_10.2.1-6_amd64.deb
  Connection timed out [IP: ...]
Failed to fetch
http://deb.debian.org/debian/pool/main/r/rabbiting-server/rabbiting-server_3.8.9-3_all.deb
  Connection timed out [IP: ...]

Unable to fetch some archives, maybe run apt-get update or try with
--fix-missing?

 Are these errors important, critical, crucial, etc.? Do we have to be
concerned about them?

 Many thanks, all.




___

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

Re: [Koha] Koha Upgrade Error 21.11

[Mason James]

hi folks
i added a test for this problem here...

 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19169


On 5/03/22 8:05 am, Fridolin SOMERS wrote:

Ohhh good catch

DEV atomic updates should not exist in releases.

I've added a comment on Bug report :
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29596#c16

Best regards,

Le 03/03/2022 à 21:28, Chief Librarian, SAIACS a écrit :

Hi Friends
I was testing
koha (on ubuntu 20.04) upgrade from 21.05 throws an error as
mentioned below.
Kindly advise me, should i downgrade the koha. I have a backup of the
database on koha 21.05. Your insights would be appreciated.

Atomic updates:

    - DEV atomic update
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/
    bug_29596.pl [11:31:16]: Bug 29596 - Add Yiddish language

Update errors :

    - Upgrade to 21.11.02.003 [11:31:16]: Bug 29605 - Resync DB structure
    for existing installations
    ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate
    entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 738

Thanks

__

*Dr. Yesan Sellan, * *MLISc., PGDLAN, BCS., UGC-NET., PhD*


*Strategic | Learner | Achiever | Responsibility | Intellection*


*Chief Librarian*

South Asia Institute of Advanced Christian Studies (SAIACS)

363 Dodda Gubbi Cross Road, Kothanur P.O., Bangalore 77, India

Phone: 91 80 2846 5235/5344/ 5649, Fax: 91 80 28465412, Mobile:
91-9972348251

www.saiacs.org Alternative Email: yes...@gmail.com

https://orcid.org/-0002-0501-5661




__

IMPORTANT : This message is intended only for the addressee. It may contain
confidential information. Any unauthorized disclosure is strictly
prohibited. If you have received this message in error, please notify us
immediately so that we may correct our internal records. Please then delete
the original message. Thank you.



P Please consider the environment before printing this email*.*
___

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] Koha releases are available 

[Mason James]

kia ora community,

the latest Koha packages and tarballs are ready

release notes are here...
  https://koha-community.org/koha-21-11-03-released
  https://koha-community.org/koha-21-05-11-released
  https://koha-community.org/koha-20-11-15-released
  https://koha-community.org/koha-19-11-26-released


cheers, Mason
___

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

[Koha] Koha 21.05.10 package is available 

[Mason James]

kia ora community,
the Koha 21.05.10 package is available

cheers, Mason

On 10/02/22 7:17 am, Andrew Fuerste-Henry wrote:

Hello Koha!
The Koha community is proud to announce the release of version 21.05.10.
This is a maintenance release to correct an error in 21.05.09.

You can see the release notes here: 
https://koha-community.org/koha-21-05-10-released/

Or you can see the bug detailing the error here: 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30065

Thanks!
Andrew
--
Andrew Fuerste-Henry
Educator
(he/they)
ByWater Solutions
bywatersolutions.com 
Phone:(888)900-8944 

What is Koha?


___
Koha-devel mailing list
koha-de...@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/


___

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

Re: [Koha] Restarting Indexing -- Maybe Reindexing Altogether

[Mason James]

hi Charles

you are looking for the following 4 commands

 sudo koha-indexer --status  mykoha

 sudo koha-indexer --stop  mykoha
 sudo koha-indexer --start  mykoha
 sudo koha-indexer --restart  mykoha

https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-indexer


On 10/02/22 5:53 pm, Charles Kelley wrote:

Hi, all!

 My library's system has stopped indexing new records. Case in point: I
added Starlog to our catalog, and five ours later, it still does not appear
when searched. We've also added a few more authority headings, but several
hours later, they too cannot be found.

 So is it possible to restart the indexing? Failing that, is is possible
to reindex the entire catalog? I'd like to learn this now before we upgrade
to 20.05 or 20.11 this spring or summer.

 Many thanks.

P. S. Running Koha 19.05 on Debian 9 "Buster".

 (When we upgrade to 20.XX, we'll also upgrade to Debian 10 or 11.)



___

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

[Koha] Koha SECURITY releases are available 

[Mason James]

kia ora community,
we have some Koha SECURITY releases this month

the latest Koha packages and tarballs are ready

release notes are here...
 https://koha-community.org/koha-21-11-02-released
 https://koha-community.org/koha-21-05-09-released
 https://koha-community.org/koha-20-11-14-released
 https://koha-community.org/koha-19-11-25-released


cheers, Mason
___

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

[Koha] Koha packages are available 

[Mason James]

kia ora community,
the latest Koha packages are available

cheers, Mason
___

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

Re: [Koha] Branch library list empty

[Mason James]

hi David,
the system has a version of libjson-validator-perl, thats too new for koha

it's probably manually been built/installed, via the cpan2deb tool?

try the following to fix the problem...

$ sudo apt update; sudo apt upgrade libjson-validator-perl


and confirm with...

$ apt-cache policy libjson-validator-perl
libjson-validator-perl:
  Installed: 5.99+really3.14-koha1
  Candidate: 5.99+really3.14-koha1
  Version table:
 *** 5.99+really3.14-koha1 500
    500 http://debian.koha-community.org/koha 20.11/main amd64 Packages


On 15/12/21 5:23 am, David Liddle wrote:

Thank you for the informative tip, Manos. For other readers, the summary is 
that the problem may be caused  by the installation of an unacceptable version 
of a particular Perl module, JSON::Validator. What I find on our own server is 
the following:

# sudo cpan -D JSON::Validator
JSON::Validator
-
 (no description)
 J/JH/JHTHORSEN/JSON-Validator-5.04.tar.gz
 /usr/share/perl5/JSON/Validator.pm
 Installed: 5.02
 CPAN:  5.04  Not up to date
 Jan Henning Thorsen (JHTHORSEN)
 jhthor...@cpan.org

#  apt-cache policy libjson-validator-perl
libjson-validator-perl:
   Installed: 5.02-1
   Candidate: 5.02-1
   Version table:
  *** 5.02-1 100
 100 /var/lib/dpkg/status
  4.99.1+really3.14-koha3 500
 500 http://debian.koha-community.org/koha oldoldstable/main amd64 
Packages
  3.06+dfsg-1 500
 500 http://mirrors.digitalocean.com/debian buster/main amd64 Packages

Note the version contained in the Koha repository. If the version of this 
module is indeed the problem, I have to admit that I'm not sure how to go about 
forcing the installation of the correct one—Manos' solution in the GUI's 
package manager won't work in this server environment. It's a production 
instance, so I have to tread lightly. Again, my thanks go out to all readers 
and contributors!
___

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] [EXTERNAL] Re: Problem upgrading to 21.05: perlapi-5-24.1 is not available

[Mason James]

hi Fred
if you are running an "older" version of debian/ubuntu, follow the info on 
section 2.1.2.3 here...

 https://wiki.koha-community.org/wiki/Koha_on_Debian

 2.1.2.3 Support for Koha on older versions of Debian/Ubuntu (Debian 8, Ubuntu 
18.04, Ubuntu 16.04)

example...
$ echo 'deb http://debian.koha-community.org/koha 21.05 main xenial' | sudo tee 
/etc/apt/sources.list.d/koha.list


On 10/12/21 8:46 am, King, Fred wrote:

Hi Mason,

Thanks for the reply! Some of the settings in my Koha setup are considerably 
different from yours. I should have added that I'm running my instance on a 
Digital Ocean 64-bit cloud server, and I'm on Ubuntu 18.04, not 20.04 as I 
thought. Do you think it might be easier for me to set up a fresh instance and 
export everything from the old system with sqldump? It might be faster, but it 
would still leave a puzzle...

The upgradable but held back files are these--all of them depend on the 
mysterious and elusive perlapi-5.24.1:

koha-common/oldstable 21.05.07-1 all [upgradable from: 20.11.04-1]
libcryptx-perl/oldstable 0.063-1~bpo9+1 amd64 [upgradable from: 0.059-1~koha2]
libmojolicious-plugin-openapi-perl/oldstable 4.98+really2.16-koha1 all 
[upgradable from: 1.15-1~kohadev1]

Here's what I got, with the //*differences from your settings shown like 
this*//.

--Fred

# arch
x86.64

#lsb_release -a
LSB Version:core-9.20170808ubuntu1-noarch:security-9.20170808ubuntu1-noarch 
//*No LSB modules are available.*//
Distributor ID: Ubuntu
Description:Ubuntu 18.04.6 LTS //*Ubuntu 20.04.3 LTS*//
Release:18.04 //*20.04*//
Codename:   bionic

# cat /etc/apt/sources.list.d/koha.list
deb http(colon)//debian(dot}koha-community(dot)org/koha 21.05 main

# sudo apt-get update
[checking repositories]
Fetched 4593 kB in 1s
Reading package lists... Done

# apt-cache policy koha-common
Installed: 20.11.04.1 //*21.05.07-1*//
Candidate: 21.05.07.1
Version table:
21.05.07-1
   500 http(colon)//debian(dot)koha-community(dot)org/koha 21.05/main amd64 
Packages
*** 20.11.04-1 100 //*not in your version*//
   100 /var/lib/dpkg/status

# apt-cache policy libyaml-libyaml-perl
libyaml-libyaml-perl:
Installed: (none) //*0.81+repack-1*//
Candidate: 0.76+repack-1~bpo9+1 //*0.81+repack-1*//
Version table:
   0.76+repack-1~bpo9+1 500 // 0.81+repack-1 500*//
  500 http(colon)//debian(dot)koha-community(dot)org/koha 21.05/main 
amd64 Packages
   0.69+repack-1 500 //*not in your version*//
  500 http(colon)//mirrors(dot)digitalocean(dot)com/ubuntu bionic/main 
amd64 Packages

Fred King, MSLS, AHIP
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net
202-877-6670
ORCID -0001-5266-0279
MedStar Authors Catalog: http://medstarauthors.org

I don't know much about being a millionaire, but I'll bet I'd be darling at it.
--Dorothy Parker

-Original Message-----
From: Mason James 
Sent: Wednesday, December 08, 2021 8:49 PM
To: King, Fred ; koha 
Subject: [EXTERNAL] Re: [Koha] Problem upgrading to 21.05: perlapi-5-24.1 is 
not available



**ATTENTION: This email originated from outside the MedStar Health network.
  ** DO NOT CLICK links or attachments unless you recognize the sender and know 
the content is safe.

  


hi Fred
if you are attempting to upgrade to 21.05/olstable - your 'Candidate' values 
should match those below...



$ arch
x86_64

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal

$ cat /etc/apt/sources.list.d/koha.list
deb 
https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!!D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNdyIu3aCg$
  21.05  main

$ sudo apt-get update

$ apt-cache policy koha-common
koha-common:
    Installed: 21.05.07-1
    Candidate: 21.05.07-1 <<<<<<<<<<
    Version table:
   *** 21.05.07-1 500
      500 
https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!!D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNdyIu3aCg$
  21.05/main amd64 Packages
      100 /var/lib/dpkg/status

$ apt-cache policy libyaml-libyaml-perl
libyaml-libyaml-perl:
    Installed: 0.81+repack-1
    Candidate: 0.81+repack-1 <<<<<<<<<<
    Version table:
   *** 0.81+repack-1 500
      500 
https://urldefense.com/v3/__http://archive.ubuntu.com/ubuntu__;!!D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNdB6jCbYg$
  focal/main amd64 Packages
      100 /var/lib/dpkg/status
   0.76+repack-1~bpo9+1 500
      500 
https://urldefense.com/v3/__http://debian.koha-community.org/koha__;!!D7IIWT94AA!rYcoa-kZ0oxaWfpLR7VjA438fpKolfFI02zJAhnHElBKdtvVuWM-rFpdUNdyIu3aCg$
  21.05/main amd64 Packages


On 9/12/21 5:06 am, King, Fred wrote:

Esteemed Colleagues,

I'm trying to upgrade my Koha instance from 20.11.01.000 to 21.05

Re: [Koha] Problem upgrading to 21.05: perlapi-5-24.1 is not available

[Mason James]

also, make sure you are *not* using a 32-bit version of ubuntu - as many 
required packages for Koha are unavailable

 https://wiki.ubuntu.com/i386
 
https://ubuntu.com/blog/statement-on-32-bit-i386-packages-for-ubuntu-19-10-and-20-04-lts

32-bit debian looks to be ok, but we currently have no jenkins/CI to confirm 
this :0)


On 9/12/21 2:49 pm, Mason James wrote:

hi Fred
if you are attempting to upgrade to 21.05/olstable - your 'Candidate' values 
should match those below...



$ arch
x86_64

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal

$ cat /etc/apt/sources.list.d/koha.list
deb http://debian.koha-community.org/koha 21.05  main

$ sudo apt-get update

$ apt-cache policy koha-common
koha-common:
  Installed: 21.05.07-1
  Candidate: 21.05.07-1 <<<<<<<<<<
  Version table:
 *** 21.05.07-1 500
    500 http://debian.koha-community.org/koha 21.05/main amd64 Packages
    100 /var/lib/dpkg/status

$ apt-cache policy libyaml-libyaml-perl
libyaml-libyaml-perl:
  Installed: 0.81+repack-1
  Candidate: 0.81+repack-1 <<<<<<<<<<
  Version table:
 *** 0.81+repack-1 500
    500 http://archive.ubuntu.com/ubuntu focal/main amd64 Packages
    100 /var/lib/dpkg/status
 0.76+repack-1~bpo9+1 500
    500 http://debian.koha-community.org/koha 21.05/main amd64 Packages


On 9/12/21 5:06 am, King, Fred wrote:

Esteemed Colleagues,

I'm trying to upgrade my Koha instance from 20.11.01.000 to 21.05, or 21.11 if 
I can't do oldstable. I'm running it on Ubuntu 20.04LTS.

Short description: the upgrade appears to need perlapi-5-24.1, but it's not 
available.

Long description, my input is in (parentheses); system response is indented in 
courier:
(while upgrading)
E: Repository 'http://debian.koha-community.org/koha stable InRelease' changed 
its 'Codename' value from '20.11' to '21.11'
N: This must be accepted explicitly before updates for this repository can be 
applied. See apt-secure(8) manpage for details.
(so I typed: echo 'deb http://debian.koha-community.org/koha 21.05 main' | sudo 
tee /etc/apt/sources.list.d/koha.list)
(I also tried the above with 21.11)
(apt-get install koha-common)
koha-common: Depends: libyaml-libyaml-perl but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
(apt-get install libyaml-libyaml-perl)
The following packages have unmet dependencies:
   libyaml-libyaml-perl : Depends: perlapi-5.24.1 but it is not installable
E: Unable to correct problems, you have held broken packages.
(apt-get install perlapi-5.24.1)
Package perlapi-5-24.1 is not available, but it is referenced to by another 
package.
This may mean that the package is missing, has been obsoleted, or is only 
available from another source
E: Package 'perlapi-5.24.1 has no installation candidate
(locate perlapi)
/usr/share/perl/5.26.1/pod/perlapi.pod (and a few others)

I've searched the Wiki, Google, and elsewhere, but I haven't found an answer. 
However, I've been working mostly in my basement and have a bad case of 
Basement Brain. Could someone point me towards a solution?

Thanks,

Fred King, MSLS, AHIP
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net<mailto:fred.k...@medstar.net>
202-877-6670
ORCID -0001-5266-0279
MedStar Authors Catalog: http://medstarauthors.org

I don't know much about being a millionaire, but I'll bet I'd be darling at it.
--Dorothy Parker

--
MedStar Health is a not-for-profit, integrated healthcare delivery system, the 
largest in Maryland and the Washington, D.C., region. Nationally recognized for 
clinical quality in heart, orthopedics, cancer and GI.

IMPORTANT: This e-mail (including any attachments) may contain information that 
is private, confidential, or protected by attorney-client or other privilege. 
If you received this e-mail in error, please delete it from your system without 
copying it and notify sender by reply e-mail, so that our records can be 
corrected... Thank you.

Help conserve valuable resources - only print this email if necessary.


___

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] Problem upgrading to 21.05: perlapi-5-24.1 is not available

[Mason James]

hi Fred
if you are attempting to upgrade to 21.05/olstable - your 'Candidate' values 
should match those below...



$ arch
x86_64

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal

$ cat /etc/apt/sources.list.d/koha.list
deb http://debian.koha-community.org/koha 21.05  main

$ sudo apt-get update

$ apt-cache policy koha-common
koha-common:
  Installed: 21.05.07-1
  Candidate: 21.05.07-1 <<
  Version table:
 *** 21.05.07-1 500
    500 http://debian.koha-community.org/koha 21.05/main amd64 Packages
    100 /var/lib/dpkg/status

$ apt-cache policy libyaml-libyaml-perl
libyaml-libyaml-perl:
  Installed: 0.81+repack-1
  Candidate: 0.81+repack-1 <<
  Version table:
 *** 0.81+repack-1 500
    500 http://archive.ubuntu.com/ubuntu focal/main amd64 Packages
    100 /var/lib/dpkg/status
 0.76+repack-1~bpo9+1 500
    500 http://debian.koha-community.org/koha 21.05/main amd64 Packages


On 9/12/21 5:06 am, King, Fred wrote:

Esteemed Colleagues,

I'm trying to upgrade my Koha instance from 20.11.01.000 to 21.05, or 21.11 if 
I can't do oldstable. I'm running it on Ubuntu 20.04LTS.

Short description: the upgrade appears to need perlapi-5-24.1, but it's not 
available.

Long description, my input is in (parentheses); system response is indented in 
courier:
(while upgrading)
E: Repository 'http://debian.koha-community.org/koha stable InRelease' changed 
its 'Codename' value from '20.11' to '21.11'
N: This must be accepted explicitly before updates for this repository can be 
applied. See apt-secure(8) manpage for details.
(so I typed: echo 'deb http://debian.koha-community.org/koha 21.05 main' | sudo 
tee /etc/apt/sources.list.d/koha.list)
(I also tried the above with 21.11)
(apt-get install koha-common)
koha-common: Depends: libyaml-libyaml-perl but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
(apt-get install libyaml-libyaml-perl)
The following packages have unmet dependencies:
   libyaml-libyaml-perl : Depends: perlapi-5.24.1 but it is not installable
E: Unable to correct problems, you have held broken packages.
(apt-get install perlapi-5.24.1)
Package perlapi-5-24.1 is not available, but it is referenced to by another 
package.
This may mean that the package is missing, has been obsoleted, or is only 
available from another source
E: Package 'perlapi-5.24.1 has no installation candidate
(locate perlapi)
/usr/share/perl/5.26.1/pod/perlapi.pod (and a few others)

I've searched the Wiki, Google, and elsewhere, but I haven't found an answer. 
However, I've been working mostly in my basement and have a bad case of 
Basement Brain. Could someone point me towards a solution?

Thanks,

Fred King, MSLS, AHIP
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net
202-877-6670
ORCID -0001-5266-0279
MedStar Authors Catalog: http://medstarauthors.org

I don't know much about being a millionaire, but I'll bet I'd be darling at it.
--Dorothy Parker

--
MedStar Health is a not-for-profit, integrated healthcare delivery system, the 
largest in Maryland and the Washington, D.C., region. Nationally recognized for 
clinical quality in heart, orthopedics, cancer and GI.

IMPORTANT: This e-mail (including any attachments) may contain information that 
is private, confidential, or protected by attorney-client or other privilege. 
If you received this e-mail in error, please delete it from your system without 
copying it and notify sender by reply e-mail, so that our records can be 
corrected... Thank you.

Help conserve valuable resources - only print this email if necessary.


___

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] Koha packages are available 

[Mason James]

kia ora community,
the latest Koha packages are available

cheers, Mason
___

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

Re: [Koha] Email configuration reg

[Mason James]

hi Chitti
here is a guide i have used to configure email with postfix/gmail successfully

 https://kifarunix.com/configure-postfix-to-use-gmail-smtp-on-ubuntu-20-04/


On 24/11/21 7:18 am, Tomas Cohen Arazi wrote:

If Koha is not throwing an error, it means the emails are being handed to
the SMTP server listening in localhost:25 (i.e. your Postfix server).

So you are asking about email delivery problems/Postfix configuration
issues, not  specifically Koha-side.

My suggestion is you check the logs (/var/log/mail*) and also use some tool
like mutt to check the root user inbox for bounces to get more information.

El lun, 22 nov 2021 a las 7:27, Chitti Babu B ()
escribió:


Respected Sir,
Iam Chitti Babu B,Librarian,J.H.A Agarsen College,Chennai,Tamil
Nadu,India.i had installed Koha latest version on Linux Ubuntu.i wanted to
send email alerts to my patrons for books which are overdue.we don`t have
an email server.We installed POSTFIX.We tried to configure email in our
server.It says email sent to patron.Bit when we checked in th inbox and
spam there is no email.Source mail id is created for Library using
GMAlL.Recepient email is also GMAIL.I need your help.Kindly guide to fix
the problem.Also tell the proper steps to be followed for email
configuration.

Thanking You.

Yours truly,
B Chitti Babu.
___

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] Web install issue with 21.05.05.000

[Mason James]

hi folks

i've pushed a new package, that should fix this issue


On 31/10/21 11:46 am, Bruce Yelen wrote:

Hi Katrin,

Many thanks.  I applied the update as stated in the bug report, and all appears 
to be well.  I promise to do a better job next time of searching the bug 
database.

- Bruce

-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Saturday, October 30, 2021 4:09 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Web install issue with 21.05.05.000

Hi Bruce,

please see *Bug 29378*
 for a 
temporary workaround. Packages will be fixed as soon as possible.

Katrin

On 31.10.21 00:05, Bruce Yelen wrote:

I just upgraded my test system from 21.05.04.003 to 21.05.05.000 using
the Debian package.  After the web installer updates the database, it
returns the message "Everything went okay.  Update done.  However when
clicking "Continue to log in to Koha", you're immediate taken to the
"Web installer > Check Perl dependencies" screen again, and the entire
process repeats.  If I exit the web browser, and go back in, I'm taken
to the "Welcome to the Koha
21.05 web installer" screen again, asking for the library.koha user
and master password.  So, while obviously a bug, what would be the
proper action at this point?  Should I run the script
"koha-upgrade-schema" to try and set things to normal?



And again, an object lesson to always try out upgrades in test prior
to touching your live production system!



Thanks!



Bruce

___

Koha mailing listhttp://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 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] Koha packages are available 

[Mason James]

kia ora community,
the latest Koha packages are available

cheers, Mason
___

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

Re: [Koha] after upgrade koha from 3.22 to 19.05 zebra doesn't work in cron

[Mason James]

On 29/10/21 1:48 am, George Mikuchadze wrote:

I've successfully upgraded koha from version 3.22.21 to version 19.05.17
(in ubuntu 18.04 server) using only the tarball file because v3.22.21 was
also installed from the tarball. I didn't use any koha repository during
its installation/upgrade and therefore I don't have any "koha-common"
service/package!.


hi George

you should install koha 19.05.17 using the packages, to fix your problem

more info here... https://wiki.koha-community.org/wiki/Koha_on_Debian


$ echo 'deb http://debian.koha-community.org/koha 19.05 main bionic' | sudo tee 
/etc/apt/sources.list.d/koha.list
$ sudo apt-get update

$ apt-cache policy koha-common
koha-common:
  Installed: (none)
  Candidate: 19.05.17-1
  Version table:
 *** 19.05.17-1 500
500 http://debian.koha-community.org/koha 19.05/main amd64 Packages
100 /var/lib/dpkg/status

$ sudo apt install koha-common


___

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

Re: [Koha] zebra utility after koha upgrade

[Mason James]

hi George
you should not need to manually add any cronjob for indexing,

in newer koha versions (like 19.05) the indexing is handled automatically



if you are having problems with indexing, its possibly due to incorrect zebradb 
file/dir permissions

check in /var to confirm that the instance's zebra files/dirs are correctly 
owned by it's koha user

___

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

Re: [Koha] zebra utility after koha upgrade

[Mason James]

On 28/10/21 2:43 am, George Mikuchadze wrote:

After successful upgrading koha from v3.22.21 to v19.05.17 zebra indexer
doesn't work in the crontab.
I have the following cronjobs:
PERL5LIB=/usr/share/koha/lib
*/5 * * * * KOHA_CONF=/etc/koha/koha-conf.xml
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -z >/dev
but after 5 minutes od adding new biblioitems they are not searched.
If I run the command in the shell:
$ KOHA_CONF=/etc/koha/koha-conf.xml /usr/share/koha/bin/migration_tools/
rebuild_zebra.pl -b -a -z >/dev
the new biblioitems are appearing in serch results.
Can anybody help me to set up a crontab for the zebra rebuild utility?
___

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


hi George
you should not need to manually add any cronjob for indexing,

in newer koha versions (like 19.05) the indexing is handled automatically


you should see 2x 'daemon' jobs per koha instance.
 1 job for zebra searching, 1 job for zebra indexing


# /etc/init.d/koha-common status
● koha-common.service - LSB: Start required services for each Koha instance
   Loaded: loaded (/etc/init.d/koha-common; generated)
   Active: active (running) since Thu 2021-10-28 03:05:50 UTC; 3min 13s ago
 Docs: man:systemd-sysv-generator(8)
    Tasks: 4 (limit: 3394)
   Memory: 152.1M
   CGroup: /system.slice/koha-common.service
   ├─29544 daemon --name=dev1-koha-zebra --pidfiles=/var/run/koha/dev1/ 
--errlog=/var/log/koha/dev1/zebra-error.log 
--output=/var/log/koha/dev1/zebra-output.log --verb…
   ├─29547 /usr/bin/zebrasrv -v none,fatal,warn -k 1024 -f 
/etc/koha/sites/dev1/koha-conf.xml
   ├─29620 daemon --name=dev1-koha-indexer 
--errlog=/var/log/koha/dev1/indexer-error.log 
--stdout=/var/log/koha/dev1/indexer.log --output=/var/log/koha/dev1/indexer-ou…
   └─29622 /usr/bin/perl 
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -daemon -sleep 5

___

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

Re: [Koha] Upgrading from 17.05.00.00 to "current"

[Mason James]

oops, that apt line should be

echo "deb http://debian.koha-community.org/koha 19.11 main jessie" > 
/etc/apt/sources.list.d/koha.list



On 16/09/21 12:10 am, Mason James wrote:

|hi ||Steve
the 19.11 series is still supported on jessie

the following apt line should get you the latest 19.11.x release (currently 
koha 19.11.21)
||echo "deb http://debian.koha-community.org/koha 
<http://debian.koha-community.org/koha-staging> 19.11 main jessie" > 
/etc/apt/sources.list.d/koha.list

more info...
https://wiki.koha-community.org/wiki/Koha_on_Debian


||cheers, Mason

|
On 15/09/21 6:28 am, Steve Nickerson wrote:

Does anyone have any tips on how to successfully go from Koha 17.05 to
anything more current on Debian 8 (Jessie) package install? I've tried the
process I've used in the past and the other OS packages upgrade but Koha
keeps getting "held back" no matter what I've tried (various 'koha.list'
sources, apt-get full-upgrade, apt-get dist-upgrade, etc.). What is the
latest version that will run on Debian 8 and what should I put in my
koha.list source file?


Thanks!

Steve

___

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] Upgrading from 17.05.00.00 to "current"

[Mason James]

|hi ||Steve
the 19.11 series is still supported on jessie

the following apt line should get you the latest 19.11.x release (currently 
koha 19.11.21)
||echo "deb http://debian.koha-community.org/koha 
 19.11 main jessie" > 
/etc/apt/sources.list.d/koha.list

more info...
https://wiki.koha-community.org/wiki/Koha_on_Debian


||cheers, Mason

|
On 15/09/21 6:28 am, Steve Nickerson wrote:

Does anyone have any tips on how to successfully go from Koha 17.05 to
anything more current on Debian 8 (Jessie) package install?   I've tried the
process I've used in the past and the other OS packages upgrade but Koha
keeps getting "held back" no matter what I've tried (various 'koha.list'
sources, apt-get full-upgrade, apt-get dist-upgrade, etc.).   What is the
latest version that will run on Debian 8 and what should I put in my
koha.list source file?

  


Thanks!

Steve

___

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] Security releases for all stable branches - UPGRADE!

[Mason James]

hi Andy
i'm not sure why you are getting the error on your testing koha, it works ok 
for me

 - are your testing and prod systems running the same koha version
 - are they both running the latest 20.11.x koha version (20.11.09)?
 - do you get the error if you revert the patches?
 - do you have additional code modifications to your testing system?

the 500 error is often caused by a perl syntax error, so perhaps the patching 
has caused a syntax error in your koha

check your error logs for more info about the error...

 tail -f /var/log/koha/mykoha/*err*.log /var/log/apache/*err*.log


On 9/09/21 1:57 am, Andy Boze wrote:

Hi, all.

We applied the patch on our test server running v20.11. In testing, I've run into a problem. After 
I log in to the OPAC and click on "Your account", when I click on the "your personal 
details" tab, I get a page that states in part

Sorry, the requested page is not available
Error 500
This message can have the following reason(s):

    An error occurred while processing your request.

On our production server, following the same steps, I get a page with my 
account details.

Is anyone else who has applied the patch seeing the same error?

Andy

On 9/6/2021 8:00 AM, Jonathan Druart wrote:

Hello everybody,

Don't ignore this email!

Last week a critical security bug was reported on our bug tracker. We
fixed it and built debian packages for the four stable releases we
currently support.

The security flaw can cause a privilege escalation from OPAC users. It
can be highly damaging, especially if your staff interface is
accessible via login from everywhere without further security measures
like IP restrictions in place.


How to fix the problem?
If you are using a debian-based system you should upgrade using the
debian packages:
% apt update
% apt install koha-common

If you are using an older version of Koha (<19.11) you should either
upgrade to a newer version, or apply those two patches (they should
apply on older versions as well):
https://paste.debian.net/hidden/885fb5ec/
https://paste.debian.net/hidden/1184f523/
https://paste.debian.net/plainh/ae9f9f25

You can apply them using the following command:
% wget "https://paste.debian.net/plainh/885fb5ec; -O 28929_1.patch
% wget "https://paste.debian.net/plainh/1184f523; -O 28929_2.patch
% wget "https://paste.debian.net/plainh/ae9f9f25; -O 28947.patch
% patch -p1 -d /usr/share/koha/intranet/cgi-bin/ <
/kohadevbox/koha/28929_1.patch
% patch -p1 -d /usr/share/koha/opac/cgi-bin/ < /kohadevbox/koha/28929_2.patch
% patch -d /usr/share/koha/opac/cgi-bin/opac/ < /kohadevbox/koha/28947.patch

The two bugs are 28929 and 28947. As they contain information about
how to recreate the vulnerability they will stay hidden two more days to let
you upgrade your systems.

Let us know if you have any questions!

Regards,
Jonathan
___

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] [Koha-devel] Security releases for all stable branches - UPGRADE!

[Mason James]

hi folks
i think there might be a small typo in the patch commands - but this worked OK 
for me...

 cd /tmp
 wget "https://paste.debian.net/plainh/885fb5ec; -O 28929_1.patch
 wget "https://paste.debian.net/plainh/1184f523; -O 28929_2.patch
 wget "https://paste.debian.net/plainh/ae9f9f25; -O 28947.patch
 sudo patch -p1 -d /usr/share/koha/intranet/cgi-bin/ < 28929_1.patch
 sudo patch -p1 -d /usr/share/koha/opac/cgi-bin/ < 28929_2.patch
 sudo patch -p1 -d /usr/share/koha/opac/cgi-bin/ < 28947.patch


output looks like...
--
mason@xen1:/tmp$ sudo patch -p1 -d /usr/share/koha/intranet/cgi-bin/ < 
28929_1.patch
patching file members/memberentry.pl
Hunk #1 succeeded at 225 (offset 10 lines).

mason@xen1:/tmp$ sudo patch -p1 -d /usr/share/koha/opac/cgi-bin/ <  
28929_2.patch
patching file opac/opac-memberentry.pl
Hunk #1 succeeded at 523 (offset 1 line).

mason@xen1:/tmp$ sudo patch -p1 -d /usr/share/koha/opac/cgi-bin/ < 28947.patch
patching file opac/opac-memberentry.pl
patch unexpectedly ends in middle of line
--

it seems you can ignore the 'patch unexpectedly ends' message


On 7/09/21 12:00 am, Jonathan Druart wrote:

Hello everybody,

Don't ignore this email!

Last week a critical security bug was reported on our bug tracker. We
fixed it and built debian packages for the four stable releases we
currently support.

The security flaw can cause a privilege escalation from OPAC users. It
can be highly damaging, especially if your staff interface is
accessible via login from everywhere without further security measures
like IP restrictions in place.


How to fix the problem?
If you are using a debian-based system you should upgrade using the
debian packages:
% apt update
% apt install koha-common

If you are using an older version of Koha (<19.11) you should either
upgrade to a newer version, or apply those two patches (they should
apply on older versions as well):
https://paste.debian.net/hidden/885fb5ec/
https://paste.debian.net/hidden/1184f523/
https://paste.debian.net/plainh/ae9f9f25

You can apply them using the following command:
% wget "https://paste.debian.net/plainh/885fb5ec; -O 28929_1.patch
% wget "https://paste.debian.net/plainh/1184f523; -O 28929_2.patch
% wget "https://paste.debian.net/plainh/ae9f9f25; -O 28947.patch
% patch -p1 -d /usr/share/koha/intranet/cgi-bin/ <
/kohadevbox/koha/28929_1.patch
% patch -p1 -d /usr/share/koha/opac/cgi-bin/ < /kohadevbox/koha/28929_2.patch
% patch -d /usr/share/koha/opac/cgi-bin/opac/ < /kohadevbox/koha/28947.patch

The two bugs are 28929 and 28947. As they contain information about
how to recreate the vulnerability they will stay hidden two more days to let
you upgrade your systems.

Let us know if you have any questions!

Regards,
Jonathan
___
Koha-devel mailing list
koha-de...@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/


___

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

[Koha] Koha packages are available 

[Mason James]

kia ora community,
the latest Koha packages are available

cheers, Mason
___

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

[Koha] Koha packages are available 

[Mason James]

kia ora community,
the latest Koha packages are available

cheers, Mason
___

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

Re: [Koha] KOHA-COMMON PACKAGE INSTALLATION FAILURE

[Mason James]

hi Josh

you are on an older version of ubuntu, so you'll need to add the additional 
'bionic' codename to your /etc/apt/sources.list.d/koha.list file

'deb http://debian.koha-community.org/koha 21.05 main bionic'

you can see more info in section 2.1.2.3 from the install doco
 https://wiki.koha-community.org/wiki/Koha_on_Debian


On 4/08/21 1:25 am, Josh Getanda wrote:

Hello,

I am trying to install the Koha common package while upgrading from 20.11
to 21.05 on Ubuntu 18.04.5. However, during the installation, the error
returned is that some dependency packages will not be installed. Therefore,
koha-common does not install as a result. See the message below in bold
italicized.

*"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: libmojolicious-plugin-openapi-perl but it is not
going to be installed*
*   Depends: libnet-oauth2-authorizationserver-perl but it is
not going to be installed*
*   Depends: libyaml-libyaml-perl but it is not going to be
installed*
*E: Unable to correct problems, you have held broken packages."*

Any ideas on how to resolve this?
___

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] Koha password is forgotten

[Mason James]

hi Sanjay
its impossible to retrieve a user's password in koha, as the password is 
encrypted. (its a good thing)

if you want to retrieve the system/db password for a koha instance, use the 
'koha-passwd' command

$ sudo koha-passwd lib1
Password for lib1: O9NUVyghZggH82BX

if your koha instance is 'lib1' - your username (and database name) will be 
'koha_lib1'


On 1/08/21 4:00 pm, Sanjay Uchcharia wrote:

Hello there, I've forgotten my koha password. How to get it back in Ubuntu
20.04.


Thankyou. :)
___

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] API Errors/Plugin Issues

[Mason James]

hi Jesse

your system seems to have not upgraded correctly

these are the correct versions of the following debian packages for koha 21.05 
on stretch
 libmojolicious-perl    8.12
 libjson-validator-perl 3.25
 libmojolicious-plugin-openapi-perl 2.16

try the following command to complete the upgrade...
 $ sudo apt install koha-common



On 26/07/21 8:59 am, Jesse Stallings wrote:

Thank you! Debian 9.9 (stretch) installed via package. Noticed the error a
while after updating from 19.11 (I believe) to 21.05.


On Sun, Jul 25, 2021 at 3:54 PM Tomas Cohen Arazi 
wrote:


What is the OS and install method? It seems to be an issue with the
transfer limits API, that makes the Koha API spec be empty, and thus the
error with the plugin.

Let me know where/you installed so we check and solve it.

El dom., 25 jul. 2021 14:39, Jesse Stallings 
escribió:


Running 21.05 (Debian package) and attempting to install the Pay via
Paypal
plugin

from
Theke. After uploading .kpz and flushing memcache/restarting Plack, the
configuration page hangs on loading files
from /api/v1/contrib/paypal/static/_nuxt/, which does not exist. API error
log is here .

I suspect this is a larger issue with Mojolicious, but don't know enough
to
be sure. As a shot in the dark, here are my current versions of Perl
modules mentioned in Bug 26893
:
Mojolicious (7.21)
Mojolicious::Plugin::OpenAPI (1.15)
JSON::Validator (0.97)

Thanks for any help you can provide!

Jesse Stallings
___

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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] API Errors/Plugin Issues

[Mason James]

hi Jessie
are you running a 32-bit version of debian?


On 26/07/21 8:59 am, Jesse Stallings wrote:

Thank you! Debian 9.9 (stretch) installed via package. Noticed the error a
while after updating from 19.11 (I believe) to 21.05.


On Sun, Jul 25, 2021 at 3:54 PM Tomas Cohen Arazi 
wrote:


What is the OS and install method? It seems to be an issue with the
transfer limits API, that makes the Koha API spec be empty, and thus the
error with the plugin.

Let me know where/you installed so we check and solve it.

El dom., 25 jul. 2021 14:39, Jesse Stallings 
escribió:


Running 21.05 (Debian package) and attempting to install the Pay via
Paypal
plugin

from
Theke. After uploading .kpz and flushing memcache/restarting Plack, the
configuration page hangs on loading files
from /api/v1/contrib/paypal/static/_nuxt/, which does not exist. API error
log is here .

I suspect this is a larger issue with Mojolicious, but don't know enough
to
be sure. As a shot in the dark, here are my current versions of Perl
modules mentioned in Bug 26893
:
Mojolicious (7.21)
Mojolicious::Plugin::OpenAPI (1.15)
JSON::Validator (0.97)

Thanks for any help you can provide!

Jesse Stallings
___

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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Access denied after try to run batchRebuildBiblioTables.pl

[Mason James]

hi Eugen
try using the 'koha-shell' command

$ sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c' 
your_koha_name


cheers, Mason


On 10/07/21 2:44 am, DHIM IT wrote:

Dear colleagues,

I will try to rebuild the biblioitems table after mapping a new value in “Koha 
to MARC mapping”, but I get this error:


/usr/share/koha/bin/batchRebuildBiblioTables.pl -c

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBI connect('database=koha;host=localhost;port=3306','',...) failed: Access 
denied for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517.

DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied 
for user 'root'@'localhost' (using password: NO) at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at 
/usr/share/koha/lib/Koha/Database.pm line 117

Koha version: 20.11.05.000



I can connect to MySQL without problems without password like: mysql -u root



What am I doing wrong?

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

Re: [Koha] Koha common upgrades fails as rabbitmq service is not running

[Mason James]

On 3/07/21 12:22 am, Mike Lake wrote:

Hi all

Thanks Mason :-) That looks like it has fixed the problem.

I added the message_broker section then rebooted. Now rabbitmq server is 
running, the About Koha page/Server and System information tabs show message 
broker rabitmq is running and no errors.
The upgrade from Koha 21.05.00-1 to 21.05.01-1 then went fine.

The username & password is literally "guest" I presume? It all seems to be 
working.


hiya

i think you can change both username and password to your preference
___

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

Re: [Koha] Koha common upgrades fails as rabbitmq service is not running

[Mason James]

hi Mike
upgrading from 21.05.00 to 21.05.01 is recommended

you are probably missing this new RMQ block in your instance's koha-conf.xml 
file

 
   localhost
61613
   guest
   guest
   
 

check the /etc/koha/koha-conf-site.xml.in template file, as an example

then reboot


On 1/07/21 11:34 pm, Mike Lake wrote:

Hi

Anyone had this problem? There is already a new Koha common 21.05.01-1 which 
will probably have the same problem if I try and upgrade.

Mike

On 2021-06-26 22:24, Mike Lake wrote:

Hi

I have a problem with our library and RabbitMQ.
Koha version: 21.05.00.000 on Debian 9.13

During the latest update just tonight 

Setting up koha-common (21.05.00-1) ...
Upgrading database schema for library   <== this instance is disabled
Upgrading database schema for libtest2  <== this instance is running OK
Plugin configuration unchanged.

Applying plugin configuration to rabbit@asf3... failed.
  * Could not contact node rabbit@asf3.
    Changes will take effect at broker restart.
  * Options: --online  - fail if broker cannot be contacted.
 --offline - do not try to contact broker.
 Job for rabbitmq-server.service failed because the control process
exited with error code.
 See "systemctl status rabbitmq-server.service" and "journalctl -xe"
for details.

systemctl shows rabbitmq service is not running and it cannot start because:

# cat /var/log/rabbitmq/startup_log
ERROR: node with name "rabbit" already running on "asf3"

and in the intranet About Koha / System Information for instance libtest2 says:

  Impossible to connect to the message broker
  There is an error when trying to connect to the message broker
(RabbitMQ), check the Koha log files.
  Maybe it is not installed and configured correctly?
  Contact your system administrator.

In /etc/rabbitmq/rabbitmq-env.conf  all options are commented out.

When this instance was installed last year there was nothing that
suggested that this needed to be configured.

I also see in worker-output.log I'm getting:
Error connecting to localhost:61613: Connection refused at
/usr/share/perl5/Net/Stomp.pm line 26.

I'm not sure if this is a firewall issue or not. I am running the
stock Debian fail2ban.


Thanks




___

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

Re: [Koha] KOHA link bibs to authorities question/follow up

[Mason James]

On 1/07/21 6:49 pm, Michael Kuhn wrote:

Hi David

You wrote:

> Thank you for your quick reply.  I looked up the page you referred to,
> and also found the command  just where it was supposed to be, but
> when I tried to run it, this is what happened:
>
>   /usr/share/koha/bin*$ link_bibs_to_authorities.pl
> -bash: link_bibs_to_authorities.pl > *command not found*
>
> As you can tell I am no linux expert ... so I'm not sure what to do
> next to get this to work.
>
> Thank you for any help you can give,

Please always anser to the mailinglist!

You first need to set the correct environment.

# INSTANCE=yourinstance
# export KOHA_CONF=/etc/koha/sites/${INSTANCE}/koha-conf.xml
# export PERL5LIB=/usr/share/koha/lib

Then as Linux user "root" run

# /usr/share/koha/bin/link_bibs_to_authorities.pl



you can also run any script using the 'koha-shell' command, which set the 
environment for you...

  sudo koha-shell -c '/usr/share/koha/bin/link_bibs_to_authorities.pl'  lib123


___

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

Re: [Koha] Patron Creation failure

[Mason James]

hi Russel
have you upgraded to 21.05.01?


On 29/06/21 11:30 pm, Russel G. P. Shihepo wrote:

Dear community

I have been trying to create a new patron under the category Juvenile with
no success.

This is the message i get:

"Something went wrong when creating the patron. Check the logs."

And when i checked the logs files at
/var/log/koha/library/intranet-error.log this is what i get:
[Tue Jun 29 13:21:54.630830 2021] [cgi:error] [pid 462440] [client
127.0.0.1:59>

I'm using the current stable release 21.05.
Please give me some advice.


Regards,
Russel
___

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] upgrade from Koha 20.05.06.000 to latest version failing with Row size too large

[Mason James]

hi Mesfin
this page looks helpful... 
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb



On 28/06/21 8:17 pm, Mesfin Teshome wrote:

  Greetings everyone,    I have been trying to upgrade Koha 20.05.06.000 to the latest 
version for some time now and every time I try I get a DBI exception "Row size too 
large" message. The full error message below:


Upgrade to 20.0t.00.030 done [18:40:59] Bug 20047 - Add new system preference 
'AutoApprovePatronProfileSettings'Upgrade to 20.06.00.031 done [18:40:59] Bug 22789 
- Add non_priority column on reserves and old_reserves tables{UNKNOWN}: DBI 
Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for 
the used table type, not counting BLOBs, is 8126.This incldues storage overhead, 
check the manual. You have to change some columns to TEXT or BLOBs [for Statement 
"
     ALTER TABLE `items` ADD COLUMN 
`exclude_from_local_holds_priority` tinyint(1) default NULL AFTER `new_status`


Anyone who has any idea how I can address this and go on with the upgrade.I am 
running Koha on Debian 10 Buster, Perl 5.028001, Server version: Apache/2.4.38 
(Debian), mysql Ver 15.1 Distrib 10.3.29-MariaDB, for debian-linux-gnu (x86_64) 
using readline 5.2
Kind regards,




 On Monday, June 28, 2021, 03:01:04 AM GMT+3, 
 wrote:
  
  Send Koha mailing list submissions to

     koha@lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
     https://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
     koha-requ...@lists.katipo.co.nz

You can reach the person managing the list at
     koha-ow...@lists.katipo.co.nz

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."


Today's Topics:

   1. Re: Title search works, but Library catalog search fails in
       OPAC (Katrin Fischer)


--

Message: 1
Date: Sun, 27 Jun 2021 10:38:15 +0200
From: Katrin Fischer 
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Title search works, but Library catalog search
     fails in OPAC
Message-ID: <67a02970-fa2e-c90e-1b63-92b671b5c...@web.de>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi Tasha,

there is currently a bug about some punctuation leading to no results in
Elasticsearch that might relate to your problem:

*Bug 28316*
 - Fix
ES crashes related to various punctuation characters

Hope this helps,

Katrin

On 24.06.21 23:55, Bales (US), Tasha R wrote:

Follow-up to my problem searching the OPAC for phrases containing punctuation (i.e., 
Electroactive polymer (EAP) actuators).  This Bywater 
Solutions article 
suggests that the problem is a feature of Elasticsearch.



FYI, we are using Elasticsearch 6.1.1 on its own dedicated server, and I don’t 
believe we’ve installed the ICU Analysis plug-in (looks like it’s required for 
Zebra, but I can’t tell if it’s required for Elasticsearch), which could be a 
factor.  I couldn’t replicate all aspects of my experience in a sandbox, 
although searches for phrases containing punctuation still failed in an OPAC 
“Library Catalog” sandbox search.  I concluded that I needed to review our 
configuration.



I’ve been reviewing the Koha Wiki and elastic.co documentation, and comparing 
to our index_config.yaml.

By chance does anyone know how to interpret the syntax below?  The 
documentation describes the parameters below, but I don’t see any usage of “-“ 
before options.  Does the option “- punctuation“ mean “yes, remove 
punctuation”, or “no, don’t remove punctuation”, or does the phrase refer to 
some additional configuration file, or perhaps it’s commented out?



         analyzer_phrase:

           tokenizer: keyword

           filter:

             - icu_folding

           char_filter:

             - punctuation



Thanks for your time and consideration,





Tasha Bales

Business Support Team | Information Services

Enterprise Services | Enterprise Operations, Finance and Sustainability





-Original Message-

From: Bales (US), Tasha R

Sent: Tuesday, June 22, 2021 7:54 AM

To: 'Jonathan Druart' 

Cc: Discussion Group Koha 

Subject: RE: [EXTERNAL] Re: [Koha] Title search works, but Library catalog 
search fails in OPAC



Jonathan, thank you!



It does work without the parentheses.



I would suspect an encoding problem, but for that the problem only manifests in 
the OPAC, and not the intranet.



I came across this issue while testing after migrating from MariaDB to Percona 
MySQL.  Your reply prompted me to check the encoding of the new database, and 
it's unfortunately Latin-1.  Since these are parentheses and not diacritics, 
I’m not sure what my expectations should be, but changing to UTF-8 is a place 
to start.  Httpd.conf does have 

[Koha] Koha packages are available 

[Mason James]

kia ora community,
the latest Koha packages are available

cheers, Mason
___

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

Re: [Koha] bogged down in a koha install

[Mason James]

hiya,
looks like the koha-create command failed, or perhaps you forgot to run it?

try it again...
 sudo koha-create --create-db libraryname

or remove, then create...
 sudo koha-remove libraryname
 sudo koha-create --create-db libraryname


then...
 sudo koha-plack --enable library


On 24/06/21 9:56 am, o1bigtenor wrote:

Greetings

Following the 'destructions' at:
https://wiki.koha-community.org/wiki/Debian#Before_you_begin

have worked my way through until trying to set up plask

$ sudo a2enmod headers proxy_http

then:

$ sudo koha-plack --enable libraryname

# a2enmod proxy_http
Considering dependency proxy for proxy_http:
Enabling module proxy.
Enabling module proxy_http.
To activate the new configuration, you need to run:
   service apache2 restart
root@memyself:/# service apache2 restart
[ ok ] Restarting Apache httpd web server: apache2.
root@memyself:/# koha-plack --enable library
[FAIL] Error: Invalid instance name library: failed!

# dpkg -l | grep plack
ii  libplack-middleware-logwarn-perl   0.001002-1
  all  converts warnings to log messages
ii  libplack-middleware-reverseproxy-perl  0.16-1
  all  module supporting apps to run as a reverse
proxy backend
ii  libplack-perl  1.0047-1
  all  interface between web servers and Perl web
applications

so - - - I think I do have plack - - - - not sure how to get whatever
needs to see libplack-perl looking in the right direction.

(perl is already the newest version (5.28.1-6+deb10u1). - - - - if it matters.)

TIA

(just subscribed to the user list and haven't seen any questions on
install so chose to cc the dev list - - - hopefully not deprecated
behavior - - - - :-)  !)
___

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 500 when calling "import_borrowers.pl"

[Mason James]

i logged a bug

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28616

On 23/06/21 2:16 pm, Mason James wrote:

hi Michael ,
this does seem to be a bug in 21.05 (at least)

the following command should fix the problem, if the libdata-printer-perl 
package is not installed

 $ sudo apt install libdata-printer-perl


On 23/06/21 4:14 am, Michael Kuhn wrote:

Hi Himanshu

> image.png
> This is the error i am getting when I click on import Patrons module.
> Koha version is 21.05. this is the reason I asked.

Error 500 is a very unspecific HTTP message that can have many different 
reasons. You will have to search for the reason in the log files.

However, this error has nothing to do with the (meanwhile solved) problem described in my 
posting "[Koha] Reoccurring DBMS auto increment issue".

Just for your information: I just checked in my own demo installation ( http://koha.adminkuhn.ch:8080 
) which uses Koha 21.05 - it also gives me Error 500 when clicking Koha menu "Tools > Import 
patrons". In my case log file "plack-error.log" shows the following:

Could not compile /usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl: 
Can't locate Data/Printer.pm in @INC (you may need to install the Data::Printer 
module) (@INC contains: /usr/share/koha/lib /usr/share/koha/installer 
/usr/share/koha/lib/installer /etc/perl 
/usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 
/usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 
/usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 
/usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base 
/var/lib/koha/sandkasten/plugins) at /usr/share/koha/lib/Koha/Patrons/Import.pm 
line 352.
BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patrons/Import.pm 
line 352.
Compilation failed in require at 
/usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 50.
BEGIN failed--compilation aborted at 
/usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 50.

Maybe this is just a new bug you found.

Best wishes: Michael




___

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

Re: [Koha] Error 500 when calling "import_borrowers.pl"

[Mason James]

hi Michael ,
this does seem to be a bug in 21.05 (at least)

the following command should fix the problem, if the libdata-printer-perl 
package is not installed

 $ sudo apt install libdata-printer-perl


On 23/06/21 4:14 am, Michael Kuhn wrote:

Hi Himanshu

> image.png
> This is the error i am getting when I click on import Patrons module.
> Koha version is 21.05. this is the reason I asked.

Error 500 is a very unspecific HTTP message that can have many different 
reasons. You will have to search for the reason in the log files.

However, this error has nothing to do with the (meanwhile solved) problem described in my 
posting "[Koha] Reoccurring DBMS auto increment issue".

Just for your information: I just checked in my own demo installation ( http://koha.adminkuhn.ch:8080 
) which uses Koha 21.05 - it also gives me Error 500 when clicking Koha menu "Tools > Import 
patrons". In my case log file "plack-error.log" shows the following:

Could not compile /usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl: 
Can't locate Data/Printer.pm in @INC (you may need to install the Data::Printer 
module) (@INC contains: /usr/share/koha/lib /usr/share/koha/installer 
/usr/share/koha/lib/installer /etc/perl 
/usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 
/usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 
/usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 
/usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base 
/var/lib/koha/sandkasten/plugins) at /usr/share/koha/lib/Koha/Patrons/Import.pm 
line 352.
BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Patrons/Import.pm 
line 352.
Compilation failed in require at 
/usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 50.
BEGIN failed--compilation aborted at 
/usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 50.

Maybe this is just a new bug you found.

Best wishes: Michael


___

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

Re: [Koha] Need help with Koha instance that refuses to do checkouts

[Mason James]

hi Chris
did you try Katrin's suggestion?, it is the most likely problem
  https://lists.katipo.co.nz/pipermail/koha/2021-June/056338.html

try loading your database into a test system, and experiment by removing likely 
issuing rules until you find your problematic rule

cheers, Mason


On 21/06/21 6:42 pm, Chris Brown wrote:

Dear Koha Community

Following up my post on 12 June I am repeating my call for help as Koha is
effectively unusable right now at one of our libraries.

We are running Koha 19.11 on Debian 9.11 (stretch). This supports 5 Koha
instances for some of the volunteer-run libraries in Sheffield. It has been
stable and working fine for many months.

Currently we have a serious problem with one of these instances. Any
attempt to check out a book hangs (never completes) and we see
/usr/share/koha/intranet/cgi-bin/circ/circulation.pl consuming most of the
CPU cycles (stuck in a loop perhaps?). On one occasion I noticed it was
renew.pl consuming all the CPU.

I have tried disabling plack for this instance, and have rebuilt the zebra
index, but the problem persists. There is nothing obvious reported in the
log files, though I may not be looking in the right places. I cannot see
any obvious problems with the configuration, though again I might be
looking at the wrong things. The other 4 instances are working OK.

*Any advice on how to debug or fix this would be greatly appreciated.*

Does anyone know how to turn on tracing of MySQL transactions? I was
wondering if looking at the activity at the database end might help.

Thanks and Best Regards,

Chris Brown (Voluntary Libraries in Sheffield)
___

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] 'Codename' value from '20.11' to '21.05

[Mason James]

On 11/06/21 2:50 am, Victor Barroso Oliveira wrote:
> My version is 20.11.06 e "Koha.list" is
>
> deb http://debian.koha-community.org/koha stable main bionic

hi Victor,
your koha.list file is correct, and does not need any changes

the following commands explicitly accept the 'stable' codename change from 
20.11 to 21.05, and upgrade the package to the latest stable version

 sudo apt-get update --allow-releaseinfo-change
 sudo apt-get upgrade koha-common

___

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

Re: [Koha] 'Codename' value from '20.11' to '21.05

[Mason James]

|hi Victor
the warning is expected

these commands resolve the warning...
  sudo apt-get update --allow-releaseinfo-change

or..
  sudo apt update

|

On 10/06/21 11:45 pm, Victor Barroso Oliveira wrote:

Good morning,
I received the following message after apt-get update


*E: Repository 'http://debian.koha-community.org/koha
 stable InRelease' changed i  ts
'Codename' value from '20.11' to '21.05'N: This must be accepted explicitly
before updates for this repository can be applied. See apt-secure(8)
manpage for details.*

Should this be fixed? What correction is needed?

thanks
Victor
___

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] Koha 21.05.00 released

[Mason James]

kia ora community

the packages are up 

cheers, Mason

On 29/05/21 1:02 am, Jonathan Druart wrote:

Hello everybody,

It is with great pleasure that the Koha community announces the
release of Koha 21.05, a major release of the Koha open source
integrated library system.

Read the full release notes here:
https://koha-community.org/koha-21-05-released/

The Debian packages for this new version will be available soon. Stay tuned!

Cheers,
Jonathan
___

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] Koha on VPS?

[Mason James]

On 28/05/21 8:46 am, Mason James wrote:


hi Jesse
you will need to run 'koha-create' after changing /etc/koha/koha-sites.conf

 $ sudo koha-create --create-db library

...where 'library' is the name of your koha instance

this command creates the config files under /etc/koha/sites/library


more info here...

 https://wiki.koha-community.org/wiki/Koha_on_Debian#Create_a_Koha_instance
___

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

Re: [Koha] Koha on VPS?

[Mason James]

On 28/05/21 6:46 am, Jesse A Lambertson wrote:

Hello

I am using the newest stable (20.11)

debian 10
SSHing into that server

Have DNS for the domain managed at wordpress (.phantomlandscapes.com)

the dB has been created, but the site is empty
I have installed mysql rather than the mariadB option

/etc/koha/koha-sites.conf has been edited, changing the domain to ",
phantomlandscapes.com" and changed the suffix for the staff view to "-staff"

But when I run: sudo koha-plack --enable library
I get an error saying

"failed to load external entity "/etc/koha/sites/library/koha-conf.xml"
sed: can't read : No such file or directory"


hi Jesse
you will need to run 'koha-create' after changing /etc/koha/koha-sites.conf

 $ sudo koha-create --create-db library

...where 'library' is the name of your koha instance

this command creates the config files under /etc/koha/sites/library
___

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

Re: [Koha] Release of Koha 20.11.06

[Mason James]

On 26/05/21 2:25 am, Fridolin SOMERS wrote:

Hello everyone 珞

The Koha community is proud to announce the release of Koha 20.11.06.

It is a maintenance release with 3 security fixes.

The full release notes are available here:
https://koha-community.org/koha-20-11-06-released/

Debian packages should be available in a few days.



Kia ora community, the Debian packages are uploaded

cheers, Mason
___

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