Re: Solr reports: "Can not read response from server" when running import

[Romita Saha]

Hi Shawn,

Thanks a lot for your guidance. I can import the database successfully 
now. Thanks once again.

Regards,
Romita Saha



From:   Shawn Heisey <s...@elyograg.org>
To:     solr-user@lucene.apache.org, 
Date:   10/17/2012 09:49 PM
Subject:        Re: Solr reports: "Can not read response from server" when 
running import



On 10/17/2012 12:29 AM, Romita Saha wrote:
> Hi Dave,
>
> I followed your guidance and loaded my database in MySQL. Presently the
> url reads like this:
>
> url = "jdbc:mysql://localhost:8983/var/lib/mysql/camerasys"
>
> The bin address in my.cnf file is :
> bind-address = 127.0.0.1
>
> However the issue still persists.  Kindly help me find out the issue. 
The
> error log is stated below.
>
> Caused by: com.mysql.jdbc.CommunicationsException: Communications link
> failure due to underlying exception:

Typically MySQL listens on port 3306, and if you haven't changed it from 
the default, you shouldn't even need to include it.  Your URL then needs 
to have the name of the database (schema), not the path to where MySQL 
is storing it.Port 8983 is Solr's port if you run under the included 
jetty container.

It looks like you probably can use this, assuming you named the database 
camerasys:

url="jdbc:mysql://localhost/camerasys"

Here's how my dataimport source is defined.  I pass the database host 
and schema in via the dataimport request URL, and I include the port 
number even though I don't have to:

   <dataSource type="JdbcDataSource"
     driver="com.mysql.jdbc.Driver"
     encoding="UTF-8"
url="jdbc:mysql://${dataimporter.request.dbHost}:3306/${dataimporter.request.dbSchema}?zeroDateTimeBehavior=convertToNull"
     batchSize="-1"
     user="ncprod_ro"
     password="REDACTED"/>

Thanks,
Shawn