无法使用Ubuntu 10.10将数据从MySql导入Solr(Can't import data from MySql into Solr using Ubuntu 10.10)
我通过apt-get(Ubuntu 10.10)安装了solr-commons包。 我可以浏览到http:// localhost:8080 / solr ,它运行正常。
我已经定义了这样的架构:
<fields> <field name="idEmpresa" type="sint" indexed="true" stored="true" required="true" /> <field name="nombre" type="text" indexed="true" stored="true" required="true" /> <field name="sitioWeb" type="text" indexed="true" stored="true" required="false" /> <field name="email" type="text" indexed="true" stored="true" required="false" /> <field name="telefono" type="text" indexed="true" stored="true" required="false" /> </fields> <!-- Field to use to determine and enforce document uniqueness. Unless this field is marked with required="false", it will be a required field --> <uniqueKey>idEmpresa</uniqueKey> <!-- field for the QueryParser to use when an explicit fieldname is absent --> <defaultSearchField>nombre</defaultSearchField> <!-- SolrQueryParser configuration: defaultOperator="AND|OR" --> <solrQueryParser defaultOperator="OR"/>
这是我的data-config.xml文件:
<?xml version="1.0" encoding="UTF-8"?> <dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/viajeros2_ut8" user="user" password="pwd" /> <document> <entity name="empresa" query="select idEmpresa, nombre, sitioWeb, telefono, direccion from empresas WHERE 1"> </entity> </document> </dataConfig>
最后,这是我设置solrconfig.xml的方法:
<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"> <lst name="defaults"> <str name="config">/usr/share/solr/conf/data-config.xml</str> </lst> </requestHandler>
当我尝试
http://localhost:8080/solr/dataimport?command=full-import
我得到这个:<?xml version="1.0" encoding="UTF-8"?> <response> <lst name="responseHeader"><int name="status">0</int><int name="QTime">91</int></lst><lst name="initArgs"><lst name="defaults"><str name="config">/usr/share/solr/conf/data-config.xml</str></lst></lst><str name="command">full-import</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>
我找不到任何可以帮助我解决问题的日志或任何其他信息,正如许多人所发现的那样,可用的文档并不是很有用。
任何想法将非常感激。 谢谢!
I have installed solr-commons package through apt-get (Ubuntu 10.10). I can browse to http://localhost:8080/solr and it works fine.
I have defined a schema like this:
<fields> <field name="idEmpresa" type="sint" indexed="true" stored="true" required="true" /> <field name="nombre" type="text" indexed="true" stored="true" required="true" /> <field name="sitioWeb" type="text" indexed="true" stored="true" required="false" /> <field name="email" type="text" indexed="true" stored="true" required="false" /> <field name="telefono" type="text" indexed="true" stored="true" required="false" /> </fields> <!-- Field to use to determine and enforce document uniqueness. Unless this field is marked with required="false", it will be a required field --> <uniqueKey>idEmpresa</uniqueKey> <!-- field for the QueryParser to use when an explicit fieldname is absent --> <defaultSearchField>nombre</defaultSearchField> <!-- SolrQueryParser configuration: defaultOperator="AND|OR" --> <solrQueryParser defaultOperator="OR"/>
This is my data-config.xml file:
<?xml version="1.0" encoding="UTF-8"?> <dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/viajeros2_ut8" user="user" password="pwd" /> <document> <entity name="empresa" query="select idEmpresa, nombre, sitioWeb, telefono, direccion from empresas WHERE 1"> </entity> </document> </dataConfig>
Finally, this is how I set up my solrconfig.xml:
<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"> <lst name="defaults"> <str name="config">/usr/share/solr/conf/data-config.xml</str> </lst> </requestHandler>
When I try
http://localhost:8080/solr/dataimport?command=full-import
I get this:<?xml version="1.0" encoding="UTF-8"?> <response> <lst name="responseHeader"><int name="status">0</int><int name="QTime">91</int></lst><lst name="initArgs"><lst name="defaults"><str name="config">/usr/share/solr/conf/data-config.xml</str></lst></lst><str name="command">full-import</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>
I can't find any logs or any other information that could help me tackle the issue and, as happened to many, the documentation available isn't very helpful.
Any ideas will be very appreciated. Thanks!
原文:https://stackoverflow.com/questions/4270412