[OPEN-ILS-DEV] Tsearch2 error, setup instructions
Josh Stompro
stomproj at larl.org
Tue Jun 13 17:56:41 EDT 2006
That seems to have done it, I can now import records with no errors.
Right after I made the changes you outlined I tried it and it didn't
work. I checked what I did and realized that the ownership of those
files was root, so I changed them to opensrf and that did it.
My test catalog won't load any of the records I have imported now
though. I can do a TCN search and it will act like it is trying to load
the record, but nothing comes up.
I think I have correct info in the db now, but I don't really know what
to look for.
demo-dev=# select id,tcn_value,fingerprint,tcn_source from
biblio.record_entry;
id | tcn_value | fingerprint | tcn_source
----+-------------+-------------------------+------------
9 | ocm50014396 | scarmie | OCoLC
10 | ocm45532466 | perdidostreetstationmie | OCoLC
11 | ocm55021977 | citiesfour | OCoLC
I'll play around with it tomorrow and see if I can figure out what is
wrong with searching. Thanks for your help.
Josh
Bill Erickson wrote:
> Ah, I think I know what the issue is. The install script isn't
> copying everything over.
>
> mkdir /openils/var/catalog/
> cp ILS/Open-ILS/src/javascript/backend/catalog/*.js
> /openils/var/catalog/
>
> Then add the following to the <app_settings> chunk in your global
> openils.xml config file for the open-ils.storage app.
>
>
> <script_path>/openils/var/catalog/</script_path>
> <scripts>
> <biblio_fingerprint>biblio_fingerprint.js</biblio_fingerprint>
> </scripts>
>
>
> -bill
>
>
> On 6/12/06, *Josh Stompro* <stomproj at larl.org
> <mailto:stomproj at larl.org>> wrote:
>
> I think I have the correct version installed now, but I am still
> getting the same errors. Is the / Eval failed error from the
> spidermonkey.pm <http://spidermonkey.pm> trying to run some
> javascript code? Is the Fingerprint script the javascript it is
> trying to run. Is there any way I can attempt to run just that
> script on the command line so I can test it out.
>
> [2006-6-5 16:30:3] open-ils.storage [ERR :1115:::] / Eval failed:
> [2006-6-5 16:30:3] open-ils.storage [ERR :1115:::] Fingerprint
> script died!
> [2006-6-5 16:30:3] open-ils.storage [:1115:::] Returning 46
> Fieldmapper nodes from metabib xml
> [2006-6-5 16:30:4] open-ils.storage [ERR :1115:::] Data extraction
> failed for record 7: DBD::Pg::db pg_release failed: ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block
>
> [2006-6-5 16:30:6] open-ils.storage [ERR :1115:::] * ! EXCEPTION ! *
> TYPE: OpenSRF::EX::PANIC
> Mess: System PANIC
> Mess: Couldn't COMMIT transaction!
> Loc.: 146 OpenILS::Application::WoRM
> Loc.: /openils/lib/perl5/OpenILS/Application/WoRM.pm
> Time: Mon Jun 5 16:30:06 2006
>
> [2006-6-5 16:30:6] open-ils.storage [ERR :1115:::] * ! EXCEPTION ! *
> TYPE: OpenSRF::EX::PANIC
> Mess: System PANIC
> Mess: WoRM Couldn't COMMIT transaction!
> Loc.: 153 OpenILS::Application::WoRM
> Loc.: /openils/lib/perl5/OpenILS/Application/WoRM.pm
> Time: Mon Jun 5 16:30:06 2006
>
> (I know that date is way off, my vmware install has clock issues)
> Josh
>
>
> Bill Erickson wrote:
>> Interesting...
>>
>> When I compiled JS::SM with libjs in a non-standard directory,
>> SpiderMonkey.so "remembered" the location of libjs.so even after
>> the intallation. For example, if I ran 'ldd' against
>> SpiderMonkey.so it would show that it knew where libjs.so was.
>>
>> Installling it is certainly the best option.. so i'll update the
>> wiki to suggest that.
>>
>> Does this mean you have JS::SM installed and working? Can you
>> import records?
>>
>> -bill
>>
>>
>> On 6/12/06, *Josh Stompro* <stomproj at larl.org
>> <mailto:stomproj at larl.org> > wrote:
>>
>> Bill, I don't think that the statement on the spidermonkey
>> page that says you don't need to install the libjs libs is
>> correct. Or at least not on debian. When I followed the
>> directions SpiderMonkey.so was created with a dynamic link to
>> libjs.so, which it cannot find unless libjs is copied to a
>> dir in the ldconfig path. Is there a special way to compile
>> it statically?
>> Josh
>>
>>
>>
>> Bill Erickson wrote:
>>> My mistake..
>>>
>>> I updated the wiki page.
>>>
>>> -bill
>>>
>>> On 6/9/06, *Josh Stompro* <stomproj at larl.org
>>> <mailto:stomproj at larl.org>> wrote:
>>>
>>> When I try to build libjs with the command listed on
>>> that page.
>>>
>>> cd mozilla/js/src && make -f Makefile.ref all install
>>>
>>> The library builds ok, but there doesn't seem to be an
>>> install target.
>>> make: *** No rule to make target `install'. Stop.
>>>
>>> I don't see anything about an install target in rules.mk
>>> <http://rules.mk>.
>>> Josh
>>>
>>>
>>>
>>> Bill Erickson wrote:
>>>> Josh,
>>>>
>>>> Here you go :
>>>> http://open-ils.org/dokuwiki/doku.php?id=spidermonkey
>>>>
>>>> Send questions our way...
>>>>
>>>> -bill
>>>>
>>>>
>>>> On 6/2/06, *Josh Stompro* <stomproj at larl.org
>>>> <mailto:stomproj at larl.org>> wrote:
>>>>
>>>> Thank for the response Mike.
>>>>
>>>> I dumped the database and set it back up with the C
>>>> locale and now that
>>>> error is no longer happening, but I am still not
>>>> successful with
>>>> importing a record. The errors I see now in the
>>>>
>>>> [2006-5-29 10:2:53] open-ils.storage [ERR
>>>> :18918:::] / Eval failed:
>>>> [2006-5-29 10:2:53] open-ils.storage [ERR
>>>> :18918:::] Fingerprint script
>>>> died!
>>>> [2006-5-29 10:2:54] open-ils.storage [:18918:::]
>>>> Returning 65
>>>> Fieldmapper nodes
>>>> from metabib xml
>>>> [2006-5-29 10:2:55] open-ils.storage [ERR
>>>> :18918:::] Data extraction
>>>> failed for
>>>> record 5: DBD::Pg::db pg_release failed:
>>>> ERROR: current transaction is
>>>> aborted,
>>>> commands ignored until end of transaction block
>>>>
>>>> I'm not sure how to diagnose this one. I hope
>>>> everyone has a good weekend.
>>>> Josh
>>>>
>>>>
>>>> Mike Rylander wrote:
>>>> > Sorry for the delay...
>>>> >
>>>> > On 5/30/06, Josh Stompro < stomproj at larl.org
>>>> <mailto:stomproj at larl.org>> wrote:
>>>> >> When I try to import a record from oclc I get
>>>> this error.
>>>> >>
>>>> >> [2006-5-28 10:14:20] open-ils.storage [ERR
>>>> :9098:::] Wormization failed
>>>> >> : DBD::Pg::db pg_endcopy failed: ERROR: could
>>>> not find tsearch config
>>>> >> by locale
>>>> >> CONTEXT: COPY full_rec, line 1: "4 LDR
>>>> \N \N \N
>>>> >> 01296cam a2200325 a 4500"
>>>> >>
>>>> >> The problem seems to be that tsearch2 needs some
>>>> setup work done before
>>>> >> it will work with my locale 'en_US'. There is an
>>>> easy way around this
>>>> >> of just running the command.
>>>> >> select set_curcfg('default');
>>>> >
>>>> > That will work fine.
>>>> >
>>>> >> But I don't know if that is the correct way, if
>>>> everything would work if
>>>> >> I just inserted that command before the
>>>> copy. Could someone tell me how
>>>> >> it is setup on the test server? Do I need to
>>>> setup tsearch2 to
>>>> >> recognize 'en_US'?
>>>> >>
>>>> >
>>>> > I actually create the DB in the C locale, since
>>>> the only real sorting
>>>> > we do is case insensitive anyway (sort by title
>>>> for search, sort
>>>> > library names, etc).
>>>> >
>>>> >> One other question, what is
>>>> Wormization? Wikipedia doesn't know that
>>>> >> term, and google thinks that someone by that name
>>>> has a blog. Is it
>>>> >> converting a MARC record to a long string, or
>>>> something like that?
>>>> >>
>>>> >
>>>> > It's a made up word ... and I'm open to
>>>> suggestions. The OpenSRF
>>>> > application that handles indexing of records is
>>>> called the WoRM (for
>>>> > "Write-fired Record Mangler"), and what it does is
>>>> called wormization.
>>>> > ;)
>>>> >
>>>> >> Thanks
>>>> >> Josh
>>>> >>
>>>> >>
>>>> >>
>>>> >
>>>> >
>>>>
>>>> --
>>>> --
>>>> Lake Agassiz Regional Library - Moorhead MN
>>>> larl.org <http://larl.org>
>>>> Josh Stompro | Office 218.233.3757
>>>> EXT-139
>>>> LARL Network Administrator | Mobile 701.371.3857
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Bill Erickson
>>>> PINES Systems Developer
>>>> Georgia Public Library Service
>>>> billserickson at gmail.com <mailto:billserickson at gmail.com>
>>>> http://open-ils.org
>>>
>>> --
>>> --
>>> Lake Agassiz Regional Library - Moorhead MN larl.org <http://larl.org>
>>>
>>> Josh Stompro | Office 218.233.3757 EXT-139 LARL Network
>>> Administrator | Mobile 701.371.3857
>>>
>>>
>>>
>>>
>>> --
>>> Bill Erickson
>>> PINES Systems Developer
>>> Georgia Public Library Service
>>> billserickson at gmail.com <mailto:billserickson at gmail.com>
>>> http://open-ils.org
>>
>> --
>> --
>> Lake Agassiz Regional Library - Moorhead MN larl.org <http://larl.org>
>>
>> Josh Stompro | Office 218.233.3757 EXT-139 LARL Network
>> Administrator | Mobile 701.371.3857
>>
>>
>>
>>
>> --
>> Bill Erickson
>> PINES Systems Developer
>> Georgia Public Library Service
>> billserickson at gmail.com <mailto:billserickson at gmail.com>
>> http://open-ils.org
>
> --
> --
> Lake Agassiz Regional Library - Moorhead MN larl.org <http://larl.org>
>
> Josh Stompro | Office 218.233.3757 EXT-139 LARL Network
> Administrator | Mobile 701.371.3857
>
>
>
>
> --
> Bill Erickson
> PINES Systems Developer
> Georgia Public Library Service
> billserickson at gmail.com <mailto:billserickson at gmail.com>
> http://open-ils.org
--
--
Lake Agassiz Regional Library - Moorhead MN larl.org
Josh Stompro | Office 218.233.3757 EXT-139
LARL Network Administrator | Mobile 701.371.3857
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20060613/e9d93ff5/attachment-0001.html
More information about the Open-ils-dev
mailing list