mysql - ERROR: When running sqoop import command on master node -

i have configured hadoop multi node cluster. when trying import table mysql database hive using sqoop in master node , it's throwing following error,

sqoop import --connect jdbc:mysql://master:3306/mysql --username root --password admin --table payment  --hive-import -- --null-string '\\n' \ --null-non-string '\\n' 

warning: /usr/lib/hcatalog not exist! hcatalog jobs fail.

please set $hcat_home root of hcatalog installation. warning: $hadoop_home deprecated.  14/04/14 16:17:32 warn tool.basesqooptool: setting password on command-line insecure. consider using -p instead. 14/04/14 16:17:32 info tool.basesqooptool: using hive-specific delimiters output. can override 14/04/14 16:17:32 info tool.basesqooptool: delimiters --fields-terminated-by, etc. 14/04/14 16:17:32 info manager.mysqlmanager: preparing use mysql streaming resultset. 14/04/14 16:17:32 info tool.codegentool: beginning code generation 14/04/14 16:17:33 info manager.sqlmanager: executing sql statement: select t.* `payment` t limit 1 14/04/14 16:17:33 info manager.sqlmanager: executing sql statement: select t.* `payment` t limit 1 14/04/14 16:17:33 info orm.compilationmanager: hadoop_mapred_home /usr/local/hadoop note: /tmp/sqoop-hduser/compile/e31d2917f0d797c58258a17ed005633c/payment.java uses or overrides deprecated api. note: recompile -xlint:deprecation details. 14/04/14 16:17:35 info orm.compilationmanager: writing jar file: /tmp/sqoop-hduser/compile/e31d2917f0d797c58258a17ed005633c/payment.jar 14/04/14 16:17:35 warn manager.mysqlmanager: looks importing mysql. 14/04/14 16:17:35 warn manager.mysqlmanager: transfer can faster! use --direct 14/04/14 16:17:35 warn manager.mysqlmanager: option exercise mysql-specific fast path. 14/04/14 16:17:35 info manager.mysqlmanager: setting 0 datetime behavior converttonull (mysql) 14/04/14 16:17:35 info mapreduce.importjobbase: beginning import of payment 14/04/14 16:17:36 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 0 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:37 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 1 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:38 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 2 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:39 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 3 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:41 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 4 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:42 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 5 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:43 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 6 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:44 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 7 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:45 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 8 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:46 info ipc.client: retrying connect server: master/10.10.3.74:54311. tried 9 time(s); retry policy retryuptomaximumcountwithfixedsleep(maxretries=10, sleeptime=1 seconds) 14/04/14 16:17:46 **error security.usergroupinformation: priviledgedactionexception as:hduser cause:java.net.connectexception: call master/10.10.3.74:54311 failed on connection exception: java.net.connectexception: connection refused** 14/04/14 16:17:46 error tool.importtool: encountered ioexception running import job: java.net.connectexception: call master/10.10.3.74:54311 failed on connection exception: java.net.connectexception: connection refused     @ org.apache.hadoop.ipc.client.wrapexception(client.java:1142)     @ org.apache.hadoop.ipc.client.call(client.java:1118)     @ org.apache.hadoop.ipc.rpc$invoker.invoke(rpc.java:229)     @ org.apache.hadoop.mapred.$proxy1.getprotocolversion(unknown source)     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57)     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)     @ java.lang.reflect.method.invoke(method.java:622)     @ org.apache.hadoop.io.retry.retryinvocationhandler.invokemethod(retryinvocationhandler.java:85)     @ org.apache.hadoop.io.retry.retryinvocationhandler.invoke(retryinvocationhandler.java:62)     @ org.apache.hadoop.mapred.$proxy1.getprotocolversion(unknown source)     @ org.apache.hadoop.ipc.rpc.checkversion(rpc.java:422)     @ org.apache.hadoop.mapred.jobclient.createproxy(jobclient.java:559)     @ org.apache.hadoop.mapred.jobclient.init(jobclient.java:498)     @ org.apache.hadoop.mapred.jobclient.<init>(jobclient.java:479)     @ org.apache.hadoop.mapreduce.job$1.run(job.java:563)     @ java.security.accesscontroller.doprivileged(native method)     @ javax.security.auth.subject.doas(subject.java:416)     @ org.apache.hadoop.security.usergroupinformation.doas(usergroupinformation.java:1190)     @ org.apache.hadoop.mapreduce.job.connect(job.java:561)     @ org.apache.hadoop.mapreduce.job.submit(job.java:549)     @ org.apache.hadoop.mapreduce.job.waitforcompletion(job.java:580)     @ org.apache.sqoop.mapreduce.importjobbase.dosubmitjob(importjobbase.java:186)     @ org.apache.sqoop.mapreduce.importjobbase.runjob(importjobbase.java:159)     @ org.apache.sqoop.mapreduce.importjobbase.runimport(importjobbase.java:239)     @ org.apache.sqoop.manager.sqlmanager.importtable(sqlmanager.java:600)     @ org.apache.sqoop.manager.mysqlmanager.importtable(mysqlmanager.java:118)     @ org.apache.sqoop.tool.importtool.importtable(importtool.java:413)     @ org.apache.sqoop.tool.importtool.run(importtool.java:502)     @ org.apache.sqoop.sqoop.run(sqoop.java:145)     @ org.apache.hadoop.util.toolrunner.run(toolrunner.java:65)     @ org.apache.sqoop.sqoop.runsqoop(sqoop.java:181)     @ org.apache.sqoop.sqoop.runtool(sqoop.java:220)     @ org.apache.sqoop.sqoop.runtool(sqoop.java:229)     @ org.apache.sqoop.sqoop.main(sqoop.java:238) caused by: java.net.connectexception: connection refused     @ sun.nio.ch.socketchannelimpl.checkconnect(native method)     @ sun.nio.ch.socketchannelimpl.finishconnect(socketchannelimpl.java:601)     @ org.apache.hadoop.net.socketiowithtimeout.connect(socketiowithtimeout.java:206)     @ org.apache.hadoop.net.netutils.connect(netutils.java:511)     @ org.apache.hadoop.net.netutils.connect(netutils.java:481)     @ org.apache.hadoop.ipc.client$connection.setupconnection(client.java:457)     @ org.apache.hadoop.ipc.client$connection.setupiostreams(client.java:583)     @ org.apache.hadoop.ipc.client$connection.access$2200(client.java:205)     @ org.apache.hadoop.ipc.client.getconnection(client.java:1249)     @ org.apache.hadoop.ipc.client.call(client.java:1093)     ... 33 more 

i tried giving permissions folder , it's not working.

versions of technologies ========== =============== hadoop-1.2.1 hive-0.11 sqoop-1.4.4 

please me.let me know , want more info.

thanks in advance.

you should not gave password in command line, try without it.