Re: [Koha] Can't run auth_show_hidden_data.pl script

2017-12-06 Thread Prof. Lisandro Laura
Perfect!
That works
Thank you,
Lisandro

2017-12-06 11:51 GMT-03:00 Mark Alexander :
> Excerpts from Prof. Lisandro Laura's message of 2017-12-06 11:41:57 -0300:
>> perl ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl
>>
>> But I get the following error:
>>
>> "Can't locate Koha/Authorities.pm in @INC (you may need to install the
>> Koha::Authorities module) (@INC contains: /etc/perl
>
> This sounds familiar.  Try running the following command first:
>
>   koha-shell LIBRARY
>
> where LIBRARY is your Koha instance name.  After that, the various
> Koha shell scripts should work.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Can't run auth_show_hidden_data.pl script

2017-12-06 Thread Prof. Lisandro Laura
Hi everyone!
I was upgrading from 17.05.04 to 17.05.06 and the following showed up:
"Bug 18811 fixed an inconsistency in the visibility settings for
authority frameworks. It is recommended that you run script
misc/maintenance/auth_show_hidden_data.pl to check if you have data in
hidden fields and adjust your frameworks accordingly to prevent data
loss when editing such records"

I was traying to run the script:
perl ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl

But I get the following error:

"Can't locate Koha/Authorities.pm in @INC (you may need to install the
Koha::Authorities module) (@INC contains: /etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20
/usr/share/perl/5.20 /usr/local/lib/site_perl .) at
./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl line 28.
BEGIN failed--compilation aborted at
./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl line 28."

What can I do?

Thank you in advance,
Lisandro
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Create log4pearl.conf for old Koha instance?

2017-09-04 Thread Prof. Lisandro Laura
Hi Michael.
All the files are in my Koha instance under that directory.
Thank you...

2017-09-03 5:37 GMT-03:00 Michael Kuhn :
> Hi Lisandro
>
>> It seems to be working... but I don't know how to check if it is ok...
>> No crashes so far...
>> Could you please send a list of th content of
>> /etc/koha/sites/INSTANCE/ directory? I want to know if anything else
>> is missing there...
>
>
> The content is:
>
> -rw-r- 1 root  sandkasten-koha 14680 Nov 30  2016 koha-conf.xml
> -rw-r- 1 root  sandkasten-koha   643 Nov 30  2016 log4perl.conf
> -rw-r- 1 root  sandkasten-koha  2361 Jun 30 09:34 zebra-authorities.cfg
> -rw-r- 1 root  sandkasten-koha  2044 Jun 30 09:34
> zebra-authorities-dom.cfg
> -rw-r- 1 root  sandkasten-koha  2341 Jun 30 09:34 zebra-biblios.cfg
> -rw-r- 1 root  sandkasten-koha  2314 Jun 30 09:34 zebra-biblios-dom.cfg
> -rw-r- 1 root  sandkasten-koha26 Nov 30  2016 zebra.passwd
>
> If you need the content of one or more of these files, just tell me so.
>
>
> 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
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Create log4pearl.conf for old Koha instance?

2017-09-02 Thread Prof. Lisandro Laura
Hi Michael.
I did the following (INSTANCE stands for my koha instance name):

nano /etc/koha/sites/INSTANCE/log4perl.conf

Copy / Paste the content you share and replace with my INSTANCE name
"sandkasten"

chown root:biblioteca-koha /etc/koha/sites/INSTANCE/log4perl.conf
chmod 640 /etc/koha/sites/INSTANCE/log4perl.conf

After that, I added in my  "/etc/koha/sites/INSTANCE/koha-conf.xml"
/etc/koha/sites/INSTANCE/log4perl.conf

Rebooted my Koha server...

It seems to be working... but I don't know how to check if it is ok...
No crashes so far...
Could you please send a list of th content of
/etc/koha/sites/INSTANCE/ directory? I want to know if anything else
is missing there...
Best wishes,
Lisandro

