Re: [Koha] Fwd: [Koha-devel] Call for news - Newsletter January 2024

[Chris Cormack]

Hi Michael

It was accepted as far as I can tell, it's certainly in the archive.

https://lists.katipo.co.nz/pipermail/koha/2024-January/060444.html

Chris 

On 16 January 2024 11:07:35 pm NZDT, Michael Kuhn  wrote:
>Hi
>
>From "kohan...@gmail.com" I have sent the following e-mail as usual to the 
>following two addresses:
>
>* koha@lists.katipo.co.nz
>* koha-de...@lists.koha-community.org
>
>But it only appeared via mailing list "koha-devel" - can the responsible 
>person for mailing list "koha" please have a look into the problem and enable 
>this e-mail to be accepted?
>
>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
>
>
>
> Weitergeleitete Nachricht 
>Betreff:   [Koha-devel] Call for news - Newsletter January 2024
>Datum: Sat, 13 Jan 2024 01:17:15 +0100
>Von:   Koha Newsletter via Koha-devel 
>Antwort an:Koha Newsletter 
>An:koha , koha-devel 
>
>
>
>
>Hi
>
>I'm collecting news for the January 2024 Koha Community Newsletter. Please 
>send anything noteworthy to:
>
>kohanews (at) gmail (dot) com
>
>News criteria:
>* News items can be of any length.
>* Images are fine.
>* Anything and everything Koha.
>* Submit by the 26th of the month.
>
>Text format criteria:
>* Just structured plain text, or
>* HTML text to include tables or similar
>
>For events:
>* Consider adding your event to the Koha Community calendar 
>athttps://koha-community.org/calendar/ 
>
>Thank you!
>
>Michael Kuhn
>Editor, Koha Community Newsletter
>

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

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Chris Cormack]

What does

sudo koha-plack --start instancename

Do?

Chris 

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

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Chris Cormack]

Hi Bruce

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

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

does sudo koha-list  work and list your instance?

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


Chris

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

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

Hi Bruce


I Chris. I remember meeting you in Reno!


We've found the problem.


root@store:/# apt-get update && apt-get install --reinstall koha-common
[some lines skipped]
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
koha-common : Depends: libtest-dbix-class-perl but it is not going to
be installed
E: Unable to correct problems, you have held broken packages.
This is the issue right here, koha-common can't be installed cleanly 
because a package it depends on is missing.


What does
  sudo apt install libtest-dbix-class-perl
Result in?


root@store:/etc/koha# apt install libtest-dbix-class-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
  libtest-dbix-class-perl : Depends: libdata-uuid-perl (>= 1.215)
E: Unable to correct problems, you have held broken packages


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

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


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


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


But still no love for the OPAC or admin interface.

Feels like good progress though. What next?

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


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

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

Re: [Koha] Fwd: Dead Koha Resuscitation

[Chris Cormack]

Hi Bruce

We've found the problem. 

On 19 May 2023 7:46:58 am NZST, "Bruce A. Metcalf" 
 wrote:
>On 5/18/23 14:52, David Liddle wrote:
>
>> Hello, Bruce. You've been good about chasing down the information folks have 
>> asked for. I'm sorry that we haven't brought you closer
>> to a solution.
>
>
>I'm no less appreciative of your efforts for that.
>
>
>> I have some follow-up questions:
>> 
>> 1.a. Database. Once you listed the databases, did you exit the mysql prompt 
>> and back up the koha_library database with the mysqldump command?
>
>
>Yes, and it appeared to work. I have a 450MB file called backup.sql.
>
>
>> 1.b.Can you use an FTP client such as FileZilla to download such files?
>
>
>I assume so.
>
>
>> 2.a. Path. What is the result of this command? env | grep -i 'path'
>
>
>root@store:/# env | grep -i 'path'
>PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
>
>I am aware that the path should contain several sbin directories, but I
>don't know how to add them.
>
>
>> 2.b. Path. Did you already establish that the Koha commands are or are not 
>> installed? ls /usr/sbin/koha*
>
>
>Yes, the usual list of commands is there. This suggests to me that the
>inadequate PATH command is at least part of my problem.
>
>
>> 3. Repository and deb. Did you run "apt update" before running "apt-get 
>> install --reinstall koha-common"?
>
>
>Yes. The resultant is:
>
>root@store:/# apt-get update && apt-get install --reinstall koha-common
>[some lines skipped]
>Some packages could not be installed. This may mean that you have
>requested an impossible situation or if you are using the unstable
>distribution that some required packages have not yet been created
>or been moved out of Incoming.
>The following information may help to resolve the situation:
>
>The following packages have unmet dependencies:
> koha-common : Depends: libtest-dbix-class-perl but it is not going to
>be installed
>E: Unable to correct problems, you have held broken packages.
>

This is the issue right here, koha-common can't be installed cleanly because a 
package it depends on is missing. 

What does
 sudo apt install libtest-dbix-class-perl


Result in? 

Chris 


>
>> The current version is 21.11.20.
>
>
>Right, but I haven't been able to employ any earlier version, either.
>
>
>> Yes, koha-common appears to be running, though maybe I'm reading it wrong. 
>> Have you checked the Apache config file for your instance, probably 
>> /etc/apache2/sites-available/library.conf
>
>
>There are two links in that file, one for the OPAC and one for admin access.
>
>
>> SSL Certificate information will be important.
>
>
>There is no mention of SSL Certificates in the file.
>
>
>> There are also Apache-related config files in /etc/koha, which I think could 
>> have been overwritten in the upgrade; that may or may
>> not be important.
>
>
>There are such files. I don't know what to make of them.
>
>
>> 5. This situation is a good opportunity to research and document the
>> elements on the server that you need to back up manually and download
>> in the event that you need to rebuild the server from scratch. I'm
>> guessing you don't do this work full-time, but having this
>> information written will save you and/or your successor a lot of time
>> when that day comes.
>
>
>Yeah, I should be so lucky as to have someone take over for me!  The 
>organization is a non-profit with declining participation.
>
>
>> Is this hosted server just running: 1. the main website (what
>> platform or site-building tool?), 2. a wiki (MediaWiki?), and 3.
>> Koha? That backup will probably come down to the databases you've
>> listed and one or more directories for each service.
>
>
>The virtual server is running an Online Store, a Wiki, and Koha. Minor file 
>storage is all else that's there.
>
>
>What I suspect at this point is that I need to add the sbin directories to the 
>PATH. Can someone point me to a tutorial?
>
>Regards,
>/ Bruce /
>Bruce A. Metcalf, Librarian
>The Augustan Library
>___
>
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

[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

Re: [Koha] Koha and IPV6

[Chris Cormack]

Kia ora Michael

If you want to run it via IPV6 you will just need to set up Apache (or 
Nginx or whatever you have in front of plack) to support IPV6 (and the 
networking itself of course) and then it should work fine.

There should be no tricks needed

Chris

On 21/02/23 09:36, Michael Kuhn wrote:

Hi

Our library can access the the future virtual machine running Koha only 
via IPV6. I coulnd't find the terms IPV4 or IPV6 neither in 
https://wiki.koha-community.org/wiki/System_requirements_and_recommendations nor in the current Koha manual. Thus my question (since until now I have implemented only Koha-installations with IPV4):


Is Koha able to run just with IPV6 addresses, also when using Let's 
Encrypt?


Are there maybe some caveats?

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] [Koha-devel] Upgrading bugs.koha-community.org (plus others)

[Chris Cormack]

Hi again all

Everything should be back now, please let me know if you spot anything off.

For those that are interested, I resized the server, changed it from
i386 to amd64 and upgraded from Ubuntu 18.04 to 20.04. (18.04 goes out
of support in April).
It should be slightly faster with more ram available.

Happy new OS for new year :)

Chris

On Tue, 3 Jan 2023 at 12:55, Tomas Cohen Arazi  wrote:
>
> Thanks for letting us know! Good luck!
>
> El lun, 2 ene 2023 19:54, Chris Cormack  escribió:
>>
>> Hi All
>>
>> The linode that bugs, dashboard, splitter, download, plus the bots run
>> on needs an OS upgrade.
>>
>> I am about to snapshot it and attempt that now. The server may or may
>> not go down for various parts of the upgrade. I will let you know when
>> it has been completed of I have to rollback.
>>
>> Chris
>> ___
>> 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] Upgrading bugs.koha-community.org (plus others)

[Chris Cormack]

To be clear there are still a part 2 and 3 and 4. It's not finished yet :)

Chris

On Tue, 3 Jan 2023 at 12:20, Chris Cormack  wrote:
>
> Part one is done, the harder part, switching it from i386 to amd64, so
> hopefully now the rest is smooth sailing
>
> Chris
>
> On Tue, 3 Jan 2023 at 11:53, Chris Cormack  wrote:
> >
> > Hi All
> >
> > The linode that bugs, dashboard, splitter, download, plus the bots run
> > on needs an OS upgrade.
> >
> > I am about to snapshot it and attempt that now. The server may or may
> > not go down for various parts of the upgrade. I will let you know when
> > it has been completed of I have to rollback.
> >
> > Chris
___

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

Re: [Koha] Upgrading bugs.koha-community.org (plus others)

[Chris Cormack]

Part one is done, the harder part, switching it from i386 to amd64, so
hopefully now the rest is smooth sailing

Chris

On Tue, 3 Jan 2023 at 11:53, Chris Cormack  wrote:
>
> Hi All
>
> The linode that bugs, dashboard, splitter, download, plus the bots run
> on needs an OS upgrade.
>
> I am about to snapshot it and attempt that now. The server may or may
> not go down for various parts of the upgrade. I will let you know when
> it has been completed of I have to rollback.
>
> Chris
___

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

[Koha] Upgrading bugs.koha-community.org (plus others)

[Chris Cormack]

Hi All

The linode that bugs, dashboard, splitter, download, plus the bots run
on needs an OS upgrade.

I am about to snapshot it and attempt that now. The server may or may
not go down for various parts of the upgrade. I will let you know when
it has been completed of I have to rollback.

Chris
___

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] Some very sad news.

[Chris Cormack]

Tēnā koutou anō

Here is the link for the livestream of the service tomorrow

https://view.oneroomstreaming.com/index.php?data=MTY2OTAxNDM0NDEwNDYwMDQmb25lcm9vbS1lbWFpbCZpbnZpdGF0aW9uX2NvcHlfbGluaw%3D%3D

Chris 

On 21 November 2022 11:21:54 am NZDT, Chris Cormack  
wrote:
>Tēnā koutou
>
>Here is the obituary for Rosalie
>https://deaths.dompost.co.nz/nz/obituaries/dominion-post-nz/name/rosalie-blake-obituary?pid=203242974
>
>I think the service is going to be streamed so I will send details when I have 
>them
>
>Chris 
>
>On 17 November 2022 8:09:24 pm NZDT, Chris Cormack  
>wrote:
>>Tēnā koutou
>>
>>It is with great sadness that I pass on to you all the news that Rosalie
>>Blake has passed away.
>>Rosalie was the Head Librarian at Horowhenua Library Trust when Koha was
>>started and without her Koha would not exist.
>>But more than this Rosalie was an amazing person, a librarian who always
>>thought outside the box, a gifted potter, a friend to many and a beloved
>>mother and grandmother.
>>
>>Details around the funeral and memorial note should be available tomorrow.
>>But I am sure you will all join me holding Rosalie's family and friends in
>>your thoughts.
>>
>>Tiwhatiwha te pō, tiwhatiwha te ao.
>>
>>Chris
>___
>
>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] Some very sad news.

[Chris Cormack]

Tēnā koutou

Here is the obituary for Rosalie
https://deaths.dompost.co.nz/nz/obituaries/dominion-post-nz/name/rosalie-blake-obituary?pid=203242974

I think the service is going to be streamed so I will send details when I have 
them

Chris 

On 17 November 2022 8:09:24 pm NZDT, Chris Cormack  
wrote:
>Tēnā koutou
>
>It is with great sadness that I pass on to you all the news that Rosalie
>Blake has passed away.
>Rosalie was the Head Librarian at Horowhenua Library Trust when Koha was
>started and without her Koha would not exist.
>But more than this Rosalie was an amazing person, a librarian who always
>thought outside the box, a gifted potter, a friend to many and a beloved
>mother and grandmother.
>
>Details around the funeral and memorial note should be available tomorrow.
>But I am sure you will all join me holding Rosalie's family and friends in
>your thoughts.
>
>Tiwhatiwha te pō, tiwhatiwha te ao.
>
>Chris
___

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

[Koha] Some very sad news.

[Chris Cormack]

Tēnā koutou

It is with great sadness that I pass on to you all the news that Rosalie
Blake has passed away.
Rosalie was the Head Librarian at Horowhenua Library Trust when Koha was
started and without her Koha would not exist.
But more than this Rosalie was an amazing person, a librarian who always
thought outside the box, a gifted potter, a friend to many and a beloved
mother and grandmother.

Details around the funeral and memorial note should be available tomorrow.
But I am sure you will all join me holding Rosalie's family and friends in
your thoughts.

Tiwhatiwha te pō, tiwhatiwha te ao.

Chris
___

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

Re: [Koha] Data from Koha in EBSCO EDS

[Chris Cormack]

Kia ora Magnus

The way we do it here is they fetch data with OAI-PMH (usually daily)
and use ILS-DI for the realtime info.

Hope that hels

Chris

On 27/04/21 12:29 am, Magnus Enger wrote:
> Kia ora, dear Community!
> 
> I know about the EBSCO EDS plugin:
> https://cloud.ebsco.com/apps/koha-plugin
> 
> Now I have a library asking what it takes to show live item data inside
> EBSCO EDS (so kind of the opposite direction to the plugin above). Has
> anyone done this? They have heard a rumour that a library in Ireland
> does this, but they do not know which one.
> 
> Best regards,
> Magnus Enger
> Libriotech AS
> ___
> 
> 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] Upgrading bugzilla server

[Chris Cormack]

Interesting, bugzilla hasn't changed at all. It was an OS upgrade from
xenial to bionic.

I suspect its bots hammering the site again I'll go block some ips

Chris

On Wed, 7 Apr 2021, 7:40 pm Joonas Kylmälä, 
wrote:

> Hi Chris,
>
> thanks. The attachment viewing and adding new attachments stopped
> working. It gives 504 internal server error.
>
> Joonas
>
> On 07/04/2021 00:29, Chris Cormack wrote:
> > And it's finished.
> >
> > Please let me know if you spot anything weird
> >
> > Chris
> >
> > On Wed, 7 Apr 2021 at 09:10, Chris Cormack 
> wrote:
> >>
> >> Hi all
> >>
> >> I am upgrading the OS on the bugzilla server, so things might go up
> >> and down a bit
> >>
> >> I'll update when its all good to go again
> >>
> >> Chris
> > ___
> > 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/
> >
>
> --
> Joonas Kylmälä
> Tietojärjestelmäasiantuntija
>
> Kansalliskirjasto
> Kirjastoverkkopalvelut
> PL 15 (Unioninkatu 36)
> 00014 Helsingin yliopisto
>
___

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

Re: [Koha] Upgrading bugzilla server

[Chris Cormack]

And it's finished.

Please let me know if you spot anything weird

Chris

On Wed, 7 Apr 2021 at 09:10, Chris Cormack  wrote:
>
> Hi all
>
> I am upgrading the OS on the bugzilla server, so things might go up
> and down a bit
>
> I'll update when its all good to go again
>
> Chris
___

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

[Koha] Upgrading bugzilla server

[Chris Cormack]

Hi all

I am upgrading the OS on the bugzilla server, so things might go up
and down a bit

I'll update when its all good to go again

Chris
___

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

[Koha] Come dance with the kohacon20 crew

[Chris Cormack]

Kia ora koutou

One of the events we had planned for Kohacon20 was having Aleisha's very 
talented brother, Isaac, DJ a dance party for people. Of course as with most 
things this year we can't all do that in person anymore.
But never fear you can join in from the comfort of your own own home.
From 8pm NZDT tonight you can listen/watch the stream here

https://twitch.tv/epicseal1163

Hope you enjoy a little dance with your breakfast, lunch or evening whatever 
timezone you may be in.

Chris 
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___

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

Re: [Koha] excessive growth of our Koha system

[Chris Cormack]

Actually this is not a Koha issue at all but one to do with mysql and innodb.
If you search for file_per_table and innodb you should find the answer

Chris 

