Forum OpenACS Q&A: Re: open FTS & tsearch
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
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
- 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.