# Connect Mysql to elastic search **URL:** \ **Category:** Elasticsearch\ **Created:** [March 27, 2015, 12:58pm UTC](https://discuss.elastic.co/t/connect-mysql-to-elastic-search/22944 "2015-03-27T12:58:37Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Sanu\_Vimal](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Sanu\_Vimal](https://discuss.elastic.co/u/Sanu_Vimal)\ **Post date:** [March 27, 2015, 12:58pm UTC](https://discuss.elastic.co/t/connect-mysql-to-elastic-search/22944/1 "2015-03-27T12:58:37Z")
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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/2ca5de3d-c3d5-458d-b947-45459a751762%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Schmorgs1](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@Schmorgs1](https://discuss.elastic.co/u/Schmorgs1)\ **Post date:** [March 27, 2015, 1:51pm UTC](https://discuss.elastic.co/t/connect-mysql-to-elastic-search/22944/2 "2015-03-27T13:51:40Z")
Did you read the instructions at [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) 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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/f3250ab8-7aef-4959-b68e-678dcbb015ed%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Sanu\_Vimal](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Sanu\_Vimal](https://discuss.elastic.co/u/Sanu_Vimal)\ **Post date:** [April 6, 2015, 3:34am UTC](https://discuss.elastic.co/t/connect-mysql-to-elastic-search/22944/3 "2015-04-06T03:34:33Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [April 6, 2015, 7:59am UTC](https://discuss.elastic.co/t/connect-mysql-to-elastic-search/22944/4 "2015-04-06T07:59:45Z")
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](mailto: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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/37299ce1-be71-40a2-9a10-d7b3a74da239%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHH%2Bde%3Dji4F4o9rSKgi%3D2hsGrL0S%3D9JTeNqyHqxAGrDqQ%40mail.gmail.com](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](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 12:21am UTC](https://discuss.elastic.co/t/connect-mysql-to-elastic-search/22944/5 "2017-07-06T00:21:33Z")