List Info

Thread: Webboard: Tags, htdb and Aliases




Webboard: Tags, htdb and Aliases
user name
2006-03-28 22:24:33
Author: Charles Sprickman
Email: sporkbway.net
Message:
I'm getting more and more lost...

I pulled one alias out, leaving this as the relevant
indexer.conf:

#####
DBAddr  pgsql://pgsql:mnogo/mnogo-combined/?dbmode=single 

# Server1/Tag1 postgres mailing list archive
Tag 1
HTDBAddr pgsql://allen:/archive/
HTDBList "SELECT '
http://devel3.example.com/rails-allen/message/index/'
|| id FROM 
messages WHERE list_name='pgsql-general'"

HTDBDoc "\
SELECT \
'HTTP/1.0 200 OK\\r\\n' || \
'Content-type: text/html\\r\\n' || \
'Last-Modified: ' || date_format(sent_at::timestamp, '%a,
%d %b %Y %T') || ' GMT\\r\\n' || \
'\\r\\n' || \
'<HTML><HEAD>' || \
'<TITLE>' || subject || '</TITLE>' || \
'</HEAD>\\n' || '<BODY>\\n' || body ||
'\\n</BODY></HTML>'\
FROM messages \
WHERE id='$2'"

Server htdb:/pgsql-general/        

# Server2/Tag2 rails mailing list archive
Tag 2 
HTDBList "SELECT '
http://devel3.example.com/rails-allen/message/index/'
|| id FROM 
messages WHERE list_name='rails'"

HTDBDoc "\
SELECT \
'HTTP/1.0 200 OK\\r\\n' || \
'Content-type: text/html\\r\\n' || \
'Last-Modified: ' || date_format(sent_at::timestamp, '%a,
%d %b %Y %T') || ' GMT\\r\\n' || \
'\\r\\n' || \
'<HTML><HEAD>' || \
'<TITLE>' || subject || '</TITLE>' || \
'</HEAD>\\n' || '<BODY>\\n' || body ||
'\\n</BODY></HTML>'\
FROM messages \
WHERE id='$2'"

Server htdb:/rails/  

# Add messages:
Realm  http://devel3.biglist.com/rails-allen/message/index/* 

And here's what's in the server table:

mnogo-combined=# SELECT * from server ;
   rec_id    | enabled |                          url       
                  | tag | category | command | 
ordre |   parent   | weight | pop_weight 
-------------+---------
+-------------------------------------------------------+---
--+----------
+---------+-------+------------+--------+------------
   792637109 |       1 | htdb:/pgsql-general/               
                  | 1   |        0 | S       |     
1 |          0 |      1 |          0
  1957903672 |       1 | htdb:/rails/                       
                  | 2   |        0 | S       |     2 |      
   
0 |      1 |          0
  -982024497 |       1 | http://devel3.example.com/rails-allen/message/index/* |
2   |        
0 | S       |     3 |          0 |      1 |          0
 -1212446494 |       1 | htdb:///                           
                  | 2   |        0 | S       |     2 | 
1957903672 |      1 |          0
 -1808702634 |       1 | http://devel3.example.com/
                            | 2   |        0 | S       
|     3 | -982024497 |      1 |          0
(5 rows)             

Now with the above config, the following happens:

-instead of indexing the db, the indexer hits the actual
website, which is painfully slow
-at the end of the indexing run, there is nothing in the
dictionary, and no "writing words" 
line in the logs
-I'm not sure how to use Aliases in search.htm

I'm thinking that what I want to do, which is to tag based
on a query and not a URL, is not 
possible since all messages live under a similar path...

Sorry to keep pestering, but besides being relatively new to
mnogo, I think I'm trying to do 
something somewhat non-standard...

Thanks,

Charles

Reply: <http://www.mnogosearch.org/board/message.php?id=17832&g
t;


------------------------------------------------------------
---------
To unsubscribe, e-mail: general-unsubscribemnogosearch.org
For additional commands, e-mail: general-helpmnogosearch.org

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )