Plz help me! very urgent

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

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

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

Le 2 juil. 2013 à 07:27, Puneeth Parala 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
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.
For more options, visit https://groups.google.com/groups/opt_out.

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

"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

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

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

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
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 2 juil. 2013 à 07:58, Ryan Murfitt 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
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.
For more options, visit https://groups.google.com/groups/opt_out.

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 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

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
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 2 juil. 2013 à 07:58, Ryan Murfitt 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

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.

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

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

I said: "do you see anything in elasticsearch logs?"

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

Le 2 juil. 2013 à 10:41, Puneeth Parala 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 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

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
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 2 juil. 2013 à 07:58, Ryan Murfitt 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
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.

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

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

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 wrote:

I said: "do you see anything in elasticsearch logs?"

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

Le 2 juil. 2013 à 10:41, Puneeth Parala 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 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

So in that case, he does not have to create a details index and detail
type.

My 2 cents

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

Le 2 juil. 2013 à 07:58, Ryan Murfitt 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

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.

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

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

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

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

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
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 2 juil. 2013 à 10:58, Puneeth Parala 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 wrote:
I said: "do you see anything in elasticsearch logs?"

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

Le 2 juil. 2013 à 10:41, Puneeth Parala 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 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

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
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 2 juil. 2013 à 07:58, Ryan Murfitt 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
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.

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

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

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

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

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

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

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

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

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

ya im using elasticsearch -f only....

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

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

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

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

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

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

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

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

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

ya im using elasticsearch -f only....

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

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

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

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

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

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

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

Why do you have 5 nodes running?

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

Le 2 juil. 2013 à 11:31, Puneeth Parala 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 wrote:

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

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

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

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

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

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

--
You received this message because you are subscribed to 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.

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

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

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

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

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

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

ya im using elasticsearch -f only....

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

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

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

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

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

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

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

--
You received this message because you are subscribed to 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.

@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 wrote:

Why do you have 5 nodes running?

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

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

ya im using elasticsearch -f only....

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ya im using elasticsearch -f only....

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

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

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

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

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

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

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

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

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

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

Seriously? You searched for "whatever"?

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

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

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

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

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

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

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

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

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

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

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

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

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

ya im using elasticsearch -f only....

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

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

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

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

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

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

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

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

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

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

--
You received this message because you are subscribed to 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.

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

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

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

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

Seriously? You searched for "whatever"?

Try this.

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

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

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

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

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

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

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

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

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

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

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

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

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

ya im using elasticsearch -f only....

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

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

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

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

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

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

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

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

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

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

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

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

so wat is that sir??

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

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

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

When i tried this, im getting the following:-

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

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

Seriously? You searched for "whatever"?

Try this.

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

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

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

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

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

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

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

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

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

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

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

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

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

ya im using elasticsearch -f only....

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

wrote:

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

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

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

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

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

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

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

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

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

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

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

I have a concern about that: 10.0.0.2:9301

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

My advice here is:

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

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

HTH

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

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

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

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

On Tue, Jul 2, 2013 at 5:13 PM, David Pilato david@pilato.fr wrote:
Seriously? You searched for "whatever"?

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

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

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

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

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

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

On Tue, Jul 2, 2013 at 3:10 PM, David Pilato david@pilato.fr wrote:
Use search API.
http://localhost:9200/_search?q=whatever

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

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

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

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

On Tue, Jul 2, 2013 at 3:01 PM, Puneeth Parala babloopuneeth@gmail.com wrote:
ya im using elasticsearch -f only....

On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala babloopuneeth@gmail.com wrote:
ya thank you sir now im nt getting any errors... How can i know that my mysql db is indexed??

On Tue, Jul 2, 2013 at 2:48 PM, Christian Th. chth.exensio@gmail.com wrote:
Your es node is bound to 9204 and you are trysing to curl port 9200 ? Could this be the problem?

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

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

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

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

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

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

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

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