Forum OpenACS Q&A: OpenFTS troubles...

Collapse
Posted by Jose Carrion on

I am having problems initializing the OpenFTS engine. I installed OpenFTS according to the installation docs, following all the instructions with no problems (well, I did have to add --with-tcl=/usr/lib/ when configured it, as I read in this post--I'm running RH8). When I tried to initialize the OpenFTS engine (Main Site: OpenFTS Driver: Administration: Initialize OpenFTS Engine with the defaults) I first got an error similar (probably the very same one) to the one described in this post. I retried the initialization (for some reason) and got the following message:

Database operation "dml" failed
    while executing
"error "$err""
    invoked from within
"if [catch {
    db_dml create_table "create table $table_name ( ${table_id} int not null primary key, path varchar unique, fts_index txtidx, last_modi..."
    ("uplevel" body line 21)
    invoked from within
"uplevel {
    	  ad_page_contract {

    Initialize OpenFTS

    @author Neophytos Demetriou

} {
    table_name
    table_id
    dict
    numbergroup..."
    (procedure "code::tcl::/home/jose/web/upreview/packages/openfts-driver/w..." line 2)
    invoked from within
"code::tcl::$__adp_stub"
    invoked from within
"if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init tcl $__adp_stub
..."
    ("uplevel" body line 3)
    invoked from within
"uplevel {

    if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init t..."
    (procedure "adp_prepare" line 2)
    invoked from within
"adp_prepare "
    (procedure "template::adp_parse" line 30)
    invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
    (procedure "adp_parse_ad_conn_file" line 7)
    invoked from within
"$handler"
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
	$handler
      } ad_script_abort val {
	# do nothing
      }"
    invoked from within
"rp_serve_concrete_file [ad_conn file]"
    (procedure "rp_serve_abstract_file" line 60)
    invoked from within
"rp_serve_abstract_file "$root/$path""
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
	rp_serve_abstract_file "$root/$path"
	set tcl_url2file([ad_conn url]) [ad_conn file]
	set tcl_url2path_info([ad_conn url]) [ad_conn path_inf..."

As described in this message I changed the ownership of /usr/local/src/Search-OpenFTS-tcl-0.3.2 with chown. I got the same error. Then I tried copying the fts_*.tcl files in /usr/local/src/Search-OpenFTS-tcl-0.3.2 to /home/user/web/server/packages/openfts-driver/tcl/ as fts_*-procs.tcl. No luck. I'm still getting the same error. What am I doing wrong?

Collapse
2: Re: OpenFTS troubles... (response to 1)
Posted by Kiran Halwai on
I have came across the same problem while installing OpenFTS. Could you get around the problem? If yes, can you please post the solution?

Thanks you.
-Kiran

Collapse
3: Re: OpenFTS troubles... (response to 2)
Posted by Jose Carrion on
Nothing yet, unfortunately.
Collapse
Posted by Kiran Halwai on
I carefully followed the instructions at

1. https://openacs.org/doc/openacs-4/postgres.html (Prepare PostgreSQL for OpenFTS) and

2. https://openacs.org/doc/openacs-4/nextsteps.html (
Set up site-wide search)

At pt. 2, make sure you use --with-tcl=/usr/lib/ in following command.

./configure --with-aolserver-src=/usr/local/src/aolserver/aolserver --with-tcl=/usr/lib/

Carefully follow all the 19 points.

If you already have Notes package installed, then you can uninstall and install again or put the note_id's in
search_observer_queue table.
e.g

insert into search_observer_queue(your-note-id, now(), 'INSERT');

Look for following thread also -
https://openacs.org/forums/message-view?message_id=89360

I have postgres 7.2.3, redhat 7.2 and openacs 4.6.1