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

[David Cook]

Hi once again:

I just remembered that the official TCP port for ANSI Z39.50  is 210. You might also notice some Z39.50 servers are available on port 7090. 

If you're running a public Z39.50 server, you will probably want to change the username and password for your Z39.50 server as well. By default, you connect using anonymous read-only access, but it would be trivial for someone to look at the Koha source code to read the defaults and use those to get write-access to your Zebra server...

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 12:03 PM
> 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 (follow-up)
> 
> 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