Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

WebHCat Server notworking CDH 5.7 VM

WebHCat Server notworking CDH 5.7 VM

Explorer

Hi All,

 

I'm facing an error regarding webHcat configuration. Am trying to get database names using curl via webhcat .

 

Command :

curl http://172.31.13.162:50111/templeton/v1/ddl/database?user.name=cloudera


Results :

{"statement":"show databases like '*';","error":"unable to show databases for: *","exec":{"stdout":"","stderr":"which: no /usr/lib/hadoop/bin/hadoop in ((null))\ndirname: missing operand\nTry `dirname --help' for more information.\n Command was terminated due to timeout(3000ms). See templeton.exec.timeout property","exitcode":143}}

 

Hope you can help me on this one.

 

Thanks!

Orson

3 REPLIES 3

Re: WebHCat Server notworking CDH 5.7 VM

New Contributor

Hi, did domebody face the same problem of not being able to connect to the webhcat server on CDH 5.3 (maybe similar also to another versins)? Below are the tests I have done. I can't connect both from inside or outside the VM despite of the VM being seen also from outside (I can run in the VM host browser the Hue page).

 

[cloudera@quickstart ~]$ curl http://192.168.100.201:50111/templeton/v1/ddl/database?user.name=cloudera
curl: (7) couldn't connect to host


[cloudera@quickstart ~]$ curl -i http://localhost:50111/templeton/v1/status

curl: (7) couldn't connect to host


[cloudera@quickstart ~]$ curl -i http://192.168.100.201:50111/templeton/v1/status

curl: (7) couldn't connect to host


[cloudera@quickstart ~]$ service hive-server2 status
Hive Server2 is running [ OK ]


[cloudera@quickstart ~]$ service hive-metastore status
Hive Metastore is running [ OK ]

 

#### on 9083 the connection works, on 50111 not #########


[cloudera@quickstart ~]$ curl -i quickstart.cloudera:9083
curl: (52) Empty reply from server

Thanks,

 

Radu

 

Re: WebHCat Server notworking CDH 5.7 VM

New Contributor

As additional info, here is the service status on the CDH VM:

 

[cloudera@quickstart ~]$ sudo service --status-all
abrt-ccpp hook is installed
abrtd (pid 2024) is running...
abrt-dump-oops is stopped
acpid (pid 1540) is running...
atd (pid 5008) is running...
auditd (pid 5316) is running...
By default, Cloudera's QuickStart VM manages CDH using Linux's configuration
and service management. To use Cloudera Manager instead, you must shut down
and disable the existing CDH services and then start Cloudera Manager. You can
do this by clicking the 'Launch Cloudera Manager' icon on the desktop, or by
running the following command:

sudo ~/cloudera-manager
By default, Cloudera's QuickStart VM manages CDH using Linux's configuration
and service management. To use Cloudera Manager instead, you must shut down
and disable the existing CDH services and then start Cloudera Manager. You can
do this by clicking the 'Launch Cloudera Manager' icon on the desktop, or by
running the following command:

sudo ~/cloudera-manager
cpuspeed is stopped
crond (pid 4281) is running...
cupsd (pid 1478) is running...
dnsmasq is stopped
Flume NG agent is not running [FAILED]
Hadoop datanode is running [ OK ]
Hadoop journalnode is running [ OK ]
Hadoop namenode is running [ OK ]
Hadoop secondarynamenode is running [ OK ]
Hadoop httpfs is running [ OK ]
Hadoop historyserver is running [ OK ]
Hadoop nodemanager is running [ OK ]
Hadoop proxyserver is dead and pid file exists [FAILED]
Hadoop resourcemanager is running [ OK ]
hald (pid 1568) is running...
HBase master daemon is dead and pid file exists [FAILED]
hbase-regionserver is not running.
HBase rest daemon is running [ OK ]
HBase Solr Indexer is not running [FAILED]
HBase thrift daemon is running [ OK ]
Hive Metastore is running [ OK ]
Hive Server2 is running [ OK ]
supervisor (pid 4349) is running...
Impala Catalog Server is running [ OK ]
Impala Server is running [ OK ]
Impala State Store Server is running [ OK ]
ip6tables: Firewall is not running.
iptables: Firewall is not running.
irqbalance (pid 1343) is running...
Kdump is operational
lvmetad is stopped
mdmonitor is stopped
messagebus (pid 1498) is running...
mysqld (pid 1834) is running...
netconsole module not loaded
Configured devices:
lo eth0
Currently active devices:
lo eth1
NetworkManager (pid 1508) is running...
ntpd (pid 1676) is running...
running
portreserve is stopped
master (pid 1957) is running...
Process accounting is disabled.
quota_nld is stopped
rdisc is stopped
rngd is stopped
rpcbind (pid 1365) is running...
rsyslogd (pid 1270) is running...
sandbox is stopped
saslauthd is stopped
Sentry DB Store Service is dead and pid file exists [FAILED]
smartd is stopped
Solr server daemon is running [ OK ]
Spark history-server is running [ OK ]
Spark master is running [ OK ]
Spark worker is dead and pid file exists [FAILED]
Sqoop Server is running [ OK ]
sqoop-metastore is not running.
openssh-daemon (pid 1665) is running...
winbindd is stopped
wpa_supplicant (pid 1597) is running...
zookeeper-server is running