2017-08-29 11:31 GMT-03:00 Michael Kuhn :
> Hi Lisandro
>
>> I am getting the following message in the about page:
>> "You are missing the  entry in your koha-conf.xml file.
>> Please add it, pointing to the log4perl.conf file for your Koha
>> instance."
>>
>> After a Google search I looked for the log4perl.conf file on my
>> server... but I can't find it. Do I have to create it in any way?
>> If not, Ijust need to add the following line in my
>> /etc/koha/sites/INSTANCE/koha-conf.xml ?
>>   /etc/koha/log4perl.conf
>>
>> Thank you in advance...
>
>
>
> In my demo installation (instance "sandkasten") I found the file
> "/etc/koha/sites/sandkasten/log4perl.conf" with the following content. Of
> course you will have to replace "sandkasten" with the name of your own
> instance.
>
> log4perl.logger.intranet = WARN, INTRANET
> log4perl.appender.INTRANET=Log::Log4perl::Appender::File
> log4perl.appender.INTRANET.filename=/var/log/koha/sandkasten/intranet-error.log
> log4perl.appender.INTRANET.mode=append
> log4perl.appender.INTRANET.layout=PatternLayout
> log4perl.appender.INTRANET.layout.ConversionPattern=[%d] [%p] %m %l %n
>
> log4perl.logger.opac = WARN, OPAC
> log4perl.appender.OPAC=Log::Log4perl::Appender::File
> log4perl.appender.OPAC.filename=/var/log/koha/sandkasten/opac-error.log
> log4perl.appender.OPAC.mode=append
> log4perl.appender.OPAC.layout=PatternLayout
> log4perl.appender.OPAC.layout.ConversionPattern=[%d] [%p] %m %l %n
>
> The permissions are as follows:
>
> # ls -al  /etc/koha/sites/sandkasten/log4perl.conf
> -rw-r- 1 root sandkasten-koha 643 Nov 30  2016
> /etc/koha/sites/sandkasten/log4perl.conf
>
> I never heard about this file before so I'm quite sure it is usually
> automatically created during the creation of the instance.
>
> However, my file "/etc/koha/sites/sandkasten/koha-conf.xml" does contain the
> following line which I never had to insert or change manually:
>
> /etc/koha/sites/sandkasten/log4perl.conf
>
> Hope this helps.
>
> 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
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Duplicated ID in borrowers and deletedborrowers tables

2017-09-01 Thread Prof. Lisandro Laura
Fixed!
Thank you...
Lisandro

2017-08-22 2:43 GMT-03:00 vinod mishra :
> Yes it will fix the problem.
>
> On 22 Aug 2017 05:49, "Prof. Lisandro Laura"  wrote:
>>
>> Hi everyone!
>> I encountered an issue in the About Page: "The following ids exist in
>> both borrowers y deletedborrowers tables: 52, 78"
>>
>> I think deleting the rows with "borrowernumber" equal to 52 and 78 in
>> "deletedborrowers" table will fix this (in my case). What do you think
>> about this action?
>> How can I do it?
>>
>> Koha Version: 17.05.02.000
>> Debian 8.9
>>
>> Thank you in advance,
>> Lisandro
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha 16.11.04 - Setting a template cache directory

2017-09-01 Thread Prof. Lisandro Laura
Hi!
I did what Mark suggested... so far, so well...
I think it is working... but I don't know if it improves performance or not...
Now I'm tidying up things with log4perl.conf
Thank you!
Lisandro

