Re: [Koha] Open access

[Himanshu Aggarwal]

With Html and CSS applications one can do that I have seen it.

On Thu, Apr 20, 2023 at 6:24 AM Ma. Victoria H. Silva-Manuel <
mavicsi...@gmail.com> wrote:

> Hi.
>
> Is it possible to add open access logo to a record and visible in OPAC?
>
> Thanks.
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Assistant Librarian,
Confucius Institute Scholar 13-14,
R.D. National College,
Bandra (W.)
___

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

[Koha] Overdue notice sending

[zen zenitram]

 Hello

/usr/share/koha/bin/cronjobs/overdue_notices.pl -n
Can't locate Koha/Script.pm in @INC (you may need to install the
Koha::Script module) (@INC contains: /etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.34.0 /usr/local/share/perl/5.34.0
/usr/lib/x86_64-linux-gnu/perl5/5.34 /usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.34
/usr/share/perl/5.34 /usr/local/lib/site_perl) at
/usr/share/koha/bin/cronjobs/overdue_notices.pl line 29.
BEGIN failed--compilation aborted at /usr/share/koha/bin/cronjobs/
overdue_notices.pl line 29.

How to fix this kind of error?
___

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

[Koha] Open access

[Ma. Victoria H. Silva-Manuel]

Hi.

Is it possible to add open access logo to a record and visible in OPAC?

Thanks.
___

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

[Koha] Kohacon23 call for talks is open.

[Chris Cormack]

Tēnā koutou

I have noticed that the call for papers is live at 
https://perlkohacon.fi/Call-For-Talks-Perl-Koha-Helsinki-August-2023.html
I encourage you all to submit a talk. Let's make this a great Kohacon.

Chris 
___

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

[Koha] 22.11.05 Koha String Freeze

