# Plz help me! very urgent

**URL:** <https://discuss.elastic.co/t/plz-help-me-very-urgent/12612>\
**Category:** Elasticsearch\
**Created:** [July 2, 2013, 5:27am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612 "2013-07-02T05:27:55Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 6:41am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/21 "2013-07-03T06:41:38Z")

</div>

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

On Tue, Jul 2, 2013 at 11:21 PM, David Pilato [david@pilato.fr](mailto: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/](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](http://Elasticsearch.com)_  
> @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> 
> Le 2 juil. 2013 à 19:23, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a écrit  
> :
> 
> Lolz... No sir i didnt try for whatever...
> 
> [http://localhost:9200/\_search?q=](http://localhost:9200/_search?q=) [http://localhost:9200/\_search?q=whatever](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](mailto:david@pilato.fr) wrote:
> 
> > Seriously? You searched for "whatever"?
> > 
> > Try this.
> > 
> > [http://localhost:9200/\_search?q=](http://localhost:9200/_search?q=) [http://localhost:9200/\_search?q=whatever](http://localhost:9200/_search?q=whatever)\*
> > 
> > --  
> > David 😉  
> > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > 
> > Le 2 juil. 2013 à 12:58, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a  
> > écrit :
> > 
> > [http://localhost:9200/\_search?q=whatever](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](mailto:david@pilato.fr) wrote:
> > 
> > > Use search API.  
> > > [http://localhost:9200/\_search?q=whatever](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 😉  
> > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > > 
> > > Le 2 juil. 2013 à 11:33, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com)wrote:
> > > 
> > > > ya im using elasticsearch -f only....
> > > > 
> > > > On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala \<[babloopuneeth@gmail.com](mailto: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](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > > > > > 
> > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > > 
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 3, 2013, 7:10am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/22 "2013-07-03T07:10:41Z")

</div>

ps -ef should give you info on what is running

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

Le 3 juil. 2013 à 08:41, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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](http://Elasticsearch.com)  
> @dadoonet | @elasticsearchfr | @scrutmydocs
> 
> Le 2 juil. 2013 à 19:23, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a écrit :
> 
> > Lolz... No sir i didnt try for whatever...  
> > [http://localhost:9200/\_search?q=](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](mailto:david@pilato.fr) wrote:
> > 
> > > Seriously? You searched for "whatever"?
> > > 
> > > Try this.  
> > > [http://localhost:9200/\_search?q=](http://localhost:9200/_search?q=)\*
> > > 
> > > --  
> > > David 😉  
> > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > > 
> > > Le 2 juil. 2013 à 12:58, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a écrit :
> > > 
> > > > [http://localhost:9200/\_search?q=whatever](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](mailto:david@pilato.fr) wrote:
> > > > 
> > > > > Use search API.  
> > > > > [http://localhost:9200/\_search?q=whatever](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 😉  
> > > > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > > > > 
> > > > > Le 2 juil. 2013 à 11:33, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com) wrote:
> > > > > > 
> > > > > > > ya im using elasticsearch -f only....
> > > > > > > 
> > > > > > > On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > > > > > > > > 
> > > > > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > > > > > 
> > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 7:20am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/23 "2013-07-03T07:20:37Z")

</div>

Sir, I made only one node running that is something like  
0.0.0.0:9300[http://10.0.0.2:9301/](http://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=](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](mailto:david@pilato.fr) wrote:

> ps -ef should give you info on what is running
> 
> --  
> David 😉  
> Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> 
> Le 3 juil. 2013 à 08:41, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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/](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](http://Elasticsearch.com)_  
> > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > 
> > Le 2 juil. 2013 à 19:23, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a  
> > écrit :
> > 
> > Lolz... No sir i didnt try for whatever...
> > 
> > [http://localhost:9200/\_search?q=](http://localhost:9200/_search?q=) [http://localhost:9200/\_search?q=whatever](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](mailto:david@pilato.fr) wrote:
> > 
> > > Seriously? You searched for "whatever"?
> > > 
> > > Try this.
> > > 
> > > [http://localhost:9200/\_search?q=](http://localhost:9200/_search?q=) [http://localhost:9200/\_search?q=whatever](http://localhost:9200/_search?q=whatever)\*
> > > 
> > > --  
> > > David 😉  
> > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > > 
> > > Le 2 juil. 2013 à 12:58, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a  
> > > écrit :
> > > 
> > > [http://localhost:9200/\_search?q=whatever](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](mailto:david@pilato.fr) wrote:
> > > 
> > > > Use search API.  
> > > > [http://localhost:9200/\_search?q=whatever](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 😉  
> > > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > > > 
> > > > Le 2 juil. 2013 à 11:33, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com)
> > > > 
> > > > > wrote:
> > > > 
> > > > > ya im using elasticsearch -f only....
> > > > > 
> > > > > On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala \<  
> > > > > [babloopuneeth@gmail.com](mailto: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](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > > > > > > 
> > > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > > > 
> > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 3, 2013, 7:47am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/24 "2013-07-03T07:47:09Z")

</div>

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 😉  
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 3 juil. 2013 à 09:20, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 8:21am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/25 "2013-07-03T08:21:18Z")

</div>

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](mailto: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 😉  
> Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> 
> Le 3 juil. 2013 à 09:20, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 3, 2013, 8:23am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/26 "2013-07-03T08:23:20Z")

</div>

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

--  
David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com)  
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 10:21, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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 😉  
> Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> 
> Le 3 juil. 2013 à 09:20, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 8:34am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/27 "2013-07-03T08:34:55Z")

</div>

ya im telling knw sir, if i giv this in my browser  
[http://localhost:9200/\_search?q=](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](mailto: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](http://Elasticsearch.com)_  
> @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> 
> Le 3 juil. 2013 à 10:21, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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 😉  
> > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > 
> > Le 3 juil. 2013 à 09:20, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> 
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 3, 2013, 8:38am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/28 "2013-07-03T08:38:06Z")

</div>

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](http://Elasticsearch.com)  
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 10:34, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a écrit :

> ya im telling knw sir, if i giv this in my browser [http://localhost:9200/\_search?q=](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](mailto: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](http://Elasticsearch.com)  
> @dadoonet | @elasticsearchfr | @scrutmydocs
> 
> Le 3 juil. 2013 à 10:21, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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 😉  
> > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > 
> > Le 3 juil. 2013 à 09:20, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > 
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 8:49am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/29 "2013-07-03T08:49:58Z")

</div>

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](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](mailto: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](http://Elasticsearch.com)_  
> @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> 
> Le 3 juil. 2013 à 10:34, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a écrit  
> :
> 
> ya im telling knw sir, if i giv this in my browser  
> [http://localhost:9200/\_search?q=](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](mailto: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](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/)  
> > \*  
> > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > 
> > Le 3 juil. 2013 à 10:21, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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 😉  
> > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > > 
> > > Le 3 juil. 2013 à 09:20, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > 
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 8:52am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/30 "2013-07-03T08:52:09Z")

</div>

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.com](mailto:babloopuneeth@gmail.com)wrote:

> 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](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](mailto: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](http://Elasticsearch.com)_  
> > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > 
> > Le 3 juil. 2013 à 10:34, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a  
> > écrit :
> > 
> > ya im telling knw sir, if i giv this in my browser  
> > [http://localhost:9200/\_search?q=](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](mailto: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](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/)  
> > > \*  
> > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > > 
> > > Le 3 juil. 2013 à 10:21, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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 😉  
> > > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > > > 
> > > > Le 3 juil. 2013 à 09:20, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).
> > > 
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 3, 2013, 8:57am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/31 "2013-07-03T08:57:44Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 9:01am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/32 "2013-07-03T09:01:44Z")

</div>

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

On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 9:02am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/33 "2013-07-03T09:02:58Z")

</div>

Its version is 2.0.2

On Wed, Jul 3, 2013 at 2:31 PM, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com)wrote:

> By using this command from tutorial:  
> ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> 
> On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 3, 2013, 9:21am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/34 "2013-07-03T09:21:43Z")

</div>

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](http://www.elasticsearch.org/downloads/)  
JDBC River 2.2.0 [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc)

--  
David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com)  
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 11:02, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com) wrote:  
> By using this command from tutorial:  
> ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> 
> On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 9:57am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/35 "2013-07-03T09:57:24Z")

