Webboard: mnogosearch-3.3.10 vs. postgres-9.0

Author: marcin
Email: 
Message:
Hello!

I'd like to setup search engine using postgresql-9.0 . I've a few problems with it.

1. 

# indexer -Ecreate

'/usr/share/mnogosearch//pgsql/create.blob.sql' dbtype=3 dbmode=6

SQL>'CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS '$libdir/plpgsql' LANGUAGE C'

SQL>'CREATE TRUSTED LANGUAGE plpgsql HANDLER plpgsql_call_handler'

{sqlmon.c:135} Query: CREATE TRUSTED LANGUAGE plpgsql HANDLER plpgsql_call_handler



ERROR at line 3: PQexec: ERROR:  language "plpgsql" already exists



plpgsql is installed now by default.



2. Bigger problem is with indexing and searching. I configured indexer.conf and search.htm (i'm running search.cgi using xinetd).

I've started indexing page:

^C[18219]{01} SIGINT received. Terminating. Please wait...

[18219]{01} Done (40 seconds, 51 documents, 271372 bytes,  6.63 Kbytes/sec.)

So some documents was inserted to database. select count(*) from url; gives 130 records. Next i run indexer -Eblob:

indexer -Eblob

Converting to blob

Loading URL list

Converting intag00

Converting intag01

Converting intag02

Converting intag03

Converting intag04

Converting intag05

Converting intag06

Converting intag07

Converting intag08

Converting intag09

Converting intag0A

Converting intag0B

Converting intag0C

Converting intag0D

Converting intag0E

Converting intag0F

Converting intag10

Converting intag11

Converting intag12

Converting intag13

Converting intag14

Converting intag15

Converting intag16

Converting intag17

Converting intag18

Converting intag19

Converting intag1A

Converting intag1B

Converting intag1C

Converting intag1D

Converting intag1E

Converting intag1F

Total converted: 0 records, 0 bytes

Converting url data

Switching to new blob table.

Converting to blob finished     0.04



I'm worring about line "Total converted: 0 records, 0 bytes" , imho there shouldn't be zeroes. Search.cgi isn't working, probably because earlier problem, i'm getting:"

An error occurred!

Inverted word index not found. Probably you forgot to run 'indexer -Eblob'. 

"

Can somebody give me any advice with this problem?

Thank you,

Marcin.

Reply: <http://www.mnogosearch.org/board/message.php?id=21178>