On 10 February 2020 7:35:58 PM AEDT, Hugo Agud  wrote:
>Good morning
>
>The best solution is to figureout why it is growing the database
>
>1. check logs of koha and apache
>2. check tables sizes and figure out what's the table
>3. check that  cleanup cron is working fine
>
>
>
>El lun., 10 feb. 2020 a las 9:29, Archivo Historico Andalucia (<
>archivohistor...@and.ccoo.es>) escribió:
>
>>  Hi everyone!
>>
>> For some time we have been having an error in our koha system due to
>> excessive growth of the database. The file that is constantly growing
>is:
>> var/lib/mysql/ibdata1. It seems a zebra problem (We have a Koha old
>> versión: 3.08...)
>>
>> We don't know why it grows so much or how to fix it. Currently we
>have to
>> increase the server space because every few days there is a failure
>due to
>> lack of space. It is a temporary solution but we would definitely
>like to
>> fix the problem.
>>
>> Any suggestions?
>>
>> Thank you very much in advance!
>>
>> Manuel
>> --
>> *Manuel Bueno Lluch*
>> Archivo Histórico de CCOO de Andalucía
>> c/ Japón, 41 - 41008, Sevilla
>> Tlf: 954401619 / 62726
>> archivohistor...@and.ccoo.es
>> www.estudiossindicales.andalucia.ccoo.es
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>-- 
>
>*Hugo Agud - Orex Digital *
>
>*www.orex.es *
>
>
>[image: www.orex.es/koha]
>
>   [image: www.orex.es/vufind] 
>
>
>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 contiene información que puede ser CONFIDENCIAL y/o de USO
>RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
>está autorizado a recibirlo por el remitente), no está autorizado a
>copiar,
>reenviar o divulgar el mensaje o su contenido. Si ha recibido este
>mensaje
>por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
>sistema.
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Request

[Chris Cormack]

The release notes on the website only go back until 2010, there's 10 more years 
before that so you will need to look in git.

I'm not entirely sure what the goal is as there have been hundreds of releases 
of  Koha now.
Apart from historical curiosity I guess.

Organisations should all (with a few rare exceptions) be running the latest 
stable of Koha. As it will have all the fixes and security fixes in it.

Chris 

On 21 January 2020 7:17:05 PM NZDT, Franz Dietrich  
wrote:
>Then use the git repo as source:
>
>http://git.koha-community.org/gitweb/?p=koha.git;a=summary
>
>or the release notes:
>
>https://koha-community.org/category/release/
>
>Am 21.01.20 um 07:13 schrieb Sugandha Bajaj:
>> And their usage and compatibility and learning in India.
>> 
>> 
>> On Tue, 21 Jan 2020 at 11:43, Sugandha Bajaj 
>wrote:
>> 
>>> Hi!
>>>
>>> We are drawing a comparative of all the versions i.e from the
>beginning
>>> till date.
>>>
>>> Best Regards,
>>> Sugandha
>>>
>>> On Tue, 21 Jan 2020 at 11:35, Chris Cormack
>
>>> wrote:
>>>
>>>> Hi Sugandha
>>>>
>>>> What Koha versions are you looking to compare 19.11 vs 19.05?
>>>>
>>>> Chris
>>>>
>>>> On Tue, 21 Jan 2020, 6:16 PM Sugandha Bajaj, 
>wrote:
>>>>
>>>>> Dear Sir/Madam,
>>>>>
>>>>> I hope you are doing well.
>>>>>
>>>>> I and my colleague wish to do a qualitative research and draw a
>>>>> comparative study of the KOHA versions. It shall be of great help
>if you
>>>>> could provide, which resources to look up for literature and if
>you could
>>>>> help us with insights on the same.
>>>>>
>>>>> Best regards,
>>>>> Sugandha Bajaj
>>>>> ___
>>>>> 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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Request

[Chris Cormack]

Hi Sugandha

What Koha versions are you looking to compare 19.11 vs 19.05?

Chris

On Tue, 21 Jan 2020, 6:16 PM Sugandha Bajaj,  wrote:

> Dear Sir/Madam,
>
> I hope you are doing well.
>
> I and my colleague wish to do a qualitative research and draw a
> comparative study of the KOHA versions. It shall be of great help if you
> could provide, which resources to look up for literature and if you could
> help us with insights on the same.
>
> Best regards,
> Sugandha Bajaj
> ___
> 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] Kohacon20 registrations open!

[Chris Cormack]

And to answer myself

More details about the location are now up at
https://2020.kohacon.org/posts/location/

Chris

On 6/01/20 10:13 am, Chris Cormack wrote:
> Yep, we will be updating the location page shortly.
> 
> But the short version is
> 
> The 3 days of talks and 1 day of workshops is at
> 
> Kaiwhanga Kauhau,
> National Library Wellington
> Molesworth Street,
> Thorndon,
> Wellington,
> New Zealand
> 
> And the 2 days of working together (previously called hackfest) will be at
> Catalyst House
> 150 Willis Street
> Wellinton,
> New Zealand
> 
> Chris
> On 6/01/20 10:03 am, Owen Leonard wrote:
>>> But we have opened registrations for the conference.
>>> https://2020.kohacon.org/posts/registration/
>>
>> Has the venue been announced?
>>
>>  -- Owen
>>
> ___
> 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] Kohacon20 registrations open!

[Chris Cormack]

Yep, we will be updating the location page shortly.

But the short version is

The 3 days of talks and 1 day of workshops is at

Kaiwhanga Kauhau,
National Library Wellington
Molesworth Street,
Thorndon,
Wellington,
New Zealand

And the 2 days of working together (previously called hackfest) will be at
Catalyst House
150 Willis Street
Wellinton,
New Zealand

Chris
On 6/01/20 10:03 am, Owen Leonard wrote:
>> But we have opened registrations for the conference.
>> https://2020.kohacon.org/posts/registration/
> 
> Has the venue been announced?
> 
>  -- Owen
> 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Kohacon20 registrations open!

[Chris Cormack]

Kia ora

Ngā mihi o te tau hou pākehā.
Happy New year.

New year, new conference news! We had a ton of great submissions for
talks, and we are working on a draft programme now.
But we have opened registrations for the conference.
https://2020.kohacon.org/posts/registration/

Bearing in mind there is no conference fee, please only register if you
are planning to attend. Or if circumstances change so you can't attend
please let us know.
There is finite capacity at the venue and we would hate to turn away
people and have empty seats.

That being said, we would love to see you there, go forth and register :)

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

Re: [Koha] error occurred while importing the database structure

[Chris Cormack]

Hi Rasheed

I am removing you from the list for spamming, I was going to let it go
when you posted once.
But replying to threads with advertisements is not acceptable

Chris

On 27/11/19 8:20 am, Rasheed A. wrote:
> *Honorable Friends *
> 
> *ABCD Software is a power full Library Automation Software*
> 
> *FOR PRESENTATION Please Google Search: Rasheed ABCD*
> 
> *https://www.slideshare.net/Rasheed1976/presentation-by-rasheedahmedmarch2011
> *
> 
> *ABCD* stands for "Automatización de Bibliotecas y Centros de
> Documentación" (Spanish), which means: Library and Documentation Centers
> Automation. Its development was promoted and coordinated by BIREME, with
> the support of VLIR.
> 
> *ABCD* is web-based integrated library management software comprising the
> main basic library functions. This kind of library application is a long
> held aspiration for the ISIS community, since the first MS-DOS version came
> out more than 20 years ago. Several library automation systems were
> developed during this period and are still in operation worldwide. BIRME
> EMP previous system was limited to the circulation services. The main
> characteristics of ABCD are the coverage of the main library functions, its
> web centrality and its development and maintenance under the methodology of
> Free and Open Source Software.
> 
> *Main functions*
> 
>- Definition of any number of new databases (similar to Winisis), which
>includes: FDT, PFT, FST, and worksheets directly on the Web, or copying
>from existing ones either from the Web or from Winisis on a local hard 
> disk,
>- Cataloguing of books and serials, independently of the format: MARC,
>LILACS, AGRIS, etc.
>- End-user searching (OPAC),
>- Loans circulation,
>- Acquisitions,
>- Library services like SDI, barcode printing, quality control, etc.
>- Compatible with CDS/ISIS database technology for the bibliographic
>databases, i.e. reading ISIS-databases and making use of ISIS Formatting
>Language for producing output and indexing of records;
>- Run on both Windows and Linux platforms;
>- Use of MARC-21 cataloging formats and other current standards or
>protocols (Dublin Core, METS, Z39.50...);
>- Published as Free and Open Source Software (FOSS) with the
>accompanying tools for the developer community;
>- Multi-lingual;
> 
> *Rasheed Ahmed*
> 
> 
> 
> 
> On Thu, Nov 21, 2019 at 10:19 PM Davide Spanu 
> wrote:
> 
>> Good evening to all.
>> I have tried several times to install Koha on a new server and I continue
>> to receive database error(s). I follow the procedure step by step but I
>> just can't understand where I'm wrong. The error I get with the
>> webinstaller is this (then, consequently, many others).
>>
>> The following error occurred while importing the database structure:
>> [Thu Nov 21 18:26:44 2019] install.pl: DBD::mysql::st execute failed:
>> BLOB, TEXT, GEOMETRY or JSON column 'changed_fields' can't have a default
>> value at /usr/share/perl5/DBIx/RunSQL.pm line 273.
>> Please contact your system administrator
>>
>> Something is wrong with Mysql, but I don't understand what.
>> I thank all of you in advance.
>> Davide
>>
>> ___
>> 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] Edited barcodes not saving

[Chris Cormack]

That might also be a problem, but the foreign key error before that definitely 
is. It means in that item record the value in homebranch doenst match a row in 
the branches table.
That's why you can't update that item. Try changing the homebranch and save 
again (maybe try changing all the branch info on that item)

It may be that somehow someone deleted a branch, check in administration, to 
see if all the libraries/branches are there that you expect to be

Chris 

