What query are you doing? Try q=*:*
Also, what does /solr/admin/stats.jsp report for number of docs? Upayavira On Mon, 28 Mar 2011 04:28 -0700, "Merlin Morgenstern" <merli...@fastmail.fm> wrote: > 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 > --- Enterprise Search Consultant at Sourcesense UK, Making Sense of Open Source