Re: [Koha] Export tool failure Koha 21.11.03.000

[Evan Stewart]

All,

Thanks.  After searching (and praying) I found the problem.  The export.pl
script was failing to load in the browser.  I checked the error log
"/var/log/koha//intranet-error.log" and found this error:

[*cgid*:error] [pid 10306] (13)Permission denied: [client 174.22.2.20:53436]
AH01257: unable to connect to cgi daemon after multiple tries:
/usr/share/koha/intranet/cgi-bin/tools/export.pl

I thought the "cgid" module was disabled because the error message
references "cgid", but when I tried to enable it my server showed it was
already enabled.  I assumed the "cgi" module was already enabled and so I
never checked on it.  Later into my troubleshooting I ran the enable
command for "cgi" and discovered it was disabled.  After enabling it and
restarting Apache, the export tool is now loading in the browser.

My local testing server had the cgi module enabled, but I never noticed the
difference with my AWS server until now.

(In case someone else encounters this problem with the export tool) Running
the following commands fixed the problem:

sudo a2enmod cgi
sudo systemctl restart apache2

-Evan

On Tue, May 10, 2022 at 12:31 PM Elaine Bradtke  wrote:

> I just tested it (21.11.05) with Authorities, giving a specific number and
> a range of record numbers (1, and then 50 records) both worked. Tried both
> XML and MARC.  We are not using AWS.
> Elaine
> VWML 
>
>
>
> On Mon, May 2, 2022 at 3:23 AM Katrin Fischer 
> wrote:
>
> > Hi Evan,
> >
> > there have been no bug reports about the export not working.
> >
> > Are you exporting authority or bibliographic records?
> >
> > Which settings do you use?
> >
> > Does it also happen when you try to export a single or very few records,
> > for example by biblionumber range?
> >
> > Hope this helps,
> >
> > Katrin
> >
> >
> > On 28.04.22 13:43, Evan Stewart wrote:
> > > Hi all,
> > >
> > > Has anyone else experienced errors with the Export tool in the Tools
> > menu?
> > >
> > > -Evan Stewart
> > >
> > > On Wed, Apr 13, 2022 at 3:09 AM Evan Stewart  >
> > > wrote:
> > >
> > >> Hello,
> > >>
> > >> I seem to be having a problem with the Export data tool (Tools >
> Export
> > >> Data).  When I click the Export link, I get a "503 Service
> Unavailable"
> > >> message.  All other tools I try are working fine. I'm running Koha on
> > AWS
> > >> (see details below).
> > >>
> > >> My local server versions of Koha (running on Debian) are working fine.
> > >> Just the AWS install is having the export tool failure.
> > >>
> > >> Has anyone experienced this problem with exporting data?
> > >>
> > >> Hosting Environment: AWS Lightsail, 2GB RAM
> > >> OS: Debian 10
> > >> Koha: 21.11.04.001
> > >> Server: Apache 2.4.38
> > >>
> > >> Any thoughts on how to troubleshoot to discover the cause?
> > >>
> > >> Thanks,
> > >> Evan Stewart
> > >>
> > >>
> > >>
> > > ___
> > >
> > > 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need help to reconfigure Koha Mail with Gmail

[David Nind]

Hi Chris.

I've used these instructions when testing bugs in Koha (using the
koha-testing-docker development environment), so not a production system:
https://gitlab.com/-/snippets/1893788#user-content-enabling-email-for-testing-more-complex-way

I haven't tested these in a while, as there is now an easier way for
testing email in more recent versions of Koha.

David Nind
___

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 to reconfigure Koha Mail with Gmail

[Chris Brown]

Thank you Thomas, the linode guide you supplied a link to is exactly what I
need. I'll take a look at this tomorrow when I'm feeling more awake.

Chris Brown


On Mon, Jun 20, 2022 at 7:27 PM Thomas Klausner  wrote:

