Hi Dave, Thank you for your prompt reply. The name of the database am using is sampledatabase.sql and it is located in home/demo/snp-comm folder. Hence I have specified the url as
url="jdbc:mysql://localhost:8983/home/demo/snp-comm/sampledatabase.sql" /> Could you please specify which conf file i need to look into? Thanks and regards, Romita From: Dave Meikle <loo...@gmail.com> To: solr-user@lucene.apache.org, Date: 10/15/2012 06:24 PM Subject: Re: Solr reports: "Can not read response from server" when running import Hi, On 15 Oct 2012, at 11:02, Romita Saha <romita.s...@sg.panasonic.com> wrote: > My dataconfig.xml file looks like the following : > > - <dataConfig> > <dataSource driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:8983/home/demo/snp-comm/sampledatabase" /> > - <document> > - <entity name="customers" query="select contactLastName from customers"> > <field column="contactLastName" name="contactLastName" /> > </entity> > </document> > </dataConfig> The error information means that the connection wasn't accepted by the server. I would make sure that a) your connection URL is correct as it looks wrong to me - i.e. your database name in the URL looks like a path[1] - and b) your binding address is correct in your config file (my.cnf) and your associated host/DNS entries would let you resolve it. Cheers, Dave [1] http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
