I have installed Open-ILS on Ubuntu 8.04 and have managed to get around a few
problems (requires postgres 8.2 rather than 8.3, staff client doesn't work on
server, etc). I'm just at the point where I'm trying to figure out how to
actually do something with it.
Doing a search for the word "dog" (or any other term) from the main page yields
the error message included below. Just from a naive first impression, it looks
like the problem seems to be "schema 'search' does not exist".
I looked for the appropriate sql file in
Evergreen-ILS-1.2.2.3/Open-ILS/src/sql/Pg and found
300.schema.staged_search.sql
When trying to run that file, I get the error:
psql:300.schema.staged_search.sql:583: ERROR: creation of Perl function
failed: Can't locate JSON/XS.pm in @INC (@INC contains: /etc/perl
/usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5
/usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl
.) at line 2.
BEGIN failed--compilation aborted at line 2.
ROLLBACK
So I installed JSON:XS via CPAN and the schema was created without any error.
This also corrected the error when searching.
Just providing this information in to help anyone else who might encounter this
on Ubuntu 8.04 server. Perhaps a check for JSON:XS could be added to
settings-tester.pl?
Regards,
Syd
osrf_json_gw 2008-08-05 09:47:31
[INFO:24051:osrf_json_gateway.c:327:1217763753240511] Completed processing
service=open-ils.search, method=open-ils.search.biblio.audience_map.retrieve.all
osrf_json_gw 2008-08-05 10:59:12
[INFO:24053:osrf_app_session.c:522:1217763753240531] [open-ils.search] sent 299
bytes of data to [EMAIL PROTECTED]/open-ils.search
osrf_json_gw 2008-08-05 10:59:12
[ACT:24053:osrf_json_gateway.c:220:1217763753240531] [142.132.4.4] []
open-ils.search open-ils.search.biblio.multiclass.query
{"org_unit":1,"depth":0,"limit":10,"offset":0,"visibility_limit":3000,"default_class":"keyword"},
"dog", 1
osrf_json_gw 2008-08-05 10:59:12
[INFO:24053:osrf_json_gateway.c:220:1217763753240531] [142.132.4.4] []
open-ils.search open-ils.search.biblio.multiclass.query
{"org_unit":1,"depth":0,"limit":10,"offset":0,"visibility_limit":3000,"default_class":"keyword"},
"dog", 1
osrf_json_gw 2008-08-05 10:59:12 [WARN:24053:osrf_stack.c:182:1217763753240531]
The stack doesn't know what to do with the provided message code: 500, name
osrfMethodException. Passing UP.
osrf_json_gw 2008-08-05 10:59:12 [INFO:24053:osrf_stack.c:103:1217763753240531]
Message processing duration 0.000111
osrf_json_gw 2008-08-05 10:59:12 [ERR
:24053:osrf_json_gateway.c:262:1217763753240531] Gateway received error: ***
Call to [open-ils.search.biblio.multiclass.query] failed for session
[1217951952.413803.121795195224053], thread trace [1]:
* ! EXCEPTION ! *
TYPE: OpenSRF::EX::ERROR
Mess: System ERROR
Mess: Call to open-ils.storage for method
open-ils.stosrage.biblio.multiclass.staged.search_fts.atomic
Mess: failed with exception: * ! EXCEPTION ! *
Mess: TYPE: OpenSRF::EX::ERROR
Mess: Mess: System ERROR
Mess: Mess: * ! EXCEPTION ! *
Mess: Mess: TYPE: OpenSRF::DomainObject::oilsMethodException
Mess: Mess: Mess: <500> *** Call to
[open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for
session [1217951952.422787184.99934765617], thread trace [1]:
Mess: Mess: Mess: DBD::Pg::st execute failed: ERROR: schema "search" does not
exist
Mess: Mess: Mess: [for Statement " SELECT *
Mess: Mess: Mess: FROM search.staged_fts(
Mess: Mess: Mess: 1,
Mess: Mess: Mess: 0,
Mess: Mess: Mess:
$${"keyword":{"fts_query":["to_tsquery('keyword','dog')"],"fts_rank":["rank(keyword.index_vector,
to_tsquery('keyword','dog'))"],"phrase":[],"word":["dog"]}}$$,
Mess: Mess: Mess: $${}$$,
Mess: Mess: Mess: $${}$$,
Mess: Mess: Mess: $${}$$,
Mess: Mess: Mess: $${}$$,
Mess: Mess: Mess: $${}$$,
Mess: Mess: Mess: $${}$$,
Mess: Mess: Mess: $${}$$,
Mess: Mess: Mess: $$$$,
Mess: Mess: Mess: NULL,
Mess: Mess: Mess: $$$$,
Mess: Mess: Mess: 'f',
Mess: Mess: Mess: 'f',
Mess: Mess: Mess: 'f',
Mess: Mess: Mess: NULL,
Mess: Mess: Mess: 1000,
Mess: Mess: Mess: NULL
Mess: Mess: Mess: );
Mess: Mess: Mess: "] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
Mess: Mess: Mess:
Mess: Mess:
Mess: Mess: Loc.: 996 OpenSRF::AppRequest
Mess: Mess: Loc.: /openils/lib/perl5/OpenSRF/AppSession.pm
Mess: Mess: Time: Tue Aug 5 10:59:12 2008
Mess:
Mess: Loc.: 163 OpenILS::Application::AppUtils
Mess: Loc.: /openils/lib/perl5/OpenILS/Application/AppUtils.pm
Mess: Time: Tue Aug 5 10:59:12 2008
Mess: :
Loc.: 185 OpenSRF::Application
Loc.: /openils/lib/perl5/OpenSRF/Application.pm
Time: Tue Aug 5 10:59:12 2008
osrf_json_gw 2008-08-05 10:59:12
[INFO:24053:osrf_json_gateway.c:327:1217763753240531] Completed processing
service=open-ils.search, method=open-ils.search.biblio.multiclass.query