</div>

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](mailto: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](http://www.elasticsearch.org/downloads/)  
> JDBC River 2.2.0 [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc)
> 
> --  
> _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_  
> @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> 
> Le 3 juil. 2013 à 11:02, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com)wrote:
> 
> > By using this command from tutorial:  
> > ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> > 
> > On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 3, 2013, 10:08am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/36 "2013-07-03T10:08:32Z")

</div>

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](http://www.elasticsearch.org/help/)

In addition to this, look at this page: [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/)  
In the search box: enter PHP

It should help.

--  
David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com)  
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 3 juil. 2013 à 11:57, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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](http://www.elasticsearch.org/downloads/)  
> JDBC River 2.2.0 [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc)
> 
> --  
> David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com)  
> @dadoonet | @elasticsearchfr | @scrutmydocs
> 
> Le 3 juil. 2013 à 11:02, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com) wrote:  
> > By using this command from tutorial:  
> > ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> > 
> > On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 10:11am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/37 "2013-07-03T10:11:20Z")

</div>

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](mailto: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](http://www.elasticsearch.org/help/)
> 
> In addition to this, look at this page:  
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/)  
> In the search box: enter PHP
> 
> It should help.
> 
> --  
> _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_  
> @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> 
> Le 3 juil. 2013 à 11:57, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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](http://www.elasticsearch.org/downloads/)  
> > JDBC River 2.2.0 [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc)
> > 
> > --  
> > _David Pilato_ | _Technical Advocate_ | \*[Elasticsearch.com](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/)  
> > \*  
> > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > 
> > Le 3 juil. 2013 à 11:02, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com)wrote:
> > 
> > > By using this command from tutorial:  
> > > ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> > > 
> > > On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 11:13am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/38 "2013-07-03T11:13:37Z")