On 7 November 2019 2:56:32 AM NZDT, Alvaro Cornejo  
wrote:
>Hi Muirunyeri
>
>The query used to update the barcode said it is finding several results
>"...Query returned more than one row..."
>
>This means that, when updating a record, msql is founding several
>records
>to update this might seems you have duplicated records in your
>database.
>
>Check on the about page whether you have something about that on system
>status.
>
>Regards,
>
>Alvaro
>
>
>|-|
>Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
>celular y Nextel
>en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
>SMS
>y GPRS online
>  Visitenos en www.perusms.com
>
>
>Le mer. 6 nov. 2019 à 03:37, muirunyeri  a écrit
>:
>
>>
>> Hi Vikram and team,
>> Below is the error log I tried copying.
>> AH01215: [Tue Nov  5 14:38:12 2019] additem.pl: ERROR in
>> _koha_modify_item UPDATE items SET
>>
>stack=?,price=?,itemnotes_nonpublic=?,replacementprice=?,notforloan=?,enumchron=?,stocknumber=?,itemnotes=?,withdrawn_on=?,datelastseen=?,dateaccessioned=?,restricted=?,copynumber=?,homebranch=?,barcode=?,ccode=?,replacementpricedate=?,holdingbranch=?,coded_location_qualifier=?,location=?,itemlost=?,materials=?,uri=?,booksellerid=?,itemcallnumber=?,itype=?,more_subfields_xml=?,permanent_location=?,items.cn_source=?,damaged=?,itemlost_on=?,withdrawn=?,items.cn_sort=?
>> WHERE itemnumber=?: Cannot add or update a child row: a foreign key
>> constraint fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_2`
>FOREIGN
>> KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE
>CASCADE)
>> at /usr/share/koha/lib/C4/Items.pm line 2029.:
>> /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer:
>>
>http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem=53332=19020=
>> [Tue Nov 05 14:38:12.848114 2019] [cgi:error] [pid 2832] [client
>> 192.168.67.5:56592] AH01215: [Tue Nov  5 14:38:12 2019] additem.pl:
>> DBIx::Class::Storage::DBI::select_single(): Query returned more than
>one
>> row.  SQL that returns multiple rows is DEPRECATED for ->find and
>->single
>> at /usr/share/koha/lib/Koha/Objects.pm line 92:
>> /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer:
>>
>http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem=53332=19020=
>> Any assistance will be highly appreciated.
>>
>> Sent from my Samsung Galaxy smartphone. Original message
>> From: vikram zadgaonkar  Date:
>> 04/11/2019  07:34  (GMT+03:00) To: muirunyeri 
>Cc:
>> Owen Leonard , koha 
>> Subject: Re: [Koha] [koha] Edited barcodes not saving
>> Will you be able to share screen shot of the error.
>> Vikram Zadgaonkar
>>
>> On Mon, Nov 4, 2019 at 10:00 AM muirunyeri 
>wrote:
>> Hello Owen,
>>
>> Thanks for getting back to me on my query and sorry for not replying
>> sooner.
>>
>> We are using version 17.05.
>>
>> There are no upgrades to koha, Mysql or the server. There are no
>changes
>> whatsoever and no one has accessed the server.
>>
>> Kindly guide me on how to access the error logs and I will do so.
>>
>> Am very grateful for any assistance
>>
>> Thank you
>>
>>
>>
>> Sent from my Samsung Galaxy smartphone. Original message
>> From: Owen Leonard  Date: 31/10/2019 
>14:43
>> (GMT+03:00) To: muiru james  Cc: koha <
>> koha@lists.katipo.co.nz> Subject: Re: [Koha] [koha] Edited barcodes
>not
>> saving
>>
>> >  Over the last few days, the new barcode is not saving  i.e. after
>>
>> > saving the old number is still showing instead of the new one.
>>
>>
>>
>> What version of Koha are you using? Has anything changed which might
>>
>> be linked to this problem? A server upgrade, Koha upgrade, MySQL
>>
>> upgrade?
>>
>>
>>
>> Do you have access to Koha's error logs?
>>
>>
>>
>>  -- Owen
>>
>>
>>
>> --
>>
>> Web Developer
>>
>> Athens County Public Libraries
>>
>> (740) 737-6006
>>
>> https://www.myacpl.org
>>
>> ___
>>
>> 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

Re: [Koha] Bulk search/delete by ISBNs?

[Chris Cormack]

Hi Fred

You might be able to write a report to get all biblio with no items attached, 
of a certain type and then use that list of biblionumbers in the bulk biblio 
delete.

Hope this helps 
Chris 

On 30 August 2019 1:51:31 AM NZST, "King, Fred"  wrote:
>Esteemed Colleagues,
>
>My library has a collection of about 5000 online books that are in Koha
>with bib records and no items. The publisher periodically archives
>titles so they're no longer available, and I have a list of them that
>I'd like to remove from Koha. The problem is that my list consists of
>ISBNs and that there are over 450 of them. I could search and delete
>one-by-one, but that's an awful lot of searching and deleting. Is there
>an easier way?
>
>We're on Koha 17.05* and Ubuntu 16.04.
>
>*I know, I know, but I'm hoping to get a new server before I upgrade.
>
>Fred King, AHIP
>Medical Librarian, MedStar Washington Hospital Center
>fred.k...@medstar.net
>202-877-6670
>ORCID -0001-5266-0279
>MedStar Authors Catalog: http://medstarauthors.org
>
>Rest is not idleness, and to lie sometimes on the grass under trees on
>a summer's day, listening to the murmur of the water, or watching the
>clouds float across the sky, is by no means a waste of time.
>--Sir John Lubbock, The Use of Life (1894)
>
>--
>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, orthopaedics,
>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
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cannot find records created in KoHa

[Chris Cormack]

Just a quick off topic reply, as I've seen a few people spell Koha as KoHa.
It is a te reo Māori word and can be spelt Koha or koha

Here's a slide about the name from last week at Kohacon19
https://slides.com/ranginui/kohacon19#/2

Chris

On Sat, 1 Jun 2019, 1:58 AM Lichtsteiner Patric (lici), 
wrote:

> Hi,
>
> I guess this is a very basic and silly question.
>
> I just created my first record with some items. Among other things I
> filled in the field "Number (ISBN)” with 100.100.
>
> Using the advanced catalog search I’m trying to find my record, but
> nothing is found:
> No results match your search for 'nb: 100.100'.
>
> What did I miss?
>
> Best,
> Patric
> ___
> 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-devel] Koha 19.05.00 Released

[Chris Cormack]

Well done all. 

Just a typo with the release notes,
https://koha-community.org/koha-19-05-release/

Is the correct url

Chris 

On 31 May 2019 3:52:20 AM NZST, Nick Clemens  wrote:
>Hello everybody,
>
>It is with great pleasure that the Koha community announces the release
>of
>Koha 19.05, a major release of the Koha open source integrated library
>system.
>
>This release (as always) is the work of many librarians, developers,
>and
>community members who donate their time and effort to the project.
>Their
>contributions help shape the release, and the project going forward.
>None
>of this would be possible without them, and my sincere thanks goes out
>to
>everyone who had a hand in the project
>
>Extra thanks to all who helped me with this release, and with getting
>here
>to be the release manager for this version. I am so lucky to work with
>such
>a great team on a wonderful project and look forward to helping make
>Koha
>better on each release. Excelsior!
>
>Read the full release notes here:
>https://koha-community.org/koha-18-11-release/
>
>Debian packages will be available shortly, if you are following a suite
>you
>will
>automatically upgrade to the next branch with this release, more info
>here:
>https://wiki.koha-community.org/wiki/Koha_on_Debian#Follow_a_suite:_stable.2C_oldstable_.E2.80.A6
>
>Thank you all,
>Nick (kidclamp)
>
>-- 
>Nick Clemens
>ByWater Solutions
>bywatersolutions.com
>Phone: (888) 900-8944
>Pronouns: (he/him/his)
>Timezone: Eastern

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Modifications in OPAC script not shown

[Chris Cormack]

Salud Camilo

So there are 2 things

The changes will not be showing because of plack, you will need to
restart plack if you make any changes to the scripts or the modules
BUT
If you are wanting to make changes to the display you are much better
off editing the template files

Chris

On 14/05/19 10:25 am, Camilo Freire wrote:
> Salud:
> 
> i'im triying to do some little modifications in the script that shows the
> MARC format of the record in Koha's OPAC (opac-MARCdetail.pl). I've found
> that any modification in the code is not shown inmmedialely on the screen,
> for example if I make
> 
> print "Content-Type: text/html\n\n";
> print "something";
> exit;
> 
> the message is not shown at all. Only if I change the name of the script
> and run it works, but again the new script seems to remain "frozen" in this
> initial step and doesn't show any further modification.
> 
> I suppose that the problem is based in the existence of some cache
> anywhere, I would like to know how to avoid this behaviour in order to see
> in real time the effect of the modifications I'm doing.
> 
> Thank you very much
> Camilo Freire
> Uruguay
> ___
> 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] Patron categories automatically reverting (3.18.11)

[Chris Cormack]

I would ask whoever has access to the server to check if there are any
cron jobs running to do with patrons.
There may be a job running nightly or the like that changes categories,
that's where I would start looking.

There is a job called j2a.pl that is supposed to change
children/juveniles to adults. I wonder if this is running and changing
things


Chris

On 14/05/19 8:39 am, TCC_Beth wrote:
> Yes, it is odd! The only thing I can think of that I know was changed was
> that we added some new patron categories. But I remember seeing this even
> before we did that. So I am stumped! 
> 
> I actually don't know if this was happening before I started or not. It's
> possible that it was happening for a while and no one noticed- we have a low
> circulation rate and most of the people checking things out are students, so
> it could have gone under the radar for a while.
> 
> 
> 
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> 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] Patron categories automatically reverting (3.18.11)

[Chris Cormack]

I would ask whoever has access to the server to check if there are any
cron jobs running to do with patrons.
There may be a job running nightly or the like that changes categories,
that's where I would start looking.

There is a job called j2a.pl that is supposed to change
children/juveniles to adults. I wonder if this is running and changing
things


Chris

On 14/05/19 8:39 am, TCC_Beth wrote:
> Yes, it is odd! The only thing I can think of that I know was changed was
> that we added some new patron categories. But I remember seeing this even
> before we did that. So I am stumped! 
> 
> I actually don't know if this was happening before I started or not. It's
> possible that it was happening for a while and no one noticed- we have a low
> circulation rate and most of the people checking things out are students, so
> it could have gone under the radar for a while.
> 
> 
> 
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> 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] Patron categories automatically reverting (3.18.11)

[Chris Cormack]

Hi

It seems very odd that this would suddenly start happening.
I would try to find out what someone/something has changed. Because it
doesn't sound like a bug in Koha, more like something that has been changed.

Chris


On 14/05/19 8:32 am, TCC_Beth wrote:
> We have an old installation (3.18.11), and have recently started seeing
> patrons who used to be listed as one category (Staff) all reverting to a
> different category (Student). We'll go in via admin and manually change them
> back, and then the next time we check them, it's reverted back to Student
> again. This is really messing up our stats and is also problematic because
> different categories have different borrowing privileges.
> 
> Without a drastic update to the newest release of Koha (skipping many in
> between which I worry would cause a lot of problems), does anyone know if
> there were any bug fixes released for 3.18 that might fix this issue? Or is
> there some setting that might be causing this that we could tweak? I'm new
> to my position and to Koha, so I'm not sure how to remedy this issue. 
> 
>  
> 
> 
> 
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> 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] Regarding DBMS Auto increment fix

[Chris Cormack]

It's not a Koha thing it's a DB thing. So it depends on what version of mysql 
or mariadb you are running.

If it is 5.7 or earlier then yes, you need it. If it is later then no it is 
fixed

https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html#innodb-auto-increment-initialization

Chris 

On 9 May 2019 4:52:01 PM NZST, Sambhunath Sahoo  wrote:
>Dear friends,
>
>*Is DBMS auto increment fix required for Koha 18.11.05 (Current
>version)?
>Yes/No*
>In Koha wiki site, it shows only for Koha 16.05, 16.11, and 17.05.
>There is
>nothing written for Koha 18.05 and Koha 18.11.
>
>Regards,
>Sambhunath Sahoo/सम्भुनाथ साहु
>Information Scientist,
>Central Library,
>Tezpur University,
>Tezpur-784028
>Assam
>Mobile: 9085252152, 8895488636
>Phone : 03712-27-3229
>E-Mail : sambhum...@gmail.com,
>sam...@tezu.ernet.in
>*ORCID ID:* -0001-9162-879X
>*Researcher ID:* K-4446-2018
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Why people' are using the term Koha as KOHA?

[Chris Cormack]

Hi Fred

Lovely!!

I have a slide addressing this that I will be using at Kohacon in a few
weeks :)

Chris

On 3/05/19 4:39 am, King, Fred wrote:
> And it's a WONDERFUL ILS! Its existence should be PROCLAIMED FROM EVERY 
> ROOFTOP! 
> 
> Anybody else going to the Medical Library Association conference in Chicago 
> tomorrow/next week? E-mail me and maybe we can get together for tea.
> 
> Fred King
> Medical Librarian, MedStar Washington Hospital Center
> fred.k...@medstar.net
> 202-877-6670
> ORCID -0001-5266-0279
> MedStar Authors Catalog: http://medstarauthors.org
> 
> I like a teacher who gives you something to take home to think about besides 
> homework.
> --Lily Tomlin (attrib.)
> 
> -Original Message-
> From: Koha  On Behalf Of Michael Kuhn
> Sent: Thursday, May 02, 2019 12:34 PM
> To: koha@lists.katipo.co.nz
> Subject: [EXTERNAL] Re: [Koha] Why people' are using the term Koha as KOHA?
> 
>  ** ATTENTION: This email originated from outside the MedStar network. ** DO 
> NOT CLICK links or attachments unless you recognize the sender and know the 
> content is safe. 
> 
>  > Why people' are using the term Koha as KOHA?
>  > It is a simple word, not any acronym.
> 
> Some people like majuscules. Some people are just wrong. Some don't even care.
> 
> 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 
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.adminkuhn.ch=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=gFWkGD8xY8R9hbjs06JWYXFVMxiIZ1sYXDwJoh25aa4=tVCwhViIJAyiWUmVk6DWilg5lFWsk_J3HC_j0oR0pWw=
> ___
> Koha mailing list  
> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=gFWkGD8xY8R9hbjs06JWYXFVMxiIZ1sYXDwJoh25aa4=-eD-fXQ-fcd54QvLdtUGMF7HDH2W0GbTIcfFMH2_Qrw=
> Koha@lists.katipo.co.nz
> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=gFWkGD8xY8R9hbjs06JWYXFVMxiIZ1sYXDwJoh25aa4=p2hCbi4aUXmBdbeToWl7SccaMfR-59GqKO0a6z9m55g=
> 
> --
> 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, orthopaedics, 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
> 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 3.4

[Chris Cormack]

Hi Luisa

I would stop now, the last 3.4 release was 7 years ago, it is very very
out of date. And upgrading from a version that old will be very hard.

If you haven't catalogued much already I would start with a new install
of 18.11.04 and start with that.

Chris

On 2/04/19 11:17 am, Luisa Korodrau wrote:
> Dear Koha Community,
> Need help. I have only just been appointed as Librarian to a Theological
> library and we have just installed Koha 3.4 to automate the collection and
> as of last week I have started cataloguing the 15,000 resources that we
> currently have.
> 
> I need technical advise whether I should install the latest Koha 18 version
> or continue with version 3.4 and upgrade later.
> 
> Luisa Korodrau
> ___
> 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] Extracting list of biblios with . in the subject

[Chris Cormack]

Awesome!

Now someone just has to be funded to work on it. People always want to fix 
bugs, but we have to work on what we are paid to do. So there's the next 
mission should you choose to  accept it :)

Chris 

On 26 March 2019 8:53:54 AM NZDT, Tami Wilkerson  wrote:
>Thanks everyone for the most helpful responses!
>
>Sarah, I couldn't agree more. We should not have to mess up properly
>formatted records to accommodate a flaw in the system. Going to comment
>on 17661 right now!
>
>Tami
>
>
>
>-Original Message-
>From: Sarah B. Cornell  
>Sent: Monday, March 25, 2019 12:25 PM
>To: Hernandez, Heather ; Tami Wilkerson
>
>Cc: koha 
>Subject: RE: [Koha] Extracting list of biblios with . in the subject
>
>Heather,
>
>This display has bothered me all along, and I can't seem to NOT see it
>on a regular basis! "Fixing" all the records with periods in the
>subject is so tempting but I'm trying to leave our MARC records in good
>form rather than editing them to accommodate Koha's shortcomings.  
>
>I hadn't noticed that the search performed is exactly the same whether
>the user selects "Whales" or "Whales.". But even if they are just
>duplicates, I'd rather see more unique facets in that initial list and
>not have to select "show more" all the time!
>
>I'm going to comment on bug 17661, which proposes a fix.  Anybody want
>to join me? :)
>
>Sarah
>
>
>
>-Original Message-
>From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
>Hernandez, Heather
>Sent: Friday, March 22, 2019 3:57 PM
>To: Tami Wilkerson 
>Cc: koha 
>Subject: Re: [Koha] Extracting list of biblios with . in the subject
>
>Hi, Tami--
>
>Ah--ours displays exactly the same way--we don't have records with the
>subject "Lampreys," but we do have whales:
>
>- Topics
>
>   - Whales
>
>   - Whales.
>
>   - Whaling
>
>   - Whaling in art.
>   in art.>
>   - Whaling.
>
>   - Show more
>
>
>This display used to bother me, but at least in our catalog, if the
>user selects either one, they retrieve the same record set--selecting
>the one without the ending period retrieves the exact same 513 results
>as selecting the one with the ending period--at least in our catalog. 
>I try to calm my Inner Cataloger and not look at this display too
>often.:)
>
>I don't know if there's a way to have the whole string appear in that
>facet area--the facet area is pretty small!  I think if a user wanted
>to click/tap through subject headings that included subdivisions,
>they'd need to do that after they select a record to display--i.e.,
>from the "Normal view" of one record.
>
>But I'm no Koha display expert by a LONG shot--those on the list who
>are might have some helpful ideas/suggestions!
>
>Keep asking questions--we all learn something when people ask
>questions!
>Glad you've joined us in this friendly community!
>
>Cheerio!
>h2
>~~
>Heather Hernandez (she, her, hers)
>Technical Services Librarian
>San Francisco Maritime National Historical Park Research Center
>2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
>415-561-7032, heather_hernan...@nps.gov Library catalog:
>http://keys.bywatersolutions.com/
>___
>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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

[Chris Cormack]

Ahh those are changed by apache, it looks like one or 2 of your config files 
didn't update (maybe local changes)

In /etc/koha
Check that apache-shared-intranet.conf and apache-shared-opac.conf have

RewriteRule ^(.*)_[0-9]{2}\.[0-9]{7}\.(js|css)$ $1.$2 [L]

If not add that

This actually means in future after upgrades you don't have to clear the cache 
:)

Chris 

On 23 March 2019 7:48:54 AM NZDT, Daniel Owens  wrote:
>Oh, of course.
>
>Full output is below, but looking through the errors, I found two
>kinds:
>
>  * "Loading failed for the 

[Koha] Kohacon19

[Chris Cormack]

Kia ora koutou

For those of us fortunate enough to be able to go to Kohacon this year I have 
started a page https://wiki.koha-community.org/wiki/Kohacon19/Social

Where people can record their flight times and perhaps make some plans for 
social events.
Please feel free to add to it.

Chris 
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Incredibly sad and horrific news from New Zealand

[Chris Cormack]

A few people have emailed me to ask if there is anything they can do.

There is 
https://www.launchgood.com/project/support_for_the_families__victims_of_the_new_zealand_mosque_shootings#!/

Where you can donate if you have the means.
But also we can all try harder to not tolerate religious, racial, gender 
intolerance. We can call it out when we see it. We can make it clear we reject 
it utterly. We must do better. 

This will be my  last email about it, unless someone from the Muslim community 
asks me to do more, I think we must now listen (and I should stop talking) to 
those most effected. 

Chris 

On 16 March 2019 10:07:22 PM NZDT, Hugo Agud  wrote:
>Hello,
>
>Yes it is a tragedy, all our praies  goes to the all the people
>affected by
>that attack
>
>Hugo
>
>
>El El sáb, 16 mar 2019 a las 8:33, Chris Cormack
>
>escribió:
>
>> Hello all
>>
>> I am sure you will have all heard of the terrorist attack in
>> Christchurch, New Zealand by now.
>> I don't want to say too much, I don't have the words, I am still in
>> shock and heartbroken.
>>
>> But I just wanted to let you know, we in the immediate NZ Koha and
>> Catalyst community are all safe and accounted for.
>>
>> I also wanted to say, that to all our Muslim colleagues, friends,
>> family, and Koha community members I am so so so sorry that this
>happened.
>>
>> I weep for the families of the 49 people murdered.
>> I have no more words
>>
>> Māringiringi noa ngā roimata
>> (The tears flow unceasing)
>>
>> Chris
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>-- 
>
>*Hugo Agud - Orex Digital *
>
>*www.orex.es <http://www.orex.es>*
>
>
><http://www.orex.es/>[image: www.orex.es/koha]
><http://www.orex.es/koha>
>   [image: www.orex.es/vufind] <http://www.orex.es/vufind>
>
>
>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 contiene información que puede ser CONFIDENCIAL y/o de USO
>RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
>está autorizado a recibirlo por el remitente), no está autorizado a
>copiar,
>reenviar o divulgar el mensaje o su contenido. Si ha recibido este
>mensaje
>por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
>sistema.

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Incredibly sad and horrific news from New Zealand

[Chris Cormack]

Hello all

I am sure you will have all heard of the terrorist attack in
Christchurch, New Zealand by now.
I don't want to say too much, I don't have the words, I am still in
shock and heartbroken.

But I just wanted to let you know, we in the immediate NZ Koha and
Catalyst community are all safe and accounted for.

I also wanted to say, that to all our Muslim colleagues, friends,
family, and Koha community members I am so so so sorry that this happened.

I weep for the families of the 49 people murdered.
I have no more words

Māringiringi noa ngā roimata
(The tears flow unceasing)

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

Re: [Koha] Error retrieving biblio in rebuild_zebra.pl line 680

[Chris Cormack]

Hi

The best thing to do is restore from a backup (you did this upgrade on a test 
server eh? You've jumped about 3 years worth of upgrades)

Then run the upgrade again, paying particular attention to any errors that 
occur. Because there may well have been other ones too. You will want to catch 
all of them to make sure you fix them all, before you start using it in 
production.

Chris 

On 30 January 2019 7:59:12 PM NZDT, otuoma  wrote:
>Yesterday I upgraded from koha 3.22.08 to 18.11 but can't run
>koha-rebuild-zebra -f -v -b koha on Ubuntu 16.04
>
>The error I get is exactly the same with bug 18927
>https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927
>
>Zebra configuration information
>
>Zebra biblio directory  = /var/lib/koha/koha_library/biblios
>Zebra authorities directory = /var/lib/koha/koha_library/authorities
>Koha directory  = /usr/share/koha/intranet/cgi-bin
>Lockfile=
>/var/lock/koha/koha_library/rebuild/rebuild..LCK
>BIBLIONUMBER in : 999$c
>BIBLIOITEMNUMBER in : 999$d
>
>skipping authorities
>
>exporting biblio
>
>1error retrieving biblio 2 at
>/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680.
>.error retrieving biblio 3 at
>/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680.
>
>...
>
>Records exported: 0
>
>REINDEXING zebra
>
>
>CLEANING
>
>
>
>When I check the file at
>/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680, the code
>already has the fix described at
>https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18927
>
>On further examination, I noticed that the issue is also related to bug
>17196 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196
>
>After the upgrade, it appears the table biblioitems no longer has the
>marcxml field. Also, the new table biblio_metadata exists but is empty.
>The
>other new table deletedbiblio_metadata however has data in it.
>
>Indexing with koha-rebuild-zebra -f -v -a koha for authorities works
>fine
>with no problems.
>
>It appears the update process didn't migrate the data from
>biblioitems.marcxml to biblio_metadata as should be the case and this
>is
>most likely why zebra is not able to index.
>
>My problem is now how to solve this issue, thank you.
>
>
>
>
>
>
>
>--
>Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha library cards

[Chris Cormack]

Hi all

As you might know I have been collecting library cards from Koha
libraries for a while now.
I would love more though.
If you would like your card to join the others in the Koha library
card wall (currently in the shape of an xmas tree)

https://ranginui.files.wordpress.com/2018/12/img_20181207_084837.jpg

Then please contact me offlist and we can figure out how to get me a card :)

Thank you

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

Re: [Koha] Sudden suspicious email

[Chris Cormack]

Hi Agnes

Unfortunately it is people spoofing from addresses. So nothing we can do
about it

:(

Chris

On Wed, 21 Nov 2018, 09:31 Agnes Rivers-Moore  Hi - Chris?
>
> Just to let you know, I have received two messages today with suspicious
> attachments, from:
> koha-boun...@lists.katipo.co.nz
>
> I am not currently on the list.
> Regards,
> Agnes
> --
> *Agnes Rivers-Moore*
> CEO / Chief Librarian
> *Hanover Public Library*
> 451 10th Ave,
> Hanover, ON, N4N 2P1
>
> Tel: 519.364.1420 x 1244 | Fax: 519.364.1747
> Email: a...@hanover.ca |
> Web: Hanoverlibrary.ca 
> *Facebook* Hanover Public Library | *Twitter* @HanoverLibrary
>
> Support your library! Could you volunteer, make a donation, or remember us
> in your will? Hanover Public Library is a Registered Charity - BN
> 10802-6947-RR0001
> We use email to communicate service messages to members who provide an
> address during registration or who contact us by email, and to promote
> charitable donations and fundraising events, in compliance with CASL.
> Please contact the library to change your email preferences or use the
> link below.
> Unsubscribe request
> 
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Community Newsletter: October 2018

[Chris Cormack]

Oops, this link instead

https://koha-community.org/koha-community-newsletter-october-2018/

Chris 

On 1 November 2018 11:35:23 AM NZDT, kohanews  wrote:
>The Koha Community Newsletter for October 2018 is here:
>https://koha-community.org/koha-community-newsletter-september-2018/
>
>Many thanks to the folks ( and poultry 
> ) who submitted articles 
>and news to this month's newsletter.
>
>Please feel free to email me with any corrections or suggestions.
>
>-- 
>Chad Roseburg
>Editor, Koha Community Newsletter
>
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cannot restore my old koha db to a new installation

[Chris Cormack]

On 17/10/18 2:10 PM, Larisa Snabi wrote:
> Hello community,
> I have done a fresh installation of the koha 18.xx but when I tried to
> restore my old koha(3.xx) db from a MySQL dump I am getting errors on
> reaching the upgrade schema library.
> We are using Ubuntu 16 and have also installed MariaDB. The error I am
> getting is


I am guessing you mean 18.05.xx ? (It is very useful to include the year
and date, there are always 2 major releases each year.
So saying 17.xx doesn't tell us if you used 17.05.xx or 17.11.xx for
example.)
Also Koha 3.22.x ? or earlier?
And Ubuntu 16.04 or 16.10 ?

The reason this is important is because if we assume you mean 3.22.x and
you meant 3.4.x Koha, we will give you the wrong advice.

> 
> 
> *DBD : :mysql: :db do failed: Table 'koha_cpgslibrary.systempreferences'
> does not exist [for statement "Select " FROM systempreferences WHERE 1=0" ]
> at usr/share/koha/lib/koha/Database.pm line 110.*
> *I also tried without upgrading the schema but I am getting a Dbix error *
> What should I do to be able to restore back the old db.

Can you check in your database dump from your earlier version, if the
systempreferences table exists?

Chris

> Thank you
> Larisa
> ___
> 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 version for new install

[Chris Cormack]

It depends on which version of 17.xx if it is 17.05 then that is out of support 
next month, so doing a new install of that is not a good idea.

And yes you should start planning to upgrade.

Chris 

On 17 October 2018 8:03:29 AM NZDT, Luis Moises Rojas  
wrote:
>Hello,
>Well i think it is much better to stay on 17..
>Not to have several version.
>About the official path, yes, it almost the same
>
>
>El mar., 16 de oct. de 2018 a la(s) 11:45, Scott Owen
>(so...@edzone.net)
>escribió:
>
>> Hi all,
>>
>> I am rolling out a new Koha server / install for one of my elementary
>> buildings.
>> This will be a "start from scratch" install.they are still using
>cards.
>>
>> Currently my other 3 installs are on the 17.xxx branch / version.
>when
>> I ran the new install (On Debian) the 18.xxx version installed.
>>
>> Any reason for me *not* to run with the 18.xxx branch ?
>>
>> and...
>>
>> Should I be upgrading my 17. to the 18.xxx ???
>> If so...are there official path / directions for that ??
>>
>> Thank you,
>>
>> -S
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>-- 
>*Luis Moisés Rojas P.*
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Spam email

[Chris Cormack]

If you notice the from address you will see it's not coming from the Koha
list at all


It's just someone crafting an email to look like it was. There is pretty
much nothing we can do about that. It's a pretty standard example of a
phishing attack, craft an email that at first glance looks to be coming
from a legit source.



Chris

On Thu, 27 Sep 2018, 00:51 Eric Bégin,  wrote:

> Hi,
>
> I guess I'm not the only who receive the email below which attachment is
> infected.
>
> It seems that Koha's mailing list has been "infiltrated" with spam bots.
>
> Anybody has a clue how to fix this ?
>
> Best regards,
>
> Eric
>
>
>  Forwarded Message 
> Subject:Koha Available Invoice 0E787866 from 26 September
> Date:   Wed, 26 Sep 2018 03:22:41 -0300
> From:   Koha
> <"koha-boun...@lists.katipo.co.nzasistentegerencia"@colboletos.com>
> To: eric.be...@inlibro.com
>
>
>
> Good Morning,
>
>
> Please be advised that that your order, detailed in the attached invoice,
> shipped.
> We thank you and appreciate your business.
> Attached is your invoice from Koha.
>
>
> Sincerely,
>
> --
> Koha
> koha-boun...@lists.katipo.co.nz
>
> --
>
>
> ___
> 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] Untold tales of Koha

[Chris Cormack]

Hi all

I am working on my talk for Kohacon18 titled Untold Tales of Koha.
I have lots of stories to share, but if anyone has any photos/stories
they would like to send to me to add I would love it.

I have things so far like baby clothes, replacing laptops, the
Queensland floods, Nigerian universities, but I can always use more.

Thanks in advance

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

Re: [Koha] Why are there two SIP2 ports in Koha?

[Chris Cormack]

Some self check machines operate SIP2 over telnet instead of raw. It's no more 
secure but some older machines work that way.

Of course SIP2 is hideously insecure so those ports should never be exposed 
except on localhost and run through stunnel or a VPN.

If you expose unencrypted SIP2 traffic on a network then you are sending all 
sorts of personal info unencrypted, most likely violating the GDPR. And 
definitely opening yourself up to being compromised

(it's trivial to capture the user and password of the SIP2 user at the very 
least)

Chris 

On 29 August 2018 7:21:03 AM NZST, Michael Kuhn  wrote:
>Hi
>
>When using the standard configuration in file "SIPconfig.xml" after 
>enabling and starting the SIP2 servers there are two ports:
>
>port="8023/tcp"
>   transport="telnet"
>   protocol="SIP/2.00"
>   timeout="60" />
>
>port="127.0.0.1:6001/tcp"
>   transport="RAW"
>   protocol="SIP/2.00"
>   client_timeout="600"
>   timeout="60" />
>
>We have just reconfigured the following line
>
>   port="10.0.0.1:6001/tcp"
>
>and our 3M SelfCheck System Model 8420 can successfully connect and 
>communicate via port 6001, without needing to add any sign in commands 
>in expect syntax (which is needed when using port 8023 via telnet, as
>it 
>is described in 
>https://wiki.koha-community.org/wiki/Setting_up_Koha_SIP_and_3M_machines
>).
>
>Can someone please explain why there are two ports? Are these just 
>offering the same functionality in two different ways (telnet, RAW), or
>
>is it maybe recommended to use telnet for some unknown security
>reasons?
>
>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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Debian packages for 18.05.02 and 17.11.08 are up

[Chris Cormack]

It works fine here.
I think it's something local to your setup

Chris 

On 27 July 2018 6:12:07 AM NZST, Narcis Garcia  wrote:
>I see that workaround at
>https://lists.katipo.co.nz/public/koha/2018-May/050652.html
>(thank you)
>
>...but there is a package dependencies problem anyway.
>I'm not in a hurry to upgrade Koha; then I prefer to wait for a
>consistent packages scenario.
>
>
>El 26/07/18 a les 19:47, Mirko Tietgen ha escrit:
>> Please check the bug tracker at
>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20826#c12
>> about this issue.
>> 
>> Narcis Garcia schrieb am 26.07.2018
>>> This v18.05.02 seems bad packaged same as v18.05.01
>>>
>>> $ apt update
>>> $ apt-cache show koha-common | grep -ie version
>>> Version: 18.05.02-1
>>> Version: 17.11.06-1
>>>
>>> $ apt full-upgrade
>>> The following packages were automatically installed and are no
>longer
>>> required:
>>> [400 packages listed]
>>> Use 'sudo apt autoremove' to remove them.
>>> The following packages will be REMOVED:
>>>   koha-common libhttp-oai-perl
>>> The following NEW packages will be installed:
>>>   libnet-libidn-perl libsub-quote-perl
>>> The following packages will be upgraded:
>>> apache2 [...]
>>> 44 upgraded, 2 newly installed, 2 to remove and 0 not upgraded.
>>> Need to get 43.1 MB of archives.
>>> After this operation, 461 MB disk space will be freed.
>>> Do you want to continue? [Y/n] n
>>>
>>> $ apt install koha-common
>>> Reading package lists... Done
>>> Building dependency tree
>>> Reading state information... Done
>>> Some packages could not be installed. This may mean that you have
>>> requested an impossible situation or if you are using the unstable
>>> distribution that some required packages have not yet been created
>>> or been moved out of Incoming.
>>> The following information may help to resolve the situation:
>>> The following packages have unmet dependencies:
>>>  koha-common : Depends: libnet-oauth2-authorizationserver-perl but
>it is
>>> not going to be installed
>>> E: Unable to correct problems, you have held broken packages.
>>>
>>>
>>> El 26/07/18 a les 19:21, Mirko Tietgen ha escrit:
 Hi,

 it's hot, no further text, ;)

 Cheers,

 Mirko


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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Introducing a Puppet module for Koha

[Chris Cormack]

Dear Jérôme

This is great! Thank you for sharing

Chris 

On 21 June 2018 5:42:49 AM NZST, "Jérôme Charaoui" 
 wrote:
>Dear Koha users and developpers,
>
>I would like to introduce to you a new Koha Puppet module:
>
>https://gitlab.com/cmaisonneuve/puppet-koha
>
>This work has been sponsored by my employer: Collège de Maisonneuve 
>(http://www.cmaisonneuve.qc.ca/).
>
>Puppet is an open-source configuration management platform aimed at 
>enabling automation of software deployments.
>
>The Puppet Koha module can take care of configuring the Koha APT 
>repository, installing the koha-common package, managing the Koha 
>configuration files and templates, installing and configuring the
>Apache 
>webserver, and, of course, creating and managing Koha instances.
>
>You don't need a full server/client Puppet deployment to use this 
>module: it also works with a standalone agent.
>
>It's currently light on tests and documentation, but I hope to fix this
>
>in future releases.
>
>Bug reports and merge requests welcome!
>
>
>Thanks,
>
>-- Jerome
>
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Fwd: [Koha-oz] FW: RFC for overhauling notices

[Chris Cormack]

Hi all



Please take the time to consider Brimbank’s RFC for an overhaul to the
notices system.



The short descriptions is that we’d like to bring management of all notice
types together, treating overdues like all other notices, and making print
notices a first class citizen at the same time. Currently dealing with
print notices in a medium-large public library is …challenging.



RFC is here: https://wiki.koha-community.org/wiki/Notices_Overhaul_RFC

Bugzilla is here:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20962



Please note this is a sponsored project so we are not really looking to
extend the proposal further, but seeking advice on whether anyone else is
already working on something similar, or the proposed way forward is a bad
idea for some important reason.



***Please provide feedback and suggestions by Monday 9 July*** either in
the bug, or via email to libr...@brimbank.vic.gov.au
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] MySQL EOL

[Chris Cormack]

Hi Cab

The latest version of Koha works fine with 5.6 and 5.7 (and the latest
mariadb releases) so shouldn't be an issue
*fingers crossed* :)

Chris

* Cab Vinton (bibli...@gmail.com) wrote:

According to https://endoflife.software/applications/databases/mysql,
end of life date for MySQL ver 5.5 is December 2018 -- not too far
off.

Wondering what the roadmap for Koha looks like w/ respect to MySQL.

Versions 5.6 & 5.7 have several years still to go, and EOL for 8.0 is
presumably way out.

Things one wonders on a lazy Father's Day afternoon ...

Cab Vinton
Plaistow Public Library
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to introduce a new user-permission to Koha?

[Chris Cormack]

Kia ora Markus

Shifting this over to the development list.
As you are more likely to get an answer there.

If no one has answered by the time I get in front of a computer, I'll try :)

Chris 

On 14 June 2018 7:02:30 AM NZST, Markus Becker  wrote:
>Dear Koha-Community,
>
>i did not find any hint oder documentation, where the permissions for
>using tools etc. are stored.
>
>My example:
>For testing purpose i want to insert my own perl-script into Koha and
>it should appear on the "tools"-page.
>
>The links on this page are shown to the user or not depending on the
>permissions he has:
>(tools-home.tt)
>
> [% IF ( CAN_user_tools_manage_staged_marc ) %]
>href="/cgi-bin/koha/tools/bibliotheca_convert.pl">Bibliotheca-Datei
>hochladen
>Werkzeug um BIBLIOTHECAplus-Exportdatei für den Import
>hochzuladen
> [% END %]
>
>I can not find the place, where these rights are deposited. How does
>Koha know if a certain right is existing?
>I found the file permissions.inc but changes there did not having any
>effect.
>
>Of cource i could use the permission
>"CAN_user_tools_manage_staged_marc" for my own script (and then the
>link is shown), but IMHO it would be not correct to "steal" the
>permission of another script.
>
>I would be very grateful if someone could give me a hint how to
>introduce the permission to start my script to Koha.
>
>Thank You very much in Advance,
>Markus Becker
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Help with funding the koha-community.org webserver

[Chris Cormack]

Kia ora tātou

Yay, so great to see how fast this was funded!

Just a bit of background.
After what happened in 2009 when we had a company in control of lots
of our infrastructure, we decided to never let that happen again.
Hence Liz running the www.koha-community.org site (rather than say
Catalyst doing it).

We shared out most of the sites, like git and bugs etc so that they are
distributed and hard to capture :)

A list is here
https://wiki.koha-community.org/wiki/Website_Administration

(So just to allay peoples concerns, it was a conscious community
decision to share the infrastructure around )

Chris

On 06/06/18 21:08, Liz Rea wrote:
> Victory, everyone!
> 
> Goal achieved and the website is golden for another year!
> 
> Thank you all so much <3
> 
> The Koha community is truly awesome.
> 
> Now... To go freshen up that website :D
> 
> Cheers,
> Liz
> 
> On Wed, 6 Jun 2018, 20:39 Narcis Garcia,  wrote:
> 
>> It's time to propose a better alternative for sending money:
>> https://en.wikipedia.org/wiki/List_of_online_payment_service_providers
>>
>>
>> El 06/06/18 a les 07:54, Michael Kuhn ha escrit:
>>> Hi Liz
>>>
 I have set up a ko-fi at https://ko-fi.com/lizrea and you can
 contribute there
>>>
>>> Sorry, but I don't like Paypal and I don't want to set up an account
>> there.
>>>
>>> But as said I will contribute immediately if you send me the necessary
>>> details (bank account etc).
>>>
>>> Best wishes: Michael
>> ___
>> 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] Elastic search error

[Chris Cormack]

Hi

You will need to install those modules. But before you do, you have an 
Elasticsearch cluster set up ready to go eh? You will need at least one elastic 
server, preferably 3 to be sure of data integrity across them.
If you have your cluster set up, then you can install those modules and 
configure the system preferences.
However if you haven't already done that there is no point doing anything else.

For the benefit of the list, Elasticsearch is great but it is not something we 
can package and install with Koha. It needs to be set up and maintained 
separately. If you plan to use it with Koha you will want to read up on it and 
how to install and maintain it. Like I mentioned the minimal safe cluster is 3 
nodes.

Chris 

On 28 May 2018 5:31:56 PM NZST, Arshad Iqbal  wrote:
>Hello everyone
>
>I have successfully upgraded 17.11.06 to 18.05. In system preferences i
>have changed Elastic search engine instead of zebra server for data
>searching. I got these error.
>
>Software error:
>
>Can't locate Catmandu/Store/ElasticSearch.pm in @INC (you may need to
>install the Catmandu::Store::ElasticSearch module) (@INC contains:
>/usr/share/koha/lib /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) at
>/usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Search.pm line 50.
>BEGIN failed--compilation aborted at
>/usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Search.pm line 50.
>
>Software error:
>
>[Mon May 28 09:26:47 2018] search.pl: Can't locate
>Catmandu/Store/ElasticSearch.pm in @INC (you may need to install the
>Catmandu::Store::ElasticSearch module) (@INC contains:
>/usr/share/koha/lib /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) at
>/usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Search.pm line 50.
>[Mon May 28 09:26:47 2018] search.pl: BEGIN failed--compilation
>aborted at
>/usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Search.pm
>line 50.
>Compilation failed in require at
>/usr/share/koha/lib/Koha/SearchEngine/Search.pm line 54.
>
>
>
>-- 
>
>
>*Muhammad Arshad Iqbal*
>Assistant Librarian at Publishing and Student Affairs Directorate,
>National University of Science and Technology (NUST) Islamabad.
>Phone number:051-90851371
>Cell no.+923444900809
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 17.05 and memcached

[Chris Cormack]

Yep that's write, create the dirs again and start zebra with the command from  
Michael.

It's the Ubuntu restart that's deleting the dirs, not the upgrade.

Chris 

On 11 May 2018 6:07:34 AM NZST, Michael Kuhn  wrote:
>Hi
>
>You wrote:
>
> > ...
> > Tried to run sudo koha-zebra –start instance-name…and received the
> > error “sudo: koha-zebra: command not found”.
>
>There is no such script named "koha-zebra". According to the 
>"koha-common" manpage available Zebra-related scripts are:
>
>* koha-start-zebra: Start Zebra for named Koha instances.
>* koha-restart-zebra: Restart Zebra for named Koha instances.
>* koha-rebuild-zebra: Rebuild the Zebra database for a Koha instance.
>* koha-stop-zebra: Stop Zebra for named Koha instances.
>
>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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 17.05 and memcached

[Chris Cormack]

Did you reboot the server in between?

The OS sometimes decides to clean up /var/run

You can run koha-create-dirs instancename and it will sort it out 

Chris 


On 9 May 2018 3:22:43 AM NZST, "Bortel, Gary"  wrote:
>This morning we tried updating from 17.05.10 to 17.05.11. All seemed to
>go well, but afterwards not results were returned from a search in
>either the public or staff interfaces. Assuming Zebra had failed to
>start, I ran "koha-start-zebra instance-name", but received the error
>"Invalid --pidfiles argument: '/var/run/koha/instance-name/' (Directory
>does not exist)". Checked /var/run and...the koha directory in fact no
>longer existed. Reverting back to the old snapshot of this server shows
>that directory in place.
>
>Is this expected behavior? Resolution?
>
>Multi-tenant installation
>Koha 17.05.10 --> 17.05.11
>Ubuntu 16.04
>Running memcached, but not yet upgraded to Plack
>
>Thanks
>gcb
>
>
>
>-Original Message-
>From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of guille
>Sent: Monday, April 30, 2018 6:14 AM
>To: koha@lists.katipo.co.nz
>Subject: Re: [Koha] Koha 17.05 and memcached
>
>sorry for my english is google translator
>
>yes, jonathan, i am testing plack in my installation, and it works
>fine, but when I restart the server it disables the intranet and opac
>page, and deletes at least that i know the file / var / run / koha.
>what am I doing wrong. my version of koha is 17.05.11
>
>
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Fwd: openldap

[Chris Cormack]

Thats telling you don't have a branchcode mapped, and no default defined
(or it is mapped by doesn't match a branchcode in the db)
  MAIN

For example

Chris

On 09/05/18 19:32, Andreas Schultze wrote:
> Hi Chris,
> Thank you for your answer.
> ST is working
> 
> But now I have a problem with entering into the database
> 
> 
> 
> 
> /usr/share/koha/opac/cgi-bin/opac/opac-user.pl userid=anna password=
> DBD::mysql::st execute failed: Cannot add or update a child row: a foreign 
> key constraint fails (`koha_nw`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` 
> FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) [for 
> Statement "INSERT INTO `borrowers` ( `branchcode`, `cardnumber`, 
> `categorycode`, `dateenrolled`, `dateexpiry`, `dateofbirth`, `debarred`, 
> `email`, `guarantorid`, `initials`, `password`, `privacy`, 
> `privacy_guarantor_checkouts`, `sms_provider_id`, `userid`) VALUES ( ?, ?, ?, 
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="TYLER", 1=' ', 
> 2="ST", 3="2019-07-01", 4="2019-09-01", 5=undef, 6=undef, 7='a...@nwschule.de 
> <mailto:7='a...@nwschule.de>', 8=undef, 9=' ', 
> 10='$2a$08$YYhbT6xQ.oibdpEUvojdpuT.jp7IewumfmzwCt5Ur/.5iRvtPcx/.', 11=1, 
> 12=1, 13=undef, 14='anna'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 
> 1836,  line 755.
> DBIx::Class::Storage::DBI::_dbh_execute(): Cannot add or update a child row: 
> a foreign key constraint fails (`koha_nw`.`borrowers`, CONSTRAINT 
> `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` 
> (`branchcode`)) at /usr/share/koha/lib/Koha/Object.pm line 121
> 
> could you help me ?
> 
> Thank you and best regards
> Andreas
> 
> 
> 
> 
>> Anfang der weitergeleiteten Nachricht:
>>
>> Von: Chris Cormack <chr...@catalyst.net.nz <mailto:chr...@catalyst.net.nz>>
>> Betreff: Aw: [Koha] openldap
>> Datum: 9. Mai 2018 um 08:42:41 MESZ
>> An: koha@lists.katipo.co.nz <mailto:koha@lists.katipo.co.nz>
>>
>> Hi Andreas
>>
>> If you look here
>>
>> https://perldoc.koha-community.org/C4/Auth_with_ldap.html#KOHA_CONF_and_field_mapping
>>  
>> <https://perldoc.koha-community.org/C4/Auth_with_ldap.html#KOHA_CONF_and_field_mapping>
>>
>> You can see an example of how to set a default category code
>> Chris
>>
>>
>> On 09/05/18 18:08, Andreas Schultze wrote:
>>> Hi Jonathan,
>>> Thank you for your answer, unfortunately I do not quite understand this. It 
>>> is the first login of an LDAP user, which is not yet available in the 
>>> system.
>>> Is there a way to set the categorycode.
>>>
>>> /usr/share/koha/misc/koha-install-log
>>> 1
>>>  
>>>ldap://debian.nwschule.de 
>>> <ldap://debian.nwschule.de>
>>>ou=people,dc=nwschule,dc=de
>>>
>>>
>>>1   
>>>1 
>>>0 
>>>1
>>>
>>>   
>>>
>>>
>>>
>>>2019-09-01
>>>2019-07-01
>>> 
>>>  
>>>
>>>
>>>
>>> Thank you and best regards
>>> Andreas
>>>
>>>> Am 08.05.2018 um 15:18 schrieb Jonathan Druart 
>>>> <jonathan.dru...@bugs.koha-community.org 
>>>> <mailto:jonathan.dru...@bugs.koha-community.org>>:
>>>>
>>>> Hi Andreas,
>>>>
>>>> It seems that the category (categorycode) you use for this patron does not 
>>>> exist.
>>>>
>>>> Regards,
>>>> Jonathan
>>>>
>>>>
>>>> On Tue, 8 May 2018 at 04:26 Andreas Schultze <aschul...@online.de 
>>>> <mailto:aschul...@online.de>> wrote:
>>>> Hallo,
>>>> I have a problem with the ldap connection on Debian9 Server.
>>>> User authentication works but I can not log in with an ldap user.
>>>>
>>>> I receive the following error message:
>>>> /usr/share/koha/opac/cgi-bin/opac/opac-user.pl <http://opac-user.pl/> 
>>>> userid= password=
>>>> Can't call method "default_privacy" on an undefined value at 
>>>> /usr/share/koha/lib/C4/Members.pm line 416,  line 755.
>>>>
>>>> Thank you and best regards
>>>> Andreas
>>>> ___
>>>> Koha mailing list  http://koha-community.org <http://koha-community.org/>
>>>> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
>>>> 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
>>> 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 and 2 factor authentication

[Chris Cormack]

Hey Kyle

You already guessed my response, google authenticator would be ok, as a choice. 
But not the ideal option.
We ideally will support something that can handle things like yubikey as well.

So ok for Google as an option but not the only option, ie a system that 
supports other systems as well as authenticator 

Chris 

On 20 April 2018 5:52:42 AM NZST, Kyle Hall  wrote:
>There seems to be some interest in adding 2 factor authentication to
>Koha.
>We are trying to find out what would be the most practical and easiest
>way
>to implement 2fa for Koha combined with what would be most useful for
>libraries that would actually *use* 2fa.
>
>The bug report filed for it is
>https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20476
>
>Basically, at this point we've come up with two ideas:
>1) Use Auth::GoogleAuthenticator
>2) Use PrivacyIdea ( https://www.privacyidea.org/ )
>
>Implementing GoogleAuthenticator would be much simpler I think.
>However, my
>thought is the same users that are concerned about 2fa are the same
>users
>that are concerned about privacy, and may not be interested in it
>simply
>because it means giving at least some data to Google.
>
>PrivacyIdea on the other hand would be more work for both the developer
>and
>the system admin since it is a completely separate package that would
>require installation and maintenance independent of Koha itself.
>However,
>it is also much more powerful and can offer a myriad of 2FA options
>that
>GoogleAuthenticator cannot. On the developer side, OTRS which is also
>written in Perl has implemented and may or may not have something
>useful we
>can crib from it (
>https://github.com/privacyidea/privacyidea/tree/master/authmodules/OTRS
>).
>
>So, what does everything think? If you want 2FA, would
>GoogleAuthenticator
>be a reasonable solution?
>
>Kyle
>
>
>http://www.kylehall.info
>ByWater Solutions ( http://bywatersolutions.com )
>Meadville Public Library ( http://www.meadvillelibrary.org )
>Crawford County Federated Library System ( http://www.ccfls.org )
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha on a Raspberry Pi

[Chris Cormack]

Hi David 


It's been done before, you will definitely need to have it running plack

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

and

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

If the pi is running debian already then its quite easy

Chris

* David Nind (david.n...@gmail.com) wrote:

Hi everyone.

Has anyone been able to successfully get Koha working on a Raspberry Pi
recently?

If you have, could you share how you did it?

Thanks.

(Asking for a query from Twitter - they would like to use it as a demo for
a library group meeting.)


David Nind | david.n...@gmail.com
PO Box 12367, Thorndon, Wellington, New Zealand 6144
m. +64 21 0537 847
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] DDoS attack on memcached

[Chris Cormack]

That will work, however unless you have configured your memcached server to 
listen on an external IP it will only be listening on localhost. It's worth 
checking both though.

Chris 

On 1 March 2018 2:55:56 AM NZDT, Mark Alexander  wrote:
>Apparently, a bug in memcached (which we use in Koha) causes it to be
>used an intermediary in a DDoS attack:
>
>https://arstechnica.com/information-technology/2018/02/in-the-wild-ddoses-use-new-way-to-achieve-unthinkable-sizes/
>
>I'm not an expert on this kind of thing by any means, but judging
>from this:
>
>  https://github.com/memcached/memcached/wiki/ReleaseNotes156
>
>It seems that we can disable the attack by preventing memcached from
>listening on a UDP port.  I was able to do this by adding the
>following lines to /etc/memcached.conf:
>
>  # Disable UDP
>  -U 0
>
>Then restarted memcached and apache2.
>
>My questions for the experts: Is this the correct approach?  Is it even
>necessary?
>Is there more we should do?
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha 16.11.16 released

[Chris Cormack]

The Koha community is proud to announce the release of Koha 16.11.16

You can read the full release notes here

https://koha-community.org/koha-16-11-16-released/

Chris
--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cronjob Settings Help ?

[Chris Cormack]

And yes you will need to set up your mta to actually deliver mail. This is 
entirely separate to Koha though.

Chris 

On 10 February 2018 7:59:18 AM NZDT, SATISH  wrote:
>Yes, I am using package method for installation.
>
>Now, removed all the crontab entries made by me.
>
>Since it was not delivering mails, I started working with cronjob and
>then
>to postfix.
>
>As you had mentioned, cron settings are already made with package
>installation, then I assume
>
>It must be with postfix issue now,
>
>However, I attached a screenshot  for the test mail  verification from
>postfix at https://ibb.co/gBHVOx
>
>Thank you all.
>Satish
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cronjob Settings Help ?

[Chris Cormack]

Did you run the command to enable email?

Chris 

On 10 February 2018 7:59:18 AM NZDT, SATISH  wrote:
>Yes, I am using package method for installation.
>
>Now, removed all the crontab entries made by me.
>
>Since it was not delivering mails, I started working with cronjob and
>then
>to postfix.
>
>As you had mentioned, cron settings are already made with package
>installation, then I assume
>
>It must be with postfix issue now,
>
>However, I attached a screenshot  for the test mail  verification from
>postfix at https://ibb.co/gBHVOx
>
>Thank you all.
>Satish
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cronjob Settings Help ?

[Chris Cormack]

If you are using packages, you want to do none of that. None at all.

The packages put the cron jobs in place already. In /etc/cron.d/koha-common as 
well as cron.daily hourly etc

You have now sadly made quite a mess. All you really needed to do with the 
packages is make sure your mta is set up then run
 sudo koha-email-enable instancename

I don't know who told you to do it the way you have, but they are wrong. 

Chris 
 

On 10 February 2018 6:47:22 AM NZDT, SATISH  wrote:
>Hi,
>
>1) I removed all cron entries by crontab -r
>
>2) did # sudo koha-shell igntucl ( as koha default user created by
>package
>installation)
>
>3) crontab -e igntucl-koha crontab.example
>
>4) manually did bin/process_message_queue.pl as (igntucl-koha) user
>
>5) mail notices status changed to - sent
>
>6) mail log for igntucl-koha user shows;
>
>root@testserver:/var/mail# tail -f igntucl-koha
>X-Cron-Env: 