> Hi!
>
> On Mon, Jun 20, 2022 at 06:40:58PM +0100, Chris Brown wrote:
>
> > Our koha mail system is set up to use a gmail account to process outbound
> > email, using the "less secure apps" option in the gmail account. This has
> > stopped working for us (and I'm sure for many others) now that Google
> have
> > disabled this feature. I am looking for specific advice on how to
> > reconfigure Koha so it continues to work with gmail (setting up an "app
> > password" perhaps?). I have seen a little discussion about this on the
> list
> > but no real guidance. Can anyone help please?
>
> This is not related to Koha, and cannot be fixed in Koha, but needs to
> be fixed on your SMTP connection (in postfix)
>
> I did a blog post (in a different context) on how to set up a google
> "app password":
>
> To get such an app password, you first have to secure your account with
> Two Factor Authentication (2FA) (if you haven't already done that):
>
> Go to https://myaccount.google.com
> Find "2-Step Verification" under the Security headline
> Go through the process. I use the "Google Authenticator" app on my
> mobile phone
> After you've set this up, you'll find the new option "App passwords"
> under "Security" / "Signing into Google"
> Select an app ("Mail") and give it a custom name (eg "offlineimap"),
> click on "generate" and copy the password (you'll never see it again!)
>
> The full blog post is here:
> https://domm.plix.at/perl/2022_05_use_multiple_gmail_accounts_via_mutt_and_offlineimap.html
>
>
> Then you will need to figure out how make postfix use that new password.
>
> A little bit of googling found this:
>
>
> https://www.linode.com/docs/guides/configure-postfix-to-send-mail-using-gmail-and-google-workspace-on-debian-or-ubuntu/
>
> Which also goes through the process of setting up an app password.
>
>
> Greetings,
> domm
>
> --
> #!/usr/bin/perl https://domm.plix.at
> for(ref bless{},just'another'perl'hacker){s-:+-$"-g&$_.$/}
> ___
>
> 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] Need help to reconfigure Koha Mail with Gmail

[Thomas Klausner]

Hi!

On Mon, Jun 20, 2022 at 06:40:58PM +0100, Chris Brown wrote:
 
> Our koha mail system is set up to use a gmail account to process outbound
> email, using the "less secure apps" option in the gmail account. This has
> stopped working for us (and I'm sure for many others) now that Google have
> disabled this feature. I am looking for specific advice on how to
> reconfigure Koha so it continues to work with gmail (setting up an "app
> password" perhaps?). I have seen a little discussion about this on the list
> but no real guidance. Can anyone help please?

This is not related to Koha, and cannot be fixed in Koha, but needs to 
be fixed on your SMTP connection (in postfix)

I did a blog post (in a different context) on how to set up a google 
"app password":

To get such an app password, you first have to secure your account with Two 
Factor Authentication (2FA) (if you haven't already done that):

Go to https://myaccount.google.com
Find "2-Step Verification" under the Security headline
Go through the process. I use the "Google Authenticator" app on my mobile 
phone
After you've set this up, you'll find the new option "App passwords" under 
"Security" / "Signing into Google"
Select an app ("Mail") and give it a custom name (eg "offlineimap"), click 
on "generate" and copy the password (you'll never see it again!)

The full blog post is here: 
https://domm.plix.at/perl/2022_05_use_multiple_gmail_accounts_via_mutt_and_offlineimap.html


Then you will need to figure out how make postfix use that new password.

A little bit of googling found this:

https://www.linode.com/docs/guides/configure-postfix-to-send-mail-using-gmail-and-google-workspace-on-debian-or-ubuntu/

Which also goes through the process of setting up an app password.


Greetings,
domm

-- 
#!/usr/bin/perl https://domm.plix.at
for(ref bless{},just'another'perl'hacker){s-:+-$"-g&$_.$/}
___

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

[Koha] Need help to reconfigure Koha Mail with Gmail

[Chris Brown]

Dear Koha Community

Our koha mail system is set up to use a gmail account to process outbound
email, using the "less secure apps" option in the gmail account. This has
stopped working for us (and I'm sure for many others) now that Google have
disabled this feature. I am looking for specific advice on how to
reconfigure Koha so it continues to work with gmail (setting up an "app
password" perhaps?). I have seen a little discussion about this on the list
but no real guidance. Can anyone help please?

We are running Koha 19.11.22 (installed from packages) on Debian and we're
using postfix 3.1.15 as our mail transport agent.

Thanks!

Chris Brown (Greenhill Community Library in the UK)
___

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

Re: [Koha] Fast cataloging

[Katrin Fischer]

Hi,

some ideas:

* Does your user have the fast_cataloging permission?

* Do you have a bibliographic MARC framework with framework code FA?

Hope this helps,

Katrin

On 20.06.22 09:13, Ma. Victoria H. Silva-Manuel wrote:

Hi.
"Fast cataloging" option is not showing up when I tried to check out
uncatalog book.
How to activate this feature?
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] search patron not working

[Katrin Fischer]

Hi Giuseppe,

I believe you might have to change the entry in koha.list as you are
using an older Ubuntu version:

https://wiki.koha-community.org/wiki/Koha_on_Debian#Support_for_Koha_on_older_versions_of_Debian.2FUbuntu_.28Debian_8.2C_Ubuntu_18.04.2C_Ubuntu_16.04.29

I am not sure what the exact steps are, but this might get you a little
further to resolving this.

Katrin

On 20.06.22 05:35, Giuseppe Angilella wrote:

Hi, Katrin.


You have a package installation on Ubuntu 18.04 LTS?


Yes, correct.


What does your entry in etc/apt/sources.list.d/koha.list look like?


The above file reads:

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

Many thanks!

Giuseppe.


___

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

[Koha] Background jobs in Koha menu "Administration"

[Michael Kuhn]

Hi

We saw in Koha 22.05 there is a new Koha menu "Administration > Manage 
background jobs". Unfortunately there seems to be no entry in the Koha 
manual 22.05 for it, also the context-sensitive help just leads to 
https://koha-community.org/manual//21.11/en/html/ (this is in an 
installation of Koha 22.05!).


However the shown list has a column "progress" which can say "1/1" or 
"0/0" for example. What does ist mean? Library personnel thinks "0/0" 
suggests that something went wrong even if column "Status" says 
"Finished". Unfortunately clicking the button "View" does not show more 
information like WHAT biblio or item exactly the entry is referring to.


We saw that Bywater Solutions wrote an article about this new menu ( 
https://bywatersolutions.com/education/koha-21-11-background-jobs-and-task-queue-enhancements 
) but our question is not answered there. Can someone please enlighten 
us what "0/0" means?


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

Re: [Koha] Error

[Hugo Agud Andreu]

Good morning

I have faced the same issue, there is no info on log file, howerver with the 
inspector i get some feedback it is related, sorry it is in spanish..

Content Security Policy: No se puede procesar la directiva desconocida 
'upgrade-insecure-requests�' 2

Esta página utiliza la propiedad no estándar “zoom”. Considere usar calc() en 
los valores de propiedad relevantes, o usar “transform” junto con 
“transform-origin: 0 0”. batch_record_modification.pl

La cookie “CGISESSID” no tiene un valor de atributo “SameSite” adecuado. 
Pronto, las cookies sin el atributo “SameSite o con un valor no válido serán 
tratadas como “Lax”. Esto significa que la cookie ya no se enviará en contextos 
de terceros. Si su aplicación depende de que esta cookie esté disponible en 
dichos contextos, añada el atributo “SameSite=none“. Para saber más sobre el 
atributo “SameSite“, leac

Thanks!


Hugo Agud - Orex Digital

www.orex.es - 
Linkedin

Innovando para ayudar a las bibliotecas a alcanzar el siguiente nivel




Director


Passeig Comte Vilardaga, 118 3-3  08980 -Sant Feliu de Llobregat - Tel: 933 856 
138   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 Himanshu Aggarwal 

Enviado: jueves, 3 de junio de 2021 14:49
Para: Jonathan Druart 
Cc: Koha 
Asunto: Re: [Koha] Error

Thanks, I checked but I get error  tail: cannot open '/var/log/koha//*.log'
for reading: No such file or directory
tail: no files remaining


On Thu, Jun 3, 2021 at 5:22 PM Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> run the following command on the server and try again a new batch
> record modification, you should see the relevant error.
>
>   tail -f /var/log/koha/$KOHA_INSTANCE/*.log
>
> Le jeu. 3 juin 2021 à 10:47, Himanshu Aggarwal
>  a écrit :
> >
> > No, I didn't. And I don't know how to look into that file. Sir can you
> guide me through the commands for the same?
> >
> > On Thu, Jun 3, 2021 at 1:42 PM Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
> >>
> >> Did you check the log files in /var/log/koha/$INSTANCE/*.log?
> >>
> >> Le sam. 29 mai 2021 à 07:24, Himanshu Aggarwal
> >>  a écrit :
> >> >
> >> > While doing batch record modification I am getting following error
> Cannot
> >> > enqueue this job. (The error was: Job has not been enqueued. See the
> Koha
> >> > logfile for more information). Kindly help
> >> >
> >> > --
> >> > Assistant Librarian,
> >> > Confucius Institute Scholar 13-14,
> >> > R.D. National College,
> >> > Bandra (W.)
> >> > 

[Koha] Problem while restoring Koha

[Abid Fakhre Alam]

Dear All,

When I upgrading the schema with this command "sudo koha-upgrade-schema
library" I got the following message.

*Upgrade to 21.06.00.001 [12:11:43]: Bug 28489 - Modify sessions.a_session
from longtext to longblob*
*ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Table
'koha_library.sessions' doesn't exist at
/usr/share/koha/lib/C4/Installer.pm line 739.*

Can anybody help me with this issue?


Thanks and Best Regards,
AFA
___

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

[Koha] Fast cataloging

[Ma. Victoria H. Silva-Manuel]

Hi.
"Fast cataloging" option is not showing up when I tried to check out
uncatalog book.
How to activate this feature?
Thanks.
___

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