Plz help me! very urgent

How to make sure that only one node is running??

On Tue, Jul 2, 2013 at 11:21 PM, David Pilato david@pilato.fr wrote:

I have a concern about that: 10.0.0.2:9301

If you have only one node running that should be something like
10.0.0.2:9300 http://10.0.0.2:9301/

My advice here is:

  • make sure that you have only one node running
  • delete all: curl -XDELETE localhost:9200/
  • create again the river
  • run again the same query

If it does not work, check your SQL connection (login/password), run the
same query "select * from details" and check that it works fine.

HTH

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 2 juil. 2013 à 19:23, Puneeth Parala babloopuneeth@gmail.com a écrit
:

Lolz... No sir i didnt try for whatever...

http://localhost:9200/_search?q= http://localhost:9200/_search?q=whatever*

When i tried this, im getting the following:-

{"took":22,"timed_out":false,"_shards":{"total":6,"successful":6,"failed":0},"hits":{"total":2,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0, "_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}},{"_index":"_river","_type":"my_jdbc_river","_id":"_status","_score":1.0, "_source" : {"ok":true,"node":{"id":"QGFMld-xSISaYNqBDB5dCg","name":"Bible John","transport_address":"inet[/10.0.0.2:9301]"}}}]}}

On Tue, Jul 2, 2013 at 5:13 PM, David Pilato david@pilato.fr wrote:

Seriously? You searched for "whatever"?

Try this.

http://localhost:9200/_search?q= http://localhost:9200/_search?q=whatever*

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 12:58, Puneeth Parala babloopuneeth@gmail.com a
écrit :

http://localhost:9200/_search?q=whatever
when i tried the above thing, im getting this:-

{"took":16,"timed_out":false,"_shards":{"total":6,"successful":6,"failed":0},"hits":{"total":0,"max_score":null,"hits":}}

I cant figure out wat is this.....

On Tue, Jul 2, 2013 at 3:10 PM, David Pilato david@pilato.fr wrote:

Use search API.
http://localhost:9200/_search?q=whatever

Also, give a look at README file in elasticsearch/elasticsearch github
repository. It could help you as well.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Sir i really very new to elasticsearch... Am i correctly following the
steps till now to index and search mysql dB? I just followed that
tutorial...

On Tue, Jul 2, 2013 at 3:01 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

ya im using elasticsearch -f only....

On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <babloopuneeth@gmail.com

wrote:

ya thank you sir now im nt getting any errors... How can i know that
my mysql db is indexed??

On Tue, Jul 2, 2013 at 2:48 PM, Christian Th. chth.exensio@gmail.comwrote:

Your es node is bound to 9204 and you are trysing to curl port 9200 ?
Could this be the problem?

--
You received this message because you are subscribed to a topic in
the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

ps -ef should give you info on what is running

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 08:41, Puneeth Parala babloopuneeth@gmail.com a écrit :

How to make sure that only one node is running??

On Tue, Jul 2, 2013 at 11:21 PM, David Pilato david@pilato.fr wrote:

I have a concern about that: 10.0.0.2:9301

If you have only one node running that should be something like 10.0.0.2:9300

My advice here is:

  • make sure that you have only one node running
  • delete all: curl -XDELETE localhost:9200/
  • create again the river
  • run again the same query

If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine.

HTH

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 2 juil. 2013 à 19:23, Puneeth Parala babloopuneeth@gmail.com a écrit :

Lolz... No sir i didnt try for whatever...
http://localhost:9200/_search?q=*
When i tried this, im getting the following:-

{"took":22,"timed_out":false,"_shards":{"total":6,"successful":6,"failed":0},"hits":{"total":2,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0, "_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}},{"_index":"_river","_type":"my_jdbc_river","_id":"_status","_score":1.0, "_source" : {"ok":true,"node":{"id":"QGFMld-xSISaYNqBDB5dCg","name":"Bible John","transport_address":"inet[/10.0.0.2:9301]"}}}]}}

On Tue, Jul 2, 2013 at 5:13 PM, David Pilato david@pilato.fr wrote:

Seriously? You searched for "whatever"?

Try this.
http://localhost:9200/_search?q=*

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 12:58, Puneeth Parala babloopuneeth@gmail.com a écrit :

http://localhost:9200/_search?q=whatever
when i tried the above thing, im getting this:-

{"took":16,"timed_out":false,"_shards":{"total":6,"successful":6,"failed":0},"hits":{"total":0,"max_score":null,"hits":}}

I cant figure out wat is this.....

On Tue, Jul 2, 2013 at 3:10 PM, David Pilato david@pilato.fr wrote:

Use search API.
http://localhost:9200/_search?q=whatever

Also, give a look at README file in elasticsearch/elasticsearch github repository. It could help you as well.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala babloopuneeth@gmail.com a écrit :

Sir i really very new to elasticsearch... Am i correctly following the steps till now to index and search mysql dB? I just followed that tutorial...

On Tue, Jul 2, 2013 at 3:01 PM, Puneeth Parala babloopuneeth@gmail.com wrote:

ya im using elasticsearch -f only....

On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala babloopuneeth@gmail.com wrote:

ya thank you sir now im nt getting any errors... How can i know that my mysql db is indexed??

On Tue, Jul 2, 2013 at 2:48 PM, Christian Th. chth.exensio@gmail.com wrote:

Your es node is bound to 9204 and you are trysing to curl port 9200 ? Could this be the problem?

--
You received this message because you are subscribed to a topic in the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Sir, I made only one node running that is something like
0.0.0.0:9300http://10.0.0.2:9301/

When i run this command:-
curl -XGET 'localhost:9200/jdbc/jdbc/_search?pretty&q=*'
Im getting this:-
{
"error" : "IndexMissingException[[jdbc] missing]",
"status" : 404
}

When I run this command:-
http://localhost:9200/_search?q=*
Im getting this:-

{"took":48,"timed_out":false,"_shards":{"total":1,"successful":1,"failed":0},"hits":{"total":1,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0,
"_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}}]}}

On Wed, Jul 3, 2013 at 12:40 PM, David Pilato david@pilato.fr wrote:

ps -ef should give you info on what is running

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 08:41, Puneeth Parala babloopuneeth@gmail.com a
écrit :

How to make sure that only one node is running??

On Tue, Jul 2, 2013 at 11:21 PM, David Pilato david@pilato.fr wrote:

I have a concern about that: 10.0.0.2:9301

If you have only one node running that should be something like
10.0.0.2:9300 http://10.0.0.2:9301/

My advice here is:

  • make sure that you have only one node running
  • delete all: curl -XDELETE localhost:9200/
  • create again the river
  • run again the same query

If it does not work, check your SQL connection (login/password), run the
same query "select * from details" and check that it works fine.

HTH

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 2 juil. 2013 à 19:23, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Lolz... No sir i didnt try for whatever...

http://localhost:9200/_search?q= http://localhost:9200/_search?q=whatever*

When i tried this, im getting the following:-

{"took":22,"timed_out":false,"_shards":{"total":6,"successful":6,"failed":0},"hits":{"total":2,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0, "_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}},{"_index":"_river","_type":"my_jdbc_river","_id":"_status","_score":1.0, "_source" : {"ok":true,"node":{"id":"QGFMld-xSISaYNqBDB5dCg","name":"Bible John","transport_address":"inet[/10.0.0.2:9301]"}}}]}}

On Tue, Jul 2, 2013 at 5:13 PM, David Pilato david@pilato.fr wrote:

Seriously? You searched for "whatever"?

Try this.

http://localhost:9200/_search?q= http://localhost:9200/_search?q=whatever*

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 12:58, Puneeth Parala babloopuneeth@gmail.com a
écrit :

http://localhost:9200/_search?q=whatever
when i tried the above thing, im getting this:-

{"took":16,"timed_out":false,"_shards":{"total":6,"successful":6,"failed":0},"hits":{"total":0,"max_score":null,"hits":}}

I cant figure out wat is this.....

On Tue, Jul 2, 2013 at 3:10 PM, David Pilato david@pilato.fr wrote:

Use search API.
http://localhost:9200/_search?q=whatever

Also, give a look at README file in elasticsearch/elasticsearch github
repository. It could help you as well.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Sir i really very new to elasticsearch... Am i correctly following the
steps till now to index and search mysql dB? I just followed that
tutorial...

On Tue, Jul 2, 2013 at 3:01 PM, Puneeth Parala <babloopuneeth@gmail.com

wrote:

ya im using elasticsearch -f only....

On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <
babloopuneeth@gmail.com> wrote:

ya thank you sir now im nt getting any errors... How can i know that
my mysql db is indexed??

On Tue, Jul 2, 2013 at 2:48 PM, Christian Th. <chth.exensio@gmail.com

wrote:

Your es node is bound to 9204 and you are trysing to curl port 9200
? Could this be the problem?

--
You received this message because you are subscribed to a topic in
the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

So?

run again the same query

If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala babloopuneeth@gmail.com a écrit :

run again the same query

If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

ya actually what is that sir? Is that an error? Does my database in
indexed??

On Wed, Jul 3, 2013 at 1:17 PM, David Pilato david@pilato.fr wrote:

So?

run again the same query

If it does not work, check your SQL connection (login/password), run the
same query "select * from details" and check that it works fine.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala babloopuneeth@gmail.com a écrit
:

run again the same query

If it does not work, check your SQL connection (login/password), run the
same query "select * from details" and check that it works fine.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

I can't tell without seeing what gives a _search?q=*
But yes, your database could be indexed.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 10:21, Puneeth Parala babloopuneeth@gmail.com a écrit :

ya actually what is that sir? Is that an error? Does my database in indexed??

On Wed, Jul 3, 2013 at 1:17 PM, David Pilato david@pilato.fr wrote:
So?

run again the same query

If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala babloopuneeth@gmail.com a écrit :

run again the same query

If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine.

--
You received this message because you are subscribed to a topic in the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

ya im telling knw sir, if i giv this in my browser
http://localhost:9200/_search?q=*
im getting the following:-

{"took":2,"timed_out":false,"_shards":{"total":1,"successful":1,"failed":0},"hits":{"total":1,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0,
"_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}}]}}

On Wed, Jul 3, 2013 at 1:53 PM, David Pilato david@pilato.fr wrote:

I can't tell without seeing what gives a _search?q=*
But yes, your database could be indexed.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 10:21, Puneeth Parala babloopuneeth@gmail.com a écrit
:

ya actually what is that sir? Is that an error? Does my database in
indexed??

On Wed, Jul 3, 2013 at 1:17 PM, David Pilato david@pilato.fr wrote:

So?

run again the same query

If it does not work, check your SQL connection (login/password), run
the same query "select * from details" and check that it works fine.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala babloopuneeth@gmail.com a
écrit :

run again the same query

If it does not work, check your SQL connection (login/password), run
the same query "select * from details" and check that it works fine.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

So.

What gives: "If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine".

Could you output here an extract of: select * from details
Do you see anything in elasticsearch logs?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 10:34, Puneeth Parala babloopuneeth@gmail.com a écrit :

ya im telling knw sir, if i giv this in my browser http://localhost:9200/_search?q=*
im getting the following:-
{"took":2,"timed_out":false,"_shards":{"total":1,"successful":1,"failed":0},"hits":{"total":1,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0, "_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}}]}}

On Wed, Jul 3, 2013 at 1:53 PM, David Pilato david@pilato.fr wrote:
I can't tell without seeing what gives a _search?q=*
But yes, your database could be indexed.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 10:21, Puneeth Parala babloopuneeth@gmail.com a écrit :

ya actually what is that sir? Is that an error? Does my database in indexed??

On Wed, Jul 3, 2013 at 1:17 PM, David Pilato david@pilato.fr wrote:
So?

run again the same query

If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala babloopuneeth@gmail.com a écrit :

run again the same query

If it does not work, check your SQL connection (login/password), run the same query "select * from details" and check that it works fine.

--
You received this message because you are subscribed to a topic in the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Sir when I login the mysql server and give select * from details.. Its
working! Im getting my data...
This is my elasticsearch log..
[2013-07-03 13:55:50,562][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: initializing ...
[2013-07-03 13:55:50,572][INFO ][plugins ] [Frog-Man]
loaded [jdbc-river], sites
[2013-07-03 13:55:52,541][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: initialized
[2013-07-03 13:55:52,541][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: starting ...
[2013-07-03 13:55:52,630][INFO ][transport ] [Frog-Man]
bound_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish_address {inet[/
10.42.0.35:9300]}
[2013-07-03 13:55:55,663][INFO ][cluster.service ] [Frog-Man]
new_master [Frog-Man][qk6azmI1SPy554yr2TG_Jg][inet[/10.42.0.35:9300]],
reason: zen-disco-join (elected_as_master)
[2013-07-03 13:55:55,701][INFO ][discovery ] [Frog-Man]
elasticsearch/qk6azmI1SPy554yr2TG_Jg
[2013-07-03 13:55:55,714][INFO ][http ] [Frog-Man]
bound_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish_address {inet[/
10.42.0.35:9200]}
[2013-07-03 13:55:55,719][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: started
[2013-07-03 13:55:55,845][INFO ][gateway ] [Frog-Man]
recovered [0] indices into cluster_state
[2013-07-03 14:02:06,846][INFO ][cluster.metadata ] [Frog-Man]
[_river] creating index, cause [auto(index api)], shards [1]/[1], mappings

[2013-07-03 14:02:07,259][INFO ][cluster.metadata ] [Frog-Man]
[_river] update_mapping [my_jdbc_river] (dynamic)
[2013-07-03 14:02:07,301][INFO
][org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth] waiting
for cluster...
[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
^C[2013-07-03 14:19:00,663][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: stopping ...
[2013-07-03 14:19:00,672][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] closing JDBC river [my_jdbc_river/oneshot]
[2013-07-03 14:19:00,754][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: stopped
[2013-07-03 14:19:00,754][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: closing ...
[2013-07-03 14:19:00,773][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: closed
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ ^C
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ ^C
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ ^C
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ curl
-XPOST 'http://localhost:9200/_shutdown'
curl: (7) couldn't connect to host
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$
./bin/elasticsearch -f
[2013-07-03 14:19:19,623][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: initializing ...
[2013-07-03 14:19:19,632][INFO ][plugins ] [Garrison,
Sean] loaded [jdbc-river], sites
[2013-07-03 14:19:21,683][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: initialized
[2013-07-03 14:19:21,683][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: starting ...
[2013-07-03 14:19:21,763][INFO ][transport ] [Garrison,
Sean] bound_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish_address {inet[/
10.42.0.35:9300]}
[2013-07-03 14:19:24,808][INFO ][cluster.service ] [Garrison,
Sean] new_master [Garrison,
Sean][K0EKifMwTqaQZy0C7iPlZw][inet[/10.42.0.35:9300]], reason:
zen-disco-join (elected_as_master)
[2013-07-03 14:19:24,851][INFO ][discovery ] [Garrison,
Sean] elasticsearch/K0EKifMwTqaQZy0C7iPlZw
[2013-07-03 14:19:24,870][INFO ][http ] [Garrison,
Sean] bound_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish_address {inet[/
10.42.0.35:9200]}
[2013-07-03 14:19:24,871][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: started
[2013-07-03 14:19:25,272][INFO ][gateway ] [Garrison,
Sean] recovered [1] indices into cluster_state
[2013-07-03 14:19:25,886][INFO
][org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth] waiting
for cluster...
[2013-07-03 14:19:25,896][INFO ][river.jdbc ] [Garrison,
Sean] [jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Garrison, Sean][generic][T#1]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

On Wed, Jul 3, 2013 at 2:08 PM, David Pilato david@pilato.fr wrote:

So.

What gives: "If it does not work, check your SQL connection
(login/password), run the same query "select * from details" and check that
it works fine".

Could you output here an extract of: select * from details
Do you see anything in elasticsearch logs?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 10:34, Puneeth Parala babloopuneeth@gmail.com a écrit
:

ya im telling knw sir, if i giv this in my browser
http://localhost:9200/_search?q=*
im getting the following:-

{"took":2,"timed_out":false,"_shards":{"total":1,"successful":1,"failed":0},"hits":{"total":1,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0, "_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}}]}}

On Wed, Jul 3, 2013 at 1:53 PM, David Pilato david@pilato.fr wrote:

I can't tell without seeing what gives a _search?q=*
But yes, your database could be indexed.

--
David Pilato | Technical Advocate | *Elasticsearch.comhttp://elasticsearch.com/
*
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 10:21, Puneeth Parala babloopuneeth@gmail.com a
écrit :

ya actually what is that sir? Is that an error? Does my database in
indexed??

On Wed, Jul 3, 2013 at 1:17 PM, David Pilato david@pilato.fr wrote:

So?

run again the same query

If it does not work, check your SQL connection (login/password), run
the same query "select * from details" and check that it works fine.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala babloopuneeth@gmail.com a
écrit :

run again the same query

If it does not work, check your SQL connection (login/password), run
the same query "select * from details" and check that it works fine.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Ya sir where i should check whether my mysql connection is fine?? from
another terminal i connected to mysql server and went inside my table and
gave select * from details, i got the table... Is this correct? Or any
other way?

On Wed, Jul 3, 2013 at 2:19 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

Sir when I login the mysql server and give select * from details.. Its
working! Im getting my data...
This is my elasticsearch log..
[2013-07-03 13:55:50,562][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: initializing ...
[2013-07-03 13:55:50,572][INFO ][plugins ] [Frog-Man]
loaded [jdbc-river], sites
[2013-07-03 13:55:52,541][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: initialized
[2013-07-03 13:55:52,541][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: starting ...
[2013-07-03 13:55:52,630][INFO ][transport ] [Frog-Man]
bound_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish_address {inet[/
10.42.0.35:9300]}
[2013-07-03 13:55:55,663][INFO ][cluster.service ] [Frog-Man]
new_master [Frog-Man][qk6azmI1SPy554yr2TG_Jg][inet[/10.42.0.35:9300]],
reason: zen-disco-join (elected_as_master)
[2013-07-03 13:55:55,701][INFO ][discovery ] [Frog-Man]
elasticsearch/qk6azmI1SPy554yr2TG_Jg
[2013-07-03 13:55:55,714][INFO ][http ] [Frog-Man]
bound_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish_address {inet[/
10.42.0.35:9200]}
[2013-07-03 13:55:55,719][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: started
[2013-07-03 13:55:55,845][INFO ][gateway ] [Frog-Man]
recovered [0] indices into cluster_state
[2013-07-03 14:02:06,846][INFO ][cluster.metadata ] [Frog-Man]
[_river] creating index, cause [auto(index api)], shards [1]/[1], mappings

[2013-07-03 14:02:07,259][INFO ][cluster.metadata ] [Frog-Man]
[_river] update_mapping [my_jdbc_river] (dynamic)
[2013-07-03 14:02:07,301][INFO
][org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth] waiting
for cluster...
[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
^C[2013-07-03 14:19:00,663][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: stopping ...
[2013-07-03 14:19:00,672][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] closing JDBC river [my_jdbc_river/oneshot]
[2013-07-03 14:19:00,754][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: stopped
[2013-07-03 14:19:00,754][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: closing ...
[2013-07-03 14:19:00,773][INFO ][node ] [Frog-Man]
{0.19.10}[5758]: closed
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ ^C
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ ^C
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ ^C
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$ curl
-XPOST 'http://localhost:9200/_shutdown'
curl: (7) couldn't connect to host
babloo@babloo-HP-Pavilion-g6-Notebook-PC:~/elasticsearch-0.19.10$
./bin/elasticsearch -f
[2013-07-03 14:19:19,623][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: initializing ...
[2013-07-03 14:19:19,632][INFO ][plugins ] [Garrison,
Sean] loaded [jdbc-river], sites
[2013-07-03 14:19:21,683][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: initialized
[2013-07-03 14:19:21,683][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: starting ...
[2013-07-03 14:19:21,763][INFO ][transport ] [Garrison,
Sean] bound_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish_address {inet[/
10.42.0.35:9300]}
[2013-07-03 14:19:24,808][INFO ][cluster.service ] [Garrison,
Sean] new_master [Garrison,
Sean][K0EKifMwTqaQZy0C7iPlZw][inet[/10.42.0.35:9300]], reason:
zen-disco-join (elected_as_master)
[2013-07-03 14:19:24,851][INFO ][discovery ] [Garrison,
Sean] elasticsearch/K0EKifMwTqaQZy0C7iPlZw
[2013-07-03 14:19:24,870][INFO ][http ] [Garrison,
Sean] bound_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish_address {inet[/
10.42.0.35:9200]}
[2013-07-03 14:19:24,871][INFO ][node ] [Garrison,
Sean] {0.19.10}[6559]: started
[2013-07-03 14:19:25,272][INFO ][gateway ] [Garrison,
Sean] recovered [1] indices into cluster_state
[2013-07-03 14:19:25,886][INFO
][org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth] waiting
for cluster...
[2013-07-03 14:19:25,896][INFO ][river.jdbc ] [Garrison,
Sean] [jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Garrison, Sean][generic][T#1]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

On Wed, Jul 3, 2013 at 2:08 PM, David Pilato david@pilato.fr wrote:

So.

What gives: "If it does not work, check your SQL connection
(login/password), run the same query "select * from details" and check that
it works fine".

Could you output here an extract of: select * from details
Do you see anything in elasticsearch logs?

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 10:34, Puneeth Parala babloopuneeth@gmail.com a
écrit :

ya im telling knw sir, if i giv this in my browser
http://localhost:9200/_search?q=*
im getting the following:-

{"took":2,"timed_out":false,"_shards":{"total":1,"successful":1,"failed":0},"hits":{"total":1,"max_score":1.0,"hits":[{"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_score":1.0, "_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/bablool",
"user" : "root",
"password" : "babloo",
"sql" : "select * from details"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}}]}}

On Wed, Jul 3, 2013 at 1:53 PM, David Pilato david@pilato.fr wrote:

I can't tell without seeing what gives a _search?q=*
But yes, your database could be indexed.

--
David Pilato | Technical Advocate | *Elasticsearch.comhttp://elasticsearch.com/
*
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 10:21, Puneeth Parala babloopuneeth@gmail.com a
écrit :

ya actually what is that sir? Is that an error? Does my database in
indexed??

On Wed, Jul 3, 2013 at 1:17 PM, David Pilato david@pilato.fr wrote:

So?

run again the same query

If it does not work, check your SQL connection (login/password), run
the same query "select * from details" and check that it works fine.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala babloopuneeth@gmail.com a
écrit :

run again the same query

If it does not work, check your SQL connection (login/password), run
the same query "select * from details" and check that it works fine.

--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/fJkeJXoRrLo/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man] [jdbc][my_jdbc_river] starting JDBC river: URL [jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver], strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]" java.lang.NoSuchMethodError: org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

I see. Very old ES version. Old plugin version…

Could you start from the beginning using:
Elasticsearch 0.90.2 Elasticsearch Platform — Find real-time answers at scale | Elastic
JDBC River 2.2.0 GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala babloopuneeth@gmail.com a écrit :

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala babloopuneeth@gmail.com wrote:
By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:
There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man] [jdbc][my_jdbc_river] starting JDBC river: URL [jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver], strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]" java.lang.NoSuchMethodError: org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Really thank you sir, I think now Im getting the search. How can i make it
more advance? Is Elasticsearch compatible with php??

On Wed, Jul 3, 2013 at 2:51 PM, David Pilato david@pilato.fr wrote:

I see. Very old ES version. Old plugin version…

Could you start from the beginning using:
Elasticsearch 0.90.2 Elasticsearch Platform — Find real-time answers at scale | Elastic
JDBC River 2.2.0 GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala babloopuneeth@gmail.com a écrit
:

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

So now we can close this thread.

I recommend you to google a little for what you are trying to do.
And then ask for specific question regarding what you have done so far. Read Elasticsearch Platform — Find real-time answers at scale | Elastic

In addition to this, look at this page: Elasticsearch Platform — Find real-time answers at scale | Elastic
In the search box: enter PHP

It should help.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 11:57, Puneeth Parala babloopuneeth@gmail.com a écrit :

Really thank you sir, I think now Im getting the search. How can i make it more advance? Is Elasticsearch compatible with php??

On Wed, Jul 3, 2013 at 2:51 PM, David Pilato david@pilato.fr wrote:
I see. Very old ES version. Old plugin version…

Could you start from the beginning using:
Elasticsearch 0.90.2 Elasticsearch Platform — Find real-time answers at scale | Elastic
JDBC River 2.2.0 GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala babloopuneeth@gmail.com a écrit :

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala babloopuneeth@gmail.com wrote:
By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:
There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man] [jdbc][my_jdbc_river] starting JDBC river: URL [jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver], strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]" java.lang.NoSuchMethodError: org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

ya sure sir, thank you for helping me so much with patience... really kind
of u

On Wed, Jul 3, 2013 at 3:38 PM, David Pilato david@pilato.fr wrote:

So now we can close this thread.

I recommend you to google a little for what you are trying to do.
And then ask for specific question regarding what you have done so far.
Read Elasticsearch Platform — Find real-time answers at scale | Elastic

In addition to this, look at this page:
Elasticsearch Platform — Find real-time answers at scale | Elastic
In the search box: enter PHP

It should help.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:57, Puneeth Parala babloopuneeth@gmail.com a écrit
:

Really thank you sir, I think now Im getting the search. How can i make it
more advance? Is Elasticsearch compatible with php??

On Wed, Jul 3, 2013 at 2:51 PM, David Pilato david@pilato.fr wrote:

I see. Very old ES version. Old plugin version…

Could you start from the beginning using:
Elasticsearch 0.90.2 Elasticsearch Platform — Find real-time answers at scale | Elastic
JDBC River 2.2.0 GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch

--
David Pilato | Technical Advocate | *Elasticsearch.comhttp://elasticsearch.com/
*
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Sir im getting exactly how to query in different ways. I googled it but im
getting something like this:-

{
"query": {
"bool": {
"must": [
{
"match": {
"name.formatted": {
"query": "daniel tyrone",
"operator": "and"
}
}
},
{
"match": {
"display_name": "tyrone"
}
}
]
}
}
}

How do i test this in my browser???

On Wed, Jul 3, 2013 at 3:41 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

ya sure sir, thank you for helping me so much with patience... really kind
of u

On Wed, Jul 3, 2013 at 3:38 PM, David Pilato david@pilato.fr wrote:

So now we can close this thread.

I recommend you to google a little for what you are trying to do.
And then ask for specific question regarding what you have done so far.
Read Elasticsearch Platform — Find real-time answers at scale | Elastic

In addition to this, look at this page:
Elasticsearch Platform — Find real-time answers at scale | Elastic
In the search box: enter PHP

It should help.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:57, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Really thank you sir, I think now Im getting the search. How can i make
it more advance? Is Elasticsearch compatible with php??

On Wed, Jul 3, 2013 at 2:51 PM, David Pilato david@pilato.fr wrote:

I see. Very old ES version. Old plugin version…

Could you start from the beginning using:
Elasticsearch 0.90.2 Elasticsearch Platform — Find real-time answers at scale | Elastic
JDBC River 2.2.0 GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch

--
David Pilato | Technical Advocate | *Elasticsearch.comhttp://elasticsearch.com/
*
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ] [Frog-Man]
[jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Sorry im nt getting

On Wed, Jul 3, 2013 at 4:43 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

Sir im getting exactly how to query in different ways. I googled it but im
getting something like this:-

{
"query": {
"bool": {
"must": [
{
"match": {
"name.formatted": {
"query": "daniel tyrone",
"operator": "and"
}
}
},
{
"match": {
"display_name": "tyrone"
}
}
]
}
}
}

How do i test this in my browser???

On Wed, Jul 3, 2013 at 3:41 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

ya sure sir, thank you for helping me so much with patience... really
kind of u

On Wed, Jul 3, 2013 at 3:38 PM, David Pilato david@pilato.fr wrote:

So now we can close this thread.

I recommend you to google a little for what you are trying to do.
And then ask for specific question regarding what you have done so far.
Read Elasticsearch Platform — Find real-time answers at scale | Elastic

In addition to this, look at this page:
Elasticsearch Platform — Find real-time answers at scale | Elastic
In the search box: enter PHP

It should help.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:57, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Really thank you sir, I think now Im getting the search. How can i make
it more advance? Is Elasticsearch compatible with php??

On Wed, Jul 3, 2013 at 2:51 PM, David Pilato david@pilato.fr wrote:

I see. Very old ES version. Old plugin version…

Could you start from the beginning using:
Elasticsearch 0.90.2 Elasticsearch Platform — Find real-time answers at scale | Elastic
JDBC River 2.2.0 GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch

--
David Pilato | Technical Advocate | *Elasticsearch.comhttp://elasticsearch.com/
*
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala <babloopuneeth@gmail.com

wrote:

By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ]
[Frog-Man] [jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at
org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Hi Puneeth,

Don't want to sound harsh but this is not a chatroom or it's not a SMS that
you're writing. Try to use proper English.

And regarding your problem, as David mentioned, go through those docs
before asking questions here. Basic stuff like constructing a HTTP request
is not the part that needs to be solved in Elasticsearch mailing list.

Elasticsearch is all REST API using json. That means, you'll do http
requests to ES to execute the query. Look for "curl" on google or try
installing elasticsearch-head plugin. (Google on how to do all this).

On Wed, Jul 3, 2013 at 4:49 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

Sorry im nt getting

On Wed, Jul 3, 2013 at 4:43 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

Sir im getting exactly how to query in different ways. I googled it but
im getting something like this:-

{
"query": {
"bool": {
"must": [
{
"match": {
"name.formatted": {
"query": "daniel tyrone",
"operator": "and"
}
}
},
{
"match": {
"display_name": "tyrone"
}
}
]
}
}
}

How do i test this in my browser???

On Wed, Jul 3, 2013 at 3:41 PM, Puneeth Parala babloopuneeth@gmail.comwrote:

ya sure sir, thank you for helping me so much with patience... really
kind of u

On Wed, Jul 3, 2013 at 3:38 PM, David Pilato david@pilato.fr wrote:

So now we can close this thread.

I recommend you to google a little for what you are trying to do.
And then ask for specific question regarding what you have done so far.
Read Elasticsearch Platform — Find real-time answers at scale | Elastic

In addition to this, look at this page:
Elasticsearch Platform — Find real-time answers at scale | Elastic
In the search box: enter PHP

It should help.

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:57, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Really thank you sir, I think now Im getting the search. How can i make
it more advance? Is Elasticsearch compatible with php??

On Wed, Jul 3, 2013 at 2:51 PM, David Pilato david@pilato.fr wrote:

I see. Very old ES version. Old plugin version…

Could you start from the beginning using:
Elasticsearch 0.90.2 Elasticsearch Platform — Find real-time answers at scale | Elastic
JDBC River 2.2.0 GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch

--
David Pilato | Technical Advocate | *Elasticsearch.comhttp://elasticsearch.com/
*
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala babloopuneeth@gmail.com a
écrit :

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala <
babloopuneeth@gmail.com> wrote:

By using this command from tutorial:
./bin/plugin -url http://bit.ly/10FJhEd -install river-jdbc

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato david@pilato.fr wrote:

There is something important here:

[2013-07-03 14:02:07,308][INFO ][river.jdbc ]
[Frog-Man] [jdbc][my_jdbc_river] starting JDBC river: URL
[jdbc:mysql://localhost:3306/bablool], driver [com.mysql.jdbc.Driver],
strategy [oneshot], index [jdbc]/[jdbc]
Exception in thread "elasticsearch[Frog-Man][generic][T#4]"
java.lang.NoSuchMethodError:
org.elasticsearch.client.IndicesAdminClient.prepareExists([Ljava/lang/String;)Lorg/elasticsearch/action/admin/indices/exists/indices/IndicesExistsRequestBuilder;
at
org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth.createIndexIfNotExists(SimpleRiverMouth.java:305)
at
org.elasticsearch.river.jdbc.JDBCRiver.start(JDBCRiver.java:186)
at
org.elasticsearch.river.RiversService.createRiver(RiversService.java:146)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270)
at
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264)
at
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)

I think you are using a very old version of jdbc river, right?
How did you install the river?

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Regards,
Abhijeet Rastogi (shadyabhi)
http://blog.abhijeetr.com

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.