| Prev | Appendix�B.�Install additional supporting software | Next |
|---|
By Dave
+
+ 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
+ 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 tseach2 module form PostgreSQL
contrib. This is included with the PostgreSQL full source
distribution. It is also available with the PostgreSQL contrib
@@ -29,11 +30,11 @@
place it in your postgreSQL source tree ($PGSQL_SRC). This
patch makes the backup and restore procedures very
simple. If you have a working version of tsearch2 in your
database, you
do not need to re-install the tsearch2 module. Just
@@ -56,52 +57,52 @@
8.0. Install Tsearch2. This is a PostgreSQL module
that the tsearch2-driver OpenACS package requires. These
instructions assume you are using the latest point
- release of PostgreSQL 7.4.5. Click Click on the Click on the Click on the
- 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 Tsearch2 Driver. If you have installed tsearch2
into your PostgreSQL database, the installer will
- automatically enable tsearch in your OpenACS database instance. Restart the service. Wait a minute, then browse back to the home page. Click on Click on Click on Mount the Search interface in the site map. Click the
- Type Click the Type Restart the service. 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 Search interface in the site map. Click the
+new sub folder link on the
+Main Site line. Type search
+and click . Click the new
+application link on the search
+ line. Type search
where it says
- Click the
- Type Type tsearch2-driver
where it says
- Restart the service. Wait a minute, then click on Enabling Full Text Search in packages at the moment is not trivial. It involves a couple of steps, which I will illustrate taking lars-blogger as an example package Install the package.
- Click Click on the Click on the Click on the 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 Note: Usually this script is called package_name-sc-create.sql Restart the service. Restart the service. Wait a minute, then click on Main Site at the top of the page. Enabling Full Text Search in packages at the moment is not trivial. It involves a couple of steps, which I will illustrate taking lars-blogger as an example package Install the package.
+ 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 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 Note: Usually this script is called package_name-sc-create.sql Restart the service. 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.
- [postgres pgsql]$
cd /tmp
- [postgres tmp]$ wget http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_7.4.patch.gz
- [postgres pgsql]$ cd /usr/local/src/postgresql-7.4.5/
- [postgres postgresql-7.4.5] gunzip /tmp/regprocedure_7.4.patch.gz
- [postgres postgresql-7.4.5] patch -b -p1 < regprocedure_7.4.patch
+ [postgres pgsql]$ cd /tmp
+ [postgres tmp]$ wget http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_7.4.patch.gz
+ [postgres pgsql]$ cd /usr/local/src/postgresql-7.4.5/
+ [postgres postgresql-7.4.5] gunzip /tmp/regprocedure_7.4.patch.gz
+ [postgres postgresql-7.4.5] patch -b -p1 < regprocedure_7.4.patch
[root root]#
su - postgres
-[postgres pgsql]$ cd /usr/local/src/postgresql-7.4.5/contrib/tsearch2/
-[postgres tsearch2]$ make
-[postgres tsearch2]$ make install
+ release of PostgreSQL 7.4.5.[root root]# su - postgres
+[postgres pgsql]$ cd /usr/local/src/postgresql-7.4.5/contrib/tsearch2/
+[postgres tsearch2]$ make
+[postgres tsearch2]$ make install
mkdir /usr/local/pgsql/share/contrib
mkdir /usr/local/pgsql/doc/contrib
(2 lines omitted)
/bin/sh ../../config/install-sh -c -m 755 libtsearch.so.0.0 /usr/local/pgsql/lib/tsearch.so
-[postgres tsearch]$
exit
+[postgres tsearch]$ exit
logout
[root root]#
su - postgres
cd /usr/local/src/postgresql-7.4.5/contrib/tsearch2
make
make install
-exitAdmin on the top of the default home page. If prompted, log in with the account and password you entered during install.Install
-software link.Install
-new service link.Install
+exit[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$
svc -t /service/$OPENACS_SERVICE_NAME
-[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$Admin on the top of the screen.Main Site Administration in the "Subsite Administration" section.Site Map in the "Advanced Features" section.new sub folder link on the
-Main Site line. search
-and click . new
-application link on the search
- line. search
+ automatically enable tsearch in your OpenACS database instance.[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ svc -t /service/$OPENACS_SERVICE_NAME
+[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$untitled, choose
-search from the
+untitled, choose
+search from the
drop-down list, and click
-.
+.
Parameters link
- next to the Search package istance.tsearch2-driver
+Parameters link
+ next to the Search package istance.openfts-driver
+openfts-driver
in the
- FtsEngineDriver parameter.
-[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$
svc -t /service/$OPENACS_SERVICE_NAME
-[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$Main Site at the top of the page.Admin on the top of the default home page. If prompted, log in with the account and password you entered during install.Install
- software link.Install
- new application link.Install link next to Weblogger.[$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[$OPENACS_SERVICE_NAME postgresql]$
svc -t /service/$OPENACS_SERVICE_NAME
+ FtsEngineDriver parameter.
+[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ svc -t /service/$OPENACS_SERVICE_NAME
+[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$[$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[$OPENACS_SERVICE_NAME postgresql]$ svc -t /service/$OPENACS_SERVICE_NAME
[$OPENACS_SERVICE_NAME postgresl]$