[Koha] MarcEdit / Koha Set-up (follow-up)

[David Cook]

Hi again:

I also noticed that you'll want to set the syntax for the Z39.50 to "MARC21". I like working with MARCXML, but MarcEdit apparently can't handle that option, at least as of MarcEdit 6.0.5532.39684 from 23/02/2015.

With that option, I'm now able to search Koha's Z39.50 server Zebra using MarcEdit, and update the records I find : ).

David Cook
Systems Librarian
Prosentient Systems
72/330 Wattle St, Ultimo, NSW 2007


> -----Original Message-----
> From: David Cook [mailto:dcook at prosentient.com.au]
> Sent: Thursday, 10 December 2015 11:56 AM
> To: 'koha at lists.katipo.co.nz' <koha at lists.katipo.co.nz>
> Cc: 'Lezlie.Shell at contractor.cengage.com'
> <Lezlie.Shell at contractor.cengage.com>
> Subject: RE: MarcEdit / Koha Set-up
> 
> Hi Lezlie:
> 
> I failed to set up the MarcEdit-Koha integration a long time ago, but your
> email has prompted me to try again...
> 
> I filled in the ILS details, and I'm able to create/update records in Koha.
> However, I'm also having difficulties setting up the Z39.50 searching.
> 
> Here are the steps I took:
> * I uncommented the "publicserver" sections, leaving the defaults
> untouched, and restarted the Zebra server.
> 
> I tested the connection using the Z39.50 tools that come bundled with Koha:
> 
> On the Koha/Zebra server, I was able to connect to Zebra using "yaz-client
> tcp:XXX.XXX.X.XX:9998/biblios" and " yaz-client tcp:localhost:9998/biblios"
> (where XXX.XXX.X.XX is a private IP address on the network).
> 
> However, when I tried to connect to Zebra using "yaz-client
> tcp:XXX.XXX.X.XX:9998/biblios" from another server, my desktop, or
> MarcEdit, the connection timed out every time.
> 
> I looked at the server firewall and it looked like it should've accepted the
> connection, so I'm guessing there might be an issue at the router level.
> 
> The network admin is currently in a meeting, so I decided to play around with
> the port numbers a bit... and I found success with port 3000, which isn't
> officially assigned to anything else (see
> https://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers).
> 
> I chose port 3000 somewhat at random, and then I ran 'netstat -ln  | grep
> "3000"' on the server to make sure that nothing else on the server was using
> that port. I changed the configuration in koha-conf.xml, restarted Zebra, and
> I was able to connect from my Desktop "yaz-client" and in MarcEdit.
> 
> --
> 
> My question to you would be: where is the Koha server that you're trying to
> reach in relation to your computer running MarcEdit? I'm on the same wired
> LAN as my server, so I'm able to connect using a private network IP address.
> Are you on the same LAN or trying to connect over the Internet or...?
> 
> I'm also curious about how you installed Koha... If you're seeing
> ZEBRA_SRU_HOST and ZEBRA_SRU_BIBLIOS_PORT, it would seem that
> you're looking at Koha source code rather than an installed Koha. "localhost"
> and "8081" would be fine in those cases, so long as port 8081 on that server is
> reachable by outside computers. In my case, I couldn't use port 8080, as
> something else on the server was already listening on that port.
> 
> You might find the following links helpful:
> http://www.indexdata.com/yaz/doc/installation.win32.html
> http://ftp.indexdata.com/pub/yaz/win32/
> 
> While I run Koha on Linux, I use Windows for my desktop work station. I use
> yaz-client a lot on the server to diagnose issues with Z39.50 searching, but in
> this case where you want to connect using TCP rather than via a unix socket
> on the server itself, it could be helpful to download YAZ and use yaz-
> client.exe to diagnose your connection woes (as well as troubleshooting
> Zebra in the future).
> 
> Sorry if this email has too much or not enough information. I take a special
> interest in Zebra with Koha, so feel free to send more Zebra/Z39.50 queries
> my way : ).
> 
> David Cook
> Systems Librarian
> Prosentient Systems
> 72/330 Wattle St, Ultimo, NSW 2007
> 
> > -----Original Message-----
> > Date: Wed, 9 Dec 2015 18:20:16 +0000
> > From: "Shell, Lezlie" <Lezlie.Shell at contractor.cengage.com>
> > To: "koha (koha at lists.katipo.co.nz)" <koha at lists.katipo.co.nz>
> > Subject: [Koha] MarcEdit / Koha Set-up
> > Message-ID:
> > 	<BLUPR02MB1746FA7A8E1D50AF0D1B84C5BBE80 at BLUPR02MB1746.
> > namprd02.prod.outlook.com>
> >
> > Content-Type: text/plain; charset="us-ascii"
> >
> > I've been struggling to set-up the Koha integration in MarcEdit.  I
> > searched the mailing list archive and found a useful thread on the
> > need to designate a listen to port.  I passed on the information to
> > the person helping me out, but it still isn't working.
> >
> > This is his description of what he did.   Are we on the right track?
> >
> >
> > >> I just uncommented that listen tag & set the port to 8080.  I also
> > >> uncommented the server/serverinfo sections (which the koha-conf.xml
> > >> file said to do if you uncomment the listen tag).  BUT, I'm not
> > >> sure what it wants the "ZEBRA_SRU_HOST and
> "ZEBRA_SRU_BIBLIOS_PORT"
> > set
> > >> to.  From an example, I think it's just the localhost & a different
> > >> port (I used 8081).>>
> >
> >
> > Thanks,
> > Lezlie