2017-08-31 17:49 GMT-03:00 Doug Dearden :
> Hi Prof,
>
> Here is what I did.  I have multiple instances/sites running, if you have 
> more than one instance do this for each one.
> Login to a terminal session on your server as a regular user (koha, not root)
> cd /etc/koha/sites/(instance name)
> sudo nano koha-conf.xml   This brings up the editor nano and loads the 
> koha-conf.xml file into it.  Use a different editor if you are more familiar 
> with it.  Scroll down to the bottom of the file.  Near the bottom you should 
> see the tag .  Add a line right above that that reads:
> /tmp/yourinstancename
> replacing yourinstancename with the instance/site name.  Save the file (in 
> nano, Ctrl-o then Ctrl-x to exit).  Repeat for each instance/site you have.
> Using your browser go to the staff interface for the site in question.  
> Reload the About page.  The warning should be gone.  Check the OPAC also.
> If things don't load normally or you get an error, go back and check your 
> spelling.  A typo will break things. ;)
> Back in your terminal session
> cd /tmp
> ls -all
> You should see your instance names listed.  When you are happy that all is 
> well:
> exit
>
> Best,
>
> Doug Dearden, Director, IT
> School for Advanced Research
> PO Box 2188
> Santa Fe, NM 87504-2188
> 505-954-7220
> www.sarweb.org
>
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Prof. 
> Lisandro Laura
> Sent: Saturday, August 26, 2017 8:06 AM
> To: Petter Goksøyr Åsen 
> Cc: koha 
> Subject: Re: [Koha] Koha 16.11.04 - Setting a template cache directory
>
> Hello!
> Could anyone please point me to a simple step by step instruction to
> set  entry in my koha-conf.xml file?
> Thank you in advance...
>
> 2017-03-03 4:12 GMT-03:00 Petter Goksøyr Åsen
> :
>> I would choose a path that's not on a spinning disc at least. Depending on 
>> your OS setup, /tmp is
>> often mounted to RAM, so that's what I would use.
>>
>> Petter Goksøyr Åsen
>> Deichmanske bibliotek / Oslo Public Library
>> 
>> Fra: Koha [koha-boun...@lists.katipo.co.nz] på vegne av Mark Alexander 
>> [ma...@pobox.com]
>> Sendt: 2. mars 2017 21:53
>> Til: Craig Butosi
>> Kopi: koha
>> Emne: Re: [Koha] Koha 16.11.04 - Setting a template cache directory
>>
>> Excerpts from Craig Butosi's message of 2017-03-02 13:42:07 +:
>>> >You are missing the  entry in your koha-conf.xml file. 
>>> >That will bring a performance boost to >enable it.
>>>
>>> Is there an expected, standard, or best directory path to use? The error is 
>>> clear enough; however, I'd like to define the directory with an appropriate 
>>> path.
>>
>> In this bug comment:
>>
>>   https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17951#c2
>>
>> it was suggested that we use /var/cache/koha//templates,
>> so that was what I used, and it seems to work fine.
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha 16.11.04 - Setting a template cache directory

2017-08-30 Thread Prof. Lisandro Laura
Hello!
Could anyone please point me to a simple step by step instruction to
set  entry in my koha-conf.xml file?
Thank you in advance...

2017-03-03 4:12 GMT-03:00 Petter Goksøyr Åsen
:
> I would choose a path that's not on a spinning disc at least. Depending on 
> your OS setup, /tmp is
> often mounted to RAM, so that's what I would use.
>
> Petter Goksøyr Åsen
> Deichmanske bibliotek / Oslo Public Library
> 
> Fra: Koha [koha-boun...@lists.katipo.co.nz] på vegne av Mark Alexander 
> [ma...@pobox.com]
> Sendt: 2. mars 2017 21:53
> Til: Craig Butosi
> Kopi: koha
> Emne: Re: [Koha] Koha 16.11.04 - Setting a template cache directory
>
> Excerpts from Craig Butosi's message of 2017-03-02 13:42:07 +:
>> >You are missing the  entry in your koha-conf.xml file. 
>> >That will bring a performance boost to >enable it.
>>
>> Is there an expected, standard, or best directory path to use? The error is 
>> clear enough; however, I'd like to define the directory with an appropriate 
>> path.
>
> In this bug comment:
>
>   https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17951#c2
>
> it was suggested that we use /var/cache/koha//templates,
> so that was what I used, and it seems to work fine.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Create log4pearl.conf for old Koha instance?