</div>

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.com](mailto:babloopuneeth@gmail.com)wrote:

> 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](mailto: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](http://www.elasticsearch.org/help/)
> > 
> > In addition to this, look at this page:  
> > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/)  
> > In the search box: enter PHP
> > 
> > It should help.
> > 
> > --  
> > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_  
> > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > 
> > Le 3 juil. 2013 à 11:57, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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](http://www.elasticsearch.org/downloads/)  
> > > JDBC River 2.2.0 [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc)
> > > 
> > > --  
> > > _David Pilato_ | _Technical Advocate_ | \*[Elasticsearch.com](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/)  
> > > \*  
> > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > > 
> > > Le 3 juil. 2013 à 11:02, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com)wrote:
> > > 
> > > > By using this command from tutorial:  
> > > > ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> > > > 
> > > > On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\
**Post date:** [July 3, 2013, 11:19am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/39 "2013-07-03T11:19:20Z")

</div>

Sorry im nt getting

On Wed, Jul 3, 2013 at 4:43 PM, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com)wrote:

> 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.com](mailto:babloopuneeth@gmail.com)wrote:
> 
> > 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](mailto: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](http://www.elasticsearch.org/help/)
> > > 
> > > In addition to this, look at this page:  
> > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/)  
> > > In the search box: enter PHP
> > > 
> > > It should help.
> > > 
> > > --  
> > > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_  
> > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > > 
> > > Le 3 juil. 2013 à 11:57, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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](http://www.elasticsearch.org/downloads/)  
> > > > JDBC River 2.2.0 [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc)
> > > > 
> > > > --  
> > > > _David Pilato_ | _Technical Advocate_ | \*[Elasticsearch.com](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/)  
> > > > \*  
> > > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > > > 
> > > > Le 3 juil. 2013 à 11:02, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com)
> > > > 
> > > > > wrote:
> > > > 
> > > > > By using this command from tutorial:  
> > > > > ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> > > > > 
> > > > > On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![shadyabhi](https://avatars.discourse-cdn.com/v4/letter/s/edb3f5/32.png) [@shadyabhi](https://discuss.elastic.co/u/shadyabhi)\
**Post date:** [July 3, 2013, 3:21pm UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/40 "2013-07-03T15:21:15Z")

</div>

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.com](mailto:babloopuneeth@gmail.com)wrote:

> Sorry im nt getting
> 
> On Wed, Jul 3, 2013 at 4:43 PM, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com)wrote:
> 
> > 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.com](mailto:babloopuneeth@gmail.com)wrote:
> > 
> > > 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](mailto: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](http://www.elasticsearch.org/help/)
> > > > 
> > > > In addition to this, look at this page:  
> > > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/)  
> > > > In the search box: enter PHP
> > > > 
> > > > It should help.
> > > > 
> > > > --  
> > > > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_  
> > > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > > > 
> > > > Le 3 juil. 2013 à 11:57, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto: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](http://www.elasticsearch.org/downloads/)  
> > > > > JDBC River 2.2.0 [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc)
> > > > > 
> > > > > --  
> > > > > _David Pilato_ | _Technical Advocate_ | \*[Elasticsearch.com](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/)  
> > > > > \*  
> > > > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr)  
> > > > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs)
> > > > > 
> > > > > Le 3 juil. 2013 à 11:02, Puneeth Parala [babloopuneeth@gmail.com](mailto: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](mailto:babloopuneeth@gmail.com)\> wrote:
> > > > > 
> > > > > > By using this command from tutorial:  
> > > > > > ./bin/plugin -url [http://bit.ly/10FJhEd](http://bit.ly/10FJhEd) -install river-jdbc
> > > > > > 
> > > > > > On Wed, Jul 3, 2013 at 2:27 PM, David Pilato [david@pilato.fr](mailto: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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/groups/opt\_out](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

--  
Regards,  
Abhijeet Rastogi (shadyabhi)  
[http://blog.abhijeetr.com](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](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

[Previous page](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612.md?page=1)

[Next page](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612.md?page=3)
