PLZ HELP ME!! VERY URGENT

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
42 messages Options
123
Reply | Threaded
Open this post in threaded view
|

PLZ HELP ME!! VERY URGENT

Puneeth

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

https://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/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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

dadoonet
1/ don't use this kind of title. It's difficult then to understand quickly your concern.
Adding this to the title won't give you a better response time.

2/ do you see anything in elasticsearch logs? My bet is that your node did not start properly.

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 07:27, Puneeth Parala <[hidden email]> a écrit :

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

https://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/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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Ryan Murfitt
In reply to this post by Puneeth
"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 elastic search & I followed this tutorial

https://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/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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

dadoonet
Ryan,

I think that JDBC river is using index and type you specified in index.index and index.type fields.

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



Le 2 juil. 2013 à 07:58, Ryan Murfitt <[hidden email]> 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 elastic search & I followed this tutorial

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


smime.p7s (1K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
Sir, now actually what changes i have to make?? Im bit unclear...


On Tue, Jul 2, 2013 at 1:27 PM, David Pilato <[hidden email]> wrote:
Ryan,

I think that JDBC river is using index and type you specified in index.index and index.type fields.

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



Le 2 juil. 2013 à 07:58, Ryan Murfitt <[hidden email]> 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 elastic search & I followed this tutorial

https://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/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 [hidden email].

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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

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

-- 
David Pilato | Technical Advocate | Elasticsearch.com



Le 2 juil. 2013 à 10:41, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Ryan,

I think that JDBC river is using index and type you specified in index.index and index.type fields.

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



Le 2 juil. 2013 à 07:58, Ryan Murfitt <[hidden email]> 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 elastic search & I followed this tutorial

https://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/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 [hidden email].

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


smime.p7s (1K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
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 <[hidden email]> wrote:
 I said: "do you see anything in elasticsearch logs?"

-- 
David Pilato | Technical Advocate | Elasticsearch.com



Le 2 juil. 2013 à 10:41, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Ryan,

I think that JDBC river is using index and type you specified in index.index and index.type fields.

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



Le 2 juil. 2013 à 07:58, Ryan Murfitt <[hidden email]> 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 elastic search & I followed this tutorial

https://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/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 [hidden email].

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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Christian Th.
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

dadoonet
In reply to this post by Puneeth
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



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

-- 
David Pilato | Technical Advocate | Elasticsearch.com



Le 2 juil. 2013 à 10:41, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Ryan,

I think that JDBC river is using index and type you specified in index.index and index.type fields.

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



Le 2 juil. 2013 à 07:58, Ryan Murfitt <[hidden email]> 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 elastic search & I followed this tutorial

https://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/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 [hidden email].

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


smime.p7s (1K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
In reply to this post by Christian Th.
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. <[hidden email]> 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 [hidden email].

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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
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 <[hidden email]> wrote:
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

dadoonet
In reply to this post by Puneeth
Why do you have 5 nodes running?

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:31, Puneeth Parala <[hidden email]> a écrit :

ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

dadoonet
In reply to this post by Puneeth
Use search API.

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

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
In reply to this post by dadoonet
@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 <[hidden email]> wrote:
Why do you have 5 nodes running?

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:31, Puneeth Parala <[hidden email]> a écrit :

ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].

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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
In reply to this post by dadoonet

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 <[hidden email]> wrote:
Use search API.

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

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].

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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

dadoonet
Seriously? You searched for "whatever"?

Try this.

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 12:58, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Use search API.

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

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].

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 [hidden email].
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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
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 <[hidden email]> wrote:
Seriously? You searched for "whatever"?

Try this.

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 12:58, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Use search API.

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

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].

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 [hidden email].
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 [hidden email].
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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

Puneeth
so wat is that sir??


On Tue, Jul 2, 2013 at 10:53 PM, Puneeth Parala <[hidden email]> wrote:
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 <[hidden email]> wrote:
Seriously? You searched for "whatever"?

Try this.

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 12:58, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Use search API.

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

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].

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 [hidden email].
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 [hidden email].
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 [hidden email].
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 [hidden email].
For more options, visit https://groups.google.com/groups/opt_out.
 
 
Reply | Threaded
Open this post in threaded view
|

Re: PLZ HELP ME!! VERY URGENT

dadoonet
In reply to this post by Puneeth
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



Le 2 juil. 2013 à 19:23, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Seriously? You searched for "whatever"?

Try this.

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 12:58, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
Use search API.

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

--
David ;-)
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 2 juil. 2013 à 11:33, Puneeth Parala <[hidden email]> 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 <[hidden email]> wrote:
ya im using elasticsearch -f only....


On Tue, Jul 2, 2013 at 2:59 PM, Puneeth Parala <[hidden email]> 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. <[hidden email]> 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 [hidden email].

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 [hidden email].

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


smime.p7s (1K) Download Attachment
123