# ElasticSearch JDBC River plugin not working **URL:** \ **Category:** Elasticsearch\ **Created:** [December 22, 2014, 6:19am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348 "2014-12-22T06:19:39Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Ashutosh\_Parab](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@Ashutosh\_Parab](https://discuss.elastic.co/u/Ashutosh_Parab)\ **Post date:** [December 22, 2014, 6:19am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/1 "2014-12-22T06:19:39Z")
I am fairly new to ElasticSearch and what I want to achieve is to load a database from MSSql server into ElasticSearch. After reading some material online, I found out that I require JDBC River plugin to achieve it. I have followed the below steps for installing it I am installing it on _Windows Xp_.:- 1. Download and unzip ElasticSearch (version 1.0.1) 2. Download the elasticsearch-jdbc-river.zip plugin from github. (link [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc)) 3. Download the Microsoft JDBC driver and paste sqljdbc4.jar into lib folder of ElasticSearch directory. 4. Run elasticsearch.bat 5. Go to url : [http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta) to check the river There i got the following error: {"error":"IndexMissingException[[\_river] missing]","status":404} So my question is am I missing something ? Following is my elasticsearch log contents:- [2014-12-22 11:37:28,376][INFO][node] [LDN] version[1.0.1], pid[2216], build[5c03844/2014-02-25T15:52:53Z] [2014-12-22 11:37:28,376][INFO][node] [LDN] initializing ... [2014-12-22 11:37:28,392][INFO][plugins] [LDN] loaded [], sites [] [2014-12-22 11:37:32,970][INFO][node] [LDN] initialized [2014-12-22 11:37:32,970][INFO][node] [LDN] starting ... [2014-12-22 11:37:33,329][INFO][transport] [LDN] bound\_address {inet[/0.0.0.0:9300]}, publish\_address {inet[/10.90.66.186:9300]} [2014-12-22 11:37:36,564][INFO][cluster.service] [LDN] new\_master [LDN][acTCcSLyTV-GAAV1EIC5xg][ldn][inet[/10.90.66.186:9300]], reason: zen-disco-join (elected\_as\_master) [2014-12-22 11:37:36,626][INFO][discovery] [LDN] indiana/acTCcSLyTV-GAAV1EIC5xg [2014-12-22 11:37:36,767][INFO][http] [LDN] bound\_address {inet[/0.0.0.0:9200]}, publish\_address {inet[/10.90.66.186:9200]} [2014-12-22 11:37:37,830][INFO][gateway] [LDN] recovered [2] indices into cluster\_state [2014-12-22 11:37:37,830][INFO][node] [LDN] started Please help . -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Jason\_Zhang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jason_zhang/32/745_2.png) [@Jason\_Zhang](https://discuss.elastic.co/u/Jason_Zhang)\ **Post date:** [December 22, 2014, 6:55am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/2 "2014-12-22T06:55:06Z")
localhost:9200/\_river/my\_jdbc\_river/\_meta tells jdbc how to fetch data from mysql. You need to post configs in it first. On Sun 21.21.14 22:19, Ashutosh Parab wrote: > I am fairly new to Elasticsearch and what I want to achieve is to load a > database from MSSql server into Elasticsearch. After reading some material > online, I found out that I require JDBC River plugin to achieve it. I have > followed the below steps for installing it I am installing it on _Windows > Xp_.:- > > 1. Download and unzip Elasticsearch (version 1.0.1) > 2. Download the elasticsearch-jdbc-river.zip plugin from github. (link > [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc)) > 3. Download the Microsoft JDBC driver and paste sqljdbc4.jar into lib > folder of Elasticsearch directory. > 4. Run elasticsearch.bat > 5. Go to url : [http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta) to check > the river > > There i got the following error: > > {"error":"IndexMissingException[[\_river] missing]","status":404} > > So my question is am I missing something ? > > Following is my elasticsearch log contents:- > > [2014-12-22 11:37:28,376][INFO][node] [LDN] version[1.0.1], pid[2216], build[5c03844/2014-02-25T15:52:53Z] > [2014-12-22 11:37:28,376][INFO][node] [LDN] initializing ... > [2014-12-22 11:37:28,392][INFO][plugins] [LDN] loaded , sites > [2014-12-22 11:37:32,970][INFO][node] [LDN] initialized > [2014-12-22 11:37:32,970][INFO][node] [LDN] starting ... > [2014-12-22 11:37:33,329][INFO][transport] [LDN] bound\_address {inet[/0.0.0.0:9300]}, publish\_address {inet[/10.90.66.186:9300]} > [2014-12-22 11:37:36,564][INFO][cluster.service] [LDN] new\_master [LDN][acTCcSLyTV-GAAV1EIC5xg][ldn][inet[/10.90.66.186:9300]], reason: zen-disco-join (elected\_as\_master) > [2014-12-22 11:37:36,626][INFO][discovery] [LDN] indiana/acTCcSLyTV-GAAV1EIC5xg > [2014-12-22 11:37:36,767][INFO][http] [LDN] bound\_address {inet[/0.0.0.0:9200]}, publish\_address {inet[/10.90.66.186:9200]} > [2014-12-22 11:37:37,830][INFO][gateway] [LDN] recovered [2] indices into cluster\_state > [2014-12-22 11:37:37,830][INFO][node] [LDN] started > > Please help . > > -- > 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). > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/20141222065506.GA19441%40Lain.routerbf573c.com](https://groups.google.com/d/msgid/elasticsearch/20141222065506.GA19441%40Lain.routerbf573c.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Ashutosh\_Parab](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@Ashutosh\_Parab](https://discuss.elastic.co/u/Ashutosh_Parab)\ **Post date:** [December 22, 2014, 6:59am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/3 "2014-12-22T06:59:07Z")
How to do that? On Monday, 22 December 2014 11:49:39 UTC+5:30, Ashutosh Parab wrote: > I am fairly new to Elasticsearch and what I want to achieve is to load a > database from MSSql server into Elasticsearch. After reading some material > online, I found out that I require JDBC River plugin to achieve it. I have > followed the below steps for installing it I am installing it on _Windows > Xp_.:- > > 1. Download and unzip Elasticsearch (version 1.0.1) > 2. Download the elasticsearch-jdbc-river.zip plugin from github. (link > [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc)) > 3. Download the Microsoft JDBC driver and paste sqljdbc4.jar into lib > folder of Elasticsearch directory. > 4. Run elasticsearch.bat > 5. Go to url : [http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta) to check > the river > > There i got the following error: > > {"error":"IndexMissingException[[\_river] missing]","status":404} > > So my question is am I missing something ? > > Following is my elasticsearch log contents:- > > [2014-12-22 11:37:28,376][INFO][node] [LDN] version[1.0.1], pid[2216], build[5c03844/2014-02-25T15:52:53Z] > [2014-12-22 11:37:28,376][INFO][node] [LDN] initializing ... > [2014-12-22 11:37:28,392][INFO][plugins] [LDN] loaded , sites > [2014-12-22 11:37:32,970][INFO][node] [LDN] initialized > [2014-12-22 11:37:32,970][INFO][node] [LDN] starting ... > [2014-12-22 11:37:33,329][INFO][transport] [LDN] bound\_address {inet[/0.0.0.0:9300]}, publish\_address {inet[/10.90.66.186:9300]} > [2014-12-22 11:37:36,564][INFO][cluster.service] [LDN] new\_master [LDN][acTCcSLyTV-GAAV1EIC5xg][ldn][inet[/10.90.66.186:9300]], reason: zen-disco-join (elected\_as\_master) > [2014-12-22 11:37:36,626][INFO][discovery] [LDN] indiana/acTCcSLyTV-GAAV1EIC5xg > [2014-12-22 11:37:36,767][INFO][http] [LDN] bound\_address {inet[/0.0.0.0:9200]}, publish\_address {inet[/10.90.66.186:9200]} > [2014-12-22 11:37:37,830][INFO][gateway] [LDN] recovered [2] indices into cluster\_state > [2014-12-22 11:37:37,830][INFO][node] [LDN] started > > Please help . -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/24bc6de2-ae36-4f73-a34a-9855b83652a9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/24bc6de2-ae36-4f73-a34a-9855b83652a9%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Ashutosh\_Parab](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@Ashutosh\_Parab](https://discuss.elastic.co/u/Ashutosh_Parab)\ **Post date:** [December 22, 2014, 6:59am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/4 "2014-12-22T06:59:43Z")
How to do that? On Monday, 22 December 2014 12:25:20 UTC+5:30, Jason Zhang wrote: > localhost:9200/\_river/my\_jdbc\_river/\_meta tells jdbc how to fetch data > from mysql. > > You need to post configs in it first. > > On Sun 21.21.14 22:19, Ashutosh Parab wrote: > > > I am fairly new to Elasticsearch and what I want to achieve is to load a > > database from MSSql server into Elasticsearch. After reading some > > material > > online, I found out that I require JDBC River plugin to achieve it. I > > have > > followed the below steps for installing it I am installing it on > > _Windows > > Xp_.:- > > > > 1. Download and unzip Elasticsearch (version 1.0.1) > > 2. Download the elasticsearch-jdbc-river.zip plugin from github. (link > > [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc)) > > 3. Download the Microsoft JDBC driver and paste sqljdbc4.jar into lib > > folder of Elasticsearch directory. > > 4. Run elasticsearch.bat > > 5. Go to url : [http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta) to > > check > > the river > > > > There i got the following error: > > > > {"error":"IndexMissingException[[\_river] missing]","status":404} > > > > So my question is am I missing something ? > > > > Following is my elasticsearch log contents:- > > > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > version[1.0.1], pid[2216], build[5c03844/2014-02-25T15:52:53Z] > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > initializing ... > > [2014-12-22 11:37:28,392][INFO][plugins] [LDN] loaded > > , sites > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > initialized > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > starting ... > > [2014-12-22 11:37:33,329][INFO][transport] [LDN] > > bound\_address {inet[/0.0.0.0:9300]}, publish\_address {inet[/ > > 10.90.66.186:9300]} > > [2014-12-22 11:37:36,564][INFO][cluster.service] [LDN] > > new\_master [LDN][acTCcSLyTV-GAAV1EIC5xg][ldn][inet[/10.90.66.186:9300]], > > reason: zen-disco-join (elected\_as\_master) > > [2014-12-22 11:37:36,626][INFO][discovery] [LDN] > > indiana/acTCcSLyTV-GAAV1EIC5xg > > [2014-12-22 11:37:36,767][INFO][http] [LDN] > > bound\_address {inet[/0.0.0.0:9200]}, publish\_address {inet[/ > > 10.90.66.186:9200]} > > [2014-12-22 11:37:37,830][INFO][gateway] [LDN] > > recovered [2] indices into cluster\_state > > [2014-12-22 11:37:37,830][INFO][node] [LDN] > > started > > > > Please help . > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Jason\_Zhang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jason_zhang/32/745_2.png) [@Jason\_Zhang](https://discuss.elastic.co/u/Jason_Zhang)\ **Post date:** [December 22, 2014, 7:06am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/5 "2014-12-22T07:06:32Z")
Here is the manual, then `curl -XPOST` to the \_meta. > **[GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-jdbc#overview-about-the-default-parameter-settings)** > > JDBC importer for Elasticsearch. Contribute to jprante/elasticsearch-jdbc development by creating an account on GitHub. On Sun 21.21.14 22:59, Ashutosh Parab wrote: > How to do that? > > On Monday, 22 December 2014 12:25:20 UTC+5:30, Jason Zhang wrote: > > > localhost:9200/\_river/my\_jdbc\_river/\_meta tells jdbc how to fetch data > > from mysql. > > > > You need to post configs in it first. > > > > On Sun 21.21.14 22:19, Ashutosh Parab wrote: > > > > > I am fairly new to Elasticsearch and what I want to achieve is to load a > > > database from MSSql server into Elasticsearch. After reading some > > > material > > > online, I found out that I require JDBC River plugin to achieve it. I > > > have > > > followed the below steps for installing it I am installing it on > > > _Windows > > > Xp_.:- > > > > > > 1. Download and unzip Elasticsearch (version 1.0.1) > > > 2. Download the elasticsearch-jdbc-river.zip plugin from github. (link > > > [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc)) > > > 3. Download the Microsoft JDBC driver and paste sqljdbc4.jar into lib > > > folder of Elasticsearch directory. > > > 4. Run elasticsearch.bat > > > 5. Go to url : [http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta) to > > > check > > > the river > > > > > > There i got the following error: > > > > > > {"error":"IndexMissingException[[\_river] missing]","status":404} > > > > > > So my question is am I missing something ? > > > > > > Following is my elasticsearch log contents:- > > > > > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > > version[1.0.1], pid[2216], build[5c03844/2014-02-25T15:52:53Z] > > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > > initializing ... > > > [2014-12-22 11:37:28,392][INFO][plugins] [LDN] loaded > > > , sites > > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > > initialized > > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > > starting ... > > > [2014-12-22 11:37:33,329][INFO][transport] [LDN] > > > bound\_address {inet[/0.0.0.0:9300]}, publish\_address {inet[/ > > > 10.90.66.186:9300]} > > > [2014-12-22 11:37:36,564][INFO][cluster.service] [LDN] > > > new\_master [LDN][acTCcSLyTV-GAAV1EIC5xg][ldn][inet[/10.90.66.186:9300]], > > > reason: zen-disco-join (elected\_as\_master) > > > [2014-12-22 11:37:36,626][INFO][discovery] [LDN] > > > indiana/acTCcSLyTV-GAAV1EIC5xg > > > [2014-12-22 11:37:36,767][INFO][http] [LDN] > > > bound\_address {inet[/0.0.0.0:9200]}, publish\_address {inet[/ > > > 10.90.66.186:9200]} > > > [2014-12-22 11:37:37,830][INFO][gateway] [LDN] > > > recovered [2] indices into cluster\_state > > > [2014-12-22 11:37:37,830][INFO][node] [LDN] > > > started > > > > > > Please help . > > > > > > -- > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > To view this discussion on the web visit > > > [https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com). > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > -- > 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). > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/20141222070632.GA6052%40Lain.routerbf573c.com](https://groups.google.com/d/msgid/elasticsearch/20141222070632.GA6052%40Lain.routerbf573c.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Ashutosh\_Parab](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@Ashutosh\_Parab](https://discuss.elastic.co/u/Ashutosh_Parab)\ **Post date:** [December 22, 2014, 7:50am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/6 "2014-12-22T07:50:43Z")
Thanks Jason. But How can the curl command be used on Windows? I am relatively new to these commands so any help is much appreciated. On Monday, 22 December 2014 12:36:42 UTC+5:30, Jason Zhang wrote: > Here is the manual, then `curl -XPOST` to the \_meta. > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc#overview-about-the-default-parameter-settings) > > On Sun 21.21.14 22:59, Ashutosh Parab wrote: > > > How to do that? > > > > On Monday, 22 December 2014 12:25:20 UTC+5:30, Jason Zhang wrote: > > > > > localhost:9200/\_river/my\_jdbc\_river/\_meta tells jdbc how to fetch data > > > from mysql. > > > > > > You need to post configs in it first. > > > > > > On Sun 21.21.14 22:19, Ashutosh Parab wrote: > > > > > > > I am fairly new to Elasticsearch and what I want to achieve is to > > > > load a > > > > database from MSSql server into Elasticsearch. After reading some > > > > material > > > > online, I found out that I require JDBC River plugin to achieve it. > > > > I > > > > have > > > > followed the below steps for installing it I am installing it on > > > > _Windows > > > > Xp_.:- > > > > > > > > 1. Download and unzip Elasticsearch (version 1.0.1) > > > > 2. Download the elasticsearch-jdbc-river.zip plugin from github. > > > > (link > > > > [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc)) > > > > 3. Download the Microsoft JDBC driver and paste sqljdbc4.jar into > > > > lib > > > > folder of Elasticsearch directory. > > > > 4. Run elasticsearch.bat > > > > 5. Go to url : [http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta) to > > > > check > > > > the river > > > > > > > > There i got the following error: > > > > > > > > {"error":"IndexMissingException[[\_river] missing]","status":404} > > > > > > > > So my question is am I missing something ? > > > > > > > > Following is my elasticsearch log contents:- > > > > > > > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > > > version[1.0.1], pid[2216], build[5c03844/2014-02-25T15:52:53Z] > > > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > > > initializing ... > > > > [2014-12-22 11:37:28,392][INFO][plugins] [LDN] > > > > loaded > > > > , sites > > > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > > > initialized > > > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > > > starting ... > > > > [2014-12-22 11:37:33,329][INFO][transport] [LDN] > > > > bound\_address {inet[/0.0.0.0:9300]}, publish\_address {inet[/ > > > > 10.90.66.186:9300]} > > > > [2014-12-22 11:37:36,564][INFO][cluster.service] [LDN] > > > > new\_master > > > > [LDN][acTCcSLyTV-GAAV1EIC5xg][ldn][inet[/10.90.66.186:9300]], > > > > reason: zen-disco-join (elected\_as\_master) > > > > [2014-12-22 11:37:36,626][INFO][discovery] [LDN] > > > > indiana/acTCcSLyTV-GAAV1EIC5xg > > > > [2014-12-22 11:37:36,767][INFO][http] [LDN] > > > > bound\_address {inet[/0.0.0.0:9200]}, publish\_address {inet[/ > > > > 10.90.66.186:9200]} > > > > [2014-12-22 11:37:37,830][INFO][gateway] [LDN] > > > > recovered [2] indices into cluster\_state > > > > [2014-12-22 11:37:37,830][INFO][node] [LDN] > > > > started > > > > > > > > Please help . > > > > > > > > -- > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com). > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > -- > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com). > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/ff9501a2-f32c-4bcd-9e19-345425415ccf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/ff9501a2-f32c-4bcd-9e19-345425415ccf%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Beatrix\_Willius](https://avatars.discourse-cdn.com/v4/letter/b/3d9bf3/32.png) [@Beatrix\_Willius](https://discuss.elastic.co/u/Beatrix_Willius)\ **Post date:** [December 22, 2014, 7:58am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/7 "2014-12-22T07:58:56Z")
You head over to [curl - Download](http://curl.haxx.se/download.html) [http://curl.haxx.se/download.html](http://curl.haxx.se/download.html) and download the relevant package for your OS version. They've also got docs on the website on how to use curl. HTH > On 22.12.2014, at 08:50, Ashutosh Parab \<[ashusheva@gmail.com](mailto:ashusheva@gmail.com) [mailto:ashusheva@gmail.com](mailto:ashusheva@gmail.com)\> wrote: > > Thanks Jason. But How can the curl command be used on Windows? I am relatively new to these commands so any help is much appreciated. Mit freundlichen Grüßen/Regards Trixi Willius [http://www.mothsoftware.com](http://www.mothsoftware.com) [http://www.mothsoftware.com/](http://www.mothsoftware.com/) Mail Archiver X: The email archiving solution for professionals -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/284F2797-912C-4C77-BEBA-D72172B724A0%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/284F2797-912C-4C77-BEBA-D72172B724A0%40gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Jason\_Zhang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jason_zhang/32/745_2.png) [@Jason\_Zhang](https://discuss.elastic.co/u/Jason_Zhang)\ **Post date:** [December 22, 2014, 8:02am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/8 "2014-12-22T08:02:04Z")
Install cygwin or download curl binary from here [http://curl.haxx.se/dlwiz/?type=bin&os=Win64&flav=MinGW64](http://curl.haxx.se/dlwiz/?type=bin&os=Win64&flav=MinGW64) BTW, git for windows also get curl for you > On Sun 21.21.14 23:50, Ashutosh Parab wrote: > Thanks Jason. But How can the curl command be used on Windows? I am > relatively new to these commands so any help is much appreciated. > > On Monday, 22 December 2014 12:36:42 UTC+5:30, Jason Zhang wrote: > > > Here is the manual, then `curl -XPOST` to the \_meta. > > > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc#overview-about-the-default-parameter-settings) > > > > On Sun 21.21.14 22:59, Ashutosh Parab wrote: > > > > > How to do that? > > > > > > On Monday, 22 December 2014 12:25:20 UTC+5:30, Jason Zhang wrote: > > > > > > > localhost:9200/\_river/my\_jdbc\_river/\_meta tells jdbc how to fetch data > > > > from mysql. > > > > > > > > You need to post configs in it first. > > > > > > > > On Sun 21.21.14 22:19, Ashutosh Parab wrote: > > > > > > > > > I am fairly new to Elasticsearch and what I want to achieve is to > > > > > load a > > > > > database from MSSql server into Elasticsearch. After reading some > > > > > material > > > > > online, I found out that I require JDBC River plugin to achieve it. > > > > > I > > > > > have > > > > > followed the below steps for installing it I am installing it on > > > > > _Windows > > > > > Xp_.:- > > > > > > > > > > 1. Download and unzip Elasticsearch (version 1.0.1) > > > > > 2. Download the elasticsearch-jdbc-river.zip plugin from github. > > > > > (link > > > > > [https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc)) > > > > > 3. Download the Microsoft JDBC driver and paste sqljdbc4.jar into > > > > > lib > > > > > folder of Elasticsearch directory. > > > > > 4. Run elasticsearch.bat > > > > > 5. Go to url : [http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta) to > > > > > check > > > > > the river > > > > > > > > > > There i got the following error: > > > > > > > > > > {"error":"IndexMissingException[[\_river] missing]","status":404} > > > > > > > > > > So my question is am I missing something ? > > > > > > > > > > Following is my elasticsearch log contents:- > > > > > > > > > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > > > > version[1.0.1], pid[2216], build[5c03844/2014-02-25T15:52:53Z] > > > > > [2014-12-22 11:37:28,376][INFO][node] [LDN] > > > > > initializing ... > > > > > [2014-12-22 11:37:28,392][INFO][plugins] [LDN] > > > > > loaded > > > > > , sites > > > > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > > > > initialized > > > > > [2014-12-22 11:37:32,970][INFO][node] [LDN] > > > > > starting ... > > > > > [2014-12-22 11:37:33,329][INFO][transport] [LDN] > > > > > bound\_address {inet[/0.0.0.0:9300]}, publish\_address {inet[/ > > > > > 10.90.66.186:9300]} > > > > > [2014-12-22 11:37:36,564][INFO][cluster.service] [LDN] > > > > > new\_master > > > > > [LDN][acTCcSLyTV-GAAV1EIC5xg][ldn][inet[/10.90.66.186:9300]], > > > > > reason: zen-disco-join (elected\_as\_master) > > > > > [2014-12-22 11:37:36,626][INFO][discovery] [LDN] > > > > > indiana/acTCcSLyTV-GAAV1EIC5xg > > > > > [2014-12-22 11:37:36,767][INFO][http] [LDN] > > > > > bound\_address {inet[/0.0.0.0:9200]}, publish\_address {inet[/ > > > > > 10.90.66.186:9200]} > > > > > [2014-12-22 11:37:37,830][INFO][gateway] [LDN] > > > > > recovered [2] indices into cluster\_state > > > > > [2014-12-22 11:37:37,830][INFO][node] [LDN] > > > > > started > > > > > > > > > > Please help . > > > > > > > > > > -- > > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > > > To view this discussion on the web visit > > > > [https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/f77f7a73-e6c0-4b48-872f-9911bb73c0f9%40googlegroups.com). > > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > > > -- > > > > > > -- > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > To view this discussion on the web visit > > > [https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/61a8668f-96b5-40f3-80aa-9fca100fd1c7%40googlegroups.com). > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > -- > 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). > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/ff9501a2-f32c-4bcd-9e19-345425415ccf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/ff9501a2-f32c-4bcd-9e19-345425415ccf%40googlegroups.com). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/20141222080204.GA9658%40Lain.routerbf573c.com](https://groups.google.com/d/msgid/elasticsearch/20141222080204.GA9658%40Lain.routerbf573c.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Jason\_Zhang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jason_zhang/32/745_2.png) [@Jason\_Zhang](https://discuss.elastic.co/u/Jason_Zhang)\ **Post date:** [December 22, 2014, 8:05am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/9 "2014-12-22T08:05:26Z")
If you've installed elasticsearch-head, I think you can also post \_meta in 'Any Request'. On Mon 22.22.14 08:58, Beatrix Willius wrote: > You head over to [curl - Download](http://curl.haxx.se/download.html) [http://curl.haxx.se/download.html](http://curl.haxx.se/download.html) and download the relevant package for your OS version. They've also got docs on the website on how to use curl. > > HTH > > > On 22.12.2014, at 08:50, Ashutosh Parab \<[ashusheva@gmail.com](mailto:ashusheva@gmail.com) [mailto:ashusheva@gmail.com](mailto:ashusheva@gmail.com)\> wrote: > > > > Thanks Jason. But How can the curl command be used on Windows? I am relatively new to these commands so any help is much appreciated. > > Mit freundlichen Grüßen/Regards > > Trixi Willius > > [http://www.mothsoftware.com](http://www.mothsoftware.com) [http://www.mothsoftware.com/](http://www.mothsoftware.com/) > Mail Archiver X: The email archiving solution for professionals > > -- > 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). > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/284F2797-912C-4C77-BEBA-D72172B724A0%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/284F2797-912C-4C77-BEBA-D72172B724A0%40gmail.com). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- -- 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). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/20141222080526.GA23056%40Lain.routerbf573c.com](https://groups.google.com/d/msgid/elasticsearch/20141222080526.GA23056%40Lain.routerbf573c.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 12:42am UTC](https://discuss.elastic.co/t/elasticsearch-jdbc-river-plugin-not-working/21348/10 "2017-07-06T00:42:24Z")