Re: WebHCat Server notworking CDH 5.7 VM

New Contributor

...apparently nobody is listening on 50111 port although the hive-server2 and hive-metastore are running

 

[root@quickstart ~]# sudo ss -lntp
State Recv-Q Send-Q Local Address:Port Peer Address:Port
LISTEN 0 128 *:23020 *:* users:(("catalogd",4945,197))
LISTEN 0 128 *:111 *:* users:(("rpcbind",1365,8))
LISTEN 0 128 *:22000 *:* users:(("impalad",4979,194))
LISTEN 0 128 *:26000 *:* users:(("catalogd",4945,201))
LISTEN 0 50 *:10000 *:* users:(("java",3511,460))
LISTEN 0 128 *:19888 *:* users:(("java",2537,299))
LISTEN 0 100 *:14000 *:* users:(("java",2491,37))
LISTEN 0 5 *:80 *:* users:(("python",1872,3))
LISTEN 0 128 *:10033 *:* users:(("java",2537,288))
LISTEN 0 1 127.0.0.1:14001 *:* users:(("java",2491,39))
LISTEN 0 128 *:25010 *:* users:(("statestored",4425,6))
LISTEN 0 128 *:8020 *:* users:(("java",2215,301))
LISTEN 0 128 *:8085 *:* users:(("java",3234,368))
LISTEN 0 128 *:8022 *:* users:(("java",2215,291))
LISTEN 0 128 *:50070 *:* users:(("java",2215,277))
LISTEN 0 128 *:22 *:* users:(("sshd",1665,3))
LISTEN 0 100 *:8983 *:* users:(("java",4922,37))
LISTEN 0 128 127.0.0.1:631 *:* users:(("cupsd",1478,7))
LISTEN 0 128 *:23000 *:* users:(("impalad",4979,200))
LISTEN 0 1 127.0.0.1:8984 *:* users:(("java",4922,39))
LISTEN 0 100 *:11000 *:* users:(("java",4746,249))
LISTEN 0 5 *:8888 *:* users:(("python2.6",4390,3))
LISTEN 0 128 *:8088 *:* users:(("java",2854,313))
LISTEN 0 1 127.0.0.1:11001 *:* users:(("java",4746,266))
LISTEN 0 100 127.0.0.1:25 *:* users:(("master",1957,12))
LISTEN 0 128 *:21050 *:* users:(("impalad",4979,209))
LISTEN 0 50 *:13562 *:* users:(("java",2619,329))
LISTEN 0 50 *:50010 *:* users:(("java",2056,277))
LISTEN 0 50 *:9083 *:* users:(("java",3445,449))
LISTEN 0 128 *:50075 *:* users:(("java",2056,282))
LISTEN 0 128 *:25020 *:* users:(("catalogd",4945,175))
LISTEN 0 128 *:8030 *:* users:(("java",2854,293))
LISTEN 0 128 *:8031 *:* users:(("java",2854,282))
LISTEN 0 128 *:57951 *:* users:(("java",2619,308))
LISTEN 0 128 *:24000 *:* users:(("statestored",4425,11))
LISTEN 0 50 *:18080 *:* users:(("java",3952,294))
LISTEN 0 100 *:12000 *:* users:(("java",3821,102))
LISTEN 0 128 *:8032 *:* users:(("java",2854,303))
LISTEN 0 128 *:8480 *:* users:(("java",2125,277))
LISTEN 0 1 127.0.0.1:12001 *:* users:(("java",3821,104))
LISTEN 0 128 *:8033 *:* users:(("java",2854,319))
LISTEN 0 50 *:51361 *:* users:(("java",1998,14))
LISTEN 0 50 *:9090 *:* users:(("java",3353,376))
LISTEN 0 128 *:10020 *:* users:(("java",2537,303))
LISTEN 0 128 *:50020 *:* users:(("java",2056,292))
LISTEN 0 128 192.168.100.201:7077 *:* users:(("java",3952,292))
LISTEN 0 128 *:8485 *:* users:(("java",2125,285))
LISTEN 0 50 *:2181 *:* users:(("java",1998,20))
LISTEN 0 50 *:8070 *:* users:(("java",3234,379))
LISTEN 0 128 *:9095 *:* users:(("java",3353,368))
LISTEN 0 128 *:21000 *:* users:(("impalad",4979,206))
LISTEN 0 128 *:25000 *:* users:(("impalad",4979,195))
LISTEN 0 50 *:18088 *:* users:(("java",3848,284))
LISTEN 0 128 *:8040 *:* users:(("java",2619,319))
LISTEN 0 128 *:8042 *:* users:(("java",2619,330))
LISTEN 0 128 *:50090 *:* users:(("java",2367,285))
LISTEN 0 50 *:3306 *:* users:(("mysqld",1834,10))

Don't have an account?
Coming from Hortonworks? Activate your account here