[O'Mara, Jacob]

Hello all,

This email is to announce a String Freeze for the coming 22.11.05
release of Koha stable.

Kind regards,


-- 

*Jacob O'Mara*

*Junior Software Engineer*



E: jacob.om...@ptfs-europe.com

P: +44 (0) 1483 378728 ext. 1019

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

Re: [Koha] Help needed with zombie background_jobs processes

[Cindy Murdock Ames]

That's an interesting thought.  I *am* missing the 
section in my config file, but am I interpreting the patch correctly that
it defaults to "1" if it's not present?

---
Cindy Murdock Ames
IT Services Director
Meadville Public Library | CCFLS
https://meadvillelibrary.org | https://ccfls.org

Please report tech support issues in Mantis:  https://mantis.ccfls.org


On Wed, Apr 19, 2023 at 12:24 PM Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> It would be interesting to revert the changes from 32558 that have
> been backported into 22.11.04 and see if it helps.
>
> Le mer. 19 avr. 2023 à 18:01, Cindy Murdock Ames  a
> écrit :
> >
> > Hi Jonathan,
> >
> > I just tried sending SHGCHLD to the parent processes, it didn't have any
> effect.  The parents are "/usr/bin/perl /usr/share/koha/bin/
> background_jobs_worker.pl --queue default" and "/usr/bin/perl
> /usr/share/koha/bin/background_jobs_worker.pl --queue long_tasks".
> >
> > worker-error.log has a few entries like these three from today:
> > 20230419 08:44:53 ccfls-koha-worker-long_tasks: client (pid 12169)
> killed by signal 13, respawning
> > 20230419 09:36:06 ccfls-koha-worker: client (pid 14398) killed by signal
> 13, respawning
> > 20230419 09:59:35 ccfls-koha-worker: client (pid 29935) killed by signal
> 13, respawning
> >
> > Those timestamps correspond to three jobs in the jobs queue that didn't
> complete and have a "null/n" (n being numbers that I think correspond to
> the number of things in the batch).  The first is a batch item record
> modification and the other two are holds queue updates.
> >
> > I cancelled these three jobs and the zombies remained.
> >
> > worker-output.log has a number of entries like these, but unfortunately
> there are no timestamps so I can't link it to anything, although the
> timestamp on the file itself is from yesterday at 13:08, which I think
> corresponded to a successful staging and import of records.
> >
> > Use of uninitialized value $subfield_value in pattern match (m//) at
> /usr/share/koha/lib/Koha/SimpleMARC.pm line 435.
> > Use of uninitialized value $subfield_value in string eq at
> /usr/share/koha/lib/Koha/SimpleMARC.pm line 435.
> >
> > I did try something else.  The parent process for the long queue had
> apparently already respawned, but the one for the default one hadn't, so I
> killed it with -9.  The two zombies that had been there went away and the
> default queue restarted.  Before I did that I tried a MARC upload, it was
> stuck at 0%.  I cancelled the job and retried it after killing the default
> queue and it worked, but it spawned a new zombie which was a child of the
> long_tasks queue.  Yesterday it seemed to work if there was only one
> zombie, but not two.  No new entries in either of the worker- files.
> >
> > Thanks for your help.
> >
> > c.
> > ---
> > Cindy Murdock Ames
> > IT Services Director
> > Meadville Public Library | CCFLS
> > https://meadvillelibrary.org | https://ccfls.org
> >
> > Please report tech support issues in Mantis:  https://mantis.ccfls.org
> >
> >
> > On Wed, Apr 19, 2023 at 2:44 AM Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
> >>
> >> Did you have a look at worker-*.log? Nothing useful there?
> >>
> >> You can try to send SIGCHLD to the parent to kill the zombie.
> >>
> >> Le mar. 18 avr. 2023 à 22:09, Cindy Murdock Ames 
> a écrit :
> >> >
> >> > A few other things I've noticed:
> >> >
> >> > - Sometimes the zombie processes will go away on their own, sometimes
> it seems when you retry the MARC import or whatever it was that failed.
> This one is really weird to me as in all my years as a sysadmin I thought
> it was not possible for zombie processes to go away without a reboot.  But
> maybe that's changed and now zombies can rise from the dead.  Lol.
> >> >
> >> > - In looking at the jobs list in Koha, it seems that Holds queue
> updates are especially prone to getting stuck at a progress of null/1.
> >> >
> >> > - If you reattempt a job that is stuck (ie, reattempting a MARC file
> upload or what not) it will often succeed.  The original failed job remains
> with a progress of null.
> >> >
> >> > c.
> >> > ---
> >> > Cindy Murdock Ames
> >> > IT Services Direc

Re: [Koha] Help needed with zombie background_jobs processes

[Jonathan Druart]

It would be interesting to revert the changes from 32558 that have
been backported into 22.11.04 and see if it helps.

Le mer. 19 avr. 2023 à 18:01, Cindy Murdock Ames  a écrit :
>
> Hi Jonathan,
>
> I just tried sending SHGCHLD to the parent processes, it didn't have any 
> effect.  The parents are "/usr/bin/perl 
> /usr/share/koha/bin/background_jobs_worker.pl --queue default" and 
> "/usr/bin/perl /usr/share/koha/bin/background_jobs_worker.pl --queue 
> long_tasks".
>
> worker-error.log has a few entries like these three from today:
> 20230419 08:44:53 ccfls-koha-worker-long_tasks: client (pid 12169) killed by 
> signal 13, respawning
> 20230419 09:36:06 ccfls-koha-worker: client (pid 14398) killed by signal 13, 
> respawning
> 20230419 09:59:35 ccfls-koha-worker: client (pid 29935) killed by signal 13, 
> respawning
>
> Those timestamps correspond to three jobs in the jobs queue that didn't 
> complete and have a "null/n" (n being numbers that I think correspond to the 
> number of things in the batch).  The first is a batch item record 
> modification and the other two are holds queue updates.
>
> I cancelled these three jobs and the zombies remained.
>
> worker-output.log has a number of entries like these, but unfortunately there 
> are no timestamps so I can't link it to anything, although the timestamp on 
> the file itself is from yesterday at 13:08, which I think corresponded to a 
> successful staging and import of records.
>
> Use of uninitialized value $subfield_value in pattern match (m//) at 
> /usr/share/koha/lib/Koha/SimpleMARC.pm line 435.
> Use of uninitialized value $subfield_value in string eq at 
> /usr/share/koha/lib/Koha/SimpleMARC.pm line 435.
>
> I did try something else.  The parent process for the long queue had 
> apparently already respawned, but the one for the default one hadn't, so I 
> killed it with -9.  The two zombies that had been there went away and the 
> default queue restarted.  Before I did that I tried a MARC upload, it was 
> stuck at 0%.  I cancelled the job and retried it after killing the default 
> queue and it worked, but it spawned a new zombie which was a child of the 
> long_tasks queue.  Yesterday it seemed to work if there was only one zombie, 
> but not two.  No new entries in either of the worker- files.
>
> Thanks for your help.
>
> c.
> ---
> Cindy Murdock Ames
> IT Services Director
> Meadville Public Library | CCFLS
> https://meadvillelibrary.org | https://ccfls.org
>
> Please report tech support issues in Mantis:  https://mantis.ccfls.org
>
>
> On Wed, Apr 19, 2023 at 2:44 AM Jonathan Druart 
>  wrote:
>>
>> Did you have a look at worker-*.log? Nothing useful there?
>>
>> You can try to send SIGCHLD to the parent to kill the zombie.
>>
>> Le mar. 18 avr. 2023 à 22:09, Cindy Murdock Ames  a 
>> écrit :
>> >
>> > A few other things I've noticed:
>> >
>> > - Sometimes the zombie processes will go away on their own, sometimes it 
>> > seems when you retry the MARC import or whatever it was that failed.  This 
>> > one is really weird to me as in all my years as a sysadmin I thought it 
>> > was not possible for zombie processes to go away without a reboot.  But 
>> > maybe that's changed and now zombies can rise from the dead.  Lol.
>> >
>> > - In looking at the jobs list in Koha, it seems that Holds queue updates 
>> > are especially prone to getting stuck at a progress of null/1.
>> >
>> > - If you reattempt a job that is stuck (ie, reattempting a MARC file 
>> > upload or what not) it will often succeed.  The original failed job 
>> > remains with a progress of null.
>> >
>> > c.
>> > ---
>> > Cindy Murdock Ames
>> > IT Services Director
>> > Meadville Public Library | CCFLS
>> > https://meadvillelibrary.org | https://ccfls.org
>> >
>> > Please report tech support issues in Mantis:  https://mantis.ccfls.org
>> >
>> >
>> > On Tue, Apr 18, 2023 at 3:55 PM Cindy Murdock Ames  
>> > wrote:
>> >>
>> >> Yes, it's 22.11.04, package version.
>> >>
>> >> ---
>> >> Cindy Murdock Ames
>> >> IT Services Director
>> >> Meadville Public Library | CCFLS
>> >> https://meadvillelibrary.org | https://ccfls.org
>> >>
>> >>
>> >>
>> >>
>> >> On Tu

Re: [Koha] Help needed with zombie background_jobs processes

[Cindy Murdock Ames]

Hi Jonathan,

I just tried sending SHGCHLD to the parent processes, it didn't have any
effect.  The parents are "/usr/bin/perl /usr/share/koha/bin/
background_jobs_worker.pl --queue default" and "/usr/bin/perl
/usr/share/koha/bin/background_jobs_worker.pl --queue long_tasks".

worker-error.log has a few entries like these three from today:
20230419 08:44:53 ccfls-koha-worker-long_tasks: client (pid 12169) killed
by signal 13, respawning
20230419 09:36:06 ccfls-koha-worker: client (pid 14398) killed by signal
13, respawning
20230419 09:59:35 ccfls-koha-worker: client (pid 29935) killed by signal
13, respawning

Those timestamps correspond to three jobs in the jobs queue that didn't
complete and have a "null/n" (n being numbers that I think correspond to
the number of things in the batch).  The first is a batch item record
modification and the other two are holds queue updates.

I cancelled these three jobs and the zombies remained.

worker-output.log has a number of entries like these, but unfortunately
there are no timestamps so I can't link it to anything, although the
timestamp on the file itself is from yesterday at 13:08, which I think
corresponded to a successful staging and import of records.

Use of uninitialized value $subfield_value in pattern match (m//) at
/usr/share/koha/lib/Koha/SimpleMARC.pm line 435.
Use of uninitialized value $subfield_value in string eq at
/usr/share/koha/lib/Koha/SimpleMARC.pm line 435.

I did try something else.  The parent process for the long queue had
apparently already respawned, but the one for the default one hadn't, so I
killed it with -9.  The two zombies that had been there went away and the
default queue restarted.  Before I did that I tried a MARC upload, it was
stuck at 0%.  I cancelled the job and retried it after killing the default
queue and it worked, but it spawned a new zombie which was a child of the
long_tasks queue.  Yesterday it seemed to work if there was only one
zombie, but not two.  No new entries in either of the worker- files.

Thanks for your help.

c.
---
Cindy Murdock Ames
IT Services Director
Meadville Public Library | CCFLS
https://meadvillelibrary.org | https://ccfls.org

Please report tech support issues in Mantis:  https://mantis.ccfls.org


On Wed, Apr 19, 2023 at 2:44 AM Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> Did you have a look at worker-*.log? Nothing useful there?
>
> You can try to send SIGCHLD to the parent to kill the zombie.
>
> Le mar. 18 avr. 2023 à 22:09, Cindy Murdock Ames  a
> écrit :
> >
> > A few other things I've noticed:
> >
> > - Sometimes the zombie processes will go away on their own, sometimes it
> seems when you retry the MARC import or whatever it was that failed.  This
> one is really weird to me as in all my years as a sysadmin I thought it was
> not possible for zombie processes to go away without a reboot.  But maybe
> that's changed and now zombies can rise from the dead.  Lol.
> >
> > - In looking at the jobs list in Koha, it seems that Holds queue updates
> are especially prone to getting stuck at a progress of null/1.
> >
> > - If you reattempt a job that is stuck (ie, reattempting a MARC file
> upload or what not) it will often succeed.  The original failed job remains
> with a progress of null.
> >
> > c.
> > ---
> > Cindy Murdock Ames
> > IT Services Director
> > Meadville Public Library | CCFLS
> > https://meadvillelibrary.org | https://ccfls.org
> >
> > Please report tech support issues in Mantis:  https://mantis.ccfls.org
> >
> >
> > On Tue, Apr 18, 2023 at 3:55 PM Cindy Murdock Ames 
> wrote:
> >>
> >> Yes, it's 22.11.04, package version.
> >>
> >> ---
> >> Cindy Murdock Ames
> >> IT Services Director
> >> Meadville Public Library | CCFLS
> >> https://meadvillelibrary.org | https://ccfls.org
> >>
> >>
> >>
> >>
> >> On Tue, Apr 18, 2023 at 2:59 PM Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
> >>>
> >>> Hi Cindy,
> >>> Which exact version of Koha 22.11.xx? It should be the latest one.
> >>> Regards,
> >>> Jonathan
> >>>
> >>> Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames 
> a écrit :
> >>> >
> >>> > Hi all,
> >>> >
> >>> > A couple weekends ago I upgraded our Koha instance from 22.05 to
> 22.11, and
> >>> > I'm having trouble with the background_jobs processes becoming
> zombies
> >>&g

[Koha] Reminder: General IRC Meeting on "today"

[David Nind]

Just a reminder that the General IRC Meeting is scheduled for 19 April 2023
15:00 UTC.

If you are able to attend, that would be great!

See the agenda for details:
https://wiki.koha-community.org/wiki/General_IRC_meeting_19_April_2023

It's not too late to add agenda items...

David Nind
New Zealand

PS: I most likely won't be attending, as it is around 3am New Zealand time.
___

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

Re: [Koha] Help needed with zombie background_jobs processes

[Jonathan Druart]

Did you have a look at worker-*.log? Nothing useful there?

You can try to send SIGCHLD to the parent to kill the zombie.

Le mar. 18 avr. 2023 à 22:09, Cindy Murdock Ames  a écrit :
>
> A few other things I've noticed:
>
> - Sometimes the zombie processes will go away on their own, sometimes it 
> seems when you retry the MARC import or whatever it was that failed.  This 
> one is really weird to me as in all my years as a sysadmin I thought it was 
> not possible for zombie processes to go away without a reboot.  But maybe 
> that's changed and now zombies can rise from the dead.  Lol.
>
> - In looking at the jobs list in Koha, it seems that Holds queue updates are 
> especially prone to getting stuck at a progress of null/1.
>
> - If you reattempt a job that is stuck (ie, reattempting a MARC file upload 
> or what not) it will often succeed.  The original failed job remains with a 
> progress of null.
>
> c.
> ---
> Cindy Murdock Ames
> IT Services Director
> Meadville Public Library | CCFLS
> https://meadvillelibrary.org | https://ccfls.org
>
> Please report tech support issues in Mantis:  https://mantis.ccfls.org
>
>
> On Tue, Apr 18, 2023 at 3:55 PM Cindy Murdock Ames  wrote:
>>
>> Yes, it's 22.11.04, package version.
>>
>> ---
>> Cindy Murdock Ames
>> IT Services Director
>> Meadville Public Library | CCFLS
>> https://meadvillelibrary.org | https://ccfls.org
>>
>>
>>
>>
>> On Tue, Apr 18, 2023 at 2:59 PM Jonathan Druart 
>>  wrote:
>>>
>>> Hi Cindy,
>>> Which exact version of Koha 22.11.xx? It should be the latest one.
>>> Regards,
>>> Jonathan
>>>
>>> Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames  a 
>>> écrit :
>>> >
>>> > Hi all,
>>> >
>>> > A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, 
>>> > and
>>> > I'm having trouble with the background_jobs processes becoming zombies
>>> > after a very short amount of time, necessitating a reboot.  I suspect it's
>>> > a misconfiguration on my part, so if someone can shed some light I'd 
>>> > really
>>> > appreciate it!
>>> >
>>> > The first symptom was our MARC imports getting stuck at "import queued",
>>> > and after some digging (and thanks to the thread in this list with the
>>> > subject of "Background job / Staging MARC import stuck at 0%" I found I 
>>> > was
>>> > entirely missing the  section in our config, so I added
>>> > this:
>>> >
>>> >  
>>> >localhost
>>> >61613
>>> >guest
>>> >guest
>>> >
>>> >  
>>> >
>>> > Which seemed to resolve it, but now I find that the background_jobs
>>> > processes are going zombie after processing only a few jobs.  Here's some
>>> > info from the rabbitmq log after restarting the server:
>>> >
>>> > =INFO REPORT 18-Apr-2023::12:23:46 ===
>>> > node   : rabbit@ccflskoha
>>> > home dir   : /var/lib/rabbitmq
>>> > config file(s) : /etc/rabbitmq/rabbitmq.config (not found)
>>> > cookie hash: ojvkUE6eUtku7kHlx3uiFg==
>>> > log: /var/log/rabbitmq/rab...@ccflskoha.log
>>> > sasl log   : /var/log/rabbitmq/rab...@ccflskoha-sasl.log
>>> > database dir   : /var/lib/rabbitmq/mnesia/rabbit@ccflskoha
>>> >
>>> > Is it problematic that /etc/rabbitmq/rabbitmq.config is missing?  Anything
>>> > else I should be looking at?  We're running on Ubuntu SE 18.04 if that is
>>> > helpful.
>>> >
>>> > Thanks much!
>>> > Cindy
>>> >
>>> >
>>> > ---
>>> > Cindy Murdock Ames
>>> > IT Services Director
>>> > Meadville Public Library | CCFLS
>>> > https://meadvillelibrary.org | https://ccfls.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

Re: [Koha] Can't connect to local MySQL server through socket

[DHIM IT]

Hello again,

after I run the command sudo koha-mysql koha , the cron working again without 
any error. Thank you!


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


Hello, yes, without any error. 




Am 18.04.23, 07:12 schrieb "Mason James" mailto:m...@kohaaloha.com> >>:




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 




___

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