Routing with a FQDN
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@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-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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@bugs.koha-community.org> To: Luis Moises Rojas <lmoisesrojas@gmail.com>, koha@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@gmail.com> wrote:
Hi, How can we insert facebook, twitter, whatsapp and others icons in our OPAC?
Thanks
-- *Luis Moisés Rojas P.*
<
Libre de virus. 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
---------- Forwarded message ---------- From: Contact Orielstar <contact@orielstar.com> To: Koha@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@bywatersolutions.com> To: Craig Butosi <craig.butosi@rcmusic.ca> Cc: Koha <koha@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@rcmusic.ca> wrote:
Hi everyone,
, opened the record, saw the framework had changed, then saved it, so
Thanks to everyone who replied. This is exactly what I was looking for. I've tested <UPDATE biblio SET frameworkcode="XX" WHERE biblionumber = 'X'; 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@lists.katipo.co.nz] On Behalf Of Joy Nelson Sent: March-21-17 8:18 AM To: mik@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@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@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
-- 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@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@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@myacpl.org> To: koha <koha@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@myacpl.org> To: koha <koha@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?biblionumbe...
-- Owen
-- Web Developer Athens County Public Libraries http://www.myacpl.org
---------- Forwarded message ---------- From: Owen Leonard <oleonard@myacpl.org> To: koha <koha@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@sarsf.org> To: "'Contact Orielstar'" <contact@orielstar.com>, " Koha@lists.katipo.co.nz" <Koha@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@lists.katipo.co.nz] On Behalf Of Contact Orielstar Sent: Tuesday, March 21, 2017 8:48 AM To: Koha@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list Koha@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.*
participants (1)
-
Mubassir Ahsan