Forum OpenACS Q&A: Re: open FTS & tsearch

Collapse
4: Re: open FTS & tsearch (response to 1)
Posted by Angel Sotil on 03/14/04 02:48 AM
Hi,

I'm trying to set up Search-OpenFTS-tcl-0.3.2 with openacs-4-6-3 and have exactly the same problem but cannot find the solution.

I'm following the instructions in: https://openacs.org/doc/openacs-4-6-3/nextsteps.html and https://openacs.org/doc/openacs-4-6-3/aolserver.html. Everything is all right till I try:
ehrms:~> /usr/local/pgsql/bin/psql ehrms -r /usr/local/src/postgresql-7.2.4/contrib/tsearch/tsearch.sql

BEGIN
psql:/usr/local/src/postgresql-7.2.4/contrib/tsearch/tsearch.sql:8: ERROR:  stat failed on file '$libdir/tsearch': No such file or directory
psql:/usr/local/src/postgresql-7.2.4/contrib/tsearch/tsearch.sql:13: NOTICE:  current transaction is aborted, queries ignored until end of transaction block
*ABORT STATE*

Thanks for any help

Collapse
5: Re: open FTS & tsearch (response to 4)
Posted by Richard Hamilton on 03/14/04 10:09 AM
Looks like it cannot find a file - the '*/tsearch' file. I have not experienced this problem so I cannot be certain and its a while since I did it, but try these:

- a file system search for the location of the libdir directory - try manually in the path shown above (/usr/local/src/postgresql-7.2.4/contrib/tsearch/). Once you find it check the file permissions and ownership of the directory and the files within.

- check that $libdir is referencing the correct path. Look in the sql files that you are passing to psql and check where $libdir is set and what it is set to.

- try to find 'tsearch' manually - do an 'updatedb' followed by a 'locate tsearch*'

Hope this helps.

R.