[Koha] MarcEdit / Koha Set-up

[Shell, Lezlie]

Thank you, David, for the great information.  I'm passing it on to the person helping me.

Fingers crossed!

Lezlie

-----Original Message-----
From: David Cook [mailto:dcook at prosentient.com.au] 
Sent: Wednesday, December 9, 2015 6:56 PM
To: koha at lists.katipo.co.nz
Cc: Shell, Lezlie <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