Re: [Koha] Pop up Message "Leave a message" on Patron Circulation.

[Chris Cormack]

Clear your browser caches (shift-f5) often will do it

Here is more info http://www.refreshyourcache.com/en/home/

Chris   

On 23/01/18 19:13, Admire Mutsikiwa wrote:
> I have migrated my Koha instance to a new server by re-installing the
> operating system (Debian 8.5) and installing Koha 17.5.6. My Koha instance,
> which was on a lower Koha 17.5.x was subsequently upgraded to 17.5.6. Now
> when I browse or search for a patron record, on displaying it, I am getting
> a pop up message "Pop up Message "Leave a message" . 
> 
>  
> 
> Any pointer on how to get over it.
> 
>  
> 
> Kind Regards,
> 
>  
> 
> Admire Mutsikiwa (Mr)
> 
> ICT Manager
> 
> Libraries
> 
> University of Zimbabwe
> 
> Tel:+263-4-303276
> 
> Mob:+26377111
> 
>  
> 
> "It is easy to dodge our responsibilities, but we cannot dodge the
> consequences of dodging our responsibilities."  Josiah Charles Stamp
>  
> 
>  
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> 



signature.asc
Description: OpenPGP digital signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Pop up Message "Leave a message" on Patron Circulation.

[Chris Cormack]

Clear your browser caches (shift-f5) often will do it

Here is more info http://www.refreshyourcache.com/en/home/

Chris   

On 23/01/18 19:13, Admire Mutsikiwa wrote:
> I have migrated my Koha instance to a new server by re-installing the
> operating system (Debian 8.5) and installing Koha 17.5.6. My Koha instance,
> which was on a lower Koha 17.5.x was subsequently upgraded to 17.5.6. Now
> when I browse or search for a patron record, on displaying it, I am getting
> a pop up message "Pop up Message "Leave a message" . 
> 
>  
> 
> Any pointer on how to get over it.
> 
>  
> 
> Kind Regards,
> 
>  
> 
> Admire Mutsikiwa (Mr)
> 
> ICT Manager
> 
> Libraries
> 
> University of Zimbabwe
> 
> Tel:+263-4-303276
> 
> Mob:+26377111
> 
>  
> 
> "It is easy to dodge our responsibilities, but we cannot dodge the
> consequences of dodging our responsibilities."  Josiah Charles Stamp
>  
> 
>  
> 
> ___
> 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] Outage for bugs.koha-community.org : Fwd: Linode Support Ticket 9818790 - Critical Maintenance for CPU Vulnerabilities (Meltdown)

[Chris Cormack]

It looks like my linode which hosts bugs.koha-community.org and the
dashboard and few other sites will be down for maintenance
at 2018-01-19 9:00:00 AM UTC

