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

4: Re: open FTS & tsearch (response to 1)
Posted by Angel Sotil on

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: and 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

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

Thanks for any help

Posted by Richard Hamilton on
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.