Hi there, I am new to solr and have just installed it on a suse box with mysql backend.
Install and MySQL connector seem to be running. I can see the solr admin interface. Now I tried to index a table with about 0.5 Mio rows. That seemed to work as well. However, I do get 0 results doing a querie on it. Something seemes to be wrong. I also did a commit of the full import. Here is the response from import. <response> − <lst name="responseHeader"> <int name="status">0</int> <int name="QTime">3</int> </lst> − <lst name="initArgs"> − <lst name="defaults"> <str name="config">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="Total Requests made to DataSource">1</str> <str name="Total Rows Fetched">404575</str> <str name="Total Documents Skipped">0</str> <str name="Full Dump Started">2011-03-28 12:47:36</str> − <str name=""> Indexing completed. Added/Updated: 0 documents. Deleted 0 documents. </str> <str name="Committed">2011-03-28 12:47:42</str> <str name="Optimized">2011-03-28 12:47:42</str> <str name="Total Documents Processed">0</str> <str name="Time taken ">0:0:6.141</str> </lst> − <str name="WARNING"> This response format is experimental. It is likely to change in the future. </str> </response> Data-config.xml looks like this: <dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://192.168.0.109/test" user="solr" password="bOgKk0Kg"/> <document name="content"> <entity name="node" query="select phrase, country from search_site"> <field column="ID" name="id" /> <field column="phrase" name="phrase" /> <field column="country" name="country" /> </entity> </document> </dataConfig> Thank you for any hint to get this running. -- http://www.fastmail.fm - Email service worth paying for. Try it for free