# Rivers Installation trouble (JDBC, Wikipedia, ...) **URL:** \ **Category:** Elasticsearch\ **Created:** [August 18, 2012, 7:20am UTC](https://discuss.elastic.co/t/rivers-installation-trouble-jdbc-wikipedia/8778 "2012-08-18T07:20:02Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Lu\_Do](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lu_do/32/2761_2.png) [@Lu\_Do](https://discuss.elastic.co/u/Lu_Do)\ **Post date:** [August 18, 2012, 7:20am UTC](https://discuss.elastic.co/t/rivers-installation-trouble-jdbc-wikipedia/8778/1 "2012-08-18T07:20:02Z")
Hello, I'll try to evaluate elasticsearch as an alternative to sphinx search. So, my first need is to replace quickly indexer provide by sphinx. JDDB was the solution but I can't get it running at all. It seems that I can't intall any rivers. The process I'll try on both ubuntu precise 64 and debian squeeze 64 : - Install SE 0.19.8 from deb package. - The server is running very quickly and working - Install a plugin head to interract with ES without using curl, the plugin is running successful. - Install jdbc rivers plugins : > bin/plugin -install jprante/elasticsearch-river-jdbc > -\> Installing jprante/elasticsearch-river-jdbc... > Trying > [https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip](https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip)... > Trying > [https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8](https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8)... > Trying > [https://github.com/jprante/elasticsearch-river-jdbc/zipball/master](https://github.com/jprante/elasticsearch-river-jdbc/zipball/master)... > Downloading .........DONE > Identified as a \_site plugin, moving to \_site structure ... > Installed river-jdbc Seems ok, install the mysql connector in /usr/share/elasticsearch/lib - Restart elasticsearch - Log output : [2012-08-18 09:02:07,867][INFO][node] [Golden Girl] {0.19.8}[17549]: initializing ... [2012-08-18 09:02:07,881][INFO][plugins] [Golden Girl]\*loaded , sites [river-jdbc, head] \* [2012-08-18 09:02:10,222][INFO][node] [Golden Girl] {0.19.8}[17549]: initialized [2012-08-18 09:02:10,223][INFO][node] [Golden Girl] {0.19.8}[17549]: starting ... [2012-08-18 09:02:10,337][INFO][transport] [Golden Girl] bound\_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish\_address {inet[/192.168.18.207:9300]} [2012-08-18 09:02:13,390][INFO][cluster.service] [Golden Girl] new\_master [Golden Girl][NeUSfo7oSmyLgqaIeMUjZA][inet[/192.168.18.207:9300]], reason: zen-disco-join (elected\_as\_master) [2012-08-18 09:02:13,470][INFO][discovery] [Golden Girl] elasticsearch/NeUSfo7oSmyLgqaIeMUjZA [2012-08-18 09:02:13,494][INFO][http] [Golden Girl] bound\_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish\_address {inet[/192.168.18.207:9200]} [2012-08-18 09:02:13,494][INFO][node] [Golden Girl] {0.19.8}[17549]: started Seems that the pluigins is loaded - Create the rivers : > curl -XPUT 'localhost:9200/\_river/test/\_meta' -d '{ > "type" : "jdbc", > "jdbc" : { > "driver" : "com.mysql.jdbc.Driver", > "url" : "jdbc:mysql://localbost:3306/article", > "user" : "es", > "password" : "es", > "sql" : "select \* from articles" > } > }' - es return un json with ok: true but the log output : [2012-08-18 09:02:14,517][WARN][river] [Golden Girl] failed to create river [jdbc][test] org.elasticsearch.common.settings.NoClassSettingsException: Failed to load class with value [jdbc] at org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:86) at org.elasticsearch.river.RiverModule.spawnModules(RiverModule.java:57) at org.elasticsearch.common.inject.ModulesBuilder.add(ModulesBuilder.java:44) at org.elasticsearch.river.RiversService.createRiver(RiversService.java:135) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264) at org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.ClassNotFoundException: jdbc at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:423) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:356) at org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:72) ... 9 more I'll try to a lot of time on different server but I can't have any other message. I'll try with wikipedia river just for try another river type the same error Failed to load class It drive me nuts since I really don't see where I failed (moreover just at the begining). I'll try to manually put some data on ES and all seems to work. Any help will be greatly appreciate. Thanks. -- ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [August 18, 2012, 8:16am UTC](https://discuss.elastic.co/t/rivers-installation-trouble-jdbc-wikipedia/8778/2 "2012-08-18T08:16:36Z")
Look at doc: [https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) bin/plugin -install jprante/elasticsearch-river-jdbc/1.3.2 You must give the version number. HTH -- David 馃槈 Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 18 ao没t 2012 脿 09:20, Lu Do [tchiot.ludo@gmail.com](mailto:tchiot.ludo@gmail.com) a 茅crit : Hello, I'll try to evaluate elasticsearch as an alternative to sphinx search. So, my first need is to replace quickly indexer provide by sphinx. JDDB was the solution but I can't get it running at all. It seems that I can't intall any rivers. The process I'll try on both ubuntu precise 64 and debian squeeze 64 : - Install SE 0.19.8 from deb package. - The server is running very quickly and working - Install a plugin head to interract with ES without using curl, the plugin is running successful. - Install jdbc rivers plugins : bin/plugin -install jprante/elasticsearch-river-jdbc -\> Installing jprante/elasticsearch-river-jdbc... Trying [https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip](https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip)... Trying [https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8](https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8)... Trying [https://github.com/jprante/elasticsearch-river-jdbc/zipball/master](https://github.com/jprante/elasticsearch-river-jdbc/zipball/master)... Downloading .........DONE Identified as a \_site plugin, moving to \_site structure ... Installed river-jdbc Seems ok, install the mysql connector in /usr/share/elasticsearch/lib - Restart elasticsearch - Log output : [2012-08-18 09:02:07,867][INFO][node] [Golden Girl] {0.19.8}[17549]: initializing ... [2012-08-18 09:02:07,881][INFO][plugins] [Golden Girl] loaded [], sites [river-jdbc, head] [2012-08-18 09:02:10,222][INFO][node] [Golden Girl] {0.19.8}[17549]: initialized [2012-08-18 09:02:10,223][INFO][node] [Golden Girl] {0.19.8}[17549]: starting ... [2012-08-18 09:02:10,337][INFO][transport] [Golden Girl] bound\_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish\_address {inet[/192.168.18.207:9300]} [2012-08-18 09:02:13,390][INFO][cluster.service] [Golden Girl] new\_master [Golden Girl][NeUSfo7oSmyLgqaIeMUjZA][inet[/192.168.18.207:9300]], reason: zen-disco-join (elected\_as\_master) [2012-08-18 09:02:13,470][INFO][discovery] [Golden Girl] elasticsearch/NeUSfo7oSmyLgqaIeMUjZA [2012-08-18 09:02:13,494][INFO][http] [Golden Girl] bound\_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish\_address {inet[/192.168.18.207:9200]} [2012-08-18 09:02:13,494][INFO][node] [Golden Girl] {0.19.8}[17549]: started Seems that the pluigins is loaded - Create the rivers : curl -XPUT 'localhost:9200/\_river/test/\_meta' -d '{ "type" : "jdbc", "jdbc" : { "driver" : "com.mysql.jdbc.Driver", "url" : "jdbc:mysql://localbost:3306/article", "user" : "es", "password" : "es", "sql" : "select \* from articles" } }' - es return un json with ok: true but the log output : [2012-08-18 09:02:14,517][WARN][river] [Golden Girl] failed to create river [jdbc][test] org.elasticsearch.common.settings.NoClassSettingsException: Failed to load class with value [jdbc] at org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:86) at org.elasticsearch.river.RiverModule.spawnModules(RiverModule.java:57) at org.elasticsearch.common.inject.ModulesBuilder.add(ModulesBuilder.java:44) at org.elasticsearch.river.RiversService.createRiver(RiversService.java:135) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264) at org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.ClassNotFoundException: jdbc at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:423) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:356) at org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:72) ... 9 more I'll try to a lot of time on different server but I can't have any other message. I'll try with wikipedia river just for try another river type the same error Failed to load class It drive me nuts since I really don't see where I failed (moreover just at the begining). I'll try to manually put some data on ES and all seems to work. Any help will be greatly appreciate. Thanks. -- -- ---
**Author:** ![Lu\_Do](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lu_do/32/2761_2.png) [@Lu\_Do](https://discuss.elastic.co/u/Lu_Do)\ **Post date:** [August 18, 2012, 8:33am UTC](https://discuss.elastic.co/t/rivers-installation-trouble-jdbc-wikipedia/8778/3 "2012-08-18T08:33:20Z")
ok ... so dumb I am... I just see that I checkout the source and not the JAR ... Thanks a lot David for your so quick response. All works now, I can play with ES Thanks On Saturday, August 18, 2012 10:16:36 AM UTC+2, David Pilato wrote: > Look at doc: > [Quickstart 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) > bin/plugin -install jprante/elasticsearch-river-jdbc/1.3.2 > > You must give the version number. > > HTH > > -- > David 馃槈 > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > Le 18 ao没t 2012 脿 09:20, Lu Do \<[tchio...@gmail.com](mailto:tchio...@gmail.com) \\> a > 茅crit : > > Hello, > > I'll try to evaluate elasticsearch as an alternative to sphinx search. > So, my first need is to replace quickly indexer provide by sphinx. > > JDDB was the solution but I can't get it running at all. > It seems that I can't intall any rivers. > > The process I'll try on both ubuntu precise 64 and debian squeeze 64 : > > - Install SE 0.19.8 from deb package. > - The server is running very quickly and working > - Install a plugin head to interract with ES without using curl, the > plugin is running successful. > - Install jdbc rivers plugins : > > > bin/plugin -install jprante/elasticsearch-river-jdbc > > -\> Installing jprante/elasticsearch-river-jdbc... > > Trying > > [https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip](https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip) > > ... > > Trying > > [https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8](https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8)... > > Trying [https://github.com/jprante/elasticsearch-river-jdbc/zipball/master](https://github.com/jprante/elasticsearch-river-jdbc/zipball/master) > > ... > > Downloading .........DONE > > Identified as a \_site plugin, moving to \_site structure ... > > Installed river-jdbc > > Seems ok, install the mysql connector in /usr/share/elasticsearch/lib > > - Restart elasticsearch > - Log output : > > [2012-08-18 09:02:07,867][INFO][node] [Golden Girl] > {0.19.8}[17549]: initializing ... > [2012-08-18 09:02:07,881][INFO][plugins] [Golden Girl]\*loaded , sites [river-jdbc, head] > \* > [2012-08-18 09:02:10,222][INFO][node] [Golden Girl] > {0.19.8}[17549]: initialized > [2012-08-18 09:02:10,223][INFO][node] [Golden Girl] > {0.19.8}[17549]: starting ... > [2012-08-18 09:02:10,337][INFO][transport] [Golden Girl] > bound\_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish\_address {inet[/ > 192.168.18.207:9300]} > [2012-08-18 09:02:13,390][INFO][cluster.service] [Golden Girl] > new\_master [Golden > Girl][NeUSfo7oSmyLgqaIeMUjZA][inet[/192.168.18.207:9300]], reason: > zen-disco-join (elected\_as\_master) > [2012-08-18 09:02:13,470][INFO][discovery] [Golden Girl] > elasticsearch/NeUSfo7oSmyLgqaIeMUjZA > [2012-08-18 09:02:13,494][INFO][http] [Golden Girl] > bound\_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish\_address {inet[/ > 192.168.18.207:9200]} > [2012-08-18 09:02:13,494][INFO][node] [Golden Girl] > {0.19.8}[17549]: started > > Seems that the pluigins is loaded > > - Create the rivers : > > > curl -XPUT 'localhost:9200/\_river/test/\_meta' -d '{ > > "type" : "jdbc", > > "jdbc" : { > > "driver" : "com.mysql.jdbc.Driver", > > "url" : "jdbc:mysql://localbost:3306/article", > > "user" : "es", > > "password" : "es", > > "sql" : "select \* from articles" > > } > > }' > > - es return un json with ok: true but the log output : > > [2012-08-18 09:02:14,517][WARN][river] [Golden Girl] > failed to create river [jdbc][test] > org.elasticsearch.common.settings.NoClassSettingsException: Failed to load > class with value [jdbc] > at > org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:86) > at > org.elasticsearch.river.RiverModule.spawnModules(RiverModule.java:57) > at > org.elasticsearch.common.inject.ModulesBuilder.add(ModulesBuilder.java:44) > at > org.elasticsearch.river.RiversService.createRiver(RiversService.java:135) > at > org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270) > at > org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264) > at > org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:722) > Caused by: java.lang.ClassNotFoundException: jdbc > at java.net.URLClassLoader$1.run(URLClassLoader.java:366) > at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:354) > at java.lang.ClassLoader.loadClass(ClassLoader.java:423) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > at java.lang.ClassLoader.loadClass(ClassLoader.java:356) > at > org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:72) > ... 9 more > > I'll try to a lot of time on different server but I can't have any other > message. > I'll try with wikipedia river just for try another river type the same > error Failed to load class > It drive me nuts since I really don't see where I failed (moreover just at > the begining). > I'll try to manually put some data on ES and all seems to work. > > Any help will be greatly appreciate. > > Thanks. > > -- -- ---
**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:** [August 18, 2012, 10:00am UTC](https://discuss.elastic.co/t/rivers-installation-trouble-jdbc-wikipedia/8778/4 "2012-08-18T10:00:58Z")
I will add this to the JDBC river install notice. It is not obvious to see that omitting the version is installing the source code for self-compiling. Best, J枚rg On Saturday, August 18, 2012 10:33:20 AM UTC+2, Lu Do wrote: > ok ... so dumb I am... > > I just see that I checkout the source and not the JAR ... > > Thanks a lot David for your so quick response. > All works now, I can play with ES > > Thanks > > On Saturday, August 18, 2012 10:16:36 AM UTC+2, David Pilato wrote: > > > Look at doc: > > [Quickstart 路 jprante/elasticsearch-jdbc Wiki 路 GitHub](https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart) > > bin/plugin -install jprante/elasticsearch-river-jdbc/1.3.2 > > > > You must give the version number. > > > > HTH > > > > -- > > David 馃槈 > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > > > Le 18 ao没t 2012 脿 09:20, Lu Do [tchio...@gmail.com](mailto:tchio...@gmail.com) a 茅crit : > > > > Hello, > > > > I'll try to evaluate elasticsearch as an alternative to sphinx search. > > So, my first need is to replace quickly indexer provide by sphinx. > > > > JDDB was the solution but I can't get it running at all. > > It seems that I can't intall any rivers. > > > > The process I'll try on both ubuntu precise 64 and debian squeeze 64 : > > > > - Install SE 0.19.8 from deb package. > > - The server is running very quickly and working > > - Install a plugin head to interract with ES without using curl, the > > plugin is running successful. > > - Install jdbc rivers plugins : > > > > > bin/plugin -install jprante/elasticsearch-river-jdbc > > > -\> Installing jprante/elasticsearch-river-jdbc... > > > Trying > > > [https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip](https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-river-jdbc-0.19.8.zip) > > > ... > > > Trying > > > [https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8](https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8)... > > > Trying > > > [https://github.com/jprante/elasticsearch-river-jdbc/zipball/master](https://github.com/jprante/elasticsearch-river-jdbc/zipball/master)... > > > Downloading .........DONE > > > Identified as a \_site plugin, moving to \_site structure ... > > > Installed river-jdbc > > > > Seems ok, install the mysql connector in /usr/share/elasticsearch/lib > > > > - Restart elasticsearch > > - Log output : > > > > [2012-08-18 09:02:07,867][INFO][node] [Golden Girl] > > {0.19.8}[17549]: initializing ... > > [2012-08-18 09:02:07,881][INFO][plugins] [Golden Girl] > > > > - loaded , sites [river-jdbc, head]\* > > [2012-08-18 09:02:10,222][INFO][node] [Golden Girl] > > {0.19.8}[17549]: initialized > > [2012-08-18 09:02:10,223][INFO][node] [Golden Girl] > > {0.19.8}[17549]: starting ... > > [2012-08-18 09:02:10,337][INFO][transport] [Golden Girl] > > bound\_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish\_address {inet[/ > > 192.168.18.207:9300]} > > [2012-08-18 09:02:13,390][INFO][cluster.service] [Golden Girl] > > new\_master [Golden > > Girl][NeUSfo7oSmyLgqaIeMUjZA][inet[/192.168.18.207:9300]], reason: > > zen-disco-join (elected\_as\_master) > > [2012-08-18 09:02:13,470][INFO][discovery] [Golden Girl] > > elasticsearch/NeUSfo7oSmyLgqaIeMUjZA > > [2012-08-18 09:02:13,494][INFO][http] [Golden Girl] > > bound\_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish\_address {inet[/ > > 192.168.18.207:9200]} > > [2012-08-18 09:02:13,494][INFO][node] [Golden Girl] > > {0.19.8}[17549]: started > > > > - Create the rivers : > > > > > curl -XPUT 'localhost:9200/\_river/test/\_meta' -d '{ > > > "type" : "jdbc", > > > "jdbc" : { > > > "driver" : "com.mysql.jdbc.Driver", > > > "url" : "jdbc:mysql://localbost:3306/article", > > > "user" : "es", > > > "password" : "es", > > > "sql" : "select \* from articles" > > > } > > > }' > > > > - es return un json with ok: true but the log output : > > > > [2012-08-18 09:02:14,517][WARN][river] [Golden Girl] > > failed to create river [jdbc][test] > > org.elasticsearch.common.settings.NoClassSettingsException: Failed to > > load class with value [jdbc] > > at > > org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:86) > > at > > org.elasticsearch.river.RiverModule.spawnModules(RiverModule.java:57) > > at > > org.elasticsearch.common.inject.ModulesBuilder.add(ModulesBuilder.java:44) > > at > > org.elasticsearch.river.RiversService.createRiver(RiversService.java:135) > > at > > org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:270) > > at > > org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:264) > > at > > org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:86) > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > > at java.lang.Thread.run(Thread.java:722) > > Caused by: java.lang.ClassNotFoundException: jdbc > > at java.net.URLClassLoader$1.run(URLClassLoader.java:366) > > at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > > at java.security.AccessController.doPrivileged(Native Method) > > at java.net.URLClassLoader.findClass(URLClassLoader.java:354) > > at java.lang.ClassLoader.loadClass(ClassLoader.java:423) > > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > > at java.lang.ClassLoader.loadClass(ClassLoader.java:356) > > at > > org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:72) > > ... 9 more > > > > I'll try to a lot of time on different server but I can't have any other > > message. > > I'll try with wikipedia river just for try another river type the same > > error Failed to load class > > It drive me nuts since I really don't see where I failed (moreover just > > at the begining). > > I'll try to manually put some data on ES and all seems to work. > > > > Any help will be greatly appreciate. > > > > Thanks. > > > > -- -- ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [August 18, 2012, 10:14am UTC](https://discuss.elastic.co/t/rivers-installation-trouble-jdbc-wikipedia/8778/5 "2012-08-18T10:14:29Z")
Yes. And I think we should update this page : [http://www.elasticsearch.org/guide/reference/modules/plugins.html](http://www.elasticsearch.org/guide/reference/modules/plugins.html) With some details on how the plugin should appear and that it鈥檚 best (mandatory?) to give the plugin version number. Only site plugins does not require version number. David. De : [elasticsearch@googlegroups.com](mailto:elasticsearch@googlegroups.com) [[mailto:elasticsearch@googlegroups.com](mailto:elasticsearch@googlegroups.com)] De la part de J枚rg Prante Envoy茅 : samedi 18 ao没t 2012 12:01 脌 : [elasticsearch@googlegroups.com](mailto:elasticsearch@googlegroups.com) Objet : Re: Rivers Installation trouble (JDBC, Wikipedia, ...) I will add this to the JDBC river install notice. It is not obvious to see that omitting the version is installing the source code for self-compiling. Best, J枚rg On Saturday, August 18, 2012 10:33:20 AM UTC+2, Lu Do wrote: ok ... so dumb I am... I just see that I checkout the source and not the JAR ... Thanks a lot David for your so quick response. All works now, I can play with ES Thanks On Saturday, August 18, 2012 10:16:36 AM UTC+2, David Pilato wrote: Look at doc: > **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc/wiki/Quickstart)** > > elasticsearch-jdbc - JDBC importer for Elasticsearch bin/plugin -install jprante/elasticsearch-river-jdbc/1.3.2 You must give the version number. HTH -- David 馃槈 Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 18 ao没t 2012 脿 09:20, Lu Do [tchio...@gmail.com](mailto:tchio...@gmail.com) a 茅crit : Hello, I'll try to evaluate elasticsearch as an alternative to sphinx search. So, my first need is to replace quickly indexer provide by sphinx. JDDB was the solution but I can't get it running at all. It seems that I can't intall any rivers. The process I'll try on both ubuntu precise 64 and debian squeeze 64 : - Install SE 0.19.8 from deb package. - The server is running very quickly and working - Install a plugin head to interract with ES without using curl, the plugin is running successful. - Install jdbc rivers plugins : bin/plugin -install jprante/elasticsearch-river-jdbc -\> Installing jprante/elasticsearch-river-jdbc... Trying [https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-](https://github.com/downloads/jprante/elasticsearch-river-jdbc/elasticsearch-) river-jdbc-0.19.8.zip... Trying [https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8](https://github.com/jprante/elasticsearch-river-jdbc/zipball/v0.19.8)... Trying [https://github.com/jprante/elasticsearch-river-jdbc/zipball/master](https://github.com/jprante/elasticsearch-river-jdbc/zipball/master)... Downloading .........DONE Identified as a \_site plugin, moving to \_site structure ... Installed river-jdbc Seems ok, install the mysql connector in /usr/share/elasticsearch/lib - Restart elasticsearch - Log output : [2012-08-18 09:02:07,867][INFO][node] [Golden Girl] {0.19.8}[17549]: initializing ... [2012-08-18 09:02:07,881][INFO][plugins] [Golden Girl] loaded [], sites [river-jdbc, head] [2012-08-18 09:02:10,222][INFO][node] [Golden Girl] {0.19.8}[17549]: initialized [2012-08-18 09:02:10,223][INFO][node] [Golden Girl] {0.19.8}[17549]: starting ... [2012-08-18 09:02:10,337][INFO][transport] [Golden Girl] bound\_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish\_address {inet[/192.168.18.207:9300]} [2012-08-18 09:02:13,390][INFO][cluster.service] [Golden Girl] new\_master [Golden Girl][NeUSfo7oSmyLgqaIeMUjZA][inet[/192.168.18.207:9300]], reason: zen-disco-join (elected\_as\_master) [2012-08-18 09:02:13,470][INFO][discovery] [Golden Girl] elasticsearch/NeUSfo7oSmyLgqaIeMUjZA [2012-08-18 09:02:13,494][INFO][http] [Golden Girl] bound\_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish\_address {inet[/192.168.18.207:9200]} [2012-08-18 09:02:13,494][INFO][node] [Golden Girl] {0.19.8}[17549]: started Seems that the pluigins is loaded - Create the rivers : curl -XPUT 'localhost:9200/\_river/test/\_meta' -d '{ "type" : "jdbc", "jdbc" : { "driver" : "com.mysql.jdbc.Driver", "url" : "jdbc:mysql://localbost:3306/article", "user" : "es", "password" : "es", "sql" : "select \* from articles" } }' - es return un json with ok: true but the log output : [2012-08-18 09:02:14,517][WARN][river] [Golden Girl] failed to create river [jdbc][test] org.elasticsearch.common.settings.NoClassSettingsException: Failed to load class with value [jdbc] at org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:86) at org.elasticsearch.river.RiverModule.spawnModules(RiverModule.java:57) at org.elasticsearch.common.inject.ModulesBuilder.add(ModulesBuilder.java:44) at org.elasticsearch.river.RiversService.createRiver(RiversService.java:135) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService .java:270) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService .java:264) at org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.ru n(TransportAction.java:86) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:11 10) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:6 03) at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.ClassNotFoundException: jdbc at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:423) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:356) at org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:72) ... 9 more I'll try to a lot of time on different server but I can't have any other message. I'll try with wikipedia river just for try another river type the same error Failed to load class It drive me nuts since I really don't see where I failed (moreover just at the begining). I'll try to manually put some data on ES and all seems to work. Any help will be greatly appreciate. Thanks. -- -- -- ---
**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, 3:15am UTC](https://discuss.elastic.co/t/rivers-installation-trouble-jdbc-wikipedia/8778/6 "2017-07-06T03:15:57Z")