Chris



-- Forwarded message --
From:  
Date: 18 January 2018 at 16:39
Subject: Linode Support Ticket 9818790 - Critical Maintenance for CPU
Vulnerabilities (Meltdown)
To: ch...@bigballofwax.co.nz



Hello,

A number of serious security vulnerabilities affecting multiple CPU
architectures were recently disclosed by Google's Project Zero team as
outlined in our blog post[1]. In order to address the disclosed
vulnerabilities, the physical hardware on which your Linode resides
will need to undergo maintenance. This is the first of several
separate maintenances that will be necessary to fully mitigate these
vulnerabilities. This maintenance specifically patches the Meltdown
vulnerability; the Spectre vulnerability will be addressed in a future
maintenance cycle. We will inform you of these maintenance cycles via
additional tickets.

Scheduled maintenance windows are listed within the Linode Manager[2]
in the time zone that was configured in your user's My Profile[3]. The
maintenance window of new Linodes and upgraded, migrated, or resized
Linodes will be reflected in the Linode Manager[2], but you may not
receive maintenance ticket updates for these changes.

The following Linode(s) have now been assigned a maintenance window in
which a reboot will occur. Please note that these times can change as
a result of the actions mentioned above. At this time your reboot
schedule in UTC is as follows:

 * 2018-01-19 9:00:00 AM UTC - bugs

You can prepare your Linode for this maintenance by following our
Reboot Survival Guide. By following this guide before your
maintenance, you will be able to ensure that services running on your
Linode are resumed properly. The Reboot Survival Guide is available
here:

https://www.linode.com/docs/uptime/reboot-survival-guide

These updates affect the underlying infrastructure that your Linode
resides on and will not affect the data stored within your Linode. To
further protect your Linode, we strongly recommend that you verify it
is configured to boot using our latest kernel, which includes patches
to help address these vulnerabilities. If your Linode's Configuration
Profile is set to utilize our latest kernel, your kernel will
automatically be updated upon rebooting.

During the maintenance window, your Linode will be cleanly shut down
and will be unavailable while we perform the updates. A two-hour
window is allocated, however the actual downtime should be much less.
After the maintenance has concluded, each Linode will be returned to
its last state (running or powered off).

We regret the short notice and the downtime required for this
maintenance. However, due to the severity of these vulnerabilities, we
have no choice but to take swift and immediate action to ensure the
safety and security of our customers. For these reasons, we must
adhere to a strict timetable, and will not be able to reschedule or
defer this maintenance.

If you experience any issues following the maintenance, please feel
free to reach out to us and we will be happy to assist.

--Linode

[1] 
[2] 
[3] 


---
https://manager.linode.com/support/ticket/9818790
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Fwd: Koha 17.11 Web installer stuck at Choose your language

[Chris Cormack]

Hmm nope, I've never run it on a 32 bit server (well not in the last 15 years I 
haven't). All our servers are 64bit

Chris 

On 17 o Kohitātea, 2018 3:13:14 a.m. GMT+13:00, Daniel Owens 
 wrote:
>I managed to get it going using a 32-bit VPS. Are 64-bit servers not 
>supported? I am pretty sure that is the only difference in the setup.
>If 
>that is the case, does that detail need to be in the installation 
>instructions on the wiki?
>
>Daniel
>
>On 1/16/18 11:17 AM, Daniel Owens wrote:
>> Jonathan has been helping me, but we are still not able to find a 
>> solution to get beyond the Choose your language page for the web 
>> installer on Koha 17.11 using Ubuntu Server 16.04 with MariaDB
>10.0.31.
>>
>> I ran the installer, checking the log immediately afterward. I
>created 
>> a gist at 
>> https://gist.github.com/dowens76/b7fcb8f2c93a353a6dbdbc2623d57c37, in
>
>> case anyone else has any ideas.
>>
>> I assume others have successfully installed Koha 17.11 on Ubuntu 
>> 16.04. I would love to hear about any tips for doing this 
>> successfully, anything that is not included at 
>> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages.
>>
>> Daniel
>>
>>
>> On 1/10/18 8:43 PM, Jonathan Druart wrote:
>>> tail -f  /var/log/koha/$INSTANCE/*.log
>>>
>>> On Wed, 10 Jan 2018 at 10:36 Daniel Owens >> > wrote:
>>>
>>>     That would certainly be a good idea. Do you mean apache logs or
>>>     koha logs?
>>>
>>>     Daniel
>>>
>>>
>>>     On 1/10/18 6:16 PM, Jonathan Druart wrote:
     Hi Daniel,

     Did you check the log file?

     Regards,
     Jonathan

     On Tue, 9 Jan 2018 at 23:13 Daniel Owens > wrote:

     I am using the Web installer for Koha 17.11 on Ubuntu
>16.04.

     I select "en" (or vi-VN, which is also available), and
>click
     "Continue
     to the next step", but the browser says "Waiting for
     ..." for
     awhile then returns to the "Choose your language" screen.

     Any ideas what is happening?

     Daniel

     ___
     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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Missing database schema for Koha 17.11

[Chris Cormack]

* Chris Cormack (chr...@catalyst.net.nz) wrote:

Actually it's not really keeping that site up to date. It's more keeping the 
comments in kohastructure.sql up to date. So the schema is accurate.

Ill sort the site out



Done

Chris


Chris

On 16 o Kohitātea, 2018 7:13:26 p.m. GMT+13:00, Indranil Das Gupta 
<indr...@gmail.com> wrote:

Hi Michael,

I believe I may be the person at fault here. -I had volunteered as the
database documentation manager for 17.11, which as I understood was
making
sure that schema.koha-community.org is maintained uptodate. Frankly I
didn't have much clue.

As for what you are asking for, I do maintain a personal schema set
based
on the versions we end up working with. This is usually always
up-to-date.
Perhaps it can help you - https://schema.l2c2.co.in/

cheers
indranil



--
Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW  : http://www.l2c2.co.in
Blog: http://blog.l2c2.co.in
IRC : indradg on irc://irc.freenode.net
Twitter : indradg

On Tue, Jan 16, 2018 at 1:50 AM, Michael Kuhn <m...@adminkuhn.ch> wrote:


Hi

Usually the database schema of the Koha versions can be found under
http://schema.koha-community.org/ but there is no database schema for
Koha 17.11.

Also it cannot be found under an URL looking like
http://schema.koha-community.org/17_11/ (which results in nginx error

404

Not found).

Does anyone know where it can be found or how to create it?

There is a database schema for the "Koha development version" under
http://schema.koha-community.org/master/ but this stems from 26 June

2017

and so is a little outdated.

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


--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Missing database schema for Koha 17.11

[Chris Cormack]

Actually it's not really keeping that site up to date. It's more keeping the 
comments in kohastructure.sql up to date. So the schema is accurate.

Ill sort the site out 

Chris 

On 16 o Kohitātea, 2018 7:13:26 p.m. GMT+13:00, Indranil Das Gupta 
 wrote:
>Hi Michael,
>
>I believe I may be the person at fault here. -I had volunteered as the
>database documentation manager for 17.11, which as I understood was
>making
>sure that schema.koha-community.org is maintained uptodate. Frankly I
>didn't have much clue.
>
>As for what you are asking for, I do maintain a personal schema set
>based
>on the versions we end up working with. This is usually always
>up-to-date.
>Perhaps it can help you - https://schema.l2c2.co.in/
>
>cheers
>indranil
>
>
>
>--
>Indranil Das Gupta
>L2C2 Technologies
>
>Phone : +91-98300-20971
>WWW  : http://www.l2c2.co.in
>Blog: http://blog.l2c2.co.in
>IRC : indradg on irc://irc.freenode.net
>Twitter : indradg
>
>On Tue, Jan 16, 2018 at 1:50 AM, Michael Kuhn  wrote:
>
>> Hi
>>
>> Usually the database schema of the Koha versions can be found under
>> http://schema.koha-community.org/ but there is no database schema for
>> Koha 17.11.
>>
>> Also it cannot be found under an URL looking like
>> http://schema.koha-community.org/17_11/ (which results in nginx error
>404
>> Not found).
>>
>> Does anyone know where it can be found or how to create it?
>>
>> There is a database schema for the "Koha development version" under
>> http://schema.koha-community.org/master/ but this stems from 26 June
>2017
>> and so is a little outdated.
>>
>> 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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Manual 17.11 zh_TW is translated.

[Chris Cormack]

* Anthony Mao (maol...@gmail.com) wrote:

Hi Jonathan,

Thanks.
Not only zh_TW (Traditional Chinese) but other 7 translating
languages, including Arabic, Czech, Spanish, French, Italian,
Portuguese-Brazil, Turkish.


the zh_TW is updated and available at
http://koha-community.org/manual/18.05/zh_TW/html/index.html>


There has nothing about  manual 18.05 at
http://translate.koha-community.org/. But I am glad you did it on
koha-community.org. And we have HTML and ePub 2 formats.

How about Manual 17.11? It is waiting for convert to  HTML and ePub
with update translated po files.


It's there too
https://koha-community.org/manual/17.11/zh_TW/html/

Chris

--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 17.11.01 released

[Chris Cormack]

Hi Bruce 


What happens if you try

sudo apt-get install libtest-simple-perl

?

Chris

* Bruce A. Metcalf (bruce.metc...@augustansociety.net) wrote:

On 01/04/2018 01:55 PM, Chris Cormack wrote:

* Chris Cormack (chr...@catalyst.net.nz) wrote:
That usually means an unmet dependency. Definitely don't remove 
it. I'll look into it soon and see if I can spot what the issue is


Hmm, I just tried at work and the 17.11.00 to 17.11.01 worked fine

Can you paste exactly what it is saying when you upgrade (don't choose
yes to remove though)


This system has just had "apt-get update && apt-get upgrade" run, with 
no new packages suggested.

When I try to upgrade:

==
root# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... The following packages were automatically 
installed and are no longer required:
at autopoint daemon docbook-xml docbook-xsl gettext idzebra-2.0 
idzebra-2.0-common idzebra-2.0-doc idzebra-2.0-utils 
libalgorithm-checkdigits-perl libanyevent-http-perl libanyevent-perl 
libappconfig-perl libarchive-zip-perl libauthen-cas-client-perl 
libbarcode-code128-perl libbiblio-endnotestyle-perl libbit-vector-perl 
libbusiness-isbn-data-perl libbusiness-isbn-perl 
libcache-fastmmap-perl libcache-memcached-fast-perl 
libcache-memcached-perl libcache-perl libcarp-assert-more-perl 
libcarp-assert-perl libcarp-clan-perl libcgi-compile-perl 
libcgi-emulate-psgi-perl libcgi-session-driver-memcached-perl 
libcgi-session-perl libcgi-session-serialize-yaml-perl 
libclass-accessor-chained-perl libclass-accessor-grouped-perl 
libclass-accessor-perl libclass-adapter-perl 
libclass-c3-componentised-perl libclass-data-inheritable-perl 
libclass-factory-util-perl libclass-makemethods-perl libclass-mix-perl 
libclass-returnvalue-perl libclass-singleton-perl libclass-unload-perl 
libcontext-preserve-perl libconvert-basen-perl 
libcrypt-eksblowfish-perl libcrypt-gcrypt-perl 
libdata-dumper-concise-perl libdata-ical-perl libdata-page-perl 
libdate-calc-perl libdate-manip-perl libdatetime-event-ical-perl 
libdatetime-event-recurrence-perl libdatetime-format-builder-perl 
libdatetime-format-ical-perl libdatetime-format-mail-perl 
libdatetime-format-mysql-perl libdatetime-format-strptime-perl 
libdatetime-format-w3cdtf-perl libdatetime-locale-perl 
libdatetime-perl libdatetime-set-perl libdatetime-timezone-perl 
libdbd-mock-perl libdbd-sqlite2-perl libdbix-class-perl 
libdbix-class-schema-loader-perl libdbix-runsql-perl 
libdevel-cover-perl libdevel-stacktrace-ashtml-perl 
libdevel-symdump-perl libemail-abstract-perl libemail-date-perl 
libemail-simple-perl libemail-valid-perl libexception-class-perl 
libfile-nfslock-perl libfile-pushd-perl libfile-sharedir-perl 
libfile-slurp-perl libfilesys-notify-simple-perl libfont-ttf-perl 
libgd-barcode-perl libgraph-perl libgraphics-colornames-perl 
libgraphics-magick-perl libgraphicsmagick3 libgraphviz-perl 
libgravatar-url-perl libhash-multivalue-perl libheap-perl 
libhtml-scrubber-perl libhtml-tidy-perl libhttp-body-perl 
libhttp-oai-perl libhttp-parser-xs-perl libhttp-server-simple-perl 
libidzebra-2.0-0 libidzebra-2.0-dev libidzebra-2.0-mod-alvis 
libidzebra-2.0-mod-dom libidzebra-2.0-mod-grs-marc 
libidzebra-2.0-mod-grs-regx libidzebra-2.0-mod-grs-xml 
libidzebra-2.0-mod-text libidzebra-2.0-modules libimage-size-perl 
libio-multiplex-perl libio-pty-perl libipc-run-perl 
libipc-shareable-perl libjcode-pm-perl libjson-validator-perl 
liblibrary-callnumber-lc-perl liblingua-ispell-perl 
liblingua-stem-snowball-perl liblocale-currency-format-perl 
liblocale-maketext-lexicon-perl liblocale-po-perl liblog-dispatch-perl 
liblog-log4perl-perl libmail-sendmail-perl libmarc-charset-perl 
libmarc-record-perl libmarc-xml-perl libmath-base36-perl 
libmodern-perl-perl libmodule-bundled-files-perl libmodule-find-perl 
libmodule-refresh-perl libmojolicious-plugin-openapi-perl 
libnet-cidr-perl libnet-domain-tld-perl libnet-server-perl 
libnet-sftp-foreign-perl libnet-z3950-zoom-perl libnumber-format-perl 
libole-storage-lite-perl libopenoffice-oodoc-perl 
libparse-recdescent-perl libpath-class-perl libpdf-api2-perl 
libpdf-api2-simple-perl libpdf-fromhtml-perl libpdf-reuse-barcode-perl 
libpdf-reuse-perl libpdf-table-perl libpdf-writer-perl 
libplack-middleware-reverseproxy-perl libplack-perl 
libpod-coverage-perl libreadonly-perl libreadonly-xs-perl 
libschedule-at-perl libset-infinite-perl libsms-send-perl 
libspreadsheet-parseexcel-perl libspreadsheet-writeexcel-perl 
libsql-abstract-perl libsql-translator-perl libstring-crc32-perl 
libstring-random-perl libsub-uplevel-perl libswagger2-perl 
libtemplate-perl libtemplate-plugin-htmltotext-perl 
libtemplate-plugin-json-escape-perl libtemplate-plugin-stash-perl 
libtest-deep-perl libtest-longstring-perl libtest-mockmodule-perl 
libtest-pod-perl libtest-sharedfork-perl libtest-simple-perl 
libtest-strict-perl libtest-tcp-perl libtest-warn

Re: [Koha] Koha 17.11.01 released

[Chris Cormack]

* Chris Cormack (chr...@catalyst.net.nz) wrote:

Hi Bruce

That usually means an unmet dependency. Definitely don't remove it. I'll look 
into it soon and see if I can spot what the issue is

Chris


Hmm, I just tried at work and the 17.11.00 to 17.11.01 worked fine

Can you paste exactly what it is saying when you upgrade (don't choose
yes to remove though)

Chris


On January 5, 2018 5:35:09 AM GMT+13:00, "Bruce A. Metcalf" <libr...@figzu.com> 
wrote:

On 01/03/2018 12:25 PM, Jonathan Druart wrote:


The Koha community is proud to announce the release of Koha  >

17.11.01. Packages are also available.

When I attempt to upgrade using apt-get, the system proposes to remove
koha-common, but not to replace or upgrade it. This is not how previous

upgrades have been done. Is this correct?

Koha 17.05.05 installed via packages under Debian Squeeze.

Regards,
/ Bruce /
Bruce A. Metcalf, FAS
Augustan Society Library


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


--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 17.11.01 released

[Chris Cormack]

Hi Bruce

That usually means an unmet dependency. Definitely don't remove it. I'll look 
into it soon and see if I can spot what the issue is

Chris 

On January 5, 2018 5:35:09 AM GMT+13:00, "Bruce A. Metcalf"  
wrote:
>On 01/03/2018 12:25 PM, Jonathan Druart wrote:
>
>> The Koha community is proud to announce the release of Koha  >
>17.11.01. Packages are also available.
>
>When I attempt to upgrade using apt-get, the system proposes to remove 
>koha-common, but not to replace or upgrade it. This is not how previous
>
>upgrades have been done. Is this correct?
>
>Koha 17.05.05 installed via packages under Debian Squeeze.
>
>Regards,
>/ Bruce /
>Bruce A. Metcalf, FAS
>Augustan Society Library
>
>
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha 16.11.15 released

[Chris Cormack]

The Koha community is happy to announce the release of 16.11.15, this is
a maintenance release. The 16.11.x branch is no longer released as packages,
so people should upgrade to 17.05.x or 17.11.x as soon as practical.

You can read the full release notes at 
https://koha-community.org/koha-16-11-15-released/


Happy new year

Chris

--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] BOM in MARC 21 data files

[Chris Cormack]

Yes it isn't part of the standard. However vendors very rarely follow 
standards. Worse they often exhibit attitudes like this, that others should 
have to deal with cleaning up for them.
I'd estimate that 30% of the code in Koha is dealing with the fact that others 
don't follow standards :)

However we should be able to deal with the BOM without too much effort so we 
should do that.

Ill try to have a look over the Xmas break

Happy holidays all
Chris 

On 25 December 2017 8:37:22 AM NZDT, Michael Kuhn  wrote:
>Hi
>
>Recently we have the problem some vendors are delivering their 
>UTF-8-encoded MARC 21 data files (ISO 2709) starting with a byte order 
>mark / BOM (see https://en.wikipedia.org/wiki/Byte_order_mark). Most 
>vendors I know (e. g. Overdrive) don't include such a BOM, but in 
>Germany some do. When asking them to change this they say "every ILS 
>should be able to handle this".
>
>However, when trying to import such a file into Koha the first record
>is 
>simply ignored. This is especially fatal when importing a data file 
>containing only one record, of course.
>
>1. As far as I know the BOM is not part of the MARC 21 (ISO 2709) 
>format, so there mustn't be any leading BOM. Am I correct?
>
>2. Is there a way within Koha to remove that unwanted BOM or to teach 
>Koha to ignore it and import the data anyway?
>
>Of course such a BOM could be manually removed by using sed, but I feel
>
>that a) either the vendor shouldn't include the BOM at all or b) Koha 
>"should be able to handle this".
>
>What do you think?
>
>Best wishes and happy holidays! 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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Digest, Vol 146, Issue 22

[Chris Cormack]

Hi 


I bet if you go to tools -> viewlog it works.

It is only broken from if you are on the borrowers page.

Go to http://koha.adminkuhn.ch:8080/cgi-bin/koha/tools/viewlog.pl
And it works there.

So yes there is a bug, but it is only when viewing the log via a patrons
record.

So if you file a bug make sure to add that information or people will
spend time going to the tools->view log and not being able to recreate
it

Chris


* Abdulsalam Yousef (ayou...@kwareict.com) wrote:

Hello dear Katrin,

Sorry my dear, I don't think that it's a problem in my database, It may be
a bug in (koha 17.11), Just try again
by filling the (Librarian:) field with the borrower number instead of the (
Object:) field, And leave the (Object:)
field empty, You will see what I mean.
Also you can test it here
(
http://koha.adminkuhn.ch:8080/cgi-bin/koha/tools/viewlog.pl?do_it=1=MEMBERS=circulation=1=circ
)
It's a demo site for koha 17.11 in koha community here (
https://koha-community.org/demo/)  use (demo/demo) for logging in, Then
test it
for this user (Herr Demokrit Morgenstern (1)), Also the problem was not in
koha 17.05, You can test it using
Bywater demo version (koha17.05), You will see that it working fine in koha
(17.05).
Thanks in advance.
Regards.

On Mon, Dec 11, 2017 at 2:00 AM, <koha-requ...@lists.katipo.co.nz> 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: Koha 17.11 Modification log problem (Katrin Fischer)


--

Message: 1
Date: Sun, 10 Dec 2017 21:20:35 +0100
From: Katrin Fischer <katrin.fischer...@web.de>
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha 17.11 Modification log problem
Message-ID: <098cc8ec-33f5-22c7-e559-d88cd302d...@web.de>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi,

I just tried in my database and the links in the logs worked nicely from
the patron record and from the tools page. Is it possible it could be a
problem with your data?

Hope that helps,

Katrin


On 09.12.2017 21:43, Abdulsalam Yousef wrote:
> Hello all,
>
> Showing patron Modification log from koha 17.11 doesn't show any system
log
> for the patron, Instead it redirects to (
> http://domain_name/cgi-bin/koha/circ/circulation.pl?borrowernumber=
>
> Thanks in advance.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha



--

Subject: Digest Footer

___
Koha mailing list
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--

End of Koha Digest, Vol 146, Issue 22
*


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


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Export Patrons report has passwords encrypted

[Chris Cormack]

Hi Christopher

On 01/12/17 11:52, Christopher Davis wrote:
> Dear Colleagues,
> 
> My library needs to regularly send to a vendor a list of our patrons'
> library card numbers and passwords/PINs so that they can authenticate
> patrons. The only way which I have found to do this is to use the "Export
> Patrons" report found at <
> https://wiki.koha-community.org/wiki/SQL_Reports_Library#Export_patrons>.
> Unfortunately, the passwords in the report are encrypted and are not given
> in cleartext. I am glad to see that Koha does not just give out passwords
> in cleartext, but is there a way to make this work?
> 

Nope, the passwords are not stored in the clear anywhere, it's a one
directional encryption, there is no way to go back.
(On purpose of course)

Chris

> Thank you,
> 
> Christopher Davis
> Systems & E-Services Librarian
> Uintah County Library
> cgda...@uintah.utah.gov
> (435) 789-0091 <14357890091> ext.261
> uintahlibrary.org
> basinlibraries.org
> facebook.com/uintahcountylibrary
> instagram.com/uintahcountylibrary
> ___
> 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 CMS

[Chris Cormack]

Should the url be /cgi-bin/koha/pages.pl  ? 

On 9 November 2017 12:43:12 AM NZDT, hughes dimka  wrote:
>Hello All,
>
>I have been trying for the past few days on trying to set-up a cms for
>a
>small library here in Nigeria and i have used the following guide
>
>https://wiki.koha-community.org/wiki/Koha_as_a_CMS
>https://koha-community.org/manual/17.05/html/18_miscellaneous.html#using-koha-as-a-content-management-system-cms
>
>I installed koha 17.05 on ubuntu, and after following the guide and i
>check
>the page with  http://localhost/pages.pl?p=test , i keep getting "The
>requested URL /pages.pl was not found on this server" i have given
>read,execute and write permission, but still yet i keep getting erros
>
>Any help, would be highly appreciative.
>
>-- 
>Hughes Dimka
>Hopewell Solutions Services Nigeria Ltd
>No.15 Adekunle Kuye Street, Off Agbonyin Street, Off Adelabu Street,
>Surulere,Lagos State
>Nigeria
>tel: +2348066951910
>email: hdi...@gmail.com
>
>
>Virus-free.
>www.avast.com
>
><#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem with opac address

[Chris Cormack]

Also if you are already using plack. You should make sure you are using 
memcached.

Chris 

On 8 November 2017 6:22:35 AM NZDT, Pedro Amorim  wrote:
>Hello lukasz,
>
>What do you mean exactly by your IT "reindexing" the site?
>
>Could it perhaps be related to template cache? In the following
>discussion
>they talk about "About Koha" -> "System Information" and the directory
>for
>template caching. You might try removing it if you have it configured.
>https://lists.katipo.co.nz/public/koha/2017-March/047438.html
>
>I would also consider enabling Plack for your instance:
>https://wiki.koha-community.org/wiki/Plack
>
>
>
>On 7 November 2017 at 12:10,  wrote:
>
>> Hello,
>>
>>
>>
>> We've started to show new books at our OPAC site and at some point
>after
>> refreshing our main site stopped to show the changes.
>>
>> When we ask our IT, he reindexed our site and then all the changes
>were
>> shown.
>>
>> When we change something again at https://kohaopac.alingsas.se/
>without
>> reindexing there is no effect.
>>
>> But when we click on Koha logo in the upper left corner of the
>screen,
>> which has this address https://kohaopac.alingsas.se/
>> cgi-bin/koha/opac-main.pl all the changes are updated and shows
>> immediately.
>>
>> It seems as we need reindexing every time we change something at our
>OPAC
>> site, to have main address https://kohaopac.alingsas.se/ to work.
>>
>> Should we ask our IT to set reindexing for every night or is there
>any
>> other sollution to this problem?
>>
>>
>> Best regards
>> Lukasz Mesek
>> Vuxenbibliotekarie
>> Alingsås bibliotek
>> lukasz.me...@alingsas.se
>> ___
>> 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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] bugs.koha-community.org (and a few other sites) outage

[Chris Cormack]

* Chris Cormack (chr...@catalyst.net.nz) wrote:

Hi All

Linode are migrating servers to a new data centre, this will cause an
outage for the server that runs bugs.koha-community.org and a few other
sites (including download.koha-community.org)

They will do it automatically, but I am going to do it today manually so
that I can keep an eye on it.
So those sites will go down for a while, while I move it

I will update when the move is completed



All back now.

Side effect, bugs.koha-community.org is now listening on ipv6 now too

Chris


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] bugs.koha-community.org (and a few other sites) outage

[Chris Cormack]

Hi All

Linode are migrating servers to a new data centre, this will cause an
outage for the server that runs bugs.koha-community.org and a few other
sites (including download.koha-community.org)

They will do it automatically, but I am going to do it today manually so
that I can keep an eye on it.
So those sites will go down for a while, while I move it

I will update when the move is completed

Chris
--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Software error when checking out

[Chris Cormack]

On 28/09/17 22:17, Morgan Earnshaw wrote:
> Hello,
> 
> There is one record that I'm having issues trying to check out. I
> have been able to check out other items to this patron and to
> others.
> 
> I get the software error: 
> DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '304'
> for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 120
> 
> Anyone have any ideas on what's going on?
> 
> 
Hi Morgan

There's a bug in a few versions of Koha (fixed in the latest releases)
that meant that it was possible to get a record with the same id
number into 2 tables.

You will need to upgrade to the latest release, make a couple of
changes to the database config and remove the duplicate.

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

Re: [Koha] messages to the list not being delivered

[Chris Cormack]

* Mesfin Teshome (mesfin.tesh...@africainternational.edu) wrote:

Greetings,
I am not sure who the maintainer of the list is but my messages to the list are 
being held back. I have been a member of this list with my yahoo account and I 
have been unable to post from that and I registered with this and the same 
thing is happening. Would someone please tell me what I am doing wrong?
Kind regards,



Hi Mesfin

This email address (the one you sent the mail from) is not subscribed to
the list. That is why it is not being delivered without a moderator
going to check it

Chris



[AIU logo]<http://aiu.ac.ke> Mesfin Teshome | ICT Manager | ICT
Cell No.:+254722664398

Committed To His Mission, Connected To His World!
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Coordinate Koha releases -- September 2017

[Chris Cormack]

Added to that, github is just a backup. The actual repo lives at 
git.koha-community.org. Please always bear this in mind.
We use github purely for a backup, so it is always a little behind the actual 
repo.

Chris 

On 22 September 2017 5:39:13 AM NZST, Jonathan Druart 
 wrote:
>Hi Alex,
>
>Yes, these 3 versions have been released altogether because they
>contain
>some security fixes. Release maintainers will push the branches to the
>main
>repository soon (next couple of days).
>
>Regards,
>Jonathan
>
>On Thu, 21 Sep 2017 at 13:56 Alex Bernier 
>wrote:
>
>> Hello,
>>
>> There is no "v17.05.04" tag on the Github repo, is it normal ?
>>
>> Regards,
>>
>> Alex
>>
>> On Thu, Sep 21, 2017 at 03:30:30PM +, Jonathan Druart wrote:
>> > The Koha community is releasing an update for all supported
>versions of
>> > Koha.
>> >
>> > This update is not a security update but contain several security
>fixes.
>> >
>> > The update is available for the following new releases:
>> > 17.05.04 - https://koha-community.org/koha-17-05-04-release/
>> > 16.11.12 - https://koha-community.org/koha-16-11-12-release/
>> > 16.05.17 - https://koha-community.org/koha-16-05-17-release/
>> >
>> > The Debian packages are available from the Koha community
>repository.
>> >
>> > Tarballs are also available:
>> > http://download.koha-community.org/koha-17.05.04.tar.gz
>> > http://download.koha-community.org/koha-16.11.12.tar.gz
>> > http://download.koha-community.org/koha-16.05.17.tar.gz
>> >
>> > Regards,
>> > Jonathan
>> > ___
>> > 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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Software error: Koha Web Installer-MARC21

[Chris Cormack]

The main thing to do is use mariadb not mysql.
The error reported earlier in this thread is due to using mysql.

There are still some issues with Koha and latest mysql. But it's fine with 
mariadb

Chris 

On 20 September 2017 7:16:44 AM NZST, Jonathan Druart 
 wrote:
>We received good feedbacks from people using Koha packages on stretch,
>see
>this recent thread
>https://lists.katipo.co.nz/pipermail/koha/2017-August/048673.html
>
>On Tue, 19 Sep 2017 at 15:59 Michael Kuhn  wrote:
>
>> Hi Dimitris
>>
>> According to https://koha-community.org/download-koha/ Debian
>GNU/Linux
>> 9 (Stretch) is not supported.
>>
>> Koha has its own problems with Ubuntu 16.04 (see the link given by
>Zeno:
>> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages ).
>> However it is said that "16.04 LTS is based on Debian stretch/SID".
>As
>> someone said, in fact Ubuntu doesn't follow the official Debian
>> releases. They just take whatever they need from the full archive.
>>
>> 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 <+41%2061%20261%2055%2061> · E
>m...@adminkuhn.ch ·
>> W www.adminkuhn.ch
>>
>>
>>
>> Am 19.09.2017 um 18:44 schrieb Dimitris Antonakis:
>> > I encountered the same error at a Debian stretch.server.Software
>error:
>> >
>> > DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '15-24'
>for
>> > key 'PRIMARY' at /usr/share/koha/lib/Koha/SearchField.pm line 38
>> >
>> >
>> > Distributor ID: Debian
>> > Description:Debian GNU/Linux 9.1 (stretch)
>> > Release:9.1
>> > Codename:   stretch
>> >
>> > On Mon, Mar 13, 2017 at 11:07 AM Zeno Tajoli 
>wrote:
>> >
>> >> Hi,
>> >>
>> >>> Hello,
>> >>> I am installing Koha on Ubuntu 16 and I have managed to go
>through
>> >>> everything until on *stage 3* where after selecting *mandatory*
>and
>> >>> *optional options* I get a *software error*.
>> >>
>> >> install Koha on Ubuntu 16 is problematic.
>> >> See:
>> >>
>> >>
>>
>https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7
>> >>
>> >> Bye
>> >> ___
>> >> 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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Translating string at Koha manual 16.11

[Chris Cormack]

Well the English manual for 16.11 is generated from docbook XML.
So you probably will want to maintain a fork for your translated 16.11 version.

Work is being done on 17.11 which is master, and in sphinx.

In short we won't be pushing patches for 16.11

Chris 

On 19 September 2017 6:32:26 PM NZST, Zeno Tajoli  wrote:
>Hi Chris and all,
>
>>Check out an earlier commit if you want. The HTML was generated from
>the docbook XML, and will not be regenerated from sphinx. 
>>Bearing in mind no one is working on the 16.11 manual. 
>>As with the code you should work on master. 
>
>in fact for me translations are more relevant that english version and
>16.11 translations are
>based on sphinx version like those:
>
>http://translate.koha-community.org/manual/16.11/it/html/index.html
>http://translate.koha-community.org/manual/16.11/fr/html/index.html
>
>If I send patches about 16.11, will be updted .po files in
>http://translate.koha-community.org/projects/man1611/ ?
>
>After i will send patches for 17.05 and master.
>
>Bye
>Zeno Tajoli
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Translating string at Koha manual 16.11

[Chris Cormack]

Check out an earlier commit if you want. The HTML was generated from the 
docbook XML, and will not be regenerated from sphinx. 

Bearing in mind no one is working on the 16.11 manual.

As with the code you should work on master.

Chris 

On 19 September 2017 6:01:50 PM NZST, Zeno Tajoli  wrote:
>Hi Katrin and all,
>
>>16.05 and 16.11 manual translations are not generated from .rst, but
>are 
>>still using DocBook. Translations for 17.05 and 17.11 are not
>available yet.
>
>but in git archive of 16.11 manual there only .rst files:
>http://git.koha-community.org/gitweb/?p=kohadocs.git;a=tree;h=refs/heads/manual16.11.x
>
>I can send patches only about them
>
>Bye
>Zeno Tajoli
>___
>Koha mailing list  http://koha-community.org
>Koha@lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Checked out status not showing in OPAC results list

[Chris Cormack]

Hi Tim

Is Zebra indexing correctly in the background? The search results come
from zebra, the detail page directly from the db.
So the reindexer would be my suspect

Chris

On 30 August 2017 at 11:20, Tim McMahon  wrote:
> Our OPAC is not showing that items are checked out in the search results
> list.  If you click on a record, it will show the correct status.  We just
> upgraded to 15.05.02 last Friday on a Debian 8 package install.
>
> --
> Tim McMahon
> Technical Services
> West Liberty Public Library
> ___
> 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] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

[Chris Cormack]

* Indranil Das Gupta (indr...@gmail.com) wrote:

Hi

On Fri, Aug 11, 2017 at 1:04 AM, Chris Cormack <chr...@catalyst.net.nz> wrote:


So move it off the site and make it 'the community managed list'. Or some other 
name. But make it its own thing clearly maintained by volunteers, not part of 
the main site and in no way official at all.


Anything on *.koha-community.org will be deemed "official" ;-)


Yep, right off that url is what I meant.

Because I see the list as something that works against small companies,
rather than for them. As your experience would attest Indranil.
Not being on the list is used as a weapon against companies. 
So pretty much the exact opposite viewpoint to Brooke.


I see the list as just one more obstacle in a dev/vendor being able to
offer Koha support, rather than a help. Especially if as we are talking
about is making it harder to get listed. 


This will be my last email on it, and I will be talking to my colleagues
about having our name removed, and I hope the whole list and all the
problems it causes for new developers goes away.

Chris



indranil


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

[Chris Cormack]

Hi All 

A proposal, for voting on. 
1/ make the listing criteria more stringent + move the list off the main site 
to its own thing. 

Or we just make it more official and increase all the problems. 

So move it off the site and make it 'the community managed list'. Or some other 
name. But make it its own thing clearly maintained by volunteers, not part of 
the main site and in no way official at all. 

Chris 

On 11 August 2017 3:26:44 AM NZST, Jonathan Druart 
 wrote:
>Vinod,
>
>This already exists and is auto-generated for each release.
>For 17.05, https://koha-community.org/koha-17-05-released
>But, as said previously by others, 1 != 1 and there are much more than
>just
>writing patches in a community daily tasks.
>
>Regards,
>Jonathan
>
>On Thu, 10 Aug 2017 at 07:15 vinod mishra  wrote:
>
>> I think we can make a parameter like the company who have submitted
>at
>> least five patch/new code for major active release oldoldstable,
>oldstable
>> and stable will be only listed. For example if a company has five
>> code/patch in 16.5 than he may be listed continuously up-to 17.5 once
>17.11
>> will release and there is no contribution in 16.11 than they may be
>delist.
>>
>> Above is only one parameter but someone have to monitor this
>continuously
>> to update the list, however range of version can be increased, by
>doing so
>> they will be encouraged to contribute continuously if they do not
>want to
>> die from list.
>>
>>
>> With Regards,
>>
>> Vinod Kumar Mishra,
>> Assistant Librarian,
>> Biju Patnaik Central Library (BPCL),
>> NIT Rourkela,
>> Sundergadh-769008,
>> Odisha,
>> India.
>> Mob:91+9439420860
>> Website: http://mishravk.com/
>> ORCID ID: http://orcid.org/-0003-4666-7874
>>
>> *"Spiritual relationship is far more precious than physical. Physical
>> relationship divorced from spiritual is body without soul" -- Mahatma
>> Gandhi*
>>
>> On Wed, Aug 9, 2017 at 8:47 PM, Mark Tompsett 
>> wrote:
>>
>> > Greetings,
>> >
>> > Nathan A. Curulla suggested:
>> > > Maybe we should change the listing to “contributing support
>companies”
>> or
>> > > something like that.
>> >
>> > While I think that is a good idea, and then companies without
>community
>> > participation get removed, the problem still remains: people don't
>read.
>> > We've put a nice disclaimer that this is not an official list and
>has no
>> > official seal of approval meaning to the list, and yet people still
>use
>> it
>> > that way. It is impossible to educate people who refuse to read,
>even
>> > though
>> > the preamble write up is a rather good explanation of how to look
>for a
>> > Koha
>> > support provider. As such, the only reasonable course of action is
>to
>> > delete
>> > the list, otherwise it will continue to be used that way, no matter
>what
>> we
>> > put on the page(s).
>> >
>> >
>> > Owen Leonard wrote:
>> > > It would be a duplicate listing ... and should be rejected.
>> >
>> > Who determines it is a duplicate listing? Because last time I
>looked some
>> > other entries looked like duplicates to me, much like OpenLX/BBB.
>And
>> > cleaning up duplicates is a pain. Yet another reason to just delete
>the
>> > list
>> > already.
>> >
>> > GPML,
>> > Mark Tompsett
>> >
>> > ___
>> > 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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

[Chris Cormack]

* BWS Johnson (abesottedphoe...@yahoo.com) wrote:

Kia ora!
 I still hold the firm opinion that deleting the list is a cop out. The 
listing is one of the best ways that new Libraries find support if they are 
reluctant to do things themselves. Folks might want to think about linking Hea 
to this page so that people that are considering Koha can find like minded 
institutions nearby. It would be awesome if there were some way for existing 
libraries to signal that they are open to providing feedback about vendors.


I think in that case, someone else could volunteer (yourself perhaps)
to take this 'cop out' off the people who currently have to deal with
the multiple offlist emails about it. And maintain the list, maybe on the wiki
where it can be done by anyone.



 The suggested name change might help, and I would support that. I would 
also support removing any spammers.
 I feel strongly that Liz improved on the old list substantially.

 It is very easy for companies that are now happily established to want to 
scrap this list. That action punishes startups and the optics are trash. 
Pulling the ladder up after yourself is not attractive.


I find this remark quite offensive. Just FYI. In case you didn't intend
it to be.

Chris


Cheers,Brooke
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Spam from BestBookBuddies (OpenLX)

[Chris Cormack]

Just a quick note, unsolicited emails, or spam as it is commonly known is 
indeed a crime in some jurisdictions. And in almost every one it is against 
convention. 

I'm not going to respond to the rest of your email which reads as a personal 
fight between you and other Indian Koha developers/companies. Please leave this 
kind of email off the list in future. 

And if you plan to continue to send unsolicited emails to people then I think 
the request to remove the listing should stand 

Chris 

On 9 August 2017 5:58:37 AM NZST, "Sudhir Gandotra @ Kalculate" 
 wrote:
>Dear Jonathan Druart,
>
>I am rather surprised to note this mail.
>
>The only mail that I see from you to me was as below :
>
>=
>Jonathan Druart 
>May 17
>to koha
>Dear Sudhir Gandotra,
>
>You are receiving this email because you are listed as a paid support
>company on the Koha community website (https://koha-community.org/su
>pport/paid-support).
>
>We are updating the list of paid support companies for Koha on our
>community website. Please, after reading this email, either hit reply
>or
>complete the form mentioned below to confirm you are still an active
>support company.
>
>The next development cycle of Koha (17.11) is going to start before the
>month of May is out.
>Over the next 6 months we will be building the latest, even more
>awesome,
>release of Koha.  We strongly believe that having everybody involved is
>fundamental to achieving this.
>
>We want to build a task force and for that, we need to know who can
>commit
>time and effort that we can count on, in order to estimate the goals we
>can
>reach.
>Even if you have never been involved in the Koha community but are
>using
>Koha, you can help us by committing just a few hours each month:
>library workers or support companies can contribute massively by
>providing
>feedback, testing patches, contributing to the documentation or by
>getting
>involved in other specific tasks. Even if you do not know how to code
>you
>can help shape the next release and improve Koha.
>If you want to help, or if you have specific requests for this release,
>please let us know by completing this form:
>
> > https://framaforms.org/ready-to-help-the-koha-community-1493918217 <
>
>Just a couple of hours per month dedicated to the project is a huge
>help!
>
>Best regards,
>Jonathan Druart on behalf of the Koha community
>
>=
>
>I have not replied to it, as I am usually been travelling extensively
>for
>the last 12 months, but, within our team, we are discussing as to how
>we
>can take this forward and start contributing to the Koha community in
>future, starting in next few months.
>
>*On the other hand, I would like to share the following with you :*
>
>As duly acknowledged by the Koha community here, we are the entity
>(then
>known as Indserve Infotech Pvt. Ltd.) that introduced Koha in India
>with
>the first commercially done Koha implementation at Delhi Pubic Library,
>in
>2007-08, for which I can show you the formal purchase order also.
>Its another story that our trainee-engineer, who was trained by us on
>this
>project, left us, cheated us, took away the clients we were negotiating
>and
>harmed our work seriously, went to another company and is active on
>Koha
>even now.
>We were forced to lie low for a while (due to illegal actions of a
>large
>MNC against us) and restarted our activities in a big way again in
>2010,
>and after creating over 165 clients across 15 countries, have now taken
>Koha to new level, whereby we are offering the complete services free
>of
>cost and this is taking us places.
>
>The amount of publicity, growth and expansion that we have done with
>Koha
>is tremendous when you see the number of clients, the spread of these
>clients, and their support to us because of un-breaking services.
>
>I am aware that people like Vinod Mishra and some others are quiet
>jealous
>of us and now with these free services, they are, possibly, afraid of
>losing their business. And, because of this, they find all kinds of
>excuses
>of speaking against us with clients and here also on the list.
>
>I see no reason for deleting our name, because, caused by such negative
>people, it will only give bad name to the whole of community, a cause
>to
>which we have given our full support form the very beginning. And,
>moreover, we have done nothing against Koha. Rather, with the number of
>libraries to our credit, we are among the biggest providers of Koha
>services.
>
>To promote our services, we do send mails to libraries and in that
>process,
>the mail went to mycpl.org also. Owen Leonard felt bad about it, wrote
>to
>me, and I replied to him with my apologies, as our intentions have
>solely
>been to promote Koha. However, there is no law or convention that says
>that
>a Koha service provider cannot send promotional mails to libraries.
>Please

Re: [Koha] How are authority records connected with biblio records ?

[Chris Cormack]

* David Holoshka (david.holos...@ub.lu.se) wrote:

Hi,

I am migrating several million records from an existing vtls system to 
koha.  We are using mariadb, koha 17.05 (have pulled from master 
yesterday ), elastic search 5.4 and plack on debian systems.  As I 
wanted to preserve all the authority to biblio record links  I wrote 
my own migration script based on the relevant koha source.


Hi David

Did you really mean master, or did you pull from the 17.05.x branch?
If you meant master you aren't running 17.05 but the unreleased code
that will be 17.11.0 eventually.

The ES authority support is still a work in progress.

Chris



Searching in the koha authorities intra will find the authority record 
but usually lists the number of biblio records having the auth as 
zero, but not always.  If I check the biblio index in ES the items 
have the correct auth id in the "an" field.  I can find no difference 
between the biblio records in the ES index that are reported as linked 
to the auth record to the ones that are not.  I connect the biblio 
recs to the authorities in the marc21 structure by putting the  koha 
auth id in field 100 sub field 9 (if it is a name auth).  These marc 
records are now in the new biblio_metadata table.



How does koha find the biblio records connected to a paticular auth 
record ?


Is this done dynamically by searching the ES indexes ?


Is this an issue with the zebra database?  Is it still required ?  I 
haven't been loading data into it since we switched to ES.


Best Regards,

Dave

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


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] checkin problem

[Chris Cormack]

* Sahadeo Taware (sahadeo.taw...@gmail.com) wrote:

Dear Friends

When I  checkin the book following error is shown

Check in message

The item has not been checked in due to a configuration issue in your
system. You must ask an administrator to take a look at the about page
<http://192.168.35.196:8080/cgi-bin/koha/about.pl#sysinfo> and search for
the "data problems" section


Hi Sahadeo

If you go to that page it will tell you what the problem is.
To fix it you need to get into the database and update some rows in the
issues table, so they no longer have the same id as the ones in the
old_issues table.

Then if you follow the instructions to set up the mysql config, that
will stop this happening again.

Chris
--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

[Chris Cormack]

* gevos (gelinger...@yandex.com) wrote:

Overyesterday We have updated ubuntu server and the koha was updated too.
Apparently because of the mysql 5.7 the script somehow failed and we have
landed to a point where only from 30.000 books only 2 books landed to the
book_metadata.  and we don't have  now the original column marcxml in
biblioitems  :(


All you can do is restore from your backup I am afraid

Chris




--
View this message in context: 
http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Fwd: Regarding error in circulation module

[Chris Cormack]

-- Forwarded message --
From: "Mamta Arora" 
Date: 20/07/2017 5:08 PM
Subject: Regarding error in circulation module
To: 
Cc:

Respected Sir/ Ma'am

Greetings

We are the user of Koha 3.18.03.000 version approximately 11 clients in
different departments in our university campus here we are facing problem
of issued books I mean one client can't issued books to other department
patron due to this  other department can't issued books but  we can issue
books to our department which patron are enter by client . even before this
never happened these type of problems.

error
patron is not matched.

-- 






*Thanks with RegardsMamta Rani LibrarianChitkara College Pharmacy*
*Chitkara University, PUNJAB*
*Patiala Chandigarh National Highway*
*Rajpura 140401*


* "When all says its difficult you think its for you"*

[image: logo]

Punjab Campus
Chandigarh - Patiala National Highway, (NH-64)
Tehsil: Rajpura-140401, Distt. : Patiala.
Phone: 01762-507084

Administrative Office
Saraswati Kendra, SCO 160-161
Sector 9 C, Chandigarh - 160009
India.
Mobile: +919463209646 <+91%2094632%2009646>
Phone : 01762-507084
Ext. 508

www.chitkara.edu.in
http://library.chitkara.edu.in/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha