BookmarkSubscribeRSS Feed
tarunbansal
Calcite | Level 5

Hi, I am getting following error log while going to start SAS Data Loader.

2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: running command: sas-hadoop-tool init --clienthost="192.168.75.128" --clientuser="root" --clientpass="cloudera" --svckey=hivejdbc --svckey=hadoop --svckey=mapreduce --svckey=hcatapi [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129:  [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: ssh: connect to host 192.168.75.128 port 22: No route to host  [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: exit_code=1 [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129:  [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: ERROR: Connection to 192.168.75.128 failed, please review: [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: Running sas-hadoop-tool to configure the hadoop client [0m
2015-04-27 04:20:27 USER[Unauthenticated] -  [mNotice: Running hadoopconfigure on 192.168.75.129 with arguments: ******** [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: A scan is required [0m
>stderr: 
>rc: 0
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: link /opt/sasinside/hadoop [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: ssh: connect to host 192.168.75.128 port 22: No route to host  [0m
>stdout: Writing to /opt/sasinside/var/log/sva.execute/execute_task.2015.04.27.04.20.26.151825707.log
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129:  [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129:  [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129:  [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: removing symlink and recreating it later [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: Hadoop directory exists so attempting to reuse [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: testcmd: timeout -s SIGKILL 60s sas-sshpass -p cloudera ssh root@192.168.75.128 'id' [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: ERROR: client configuration failed [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: Done [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129:  [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: Testing connection to 192.168.75.128 ... [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: testcmd: timeout -s SIGKILL 60s sas-sshpass -p cloudera ssh root@192.168.75.128 'id' [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: ERROR: sas-hadoop-tool init --clienthost="192.168.75.128" --clientuser="root" --clientpass="cloudera" --svckey=hivejdbc --svckey=hadoop --svckey=mapreduce --svckey=hcatapi failed: [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: ERROR: Connection to 192.168.75.128 failed, please review: [0m
2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: Testing connection to 192.168.75.128 ... [0m
>LocalExec: ********

4 REPLIES 4
RichardFrazer
SAS Employee

It appears that the ip address of your Cloudera Quickstart VM is unreachable according to this:

2015-04-27 04:20:31 USER[Unauthenticated] -  [0;36mDebug: SSH root@192.168.75.129: ssh: connect to host 192.168.75.128 port 22: No route to host  [0m


Can you ping it from your host machine?  Or better yet attempt to ssh to the host using the credentials you provided in Information Center?


Richard

tarunbansal
Calcite | Level 5

not able to start by doing so. Can you please mention steps?

RichardFrazer
SAS Employee

If your host machine is a Windows machine, bring up a DOS command prompt (cmd), if you are on a mac, bring up the Terminal application.  In either the DOS window or the terminal window, type:

> ping 192.168.75.128

Do you get a response from that ip address?  If not, you have the IP address incorrect in the configuration screen of Data Loader.  Please follow the instructions in step 3 of the startup guide:  Get Started With SAS Data Loader for Hadoop | SAS in order to determine the ip address of the QuickStart VM.

Richard

Wilbram-SAS
SAS Employee

As Richard mentions the "No route to host" error indicates that the vApp can't reach your Hadoop VM. If using ping from a DOS command prompt to reach the Hadoop VM doesn't work, it at least explains why the vApp can't reach it either.

Another thing to test is to see whether you can reach the vApp from a DOS command prompt using ping. If that doesn't work either, there might be something wrong with the networking configuration of VMWare Player. There is lots of information on the internet on VMWare Player and networking that might help to resolve this.

Cheers,

Wilbram

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1551 views
  • 0 likes
  • 3 in conversation