[General] Webboard: No problem with mysqld_stmt_execute

2014-05-29 Thread bar
Author: Tom Paamand
Email: 
Message:
ps=none did the trick! 
I have put it like 
/?DBMode=blob&ps=none 
- and it works now.

I have only changed Server and DBAddr to my own stuff in the conf-dist, so if 
ps=none does not have any bad site effects, I will use this. 

Your first command 
indexer --sqlmon --exec="select version();" 
just outputs the indexer helpfile. I tried different variations, no luck. But 
indexer runs fine from 
mnogo/sbin 
and calls my 
mnogo/etc/indexer.conf

More luck with 
ldd indexer: 
 linux-vdso.so.1 =>  (0x7fffe0dff000)
 libpthread.so.0 => /lib/libpthread.so.0 (0x7f7d8984b000)
 librt.so.1 => /lib/librt.so.1 (0x7f7d89643000)
 libmysqlclient.so.15 => /usr/local/lib/mysql/libmysqlclient.so.15 
(0x7f7d892c7000)
 libnsl.so.1 => /lib/libnsl.so.1 (0x7f7d890ad000)
 libm.so.6 => /lib/libm.so.6 (0x7f7d88e2a000)
 libssl.so.0.9.8 => /lib/libssl.so.0.9.8 (0x7f7d88bd5000)
 libcrypto.so.0.9.8 => /lib/libcrypto.so.0.9.8 (0x7f7d88844000)
 libz.so.1 => /lib/libz.so.1 (0x7f7d8862d000)
 libpq.so.5 => /usr/lib/libpq.so.5 (0x7f7d88403000)
 libcrypt.so.1 => /lib/libcrypt.so.1 (0x7f7d881ca000)
 libc.so.6 => /lib/libc.so.6 (0x7f7d87e43000)
 /lib64/ld-linux-x86-64.so.2 (0x7f7d89a89000)
 libdl.so.2 => /lib/libdl.so.2 (0x7f7d87c3e000)
 libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x7f7d8797a000)
 libcom_err.so.2 => /lib/libcom_err.so.2 (0x7f7d87776000)
 libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x7f7d87541000)
 libldap_r-2.4.so.2 => /usr/lib/libldap_r-2.4.so.2 (0x7f7d872f5000)
 libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x7f7d870cf000)
 libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x7f7d86ec6000)
 libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x7f7d86cc3000)
 libresolv.so.2 => /lib/libresolv.so.2 (0x7f7d86aaa000)
 liblber-2.4.so.2 => /usr/lib/liblber-2.4.so.2 (0x7f7d8689b000)
 libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x7f7d86681000)
 libgnutls.so.26 => /usr/lib/libgnutls.so.26 (0x7f7d863df000)
 libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0x7f7d861cd000)
 libgcrypt.so.11 => /lib/libgcrypt.so.11 (0x7f7d85f55000)
 libgpg-error.so.0 => /lib/libgpg-error.so.0 (0x7f7d85d51000)

- but problem looks like it is solved, thanks!

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


[General] Webboard: Still problem with mysqld_stmt_execute

2014-05-29 Thread bar
Author: Alexander Barkov
Email: b...@mnogosearch.org
Message:
> The actual MySQL base called is 5.1.61, though system MySQL is 5.0.90, so 
> that bug is unfortunately not my answer.  
> 
> Problem is still, that indexer starts OK, but stops after 0-10 good hits - 
> with this error: 
> 
>  indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect arguments 
> to mysqld_stmt_execute
>  indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: 
> Incorrect arguments to mysqld_stmt_execute - '
> 
> 
> Mysql Distrib 5.1.61 [updated info] 
> Ubuntu Server 10.04.1 x86_64 
> on Shared Server. 

Can you please run these two commands and post their results:

indexer --sqlmon --exec="select version();"
ldd indexer

Thanks.


Btw, if nothing helps, you can switch off using prepared statements by adding 
"ps=none" as a parameter to DBAddr, like this:

