Webboard: indexing a database

Author: Alexander Barkov
Email: barmnogosearch.org
Message:
> > > {sql.c:8380} Query: SELECT CONCAT('HTTP/1.0
200 OKrn','Content-type: text/plainrn','rn',libelle)
FROM mnogo_test WHERE id='2'
> > 
> > If you can see this, that mean MySQL returns error
for some
> > reasons. Try to connect to MySQL using the same
user and password
> > as in "DBAddr" and try to execute the
same query to see
> > what is the error.
> 
> I've execute this request in Oracle SQL*Plus, and it
doesn't work. It returns a ORA-00909: invalid number of
arguments.
> According to Oracle documentation, CONCAT accepts only
2 parameters. So I've tried with ||
> 
> SELECT 'HTTP/1.0 200 OKrn'||'Content-type:
text/plainrn'||'rn'||libelle FROM mnogo_test WHERE
id='2';
> This request works on SQL*Plus. But not with
mnoGoSearch when I use it  with HTDBDoc
> HTDBDoc "SELECT 'HTTP/1.0 200
OK\r\n'||'Content-type:
text/plain\r\n'||'\r\n'||libelle FROM $1 WHERE
id='$2'"


Sorry for confusing, I didn't notice you're using Oracle.


Oracle doesn't work with C-alike escape sequences r and
n.
You need to use the "CHR" function instead:

SELECT 'HTTP/1.0 200 OK'||CHR(13)||CHR(10)||'Content-type:
text/plain'||CHR(13)||CHR(10)||CHR(13)||CHR(10)||libelle
FROM mnogo_test WHERE id='2';



> 
> Here's what I get with indexer -v6
> 
> indexer from mnogosearch-3.3.3-oracle8i started with
'/usr/local/mnogosearch/etc/indexer.conf'
> [17023] URL: htdb:/mnogo_test/
> [17023] Server Allow 'htdb:/mnogo_test/'
> [17023] Allow by default
> [17023] Request.Accept-Encoding:
gzip,deflate,compress
> [17023] Request.User-Agent: MnoGoSearch/3.3.3
> [17023] HTDBList: SELECT id FROM mnogo_test
> 
> [17023] Link '2' htdb:/mnogo_test/2
> [17023]  Server applied: site_id: -394718339 URL:
htdb:/mnogo_test/
> [17023] Allow by default
> [17023] Response.body: <NULL>
> [17023] Response.CachedCopy: <NULL>
> [17023] Response.case_sense: 1
> [17023] Response.Charset: <NULL>
> [17023] Response.Content-Language: <NULL>
> [17023] Response.Content-Length: 28
> [17023] Response.Content-Type: text/html
> [17023] Response.crc32: 0
> [17023] Response.crc32old: 0
> [17023] Response.crosswords: <NULL>
> [17023] Response.DefaultLang: fr
> [17023] Response.Follow: 1
> [17023] Response.Hops: 0
> [17023] Response.HTDBAddr: oracle://xxxxxxxxxx/xx
x/?dbmode=single
> [17023] Response.HTDBDoc: SELECT 'HTTP/1.0 200
OK\r\n'||'Content-type:
text/plain\r\n'||'\r\n'||libelle FROM $1 WHERE id='$2'
> [17023] Response.HTDBList: SELECT id FROM $1
> [17023] Response.ID: 267
> [17023] Response.match_type: 1
> [17023] Response.MaxDocPerSite: 0
> [17023] Response.MaxHops: 256
> [17023] Response.meta.description: <NULL>
> [17023] Response.meta.keywords: <NULL>
> [17023] Response.Method: Allow
> [17023] Response.nomatch: 0
> [17023] Response.Period: 60
> [17023] Response.PrevStatus: 0
> [17023] Response.ResponseLine: HTTP/1.0 200 OK
> [17023] Response.ResponseSize: 72
> [17023] Response.Server_id: -394718339
> [17023] Response.Site_id: -1212446494
> [17023] Response.Status: 200
> [17023] Response.Tag: nomenclatures
> [17023] Response.title: <NULL>
> [17023] Response.URL: htdb:/mnogo_test/
> [17023] Response.url.file: <NULL>
> [17023] Response.url.host: <NULL>
> [17023] Response.url.path: <NULL>
> [17023] Response.url.proto: <NULL>
> [17023] Response.URL_ID: -394718339
> [17023] Response.VaryLang: fr
> [17023] Status: 200 OK
> [17023] Stored rec_id: 267 Size: 28 Ratio: 103.57%
> [17023] Guesser: 2145h:189m fr-iso-8859-1
> [17023] Guesser: Lang: fr, Charset: iso-8859-1
> [17023] URL: htdb:/mnogo_test/2
> [17023] Server Allow 'htdb:/mnogo_test/'
> [17023] Allow by default
> [17023] Request.Accept-Encoding:
gzip,deflate,compress
> [17023] Request.User-Agent: MnoGoSearch/3.3.3
> [17023] HTDBDoc: SELECT 'HTTP/1.0 200
OKrn'||'Content-type: text/plainrn'||'rn'||libelle
FROM mnogo_test WHERE id='2'
> 
> [17023] Response.body: <NULL>
> [17023] Response.CachedCopy: <NULL>
> [17023] Response.case_sense: 1
> [17023] Response.Charset: <NULL>
> [17023] Response.Content-Language: <NULL>
> [17023] Response.Content-Type: <NULL>
> [17023] Response.crc32: 0
> [17023] Response.crc32old: 0
> [17023] Response.crosswords: <NULL>
> [17023] Response.DefaultLang: fr
> [17023] Response.Follow: 1
> [17023] Response.Hops: 1
> [17023] Response.HTDBAddr: oracle://xxxxxxxxxx/xx
x/?dbmode=single
> [17023] Response.HTDBDoc: SELECT 'HTTP/1.0 200
OK\r\n'||'Content-type:
text/plain\r\n'||'\r\n'||libelle FROM $1 WHERE id='$2'
> [17023] Response.HTDBList: SELECT id FROM $1
> [17023] Response.ID: 268
> [17023] Response.match_type: 1
> [17023] Response.MaxDocPerSite: 0
> [17023] Response.MaxHops: 256
> [17023] Response.meta.description: <NULL>
> [17023] Response.meta.keywords: <NULL>
> [17023] Response.Method: Allow
> [17023] Response.nomatch: 0
> [17023] Response.Period: 60
> [17023] Response.PrevStatus: 0
> [17023] Response.ResponseSize: 68
> [17023] Response.Server_id: -394718339
> [17023] Response.Site_id: -1212446494
> [17023] Response.Status: 0
> [17023] Response.Tag: nomenclatures
> [17023] Response.title: <NULL>
> [17023] Response.URL: htdb:/mnogo_test/2
> [17023] Response.url.file: <NULL>
> [17023] Response.url.host: <NULL>
> [17023] Response.url.path: <NULL>
> [17023] Response.url.proto: <NULL>
> [17023] Response.URL_ID: 1897926811
> [17023] Response.VaryLang: fr
> [17023] Status: 0 Not indexed yet
> [17023] No data received
> [17023] Done (0 seconds, 2 documents, 140 bytes, 
0.00 Kbytes/sec.)
> 

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


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