Re: [Koha] 2 koha web and 1 database

[Indranil Das Gupta]

Hi,

On Mon 7 Jan, 2019, 6:46 PM Shafendi,  wrote:

I only know how to install koha and database on 1 server..
>

Multi server + remote DB setups are several order of magnitude more
complex. Given what you mentioned about your current level of comfort, I
would say you might find it useful to work with a koha service provider to
help you out.

That said, many of us here are running multi server setups like the one you
describe. Often with load balancers and round robin DNS factored in to
ensure business continuity.

Search the archives of this list for - "koha on remote db."

Regards
Indranil Das Gupta
L2C2 Technologies.





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

[Koha] 2 koha web and 1 database

[Shafendi]

I have 3 vm and i want to make koha web on 1st and 2nd vm. 3d vm will become
my database. Could anyone help me how to do it.

I only know how to install koha and database on 1 server.. 



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

Re: [Koha] 2 koha web and 1 database

[Sebastian Krieg]

Hello,

I think using the OPAC web instance this should work but using workflows in 
koha with the intranet web instance there are some topics you must think about.

1. only serveral OPAC instances
Theoretical you can use several web instances with one database instance if you 
give every web instance her "own" network port (initial: 8000/8080) in the 
koha-httpd.conf. If you only will more OPAC web instances you can clone your 
web instance, give the clones new network ports (more than 8000, don't forget 
some firewall configs you have a firewall between user and web instance) and 
erase the "intranet" part of the koha-httpd.conf. On the same way you can 
"split" your koha in two web instances (1rst: OPAC with port 8000, 2nd: 
intranet with 8080).

But if you want the same network port for all web instances, then you need a 
load balancing solution in front of your web instances.

2. serveral intranet instances (I hope my description is understandable...)
You can clone your web instance in the same way like in 1. Please consider the 
serveral network ports or the possibility of a load balancing solution.

But in this case you must guarantee that you didn't get corrupt data in your 
database adding or editing biblio records with mor as one intranet web 
instance! 

If you opens the same record from two web instance clients, normally 
mysql/mariadb should lock the record you will edit. Then you should get an 
error, when the second web instance client will edit or save it, But, I'm not 
sure. you must test it.

But if create a new record I don't know if the web instance get an unique id 
from the database beginning adding the data in a new record or if the web 
instance collect the whole record data an save it in one step in the database. 
In booth cases you must test if you get corrupt data or index records.


I hope this answer will help you. Technical it's simple when you don't need a 
load balancer solution. And you must test the access from several Web instances 
to one database!


Sebastian


> Shafendi  hat am 7. Januar 2019 um 14:15 geschrieben:
> 
> 
> I have 3 vm and i want to make koha web on 1st and 2nd vm. 3d vm will become
> my database. Could anyone help me how to do it.
> 
> I only know how to install koha and database on 1 server.. 
> 
> 
> 
> --
> 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

___
mailto:sebastian.kr...@tuz-eisenach.de
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] koha-US meeting invite: Wednesday, January 9th, 2019

[koha-US Secretary]

Date: Wednesday, January 9th, 2019
Time: 10:30 AM - 11:30 AM CST (time converter

)
Location: https://kslib.zoom.us/j/110290143
Agenda:
https://docs.google.com/document/d/1h6iCwyR7iuPjA9bjiZWPUehlUG6r0RYz7XOMf6d31II/edit?usp=sharing

This month we're getting caught up on committee work which means news about
the upcoming conference, development work, the education initiative and
more. As always, there will be time to talk about bugs and issues.

If you have specific topics for the agenda, please send them to
secret...@koha-us.org

Meetings are held via Zoom video conferencing. A microphone and webcam are
recommended but not required. Zoom is available for Windows, Mac, and Linux
on desktops and Android and iOS on mobile devices. For help getting
started, visit: *https://support.zoom.us/hc/en-us/categories/200101697
*

These meetings are free and open to any and all.

Jason Robb
koha-US secretary
secret...@koha-us.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Export bibliographic records

[Elaine Bradtke]

For what it's worth, you can use a similar process for Zotero.
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)


On Sun, Jan 6, 2019 at 5:36 PM Bob Birchall  wrote:

