# Plz help me! very urgent **URL:** \ **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:** 1
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 5:27am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/1 "2013-07-02T05:27:55Z")
i want to index and search mysql database using elastic search & I followed this tutorial > **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc/wiki/Quickstart)** > > elasticsearch-jdbc - JDBC importer for Elasticsearch At first i downloaded elastic search and installed river-jdbc in its plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ Then started elasticsearch and Started another terminal window, and created a new JDBC river with name my\_jdbc\_river with this curl command curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{ "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" } }' im getting the following error:- {"error":"UnavailableShardsException[[\_river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[\_river][my\_jdbc\_river][\_meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} then when I run this command: curl -XGET 'localhost:9200/jdbc/jdbc/\_search?pretty&q=\*' and im getting following error: "error": "IndexMissingException[[jdbc] missing]", "status" : 404 plz help me... -- 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). ---
**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 2, 2013, 5:56am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/2 "2013-07-02T05:56:27Z")
1/ don't use this kind of title. It's difficult then to understand quickly your concern. Adding this to the title won't give you a better response time. 2/ do you see anything in elasticsearch logs? My bet is that your node did not start properly. -- David 馃槈 Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 2 juil. 2013 脿 07:27, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a 茅crit : > i want to index and search mysql database using Elasticsearch & I followed this tutorial > > [Quickstart 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) > At first i downloaded Elasticsearch and installed river-jdbc in its plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ Then started elasticsearch and Started another terminal window, and created a new JDBC river with name my\_jdbc\_river with this curl command > > curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{ > "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" > } > }' > im getting the following error:- > > {"error":"UnavailableShardsException[[\_river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[\_river][my\_jdbc\_river][\_meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} > > then when I run this command: curl -XGET 'localhost:9200/jdbc/jdbc/\_search?pretty&q=\*' > > and im getting following error: > > "error": "IndexMissingException[[jdbc] missing]", "status" : 404 > plz help me... > > -- > 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). ---
**Author:** ![Ryan\_Murfitt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ryan_murfitt/32/2261_2.png) [@Ryan\_Murfitt](https://discuss.elastic.co/u/Ryan_Murfitt)\ **Post date:** [July 2, 2013, 5:58am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/3 "2013-07-02T05:58:26Z")
"index" : { ``` "index" : "jdbc", "type" : "jdbc" } ``` You should be specifying your target index & type. Thats why it's saying 'jdbc' is missing. Create a 'details' index and, say, a 'detail' type. On Tuesday, July 2, 2013 3:27:55 PM UTC+10, Puneeth Parala wrote: > i want to index and search mysql database using Elasticsearch & I > followed this tutorial > > [Quickstart 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) > > At first i downloaded Elasticsearch and installed river-jdbc in its > plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ > Then started elasticsearch and Started another terminal window, and created > a new JDBC river with name my\_jdbc\_river with this curl command > > curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{ > "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" > } > }' > > im getting the following error:- > > {"error":"UnavailableShardsException[[\_river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[\_river][my\_jdbc\_river][\_meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} > > then when I run this command: curl -XGET > 'localhost:9200/jdbc/jdbc/\_search?pretty&q=\*' > > and im getting following error: > "error": "IndexMissingException[[jdbc] missing]", "status" : 404 > plz help me... -- 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). ---
**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 2, 2013, 7:57am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/4 "2013-07-02T07:57:13Z")
Ryan, I think that JDBC river is using index and type you specified in index.index and index.type fields. See [JDBC River parameters 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/JDBC-River-parameters) So in that case, he does not have to create a details index and detail type. My 2 cents -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 2 juil. 2013 脿 07:58, Ryan Murfitt [rmurfitt@gmail.com](mailto:rmurfitt@gmail.com) a 茅crit : > "index" : { > "index" : "jdbc", > "type" : "jdbc" > } > > You should be specifying your target index & type. Thats why it's saying 'jdbc' is missing. Create a 'details' index and, say, a 'detail' type. > > On Tuesday, July 2, 2013 3:27:55 PM UTC+10, Puneeth Parala wrote: > i want to index and search mysql database using Elasticsearch & I followed this tutorial > > [Quickstart 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) > At first i downloaded Elasticsearch and installed river-jdbc in its plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ Then started elasticsearch and Started another terminal window, and created a new JDBC river with name my\_jdbc\_river with this curl command > > curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{ > "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" > } > }' > im getting the following error:- > > {"error":"UnavailableShardsException[[\_river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[\_river][my\_jdbc\_river][\_meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} > > then when I run this command: curl -XGET 'localhost:9200/jdbc/jdbc/\_search?pretty&q=\*' > > and im getting following error: > > "error": "IndexMissingException[[jdbc] missing]", "status" : 404 > plz help me... > > -- > 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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 8:41am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/5 "2013-07-02T08:41:08Z")
Sir, now actually what changes i have to make?? Im bit unclear... On Tue, Jul 2, 2013 at 1:27 PM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > Ryan, > > I think that JDBC river is using index and type you specified in > index.index and index.type fields. > See > [JDBC River parameters 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/JDBC-River-parameters) > > So in that case, he does not have to create a details index and detail > type. > > My 2 cents > > -- > _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 脿 07:58, Ryan Murfitt [rmurfitt@gmail.com](mailto:rmurfitt@gmail.com) a 茅crit : > > "index" : { > > ``` > "index" : "jdbc", > > "type" : "jdbc" > > } > > ``` > > You should be specifying your target index & type. Thats why it's saying 'jdbc' is missing. Create a 'details' index and, say, a 'detail' type. > > On Tuesday, July 2, 2013 3:27:55 PM UTC+10, Puneeth Parala wrote: > > > i want to index and search mysql database using Elasticsearch & I > > followed this tutorial > > > > [https://github.com/jprante/ela\*\*sticsearch-river-jdbc/wiki/Qui\*\*ckstart](https://github.com/jprante/ela **sticsearch-river-jdbc/wiki/Qui** ckstart) > > > > At first i downloaded Elasticsearch and installed river-jdbc in its > > plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ > > Then started elasticsearch and Started another terminal window, and created > > a new JDBC river with name my\_jdbc\_river with this curl command > > > > curl -XPUT 'localhost:9200/_river/my_\*\*jdbc\_river/\_meta' -d '{ > > "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" > > } > > }' > > > > im getting the following error:- > > > > {"error":"\*\*UnavailableShardsException[[\_\*\*river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[_river][my\_jdbc\_river][_\*\*meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/\*\*bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} > > > > then when I run this command: curl -XGET 'localhost:9200/jdbc/jdbc/\_\*\* > > search?pretty&q=\*' > > > > and im getting following error: > > "error": "IndexMissingException[[jdbc] missing]", "status" : 404 > > plz help me... > > -- > 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). ---
**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 2, 2013, 8:43am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/6 "2013-07-02T08:43:56Z")
I said: "do you see anything in elasticsearch logs?" -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 2 juil. 2013 脿 10:41, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a 茅crit : > Sir, now actually what changes i have to make?? Im bit unclear... > > On Tue, Jul 2, 2013 at 1:27 PM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > Ryan, > > I think that JDBC river is using index and type you specified in index.index and index.type fields. > See [JDBC River parameters 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/JDBC-River-parameters) > > So in that case, he does not have to create a details index and detail type. > > My 2 cents > > -- > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > @dadoonet | @elasticsearchfr | @scrutmydocs > > Le 2 juil. 2013 脿 07:58, Ryan Murfitt [rmurfitt@gmail.com](mailto:rmurfitt@gmail.com) a 茅crit : > > > "index" : { > > "index" : "jdbc", > > "type" : "jdbc" > > } > > > > You should be specifying your target index & type. Thats why it's saying 'jdbc' is missing. Create a 'details' index and, say, a 'detail' type. > > > > On Tuesday, July 2, 2013 3:27:55 PM UTC+10, Puneeth Parala wrote: > > i want to index and search mysql database using Elasticsearch & I followed this tutorial > > > > [Quickstart 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) > > At first i downloaded Elasticsearch and installed river-jdbc in its plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ Then started elasticsearch and Started another terminal window, and created a new JDBC river with name my\_jdbc\_river with this curl command > > > > curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{ > > "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" > > } > > }' > > im getting the following error:- > > > > {"error":"UnavailableShardsException[[\_river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[\_river][my\_jdbc\_river][\_meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} > > > > then when I run this command: curl -XGET 'localhost:9200/jdbc/jdbc/\_search?pretty&q=\*' > > > > and im getting following error: > > > > "error": "IndexMissingException[[jdbc] missing]", "status" : 404 > > plz help me... > > > > -- > > 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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 8:58am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/7 "2013-07-02T08:58:36Z")
this is the log im getting when i run elasticsearch command... [2013-07-02 14:27:06,742][INFO][node] [Scanner] {0.19.8}[9800]: initializing ... [2013-07-02 14:27:06,750][INFO][plugins] [Scanner] loaded [jdbc-river], sites [head] [2013-07-02 14:27:08,604][INFO][node] [Scanner] {0.19.8}[9800]: initialized [2013-07-02 14:27:08,604][INFO][node] [Scanner] {0.19.8}[9800]: starting ... [2013-07-02 14:27:08,672][INFO][transport] [Scanner] bound\_address {inet[/0:0:0:0:0:0:0:0:9304]}, publish\_address {inet[babloo-HP-Pavilion-g6-Notebook-PC/127.0.1.1:9304]} [2013-07-02 14:27:08,687][WARN][discovery.zen.ping.multicast] [Scanner] disabled, failed to setup multicast discovery on port [54328], [babloo-HP-Pavilion-g6-Notebook-PC/127.0.1.1]: bad argument for IP\_MULTICAST\_IF: address not bound to any interface [2013-07-02 14:27:11,708][INFO][cluster.service] [Scanner] new\_master [Scanner][qQ3ssIOHS2Oua55c0tfJ7g][inet[babloo-HP-Pavilion-g6-Notebook-PC/127.0.1.1:9304]], reason: zen-disco-join (elected\_as\_master) [2013-07-02 14:27:11,757][INFO][discovery] [Scanner] elasticsearch/qQ3ssIOHS2Oua55c0tfJ7g [2013-07-02 14:27:11,781][INFO][http] [Scanner] bound\_address {inet[/0:0:0:0:0:0:0:0:9204]}, publish\_address {inet[/ 192.168.5.102:9204]} [2013-07-02 14:27:11,781][INFO][node] [Scanner] {0.19.8}[9800]: started [2013-07-02 14:27:11,928][INFO][gateway] [Scanner] recovered [0] indices into cluster\_state On Tue, Jul 2, 2013 at 2:13 PM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > I said: "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 2 juil. 2013 脿 10:41, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a 茅crit > : > > Sir, now actually what changes i have to make?? Im bit unclear... > > On Tue, Jul 2, 2013 at 1:27 PM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > > > Ryan, > > > > I think that JDBC river is using index and type you specified in > > index.index and index.type fields. > > See > > [JDBC River parameters 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/JDBC-River-parameters) > > > > So in that case, he does not have to create a details index and detail > > type. > > > > My 2 cents > > > > -- > > _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 2 juil. 2013 脿 07:58, Ryan Murfitt [rmurfitt@gmail.com](mailto:rmurfitt@gmail.com) a 茅crit : > > > > "index" : { > > > > ``` > > "index" : "jdbc", > > > > "type" : "jdbc" > > > > } > > > > ``` > > > > You should be specifying your target index & type. Thats why it's saying 'jdbc' is missing. Create a 'details' index and, say, a 'detail' type. > > > > On Tuesday, July 2, 2013 3:27:55 PM UTC+10, Puneeth Parala wrote: > > > > > i want to index and search mysql database using Elasticsearch & I > > > followed this tutorial > > > > > > [https://github.com/jprante/ela\*\*sticsearch-river-jdbc/wiki/Qui\*\*ckstart](https://github.com/jprante/ela **sticsearch-river-jdbc/wiki/Qui** ckstart) > > > > > > At first i downloaded Elasticsearch and installed river-jdbc in its > > > plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ > > > Then started elasticsearch and Started another terminal window, and created > > > a new JDBC river with name my\_jdbc\_river with this curl command > > > > > > curl -XPUT 'localhost:9200/_river/my_\*\*jdbc\_river/\_meta' -d '{ > > > "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" > > > } > > > }' > > > > > > im getting the following error:- > > > > > > {"error":"\*\*UnavailableShardsException[[\_\*\*river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[_river][my\_jdbc\_river][_\*\*meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/\*\*bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} > > > > > > then when I run this command: curl -XGET 'localhost:9200/jdbc/jdbc/\_\*\* > > > search?pretty&q=\*' > > > > > > and im getting following error: > > > "error": "IndexMissingException[[jdbc] missing]", "status" : 404 > > > plz help me... > > > > -- > > 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). ---
**Author:** ![Christian\_Th](https://avatars.discourse-cdn.com/v4/letter/c/f14d63/32.png) [@Christian\_Th](https://discuss.elastic.co/u/Christian_Th)\ **Post date:** [July 2, 2013, 9:18am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/8 "2013-07-02T09:18:37Z")
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 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). ---
**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 2, 2013, 9:24am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/9 "2013-07-02T09:24:33Z")
Sounds like you have more than one instance running (5 nodes). Guessing it from the fact you have 9204 port in use. To do tests, just run one single node. Kill other nodes. It's often better to start elasticsearch for tests using elaticsearch -f -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 2 juil. 2013 脿 10:58, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a 茅crit : > this is the log im getting when i run elasticsearch command... > [2013-07-02 14:27:06,742][INFO][node] [Scanner] {0.19.8}[9800]: initializing ... > [2013-07-02 14:27:06,750][INFO][plugins] [Scanner] loaded [jdbc-river], sites [head] > [2013-07-02 14:27:08,604][INFO][node] [Scanner] {0.19.8}[9800]: initialized > [2013-07-02 14:27:08,604][INFO][node] [Scanner] {0.19.8}[9800]: starting ... > [2013-07-02 14:27:08,672][INFO][transport] [Scanner] bound\_address {inet[/0:0:0:0:0:0:0:0:9304]}, publish\_address {inet[babloo-HP-Pavilion-g6-Notebook-PC/127.0.1.1:9304]} > [2013-07-02 14:27:08,687][WARN][discovery.zen.ping.multicast] [Scanner] disabled, failed to setup multicast discovery on port [54328], [babloo-HP-Pavilion-g6-Notebook-PC/127.0.1.1]: bad argument for IP\_MULTICAST\_IF: address not bound to any interface > [2013-07-02 14:27:11,708][INFO][cluster.service] [Scanner] new\_master [Scanner][qQ3ssIOHS2Oua55c0tfJ7g][inet[babloo-HP-Pavilion-g6-Notebook-PC/127.0.1.1:9304]], reason: zen-disco-join (elected\_as\_master) > [2013-07-02 14:27:11,757][INFO][discovery] [Scanner] elasticsearch/qQ3ssIOHS2Oua55c0tfJ7g > [2013-07-02 14:27:11,781][INFO][http] [Scanner] bound\_address {inet[/0:0:0:0:0:0:0:0:9204]}, publish\_address {inet[/192.168.5.102:9204]} > [2013-07-02 14:27:11,781][INFO][node] [Scanner] {0.19.8}[9800]: started > [2013-07-02 14:27:11,928][INFO][gateway] [Scanner] recovered [0] indices into cluster\_state > > On Tue, Jul 2, 2013 at 2:13 PM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > I said: "do you see anything in elasticsearch logs?" > > -- > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > @dadoonet | @elasticsearchfr | @scrutmydocs > > Le 2 juil. 2013 脿 10:41, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a 茅crit : > > > Sir, now actually what changes i have to make?? Im bit unclear... > > > > On Tue, Jul 2, 2013 at 1:27 PM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > > Ryan, > > > > I think that JDBC river is using index and type you specified in index.index and index.type fields. > > See [JDBC River parameters 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/JDBC-River-parameters) > > > > So in that case, he does not have to create a details index and detail type. > > > > My 2 cents > > > > -- > > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > > @dadoonet | @elasticsearchfr | @scrutmydocs > > > > Le 2 juil. 2013 脿 07:58, Ryan Murfitt [rmurfitt@gmail.com](mailto:rmurfitt@gmail.com) a 茅crit : > > > > > "index" : { > > > "index" : "jdbc", > > > "type" : "jdbc" > > > } > > > > > > You should be specifying your target index & type. Thats why it's saying 'jdbc' is missing. Create a 'details' index and, say, a 'detail' type. > > > > > > On Tuesday, July 2, 2013 3:27:55 PM UTC+10, Puneeth Parala wrote: > > > i want to index and search mysql database using Elasticsearch & I followed this tutorial > > > > > > [Quickstart 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) > > > At first i downloaded Elasticsearch and installed river-jdbc in its plugin folder. then added mysql-jdbc inside ES\_HOME/plugins/river-jdbc/ Then started elasticsearch and Started another terminal window, and created a new JDBC river with name my\_jdbc\_river with this curl command > > > > > > curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{ > > > "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" > > > } > > > }' > > > im getting the following error:- > > > > > > {"error":"UnavailableShardsException[[\_river][0] [2] shardIt, [0] active : Timeout waiting for [1m], request: index {[\_river][my\_jdbc\_river][\_meta], source[{\n "type" : "jdbc",\n "jdbc" : {\n "driver" : "com.mysql.jdbc.Driver",\n "url" : "jdbc:mysql://localhost:3306/bablool",\n "user" : "root",\n "password" : "babloo",\n "sql" : "select \* from details"\n },\n "index" : {\n "index" : "jdbc",\n "type" : "jdbc"\n }\n}]}]","status":503} > > > > > > then when I run this command: curl -XGET 'localhost:9200/jdbc/jdbc/\_search?pretty&q=\*' > > > > > > and im getting following error: > > > > > > "error": "IndexMissingException[[jdbc] missing]", "status" : 404 > > > plz help me... > > > > > > -- > > > 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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 9:29am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/10 "2013-07-02T09:29:35Z")
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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 9:31am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/11 "2013-07-02T09:31:26Z")
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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 9:33am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/12 "2013-07-02T09:33:42Z")
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). ---
**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 2, 2013, 9:34am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/13 "2013-07-02T09:34:40Z")
Why do you have 5 nodes running? -- David 馃槈 Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 2 juil. 2013 脿 11:31, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a 茅crit : > 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 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). ---
**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 2, 2013, 9:40am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/14 "2013-07-02T09:40:37Z")
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 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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 9:53am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/15 "2013-07-02T09:53:33Z")
@David: To be frank i was not knowing that... k i will kill those... On Tue, Jul 2, 2013 at 3:04 PM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > Why do you have 5 nodes running? > > -- > David 馃槈 > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > Le 2 juil. 2013 脿 11:31, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com) a > 茅crit : > > 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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 10:58am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/16 "2013-07-02T10:58:02Z")
[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). ---
**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 2, 2013, 11:43am UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/17 "2013-07-02T11:43:08Z")
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 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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 5:23pm UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/18 "2013-07-02T17:23:22Z")
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). ---
**Author:** ![Puneeth](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Puneeth](https://discuss.elastic.co/u/Puneeth)\ **Post date:** [July 2, 2013, 5:23pm UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/19 "2013-07-02T17:23:38Z")
so wat is that sir?? On Tue, Jul 2, 2013 at 10:53 PM, Puneeth Parala [babloopuneeth@gmail.com](mailto:babloopuneeth@gmail.com)wrote: > 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). ---
**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 2, 2013, 5:51pm UTC](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612/20 "2013-07-02T17:51:11Z")
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). [Next page](https://discuss.elastic.co/t/plz-help-me-very-urgent/12612.md?page=2)