DBAddr mysql://root@localhost/test/?ps=none



> 
> 
> > > Which MySQL version are you using?
> > > 
> > > Perhaps you hit this problem:
> > > http://bugs.mysql.com/bug.php?id=61225
> 

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


[General] Webboard: Still problem with mysqld_stmt_execute

2014-05-29 Thread bar
Author: Tom Paamand
Email: 
Message:
The actual MySQL base called is 5.1.61, though system MySQL is 5.0.90, so that 
bug is unfortunately not my answer.  

Problem is still, that indexer starts OK, but stops after 0-10 good hits - with 
this error: 

 indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect arguments 
to mysqld_stmt_execute
 indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: 
Incorrect arguments to mysqld_stmt_execute - '


Mysql Distrib 5.1.61 [updated info] 
Ubuntu Server 10.04.1 x86_64 
on Shared Server. 


> > Which MySQL version are you using?
> > 
> > Perhaps you hit this problem:
> > http://bugs.mysql.com/bug.php?id=61225


Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


[General] Webboard: Also problem with mysqld_stmt_execute

2014-05-29 Thread bar
Author: Tom Paamand
Email: 
Message:
Thanx for answer. I think it is a very good guess, and have forwarded it to my 
host. My Mysql version is 5.0.90, and is covered in the bug report. I will 
return with more info, if this was the solution!

> Ubuntu server 10.04.1 x86_64
> Mysql 14.12 Distrib 5.0.90
> Shared server. 



> > indexer starts allright, but stops after 0-10 good hits. 
> > "Incorrect arguments to mysqld_stmt_execute" 
> > Tried a lot of stuff, but no luck...
> > 
> 
> 
> Which MySQL version are you using?
> 
> Perhaps you hit this problem:
> http://bugs.mysql.com/bug.php?id=61225
> 
> > -
> > 
> > $ /mnogo/sbin/indexer -Eblob 
> > indexer[17151]: Converting to blob
> > indexer[17151]: Loading URL list
> > indexer[17151]: Converting intag00
> > indexer[17151]: mysql_stmt_execute() failed: Incorrect arguments to 
> > mysqld_stmt_execute
> > 
> > -
> > 
> > $ /mnogo/sbin/indexer -a 
> > [some good hits, then]
> > indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect 
> > arguments to mysqld_stmt_execute
> > indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: 
> > Incorrect arguments to mysqld_stmt_execute - '
> > 
> > -
> > 
> > $ /mnogo/sbin/indexer
> > indexer[17769]: indexer from mnogosearch-3.3.8-mysql-pqsql started with 
> > '/mnogo/etc/indexer.conf'
> > indexer[17769]: [17769]{01} Done (0 seconds, 0 documents, 0 bytes,  0.00 
> > Kbytes/sec.)
> > 
> > -
> > 
> > Ubuntu server 10.04.1 x86_64 
> > Mysql 14.12 Distrib 5.0.90 
> > Shared server. 

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


Re: [General] Delete a line in Server method in indexer.conf

2014-05-29 Thread Alexander Barkov

Hi,

On 05/05/2014 02:26 PM, d...@hodei.net wrote:

Hi,

In the indexer.conf file, in 'Server [Method] ', i want  to delete an
entry  like this : 'server http://www.eke.org'


Is that all pages of the site will be removed from the database during
the next crawling?


Every document has its own expiration time, which is stored in 
url.next_index_time.


When crawling, indexer deletes all expired documents that do not
have a matching Server/Real command.

Note, you can delete all documents at once,
without waiting for expiration:

indexer -Cw -u http://www.eke.org/%





Thanks


___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


Re: [General] accented characters

2014-05-29 Thread Alexander Barkov



On 05/05/2014 02:32 PM, d...@hodei.net wrote:

hi

i have accented characters in my web search.

to solve this problem, i have modify the database with this queries :

ALTER TABLE bdict CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE bdicti CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

