How do I import a mySQL database table into Solr 6?

Question

I am trying to import a simple mySQL table into Solr and keep failing. Having ploughed through:

and half a dozen other posts that are related to Solr4, I am in desperate need of some community help.

I need specific instructions for Solr 6, it's installed on RedHat to connect to a mySQL DB. Thanks a lot.

I started with a clean VM each time, so I cannot give you logs. The last version was when I got no error message, it just simply did not execute the import, or rather it did, it just had nothing to update... For now, I'd rather not do more troubleshooting but start with a clean config for Solr6. — Lefty G Balogh, Dec 19 '16 at 10:32
for me everything works fine ...I am using solr 6.2 dataimporthandler along with tika integration... — Abhijit Bashetti, Dec 19 '16 at 10:45
Magic. Can you point me in the direction of the exact steps you followed? I'd really appreciate that. Thank you. — Lefty G Balogh, Dec 19 '16 at 10:57

score 1 · Answer 1 · answered Dec 19 '16 at 11:40

Please find the steps below..

Install Java Runtime Environment (JRE) version 1.8 for Solr 6.1
Set Java home "export JAVA_HOME=/usr/lib/jvm/jdk1.8.0_101/"
Download solr 6.1 "solr-6.1.0.tgz" from http://www-eu.apache.org/dist/lucene/solr/6.1.0/
Extract tgz file using "tar zxf solr-6.1.0.tgz".
Open the port 8983 as to communicate with solr.
Go to the path ../solr-6.1.0/ and start the server with "bin/solr start"
Create a config folder named myConfig under configsets directory , move the conf folder into it. Add the data-config.xml into "/myConfig/conf".

Modified the schema.xml under the folder "/myConfig/conf" and add the data-config.xml.

add teh entry in solconfig.xml

data-config.xml

Add the jars "solr-dataimporthandler-6.1.0.jar", "solr-dataimporthandler-extras-6.1.0.jar" to path "/home/abhijit/Downloads/solr-6.1.0/server/lib".
Add the "solr-core-6.1.0.jar" jar to the path "/home/abhijit/Downloads/solr-6.1.0/server/lib".
Add the "solr-solrj-6.1.0.jar" jar to the path "/home/abhijit/Downloads/solr-6.1.0/server/lib".
If you do the above steps you will ge the error like :

"Error Instantiating requestHandler, org.apache.solr.handler.dataimport.DataImportHandler failed to instantiate org.apache.solr.request.SolrRequestHandler" This problem occurred because dataimporthandler and requesthandler are loaded by two different class loaders. To solve it, ensure that solr loads its jars only from the same class loader.

Option to steps 5,6,7 create a folder lib inside the solr folder at path "/home/abhijit/Downloads/solr-6.1.0/server/solr" and add the entry of the same to solrConfig.xml as "". Comment the other lib entries from solrConfig.xml the jars "solr-dataimporthandler-6.1.0.jar", "solr-dataimporthandler-extras-6.1.0.jar" to path "/home/abhijit/Downloads/solr-6.1.0/server/solr/lib".
Commented the updateRequestProcessorChain in solrConfig.xml.
Command for full import

if you have any params to pass on then do something like this

1 Answers1