Re: [sqoop-user] Re: Sqoop import failed ( connection refused )

["arvind@cloudera.com" <ar...@cloudera.com>]

[Moving conversation to sqoop-user@incubator.apache.org. Please
subscribe (and post) to this mailing list.]

Amit,

As long as you have provided the JDBC driver and the connect string is
valid, no other properties need to be set. The one thing to cross
check would be the connect string. Make sure that it is not set to
localhost, or a host name that cannot be resolved correctly from the
node machines.

Thanks,
Arvind

On Tue, Sep 13, 2011 at 3:32 AM, amit kumar <am...@gmail.com> wrote:
> I think the problem is connecting to mysql from remote machines in the
> cluster . How to remotely connect to mysql in the cluster . Are their
> any properties of configurations to set in the mysql ???
>
>
>
> On Sep 9, 5:49 am, "arv...@cloudera.com" <ar...@cloudera.com> wrote:
>> [Moving conversation to sqoop-u...@incubator.apache.org. Please
>> subscribe there.]
>>
>> It appears that the map task run by Sqoop cannot establish a JDBC
>> connection with the database. Check to make sure that your connect
>> string is correct and that there is no firewall blocking access to the
>> database machine. It may be worth while to write a short JDBC program
>> and run it from one of the node machines to make sure that you can
>> connect correctly.
>>
>> Thanks,
>> Arvind
>>
>>
>>
>> On Thu, Sep 1, 2011 at 10:39 PM, amit kumar <am...@gmail.com> wrote:
>> > while running an import , i m not able to get connected to mysql
>> > database. Communication link failure is shooted .
>> > I m able to connect to mysql via a java program . Problem
>> > description :
>>
>> > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
>> > Communications link failure
>> > The last packet sent successfully to the server was 0 milliseconds
>> > ago. The driver has not received any packets from the server.
>> >        at
>> > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>> >        at
>> > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcce­ssorImpl.java:
>> > 39)
>> >        at
>> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstru­ctorAccessorImpl.java:
>> > 27)
>> >        at java.lang.reflect.Constructor.newInstance(Constructor.java:
>> > 513)
>> >        ............
>> > Caused by: java.net.ConnectException: Connection refused
>> >        at java.net.PlainSocketImpl.socketConnect(Native Method)
>> >        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:
>> > 351)
>> >        at
>> > java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
>> >        ...........
>> > 11/09/02 12:08:38 INFO mapred.JobClient: Job complete:
>> > job_201108301643_0036
>> > 11/09/02 12:08:38 INFO mapred.JobClient: Counters: 6
>> > 11/09/02 12:08:38 INFO mapred.JobClient:   Job Counters
>> > 11/09/02 12:08:38 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=23440
>> > 11/09/02 12:08:38 INFO mapred.JobClient:     Total time spent by all
>> > reduces waiting after reserving slots (ms)=0
>> > 11/09/02 12:08:38 INFO mapred.JobClient:     Total time spent by all
>> > maps waiting after reserving slots (ms)=0
>> > 11/09/02 12:08:38 INFO mapred.JobClient:     Launched map tasks=4
>> > 11/09/02 12:08:38 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
>> > 11/09/02 12:08:38 INFO mapred.JobClient:     Failed map tasks=1
>> > 11/09/02 12:08:38 INFO mapreduce.ImportJobBase: Transferred 0 bytes in
>> > 34.6672 seconds (0 bytes/sec)
>> > 11/09/02 12:08:38 INFO mapreduce.ImportJobBase: Retrieved 0 records.
>> > 11/09/02 12:08:38 ERROR tool.ImportTool: Error during import: Import
>> > job failed
>>
>> > --
>> > NOTE: The mailing list sqoop-u...@cloudera.org is deprecated in favor of Apache Sqoop mailing list sqoop-u...@incubator.apache.org. Please subscribe to it by sending an email to incubator-sqoop-user-subscr...@apache.org.- Hide quoted text -
>>
>> - Show quoted text -
>
> --
> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please subscribe to it by sending an email to incubator-sqoop-user-subscribe@apache.org.
>