[Koha] Routing with a FQDN

[Mubassir Ahsan]

Dear Dave Jury,
You can overcome this situation by assigning another subdomain for the
staff client. i.e. koha.peterhouse.co.zw and opac.peterhouse.co.zw
So 80 port will be shared. You don't need to use 81 port.


On Tue, Mar 21, 2017 at 10:29 PM <koha-request at lists.katipo.co.nz> wrote:

> Send Koha mailing list submissions to
>         koha at 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-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
>         koha-owner at 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: Facebook, twitter and other icons (Jonathan Druart)
>    2. Routing with a FQDN (Contact Orielstar)
>    3. Re: Koha 16.05 - Change MARC framework globally on batch of
>       records? (Joy Nelson)
>    4. Re: Facebook, twitter and other icons (Owen Leonard)
>    5. Re: Facebook, twitter and other icons (Owen Leonard)
>    6. Re: Facebook, twitter and other icons (Owen Leonard)
>    7. Re: Routing with a FQDN (Doug Dearden)
>
>
>
> ---------- Forwarded message ----------
> From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
> To: Luis Moises Rojas <lmoisesrojas at gmail.com>, koha at lists.katipo.co.nz
> Cc:
> Bcc:
> Date: Tue, 21 Mar 2017 14:27:29 +0000
> Subject: Re: [Koha] Facebook, twitter and other icons
> Turn on pref SocialNetworks.
>
> On Tue, 21 Mar 2017 at 11:16 Luis Moises Rojas <lmoisesrojas at gmail.com>
> wrote:
>
> > Hi,
> > How can we insert facebook, twitter, whatsapp and others icons in our
> OPAC?
> >
> > Thanks
> >
> > --
> > *Luis Moisés Rojas P.*
> >
> >
> > <
> >
> https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail
> > >
> > Libre
> > de virus. www.avast.com
> > <
> >
> https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail
> > >
> > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
>
> ---------- Forwarded message ----------
> From: Contact Orielstar <contact at orielstar.com>
> To: Koha at lists.katipo.co.nz
> Cc:
> Bcc:
> Date: Tue, 21 Mar 2017 16:47:55 +0200
> Subject: [Koha] Routing with a FQDN
> Hi Folks,
>
> Are there any networking guru's out there than can help us with routing,
> please? We have Koha installed in a school running a cyberoam (which is
> basically a big router). We have a domain (.peterhouse.co.zw), and we
> would like users on the WAN (Internet) to be able to access Koha from
> home by using *koha.peterhouse.co.zw*, and not have to add a colon and a
> port number. So how can we set this up so that instead of just mapping
> the koha bit to an ip address, we map it to the ip address:81?
>
> We have tried setting up a virtual host on the cyberoam, but it's not
> working as it says port 80 (external) is already mapped. Well, all
> requests from the internet are going to come on port 80, so the mail
> server is mapped to this as well. So we've missed something very
> fundamental.... if they type mail.peterhouse.co.zw then the request
> should go to 10.10.10.5. If they type koha.peterhouse.co.zw then the
> request should go to 10.10.10.6*:81*. I can't see any way on our
> cyberoam to map an address to an ip/port, just to an ip only.
>
> Any ideas you have would be most welcome. Even if you haven't got a
> cyberoam, how have you all done external routing on your installations?
>
> Thanks for your help, and regards,
> --
>
> Dave Jury
>
>
>
> rielstar
> Business Solutions
>
>
>
> Marondera Branch:
> 10A Tipperary
> Marondera
> Phone 0773 247 121
>
>
>
>
>
> ---------- Forwarded message ----------
> From: Joy Nelson <joy at bywatersolutions.com>
> To: Craig Butosi <craig.butosi at rcmusic.ca>
> Cc: Koha <koha at lists.katipo.co.nz>
> Bcc:
> Date: Tue, 21 Mar 2017 15:58:40 +0100
> Subject: Re: [Koha] Koha 16.05 - Change MARC framework globally on batch
> of records?
> Craig-
> The 'bad' records reported would indicate corrupted marc records.
> ModBiblio will return 1 on success and 0 for no success.  The goodcount is
> incremented when ModBiblio is successful with an update and the badcount is
> updated when not successful.
>
> Thanks
> -Joy
>
> On Tue, Mar 21, 2017 at 3:25 PM, Craig Butosi <craig.butosi at rcmusic.ca>
> wrote:
>
> > Hi everyone,
> >
> > Thanks to everyone who replied. This is exactly what I was looking for.
> > I've tested <UPDATE biblio SET frameworkcode="XX" WHERE biblionumber =
> 'X';
> > > , opened the record, saw the framework had changed, then saved it, so
> the
> > query seems to work fine on at least one record. Thanks Michael.
> >
> > > or use the touch_all_biblios.pl script
> >
> > Joy, are there any major risks involved in running this (very useful!)
> > script? (There's always a risk, I know.) Looking at the output, the
> script
> > reports:
> >
> > Good: X, Bad: Y (of Z) in T seconds
> > Accuracy:  N%
> > Average time per record: T seconds
> >
> > What would constitute a record going 'bad', say?
> >
> > All best,
> >
> > Craig Butosi, MA, MLIS, B Mus (Hons.)
> > LIBRARY SERVICES MANAGER
> > THE ROYAL CONSERVATORY
> > TELUS Centre for Performance and Learning
> > 273 Bloor Street West
> > Toronto, ON M5S 1W2
> > 416.408.2824 x338
> > www.rcmusic.ca
> >
> > -----Original Message-----
> > From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Joy
> > Nelson
> > Sent: March-21-17 8:18 AM
> > To: mik at adminkuhn.ch
> > Cc: Koha
> > Subject: Re: [Koha] Koha 16.05 - Change MARC framework globally on batch
> > of records?
> >
> > You can update the biblio table with the new framework, but any
> > differences between the old and new frameworks will not be represented in
> > the bibliographic record until you save that record in Koha (or use the
> > touch_all_biblios.pl script)
> >
> > joy
> >
> > On Tue, Mar 21, 2017 at 12:51 PM, Michael Kuhn <mik at adminkuhn.ch> wrote:
> >
> > > Hi Craig
> > >
> > > Katrin wrote:
> > >
> > > it looks like the framework is stored in frameworkcode in the table
> > >> biblio. It should be possible to change it with SQL as I think it
> > >> doesn't get mapped to a MARC field at the moment.
> > >>
> > >
> > > Such an SQL statement would look like
> > >
> > > UPDATE biblio SET frameworkcode="XX"
> > >
> > > where XX is a frameworkcode that must exist in table
> "biblio_framework".
> > > Since the above statement would change the framework of ALL records to
> > "XX"
> > > it may be necessary to use some WHERE clause like
> > >
> > > UPDATE biblio SET frameworkcode="XX" WHERE biblionumber > 100000
> > >
> > > or maybe
> > >
> > > UPDATE biblio SET frameworkcode="XX" WHERE frameworkcode NOT IN ("XX",
> > > "FA")
> > >
> > > Before applying such a change I would recommend to backup the
> > > database, of course.
> > >
> > > 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
> mik at adminkuhn.ch · W
> > > www.adminkuhn.ch _______________________________________________
> > > Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> > > https://lists.katipo.co.nz/mailman/listinfo/koha
> > >
> >
> >
> >
> > --
> > Joy Nelson
> > Director of Migrations
> >
> > ByWater Solutions <http://bywatersolutions.com> Support and Consulting
> > for Open Source Software
> > Office: Fort Worth, TX
> > Phone/Fax (888)900-8944
> > What is Koha? <http://bywatersolutions.com/what-is-koha/>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> > Note: This email message and any attachments are intended only for the
> use
> > of the individual to which it is addressed, and may contain information
> > that is privileged, confidential and exempt from disclosure under
> > applicable law. If the recipient of this email is not the intended
> > recipient (or the employee or agent responsible for delivering the email
> to
> > the intended recipient), you are hereby notified that any review,
> > dissemination, distribution or copying or other use of this message is
> > strictly prohibited. If you have received this communication in error,
> > please notify the sender immediately by return email and delete this
> > message and attachments from your system, thank you.
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
> --
> Joy Nelson
> Director of Migrations
>
> ByWater Solutions <http://bywatersolutions.com>
> Support and Consulting for Open Source Software
> Office: Fort Worth, TX
> Phone/Fax (888)900-8944
> What is Koha? <http://bywatersolutions.com/what-is-koha/>
>
>
>
>
> ---------- Forwarded message ----------
> From: Owen Leonard <oleonard at myacpl.org>
> To: koha <koha at lists.katipo.co.nz>
> Cc:
> Bcc:
> Date: Tue, 21 Mar 2017 11:10:07 -0400
> Subject: Re: [Koha] Facebook, twitter and other icons
> > Turn on pref SocialNetworks.
>
> To be specific: This will give you icons for Facebook, LinkedIn,
> Delicious (does anyone use that anymore?), Google+, and Twitter on the
> bibliographic detail page in the OPAC.
>
> I'm curious what you would expect a WhatsApp icon to do?
>
>   -- Owen
>
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
>
>
>
>
> ---------- Forwarded message ----------
> From: Owen Leonard <oleonard at myacpl.org>
> To: koha <koha at lists.katipo.co.nz>
> Cc:
> Bcc:
> Date: Tue, 21 Mar 2017 11:14:56 -0400
> Subject: Re: [Koha] Facebook, twitter and other icons
> Please reply to the mailing list so that others can participate in the
> conversation.
>
> > thanks, but where it is?
>
> The  SocialNetworks system preference can be found under
> Administration -> System preferences -> OPAC preferences.
>
> The links themselves are on this page in the OPAC:
>
>
> https://catalog.bywatersolutions.com/cgi-bin/koha/opac-detail.pl?biblionumber=41393
>
> -- Owen
>
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
>
>
>
>
> ---------- Forwarded message ----------
> From: Owen Leonard <oleonard at myacpl.org>
> To: koha <koha at lists.katipo.co.nz>
> Cc:
> Bcc:
> Date: Tue, 21 Mar 2017 11:28:05 -0400
> Subject: Re: [Koha] Facebook, twitter and other icons
> Please reply to the mailing list so that others can participate in the
> conversation.
>
> > Now, how to we change the display?
> > I mean: to display (same color, etc) on our OPAC?
>
> I don't know what you mean, can you explain?
>
> Can you please share what you would like a WhatsApp button to do? Is
> this a feature you have seen somewhere else?
>
>   -- Owen
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
>
>
>
>
> ---------- Forwarded message ----------
> From: Doug Dearden <dearden at sarsf.org>
> To: "'Contact Orielstar'" <contact at orielstar.com>, "
> Koha at lists.katipo.co.nz" <Koha at lists.katipo.co.nz>
> Cc:
> Bcc:
> Date: Tue, 21 Mar 2017 16:29:13 +0000
> Subject: Re: [Koha] Routing with a FQDN
>
> Hi Dave,
>
> It sounds to me like you are trying to do this through a single public IP
> address.  We do this by paying for a range of IP addresses, then use a
> mapped IP function in our firewall to map incoming requests from an
> external address to an internal address.  It is similar to the virtual host
> idea, but not sharing an IP address and therefore the port can be 80.
>
> I think you will have better luck figuring this out by going to Cyberoam
> support.
>
> Doug
>
> -----Original Message-----
> From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Contact
> Orielstar
> Sent: Tuesday, March 21, 2017 8:48 AM
> To: Koha at lists.katipo.co.nz
> Subject: [Koha] Routing with a FQDN
>
> Hi Folks,
>
> Are there any networking guru's out there than can help us with routing,
> please? We have Koha installed in a school running a cyberoam (which is
> basically a big router). We have a domain (.peterhouse.co.zw), and we
> would like users on the WAN (Internet) to be able to access Koha from
> home by using *koha.peterhouse.co.zw*, and not have to add a colon and a
> port number. So how can we set this up so that instead of just mapping
> the koha bit to an ip address, we map it to the ip address:81?
>
> We have tried setting up a virtual host on the cyberoam, but it's not
> working as it says port 80 (external) is already mapped. Well, all
> requests from the internet are going to come on port 80, so the mail
> server is mapped to this as well. So we've missed something very
> fundamental.... if they type mail.peterhouse.co.zw then the request
> should go to 10.10.10.5. If they type koha.peterhouse.co.zw then the
> request should go to 10.10.10.6*:81*. I can't see any way on our
> cyberoam to map an address to an ip/port, just to an ip only.
>
> Any ideas you have would be most welcome. Even if you haven't got a
> cyberoam, how have you all done external routing on your installations?
>
> Thanks for your help, and regards,
> --
>
> Dave Jury
>
>
>
> rielstar
> Business Solutions
>
>
>
> Marondera Branch:
> 10A Tipperary
> Marondera
> Phone 0773 247 121
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 

*Best wishes.*
*--------------------*
*Md. Mubassir Ahsan*
*-----------------------------*
*Mobile+Viber+IMO: 01916303060*
*Facebook:* mmahsan <http://facebook.com/mmahsan>
*Skype+Twitter*: mahsandu
Website: Mubassir.info
*"Proud to be a LIS Professional*"
*Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
Greenstone), N/W Admin, DBA.*