Connect Mysql to elastic search

Elastic Stack Elasticsearch
1

Hi

Please get me some solution to connect elastic search to my table data in
mysql.
I have installed the river jdbc plugin and have put in the mysql jar file
within the plugin /jdbc folder.
I do not know how to proceed from there. I am using a mac os.
I am relatively new to Kibana so please help

Thanks,
Sanu

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/2ca5de3d-c3d5-458d-b947-45459a751762%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

Did you read the instructions
at GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch as they covered
everything off for me (albeit I'm using Oracle)

Also note that Rivers are not strategic in Elasticsearch so you might want
to consider using this in the Feeder mode to make it more future-proof

On Friday, 27 March 2015 12:58:37 UTC, Sanu Vimal wrote:

Hi

Please get me some solution to connect Elasticsearch to my table data in
mysql.
I have installed the river jdbc plugin and have put in the mysql jar file
within the plugin /jdbc folder.
I do not know how to proceed from there. I am using a mac os.
I am relatively new to Kibana so please help

Thanks,
Sanu

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/f3250ab8-7aef-4959-b68e-678dcbb015ed%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

3

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

On Friday, March 27, 2015 at 6:28:37 PM UTC+5:30, Sanu Vimal wrote:

Hi

Please get me some solution to connect Elasticsearch to my table data in
mysql.
I have installed the river jdbc plugin and have put in the mysql jar file
within the plugin /jdbc folder.
I do not know how to proceed from there. I am using a mac os.
I am relatively new to Kibana so please help

Thanks,
Sanu

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/37299ce1-be71-40a2-9a10-d7b3a74da239%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

4

The JDBC plugin can not find the JDBC driver jar.

Put a driver jar into the plugins/jdbc folder, and check for permissions.
Do not add "all types of mysql connectors" - this will not work. Just put
exactly one driver in there.

Jörg

On Mon, Apr 6, 2015 at 5:34 AM, Sanu Vimal sanuvimal@gmail.com wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

On Friday, March 27, 2015 at 6:28:37 PM UTC+5:30, Sanu Vimal wrote:

Hi

Please get me some solution to connect Elasticsearch to my table data in
mysql.
I have installed the river jdbc plugin and have put in the mysql jar file
within the plugin /jdbc folder.
I do not know how to proceed from there. I am using a mac os.
I am relatively new to Kibana so please help

Thanks,
Sanu

--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/37299ce1-be71-40a2-9a10-d7b3a74da239%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/37299ce1-be71-40a2-9a10-d7b3a74da239%40googlegroups.com?utm_medium=email&utm_source=footer
.

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

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHH%2Bde%3Dji4F4o9rSKgi%3D2hsGrL0S%3D9JTeNqyHqxAGrDqQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.