title: SOLR mysql - Sorry, no dataimport-handler defined
body: <p>I am trying to configure SOLR on Debian with mysql import. </p>
  
  <p>Solr is running and I can visit admin area on <a href="http://localhost:8983/solr/" rel="nofollow noreferrer">http://localhost:8983/solr/</a> however I am unable to dataimport under my selected core - it reports <strong>"Sorry, no dataimport-handler defined!"</strong>  </p>
  
  <p>It doesn't report any errors (I get reverse dns lookup warnings since running on test machine) and <strong>I was able to successfully import mysql via api</strong> following this guide <a href="http://solr.pl/en/2010/10/11/data-import-handler-%E2%80%93-how-to-import-data-from-sql-databases-part-1/" rel="nofollow noreferrer">http://solr.pl/en/2010/10/11/data-import-handler-%E2%80%93-how-to-import-data-from-sql-databases-part-1/</a></p>
  
  <p>Any ideas would highly appreciated!</p>
  
  <p>My config is as follows:</p>
  
  <pre><code>&lt;dataConfig&gt;
      &lt;dataSource type="JdbcDataSource"
     driver="com.mysql.jdbc.Driver"
     url="jdbc:mysql://localhost/mydatabase?zeroDateTimeBehavior=convertToNull"
     user="root"
     password=""/&gt;
  
   &lt;document name='tests'&gt;
      &lt;entity name='posts'
          query='select * from blog_posts'&gt;
      &lt;field column="ID" name="id" /&gt;
      &lt;field column="TITLE" name="title" /&gt;
      &lt;/entity&gt;
   &lt;/document&gt;
  
  &lt;/dataConfig&gt;
  </code></pre>
  
  <p><strong>schema.xml</strong>
  default chema with added:</p>
  
  <pre><code>&lt;field name="id" type="string" indexed="true" required="true" stored="true" /&gt;
  &lt;field name="title" type="string" indexed="true" required="true" stored="true" /&gt;
  </code></pre>
  
  <p><strong>solrconfig.xml</strong>
  default config with added </p>
  
  <pre><code>&lt;lib dir="${solr.install.dir:../../../..}/dist/" regex="solr-dataimporthandler-\d.*\.jar" /&gt;
  &lt;lib dir="${solr.install.dir:../../../..}/dist/" regex="solr-dataimporthandler-extras-\d.*\.jar" /&gt;
  &lt;lib dir="${solr.install.dir:../../../..}/contrib/" regex="mysql-connector-java-.*\.jar" /&gt;
  
  &lt;requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"&gt;
  &lt;lst name="defaults"&gt;
  &lt;str name="config"&gt;/opt/solr-6.4.0/server/solr/gradim/conf/mysql-gradim.xml&lt;/str&gt;
  &lt;/lst&gt;
  &lt;/requestHandler&gt;
  </code></pre>