“IndexMissingException[[jdbc] missing]”, “status” : 404

Elastic Stack Elasticsearch
1

I want to index and search mysql database using elastic search & I followed
this tutorial

elasticsearch-river-jdbchttps://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart

At first i downloaded elastic search and installed river-jdbc in its plugin
folder. then added mysql-jdbc inside
ES_HOME/elasticsearch-0.90.1/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"
}
}'

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.
For more options, visit https://groups.google.com/groups/opt_out.

2

Hello,

Do you see anything interesting in the logs?

On Thu, Jul 4, 2013 at 3:39 AM, 陈立红 qinritukou@gmail.com wrote:

I want to index and search mysql database using Elasticsearch & I
followed this tutorial

elasticsearch-river-jdbchttps://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/elasticsearch-0.90.1/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"
}
}'

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.
For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- Elasticsearch -- Solr -- Lucene

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

3

Radu,

I think it's somehow the same thread as this one: Rediriger vers Google Groupes
(same login, password and database)…

I don't understand if something was unclear.

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

Le 4 juil. 2013 à 10:56, Radu Gheorghe radu.gheorghe@sematext.com a écrit :

Hello,

Do you see anything interesting in the logs?

On Thu, Jul 4, 2013 at 3:39 AM, 陈立红 qinritukou@gmail.com wrote:
I want to index and search mysql database using Elasticsearch & I followed this tutorial

elasticsearch-river-jdbc

At first i downloaded Elasticsearch and installed river-jdbc in its plugin folder. then added mysql-jdbc inside ES_HOME/elasticsearch-0.90.1/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"
}
}'
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.
For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- Elasticsearch -- Solr -- Lucene

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

4

Thanks, David.

Now that I actually went through the whole thread, double-thanks!

On Thu, Jul 4, 2013 at 12:13 PM, David Pilato david@pilato.fr wrote:

Radu,

I think it's somehow the same thread as this one:
Rediriger vers Google Groupes
(same login, password and database)…

I don't understand if something was unclear.

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

Le 4 juil. 2013 à 10:56, Radu Gheorghe radu.gheorghe@sematext.com a
écrit :

Hello,

Do you see anything interesting in the logs?

On Thu, Jul 4, 2013 at 3:39 AM, 陈立红 qinritukou@gmail.com wrote:

I want to index and search mysql database using Elasticsearch & I
followed this tutorial

elasticsearch-river-jdbchttps://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/elasticsearch-0.90.1/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"
}
}'

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.
For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- Elasticsearch -- Solr -- Lucene

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

--
http://sematext.com/ -- Elasticsearch -- Solr -- Lucene

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