data-import problem

[Radha Krishna Reddy <ra...@gmail.com>]

Hi,

I am trying to comfigure solr on aws ubuntu instance.I have mysql on a
different server.so i created a ssh tunnel for mysql on port 3309.

Download the mysql jdbc driver and copied it to lib folder.

*I edited the example/solr/conf/solrconfig.xml*

<requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
  <str name="config">data-config.xml</str>
</lst>
</requestHandler>


*example/solr/conf/data-config.xml*

<dataConfig>
  <dataSource type="JdbcDataSource"
              driver="com.mysql.jdbc.Driver"
              url="jdbc:mysql://127.0.0.1:3309/<mydatabasename>"
              user="username"
              password="password"
              encoding="UTF-8"/>
  <document name="datas">
    <entity name="data" query="select DID from test_Data">
       <field column="DID" name="id"/>
    </entity>
  </document>
</dataConfig>

*started the server*

java -Djetty.port=80 -jar start.jar

*when i tried to import data.*

http://<myservername>/solr/dataimport?command=fullimport

i* am getting the following response*

<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader"><int name="status">0</int><int
name="QTime">5</int></lst><lst name="initArgs"><lst
name="defaults"><str
name="config">data-config.xml</str></lst></lst><str
name="command">fullimport</str><str name="status">idle</str><str
name="importResponse"/><lst name="statusMessages"/><str
name="WARNING">This response format is experimental.  It is likely to
change in the future.</str>
</response>


Can someone help me on this?Also where can i find the logs.

Thanks and Regards,
Radha Krishna.

Re: data-import problem

[ka...@gmx.de]

Hi Radha Krishna,

try command "full-import" instead of "fullimport"
see
http://wiki.apache.org/solr/DataImportHandler#Commands


Best regards
  Karsten

-------- Original-Nachricht --------
> Datum: Mon, 24 Oct 2011 11:10:22 +0530
> Von: Radha Krishna Reddy <ra...@gmail.com>
> An: solr-user@lucene.apache.org
> Betreff: data-import problem

> Hi,
> 
> I am trying to comfigure solr on aws ubuntu instance.I have mysql on a
> different server.so i created a ssh tunnel for mysql on port 3309.
> 
> Download the mysql jdbc driver and copied it to lib folder.
> 
> *I edited the example/solr/conf/solrconfig.xml*
...
> *when i tried to import data.*
> 
> http://<myservername>/solr/dataimport?command=fullimport
> 
> i* am getting the following response*
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int
> name="QTime">5</int></lst><lst name="initArgs"><lst
> name="defaults"><str
> name="config">data-config.xml</str></lst></lst><str
> name="command">fullimport</str><str name="status">idle</str><str
> name="importResponse"/><lst name="statusMessages"/><str
> name="WARNING">This response format is experimental.  It is likely to
> change in the future.</str>
> </response>
> 
> 
> Can someone help me on this?Also where can i find the logs.
> 
> Thanks and Regards,
> Radha Krishna.