| Newsgroups |
gmane.comp.web.mnogosearch.general |
| Message-ID |
<2218985.3841591260976135051.JavaMail.root@spooler3-g27.priv.proxad.net> |
Please disregard this email.
----- Mail Original -----
De: [email protected]
À: "general" <[email protected]>, "Alexander Barkov" <[email protected]>
Envoyé: Mercredi 16 Décembre 2009 15:55:53 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: Re: Various htdb questions
Hi,
> When using HTDB, mnoGoSearch does not access anything via HTTP.
> All data is fetched directly from the database.
> Make sure that your HTDBList query returns all IDs, including
> private IDs.
If I have,
HTDBAddr mysql://xxx:[email protected]/mydatabase/
...
HTDBList "SELECT CONCAT('http://test.com/drupal6/node/', nid) from node_access WHERE nid IS NOT NULL"
Server urllist htdb:/
Realm site *
the SELECT is going to generate a list of URLs such as
http://test.com/drupal6/node/
http://test.com/drupal6/node/
http://test.com/drupal6/node/
http://test.com/drupal6/node/
----- Mail Original -----
De: "Alexander Barkov" <[email protected]>
À: [email protected]
Cc: "general" <[email protected]>
Envoyé: Mercredi 16 Décembre 2009 08:49:55 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: Re: Various htdb questions
Hi,
[email protected] wrote:
> Hi,
>
> - what is the difference between 'Server urllist htdb:/' and 'Server htdb:/'?
>
> Let's say that you have an HTDBList that returns a list of ids. Would you use 'Server urllist htdb:/' or 'Server htdb:/' in this case?
It's enough to use 'Server htdb:/' in this case.
'Server urllist htdb:/' is only needed when HTDBList returns a list of
http:// URLs.
>
> - in
>
> HTDBList "SELECT url FROM mytable"
> Server urllist htdb:/
> Realm page *
>
> Why do you need 'Realm page *'?
Indexer checks all URLs it gets from HTDBList query
against Server and Realm commands. Every URL which is
put to the database must have a matching Server or Realm
command.
If you remove "Realm page *", it will ignore all URLs.
>
>
> - in the following HTDBList example, shouldn't $2 be $1, as SELECT only returns one item, id?
>
> Furthermore, why was "messages" added to the htdb URL? The messages table is already specified in the HTDBList and HTDBDoc queries.
>
> HTDBList "SELECT id FROM messages"
> HTDBDoc "SELECT title, body FROM messages WHERE id='$2'"
> Server htdb:/messages/
$2 is correct.
Imagine, HTDBList returned id "123" which results into URL
URL htdb:/messages/123, which is parsed as:
$1= messages
$2= 123
>
>
> - I am using MnogoSearch to index pages created in Drupal 6.
>
> I use an HTDBList to retrieve the list of published nodes. Unfortunately, only public nodes get indexed, not private ones.
>
> My temporary explanation is that MnogoSearch can't index data which it can't access via HTTP.
>
> Is that true?
When using HTDB, mnoGoSearch does not access anything via HTTP.
All data is fetched directly from the database.
Make sure that your HTDBList query returns all IDs, including
private IDs.
>
> Many thanks.
>
> pr
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]