Install Full Text Search

+Install Full Text Search

Prev	Appendix�B.�Install additional supporting software	Next

Install Full Text Search

By Joel Aufrecht and Malte Sussdorff

OpenACS docs are written by the named authors, and may be edited by OpenACS documentation staff. -

Install OpenFTS module

If you want full text search, and you are running PostgreSQL, install this module to support FTS. Do this step after you have installed both PostgreSQL and +

Install OpenFTS module

If you want full text search, and you are running PostgreSQL, install this module to support FTS. Do this step after you have installed both PostgreSQL and AOLserver. You will need the openfts tarball in /tmp.

Install Tsearch. This is a PostgreSQL module that OpenFTS requires.

[root root]# su - postgres
@@ -20,11 +20,11 @@
 logout
 
 [root root]#
-su - postgres
+su - postgres
 cd /usr/local/src/postgresql-7.3.4/contrib/tsearch
 make
 make install
-exit

Unpack the OpenFTS tarball and compile and install +exit

Unpack the OpenFTS tarball and compile and install the driver.

[root root]# cd /usr/local/src
 [root src]# tar xzf /tmp/Search-OpenFTS-tcl-0.3.2.tar.gz
 [root src]# cd /usr/local/src/Search-OpenFTS-tcl-0.3.2/
@@ -47,15 +47,15 @@
 n_stem.o italian_stem.o norwegian_stem.o portuguese_stem.o russian_stem.o nsfts.o  -o nsfts.so
 [root aolserver]# cp nsfts.so /usr/local/aolserver/bin/
 [root aolserver]#
-cd /usr/local/src 
+cd /usr/local/src 
 tar xzf /tmp/Search-OpenFTS-tcl-0.3.2.tar.gz
 cd /usr/local/src/Search-OpenFTS-tcl-0.3.2/
 ./configure --with-aolserver-src=/usr/local/src/aolserver/aolserver --with-tcl=/usr/lib/
 make
 cd aolserver
 make
 cp nsfts.so /usr/local/aolserver/bin
-

Build some supplemental modules.

[root aolserver]# cd /usr/local/src/Search-OpenFTS-tcl-0.3.2
+

Build some supplemental modules.

[root aolserver]# cd /usr/local/src/Search-OpenFTS-tcl-0.3.2
 [root Search-OpenFTS-tcl-0.3.2]# cp -r pgsql_contrib_openfts /usr/local/src/postgresql-7.3.4/contrib
 [root Search-OpenFTS-tcl-0.3.2]# cd /usr/local/src/postgresql-7.3.4/contrib/pgsql_contrib_openfts
 [root pgsql_contrib_openfts]# make
@@ -70,13 +70,13 @@
 /bin/sh ../../config/install-sh -c -m 644 ./README.openfts /usr/local/pgsql/doc/contrib
 [postgres pgsql_contrib_openfts]$ exit
 [root pgsql_contrib_openfts]#
-cd /usr/local/src/Search-OpenFTS-tcl-0.3.2
+cd /usr/local/src/Search-OpenFTS-tcl-0.3.2
 cp -r pgsql_contrib_openfts /usr/local/src/postgresql-7.3.4/contrib
 cd /usr/local/src/postgresql-7.3.4/contrib/pgsql_contrib_openfts
 make
 su postgres
 make install
-exit

Install OpenFTS prerequisites in PostgreSQL instance

If you are installing Full Text Search, add required +exit

Install OpenFTS prerequisites in PostgreSQL instance

If you are installing Full Text Search, add required packages to the new database. (In order for full text search to work, you must also install the PostgreSQL OpenFTS module and prerequisites.)

[service0 service0]$ /usr/local/pgsql/bin/psql service0 -f /usr/local/src/postgresql-7.3.4/contrib/tsearch/tsearch.sql
@@ -89,8 +89,8 @@
 CREATE
 CREATE
 [service0 service0]$
-/usr/local/pgsql/bin/psql service0 -f /usr/local/src/postgresql-7.3.4/contrib/tsearch/tsearch.sql
-/usr/local/pgsql/bin/psql service0 -f /usr/local/src/postgresql-7.3.4/contrib/pgsql_contrib_openfts/openfts.sql

Enable OpenFTS in config.tcl

If you have installed OpenFTS, you can enable it for this service. Uncomment this line from config.tcl. (To uncomment a line in a tcl file, remove the # at the beginning of the line.)

#ns_param   nsfts           ${bindir}/nsfts.so

Install Full Text Search Engine

Click Admin on the top of the default home page. If prompted, log in with the account and password you entered during install.
Click on the Install +/usr/local/pgsql/bin/psql service0 -f /usr/local/src/postgresql-7.3.4/contrib/tsearch/tsearch.sql +/usr/local/pgsql/bin/psql service0 -f /usr/local/src/postgresql-7.3.4/contrib/pgsql_contrib_openfts/openfts.sql

`Enable OpenFTS in config.tcl`

If you have installed OpenFTS, you can enable it for this service. Uncomment this line from config.tcl. (To uncomment a line in a tcl file, remove the # at the beginning of the line.)

#ns_param   nsfts           ${bindir}/nsfts.so

`Install Full Text Search Engine`

Click Admin on the top of the default home page. If prompted, log in with the account and password you entered during install.
Click on the Install software link.
Click on the Install new service link.
Click on the Install link next to OpenFTS Driver.

Restart the service.

[service0 service0]$ svc -t /service/service0
 [service0 service0]$

Wait a minute, then browse back to the home page.
Click on Admin on the top of the screen.
Click on Main Site Administration in the "Subsite Administration" section.
Click on Site Map in the "Advanced Features" section.
Mount the OpenFTS Full Text Search Engine in the site map.
1. Click the new sub folder link on the "/" line, the first line under Main Site:/.
2. Type openfts