> Hi Peter,
> I think the following was originally written by Chris Cormack, iirc.
> Anyway, I hope it helps:*
>
> End Note*
>
> EndNote software is licensed by Clarivate Analytics and can be purchased
> at https://endnote.com/
>
> To use Koha with Endnote download the record in “RIS” format. Depending
> on how your system is set up, Endnote might automatically import the
> file. Otherwise, you can import your citation by opening Endnote and
> selecting File->Import and then locating your file.
>
>
>
> Bob Birchall
> Calyx
>
> On 7/1/19 12:21 am, Peter Lau wrote:
> > I would like to know how to create a list of reference for those
> > bibliographic records that were saved to "My Cart" like by using
> > bibliogrphic software like EndNote.
> >
> > Thanks and regards,
> >
> > *Peter Lau*
> >
> > Librarian
> >
> > Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk
> >  | Fax: (852) 23384320
> >
> >
> >
> > 2 Tin Wan Hill Road, Tin Wan, Aberdeen
> >
> > *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
> > ___
> > 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] Koha online library book recommendation on OPAC

[Peter Lau]

When users recommending library books by using the online recommendation
form available in OPAC, can the online recommendation be sent to a specific
email for checking and/or with an alert of new recommendation?

Thanks & regards,

*Peter Lau*

Librarian

Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320

 [image:
https://docs.google.com/uc?export=download=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ]

2 Tin Wan Hill Road, Tin Wan, Aberdeen

*YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
___
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 159, Issue 7

[Peter Lau]

Dear Bob,

Thanks and it works fine.

Thanks & regards,
Peter Lau
Librarian
Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320

2 Tin Wan Hill Road, Tin Wan, Aberdeen
YCCECE, Here We Grow Our Future | www.yccece.edu.hk

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
koha-requ...@lists.katipo.co.nz
Sent: Tuesday, 8 January 2019 7:00 AM
To: koha@lists.katipo.co.nz
Subject: Koha Digest, Vol 159, Issue 7

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: Export bibliographic records (Bob Birchall)
   2. Re: 2 different circulation rules against a patron (Bob Birchall)
   3. Re: limiting the record to specific library only. (Sword eightmm)
   4. 2 koha web and 1 database (Shafendi)
   5. Re: 2 koha web and 1 database (Indranil Das Gupta)
   6. Re: 2 koha web and 1 database (Sebastian Krieg)
   7. Re: Export bibliographic records (Elaine Bradtke)
   8. koha-US meeting invite: Wednesday, January 9th, 2019
  (koha-US Secretary)


--

Message: 1
Date: Mon, 7 Jan 2019 12:35:57 +1100
From: Bob Birchall 
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Export bibliographic records
Message-ID: <36cee77b-6c83-6f83-345d-7f2a1be42...@calyx.net.au>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi Peter,
I think the following was originally written by Chris Cormack, iirc.
Anyway, I hope it helps:*

End Note*

EndNote software is licensed by Clarivate Analytics and can be purchased at
https://endnote.com/

To use Koha with Endnote download the record in “RIS” format. Depending on
how your system is set up, Endnote might automatically import the file.
Otherwise, you can import your citation by opening Endnote and selecting
File->Import and then locating your file.



Bob Birchall
Calyx

On 7/1/19 12:21 am, Peter Lau wrote:
> I would like to know how to create a list of reference for those
> bibliographic records that were saved to "My Cart" like by using
> bibliogrphic software like EndNote.
>
> Thanks and regards,
>
> *Peter Lau*
>
> Librarian
>
> Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk
>  | Fax: (852) 23384320
>
>
>
> 2 Tin Wan Hill Road, Tin Wan, Aberdeen
>
> *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
> ___
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha



--

Message: 2
Date: Mon, 7 Jan 2019 13:04:40 +1100
From: Bob Birchall 
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] 2 different circulation rules against a patron
Message-ID: 
Content-Type: text/plain; charset=utf-8; format=flowed

