Bug 9494

Summary: Library of Congress Z39.50 target seed data outdated
Product: Koha Reporter: Galen Charlton <gmcharlt>
Component: CatalogingAssignee: Galen Charlton <gmcharlt>
Status: CLOSED FIXED QA Contact:
Severity: minor    
Priority: P5 - low CC: bgkriegel, chris, elliott, m.de.rooy
Version: master   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 9520    
Attachments: bug 9494: update default LOC z39.50 target settings
[SIGNED-OFF] bug 9494: update default LOC z39.50 target settings
[Passed QA] bug 9494: update default LOC z39.50 target settings

Description Galen Charlton 2013-01-25 16:21:11 UTC
The default seed data has LC's Z39.50 target as z3950.loc.gov:7090/Voyager. This stopped working today, but regardless of whether or not that is a transitory problem, the target information is out of date.

According to http://www.loc.gov/z3950/lcserver.html#addr, the correct value is lx2.loc.gov:210/LCDB, which goes through LC's public Metaproxy instance. The Internet Archive indicates that that webpage stopped referring to z3950.loc.gov back in 2010.
Comment 1 Galen Charlton 2013-01-25 16:50:47 UTC Comment hidden (obsolete)
Comment 2 Galen Charlton 2013-01-25 16:52:36 UTC
The proposed patch only affects new installations of Koha.  I'm of two minds whether we should update the Z39.50 definition during upgrade, but if we did, the SQL would be something like

UPDATE z3950servers
SET host = 'lx2.loc.gov',
    port = 210,
    db = 'LCDB',
    encoding = 'utf8'
WHERE host = 'z3950.loc.gov'
AND port = 7090
AND db = 'Voyger';
Comment 3 Galen Charlton 2013-01-25 16:53:03 UTC
There was a typo in my SQL, it should be:

UPDATE z3950servers
SET host = 'lx2.loc.gov',
    port = 210,
    db = 'LCDB',
    encoding = 'utf8'
WHERE host = 'z3950.loc.gov'
AND port = 7090
AND db = 'Voyager';
Comment 4 Bernardo Gonzalez Kriegel 2013-01-25 17:11:09 UTC Comment hidden (obsolete)
Comment 5 Galen Charlton 2013-01-25 23:15:39 UTC
For the record, as part of correspondence on this issue, I received the following statement from Ardie Bausenbach of the Library of Congress:

As documented in the Library of Congress Z39.50/SRW/SRU Server
Configuration Guidelines (http://www.loc.gov/z3950/lcserver.html), the
Library recommends that Z39.50/SRU access to the LC Online Catalog use the
gateway found at lx2.loc.gov:210. This server supports access to a number
of LC databases in a manner that helps the Library balance search query
loads more efficiently. The original Z39.50/SRU ports to the LC Online
Catalog remain operative (z3950.loc.gov:7090 for MARC8 and
z3950.loc.gov:7091 for UTF-8). However, LC prefers that queries of the LC
Online Catalog be sent through lx2.loc.gov:210/LCDB (for UTF-8) and
lx2.loc.gov:210:LCDB-MARC8 (for MARC8).
Comment 6 Elliott Davis 2013-01-29 09:26:18 UTC
Created attachment 14912 [details] [review]
[Passed QA] bug 9494: update default LOC z39.50 target settings

This patch updates the seed data from the target list at

Comment: new target works. updated deleting and reloading
sample targets.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Signed-off-by: Elliott Davis <elliott@bywatersolions.com>
I agree with Galen that this may need to be incorproated as a follow-up for current installations
Works fine for new installs
Comment 7 Jared Camins-Esakov 2013-01-31 16:10:39 UTC
This patch has been pushed to master.

A follow-up updating current installations might not be a bad idea.
Comment 8 Bernardo Gonzalez Kriegel 2013-01-31 19:29:11 UTC
Follow-up on Bug 9520
Comment 9 Chris Cormack 2013-02-02 07:11:20 UTC
Pushed to 3.10.x and 3.8.x will be in 3.10.3 and 3.8.10