2017-08-29 Thread Prof. Lisandro Laura
Hello!
I am getting the following message in the about page:
"You are missing the  entry in your koha-conf.xml file.
Please add it, pointing to the log4perl.conf file for your Koha
instance."

After a Google search I looked for the log4perl.conf file on my
server... but I can't find it. Do I have to create it in any way?
If not, Ijust need to add the following line in my
/etc/koha/sites/INSTANCE/koha-conf.xml ?
 /etc/koha/log4perl.conf

Thank you in advance...

--
Koha: 17.05.02.000
Debian 8.9
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Duplicated ID in borrowers and deletedborrowers tables

2017-08-21 Thread Prof. Lisandro Laura
Thank you!
That fixed my issue...

2017-08-21 21:35 GMT-03:00 Joy Nelson :
> Lisandro-
> You will need direct access to the database to correct this.
>
> Login to mysql (or mariadb) and run the following query:
> delete from deletedborrowers where borrowernumber in (52,78);
>
> The above query will take care of those duplicated ids.
>
> joy
>
>
> On Mon, Aug 21, 2017 at 7:19 PM, Prof. Lisandro Laura
>  wrote:
>>
>> Hi everyone!
>> I encountered an issue in the About Page: "The following ids exist in
>> both borrowers y deletedborrowers tables: 52, 78"
>>
>> I think deleting the rows with "borrowernumber" equal to 52 and 78 in
>> "deletedborrowers" table will fix this (in my case). What do you think
>> about this action?
>> How can I do it?
>>
>> Koha Version: 17.05.02.000
>> Debian 8.9
>>
>> Thank you in advance,
>> Lisandro
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
>
> --
> Joy Nelson
> Director of Migrations
>
> ByWater Solutions
> Support and Consulting for Open Source Software
> Office: Fort Worth, TX
> Phone/Fax (888)900-8944
> What is Koha?
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Duplicated ID in borrowers and deletedborrowers tables

2017-08-21 Thread Prof. Lisandro Laura
Hi everyone!
I encountered an issue in the About Page: "The following ids exist in
both borrowers y deletedborrowers tables: 52, 78"

I think deleting the rows with "borrowernumber" equal to 52 and 78 in
"deletedborrowers" table will fix this (in my case). What do you think
about this action?
How can I do it?

Koha Version: 17.05.02.000
Debian 8.9

Thank you in advance,
Lisandro
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Patron Card Images pixelated in PDF

2014-09-27 Thread Prof. Lisandro Laura
Hi everyone!
I am new with Koha and I have been trying to print decent Patron Cards
but the result is not filling out my expectations.
Patron images and library logo are pixelated despite size, DPI and
format (jpg png).
Patron images on screen are good looking quality, but pixelated when
processing batch in the resulting PDF.
I have been googling around with no luck.
I am running Koha 3.16 over Ubuntu 12.04 LTS (updated the system a few
days ago with apt-get).
The version of Koha is: 3.16.03.000
Ubuntu is 12.04 LTS Server (i386).
About the images, we use several... last attempt was png 200x300px, 300dpi.
We also try 1600x2192px 300dpi with no results.
Is there some fix resolution for images that works?
Any ideas?
Thank you in advance,
Lisandro
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Patron Card Images pixelated in PDF

2014-09-27 Thread Prof. Lisandro Laura
Ok... so I will restart this conversation from the beginning.
Thank you,
Lisandro