Hi Chee,
I am going to answer 'No, it can't be applied to 18.05', for a few reasons:
- the patch was submitted over three years ago: that is six versions of Koha
ago;
- even if it applies to the code base, it could cause any number of
problems - it has not been tested by project maintainers or subjected to
quality assurance (QA) testing;
- the concept is a bad idea, if you read the discussion in the bug
report: the concept has been rejected by the project's QA Manager no less;
- patches that are not part of Koha have to be re-applied at every
upgrade: if you do this once, you will keep doing it, and create a
maintenance headache for yourself.
The only way in Koha for a user to have two categories is to create two
records for them. That can cause its own problems. Why not just put them in
the category with the most generous circulation rules?
Otherwise, Koha does not support the functionality you are seeking.
I hope this explains,
Bob Birchall
Calyx

On 7/1/19 9:00 am, Chee Hong wrote:
> Hi Michael,
>
> Thanks for your reply.  Is there any problem if I want to apply the
> patch to Koha 18.05? If not, please provide the steps to do so.
> I appreciate that. Thank you.
>
> Best Regards,
> Chee
>
>
> On Sun, Jan 6, 2019 at 10:20 AM Michael Kuhn  wrote:
>
>> Hi Chee
>>
>>   > There is a patch to a bug that has my use case.
>>   >
>>   >
>>
>> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=44762=edit
>>   >
>>   > My question now is this available in Koha 18.05?
>>
>> No, this patch was never pushed to master. The discussion about it
>> ended in 2015. Thus, it is not in Koha 18.05 or any other Koha version.
>>
>> Best wishes: Michael
>> --
>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg.
>> Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 

Re: [Koha] 2 different circulation rules against a patron

[Chee Hong]

Hi Bob,

Thanks for your reply and explanation. I agree with you that it will be a
maintenance nightmare for the upgrade. Personally, I think this is a nice
to have feature. In order to realize my use case, I need to create 2 patron
accounts for users who need to have this special privilege.

Best Regards,
Chee

On Sun, Jan 6, 2019 at 9:05 PM Bob Birchall  wrote:

> Hi Chee,
> I am going to answer 'No, it can't be applied to 18.05', for a few reasons:
> - the patch was submitted over three years ago: that is six versions of
> Koha ago;
> - even if it applies to the code base, it could cause any number of
> problems - it has not been tested by project maintainers or subjected to
> quality assurance (QA) testing;
> - the concept is a bad idea, if you read the discussion in the bug
> report: the concept has been rejected by the project's QA Manager no less;
> - patches that are not part of Koha have to be re-applied at every
> upgrade: if you do this once, you will keep doing it, and create a
> maintenance headache for yourself.
> The only way in Koha for a user to have two categories is to create two
> records for them. That can cause its own problems. Why not just put them
> in the category with the most generous circulation rules?
> Otherwise, Koha does not support the functionality you are seeking.
> I hope this explains,
> Bob Birchall
> Calyx
>
> On 7/1/19 9:00 am, Chee Hong wrote:
> > Hi Michael,
> >
> > Thanks for your reply.  Is there any problem if I want to apply the patch
> > to Koha 18.05? If not, please provide the steps to do so.
> > I appreciate that. Thank you.
> >
> > Best Regards,
> > Chee
> >
> >
> > On Sun, Jan 6, 2019 at 10:20 AM Michael Kuhn  wrote:
> >
> >> Hi Chee
> >>
> >>   > There is a patch to a bug that has my use case.
> >>   >
> >>   >
> >>
> >>
> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=44762=edit
> >>   >
> >>   > My question now is this available in Koha 18.05?
> >>
> >> No, this patch was never pushed to master. The discussion about it ended
> >> in 2015. Thus, it is not in Koha 18.05 or any other Koha version.
> >>
> >> 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
>
> ___
> 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] limiting the record to specific library only.

[Sword eightmm]

Dear All:

Do any body know the solution to this problem.

As I have already shared the details on this thread.

Muhammad Basit Haider.

On Fri, 4 Jan 2019, 14:32 Sword eightmm  Dear Team,
>
> It is requested that an urgent solution is needed for the problem. Please
> can any body let me know that how the book cataloging data can be uploaded
> into a specific library only. For example If one uploads the data onto the
> specific library it must not be searchable in catalogue of the other
> libraries.
> please can anybody provide the solution for that.
>
> Thanking you in anticipation,
> MBH
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_-3033852986816230134_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