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@prosentient.com.au] Sent: Thursday, 10 December 2015 11:56 AM To: 'koha@lists.katipo.co.nz' <koha@lists.katipo.co.nz> Cc: 'Lezlie.Shell@contractor.cengage.com' <Lezlie.Shell@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@contractor.cengage.com> To: "koha (koha@lists.katipo.co.nz)" <koha@lists.katipo.co.nz> Subject: [Koha] MarcEdit / Koha Set-up Message-ID: <BLUPR02MB1746FA7A8E1D50AF0D1B84C5BBE80@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