2014-09-27 13:25 GMT-03:00 Riley Childs :
> Yes, I neglected to copy the list on the email! Always copy the list on the
> email.
>
> Riley Childs
> Senior
> Charlotte United Christian Academy
> Library Services Administrator
> IT Services
> (704) 497-2086
> rileychilds.net
> @rowdychildren
> ________
> From: Prof. Lisandro Laura
> Sent: ‎9/‎27/‎2014 11:04 AM
> To: Riley Childs
> Subject: Re: [Koha] Patron Card Images pixelated in PDF
>
> Dear Riley: I apologise for any inconvenience this may cause, but I
> will like to know if I should resend this issue to Koha list.
> I have been struggling with this for a while and I need to find a way out.
> Thank you in advance for your time and effort,
> Lisandro
>
> 2014-09-22 19:00 GMT-03:00 Prof. Lisandro Laura :
>> Hi Riley!
>> The version of Koha is: 3.16.03.000
>> Ubuntu is 12.04 LTS Server (i386).
>> About the images, we use several... last attempt was png 200x300px,
>> 300dpi.
>> We also try 1600x2192px 300dpi with no results.
>> Is there some fix resolution for images that works?
>> Thank you in advance,
>> Lisandro
>>
>> 2014-09-21 18:56 GMT-03:00 Riley Childs :
>>
>>> What is the resolution of the images? And what is your exact koha version
>>> (3.16.x) under About in the staff interface
>>>
>>> Riley Childs
>>> Senior
>>> Charlotte United Christian Academy
>>> Library Services Administrator
>>> IT Services
>>> (704) 497-2086
>>> rileychilds.net
>>> @rowdychildren
>>> 
>>> From: Prof. Lisandro Laura
>>> Sent: ‎9/‎21/‎2014 11:00 AM
>>> To: koha@lists.katipo.co.nz
>>> Subject: [Koha] Patron Card Images pixelated in PDF
>>>
>>> Hi everyone!
>>> I am new with Koha and I have been trying to print decent Patron Cards
>>> but
>>> the result is not filling out my expectations.
>>> Patron images and library logo are pixelated despite size, DPI and format
>>> (jpg png).
>>> Patron images on screen are good looking quality, but pixelated when
>>> processing batch in the resulting PDF.
>>> I have been googling around with no luck.
>>> I am running Koha 3.16 over Ubuntu 12.04 LTS (updated the system a few
>>> days
>>> ago with apt-get).
>>> Any ideas?
>>> Thank you in advance,
>>> Lisandro
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Patron Card Images pixelated in PDF

2014-09-22 Thread Prof. Lisandro Laura
Hi Riley!
The version of Koha is: 3.16.03.000
Ubuntu is 12.04 LTS Server (i386).
About the images, we use several... last attempt was png 200x300px, 300dpi.
We also try 1600x2192px 300dpi with no results.
Is there some fix resolution for images that works?
Thank you in advance,
Lisandro

2014-09-21 18:56 GMT-03:00 Riley Childs :

>   What is the resolution of the images? And what is your exact koha
> version (3.16.x) under About in the staff interface
>
> Riley Childs
> Senior
> Charlotte United Christian Academy
> Library Services Administrator
> IT Services
> (704) 497-2086
> rileychilds.net
> @rowdychildren
>  ----------
> From: Prof. Lisandro Laura 
> Sent: ‎9/‎21/‎2014 11:00 AM
> To: koha@lists.katipo.co.nz
> Subject: [Koha] Patron Card Images pixelated in PDF
>
>   Hi everyone!
> I am new with Koha and I have been trying to print decent Patron Cards but
> the result is not filling out my expectations.
> Patron images and library logo are pixelated despite size, DPI and format
> (jpg png).
> Patron images on screen are good looking quality, but pixelated when
> processing batch in the resulting PDF.
> I have been googling around with no luck.
> I am running Koha 3.16 over Ubuntu 12.04 LTS (updated the system a few days
> ago with apt-get).
> Any ideas?
> Thank you in advance,
> Lisandro
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Patron Card Images pixelated in PDF

2014-09-21 Thread Prof. Lisandro Laura
Hi everyone!
I am new with Koha and I have been trying to print decent Patron Cards but
the result is not filling out my expectations.
Patron images and library logo are pixelated despite size, DPI and format
(jpg png).
Patron images on screen are good looking quality, but pixelated when
processing batch in the resulting PDF.
I have been googling around with no luck.
I am running Koha 3.16 over Ubuntu 12.04 LTS (updated the system a few days
ago with apt-get).
Any ideas?
Thank you in advance,
Lisandro
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha