Install Full Text Search using OpenFTS (deprecated see tsearch2)
OpenFTS and tsearch1 use is deprecated in favor of
Tsearch2. See
Install Full Text Search using Tsearch2. Tsearch2 is much easier to install, requiring only
compilation of one module from PostgreSQL contrib, with an
- automated install process using the tsearch2-driver package.
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
+ automated install process using the tsearch2-driver package.
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
@@ -57,7 +57,7 @@
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
+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
@@ -81,7 +81,7 @@
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.)
[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ /usr/local/pgsql/bin/psql $OPENACS_SERVICE_NAME -f /usr/local/src/postgresql-7.3.4/contrib/tsearch/tsearch.sql
@@ -101,7 +101,7 @@
It is probably because PostgreSQL's libdir configuration variable points to a diffent directory than where tsearch is.
You can find out where PostgreSQL expects to find tsearch via
pg_config --pkglibdir
-
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
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.
[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ svc -t /service/$OPENACS_SERVICE_NAME
[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$
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.
Click the new sub folder
link on the "/" line, the first line under Main Site:/.
Type openfts
@@ -131,4 +131,4 @@
new application link.
Click on the Install
link next to Weblogger.
Install all required packages as well (always say okay until you shall restart the server)
Load the service contracts datamodell and enable the service contract
[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ cd packages/lars-blogger/sql/postgresql
[$OPENACS_SERVICE_NAME postgresql]$ psql $OPENACS_SERVICE_NAME -f lars-blogger-sc-create.sql
Note: Usually this script is called package_name-sc-create.sql
Restart the service.
[$OPENACS_SERVICE_NAME postgresql]$ svc -t /service/$OPENACS_SERVICE_NAME
- [$OPENACS_SERVICE_NAME postgresl]$
If you are lucky, Full Text Search is enabled now, if not consult http://openacs.org/forums/message-view?message_id=154759. This link also contains some hints on how to make sure it is enabled.