and i have init variables *$localcharset* et *$browsercharset* with
utf-8 in my indexer.conf

But i have always the problem !

have you an idea ?

Thanks
__
my config :

* Debian 3.2.51-1 x86_64 GNU/Linux
* mnogosearch 3.3.15
* indexer.conf :
..
   DBAddr mysql://root:password@localhost/mnogosearch/?dbmode=blob



Try adding the SetNames=utf8 part, like this:


DBAddr 
mysql://root:password@localhost/mnogosearch/?SetNames=utf8&dbmode=blob


 ..




   

Ce courrier électronique ne contient aucun virus ou logiciel malveillant
parce que la protection Antivirus avast!  est
active.




___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


Re: [General] parameter to server command in indexer.conf

2014-05-29 Thread Alexander Barkov

Hi,

On 05/05/2014 05:02 PM, d...@hodei.net wrote:

hi

When i try to add this url to my list in dexer.conf
--
server http://fr.wikipedia.org/wiki/Zanpantzar
--
the crawler search all fr.wikioedia.org site and not only Zanpantzar
directory

Have you an idea ?


Hmm. http://fr.wikipedia.org/wiki/Zanpantzar
is not a directory. It's a file.


With this server command it should crawl everything
in this directory: http://fr.wikipedia.org/wiki/
It should not go outside of the "/wiki/" directory.

If it goes outside of "/wiki/", perhaps you have
more server commands.



Thanks



__
my config :

* Debian 3.2.51-1 x86_64 GNU/Linux
* mnogosearch 3.3.15
* indexer.conf :
..
   DBAddr mysql://root:password@localhost/mnogosearch/?dbmode=blob
 ..


---
Ce courrier électronique ne contient aucun virus ou logiciel malveillant
parce que la protection avast! Antivirus est active.
http://www.avast.com

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


[General] Webboard: mnoGoSearch 3.3 -> 3.4 MySQL issue

2014-05-29 Thread bar
Author: Alexander Barkov
Email: b...@mnogosearch.org
Message:
Hi,

> Hi Guys,
> 
> I moved my platform and recompiling mnoGoSearch also moved me from 
> 3.3.15 to 3.4.0
> 
> When I launch, I got a MySQL erreur because of new/different fields 
> (urlinfob for example).
> 
> Is there a migration process to keep all the indexed data ?
> 
> Thanks
> 
> Brgrds

Unfortunately, there is no a migration process.
You'll need to crawl and index your data again.



Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general


[General] Webboard: Also problem with mysqld_stmt_execute

2014-05-29 Thread bar
Author: Alexander Barkov
Email: b...@mnogosearch.org
Message:
> indexer starts allright, but stops after 0-10 good hits. 
> "Incorrect arguments to mysqld_stmt_execute" 
> Tried a lot of stuff, but no luck...
> 


Which MySQL version are you using?

Perhaps you hit this problem:
http://bugs.mysql.com/bug.php?id=61225

> -
> 
> $ /mnogo/sbin/indexer -Eblob 
> indexer[17151]: Converting to blob
> indexer[17151]: Loading URL list
> indexer[17151]: Converting intag00
> indexer[17151]: mysql_stmt_execute() failed: Incorrect arguments to 
> mysqld_stmt_execute
> 
> -
> 
> $ /mnogo/sbin/indexer -a 
> [some good hits, then]
> indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect arguments 
> to mysqld_stmt_execute
> indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: 
> Incorrect arguments to mysqld_stmt_execute - '
> 
> -
> 
> $ /mnogo/sbin/indexer
> indexer[17769]: indexer from mnogosearch-3.3.8-mysql-pqsql started with 
> '/mnogo/etc/indexer.conf'
> indexer[17769]: [17769]{01} Done (0 seconds, 0 documents, 0 bytes,  0.00 
> Kbytes/sec.)
> 
> -
> 
> Ubuntu server 10.04.1 x86_64 
> Mysql 14.12 Distrib 5.0.90 
> Shared server. 

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general