Hello, for this fix I need root access to the mysql-instance on the node where Hive is running. But I noticed, that I set it nowhere during the installation-process?! Not during ambari-installation and not during the HDP-installation. I just set the Hive-DB-password (!= root-password). When I try to execute the suggested command in the SO-question above (mysql -u root -p -hlocalhost) the Hive-password doesn't work. Also the default password 'admin' doesn't work. So, is there a trick, whats the password? Or did I do a mistake? I'd like to have full access and control over my cluster and the included components ;D Thanks, Warius ... View more

Hi there. I'm setting up a small cluster of three nodes with ambari. The nodes are all fresh installed and only for HDP-usage. During the setup, everything is working well. But when the Knox Gateway is started, the whole start-process is aborted due to a returning error: 2017-08-11 16:03:38,222 INFO hadoop.gateway (GatewayServer.java:logSysProp(197)) - System Property: user.name=knox 2017-08-11 16:03:38,224 INFO hadoop.gateway (GatewayServer.java:logSysProp(197)) - System Property: user.dir=/data/home/knox 2017-08-11 16:03:38,224 INFO hadoop.gateway (GatewayServer.java:logSysProp(197)) - System Property: java.runtime.name=OpenJDK Runtime Environment 2017-08-11 16:03:38,224 INFO hadoop.gateway (GatewayServer.java:logSysProp(197)) - System Property: java.runtime.version=1.8.0_141-b16 2017-08-11 16:03:38,224 INFO hadoop.gateway (GatewayServer.java:logSysProp(197)) - System Property: java.home=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.141-2.b16.el7_4.x86_64/jre 2017-08-11 16:03:38,355 INFO hadoop.gateway (GatewayConfigImpl.java:loadConfigResource(367)) - Loading configuration resource jar:file:/usr/hdp/2.6.1.0-129/knox/bin/../lib/gateway-server-0.12.0.2.6.1.0-129.jar!/conf/gateway-default.xml 2017-08-11 16:03:38,360 INFO hadoop.gateway (GatewayConfigImpl.java:loadConfigFile(355)) - Loading configuration file /usr/hdp/2.6.1.0-129/knox/bin/../conf/gateway-site.xml 2017-08-11 16:03:38,380 INFO hadoop.gateway (GatewayConfigImpl.java:initGatewayHomeDir(299)) - Using /usr/hdp/2.6.1.0-129/knox/bin/.. as GATEWAY_HOME via system property. 2017-08-11 16:03:38,695 INFO hadoop.gateway (JettySSLService.java:init(95)) - Credential store for the gateway instance found - no need to create one. 2017-08-11 16:03:38,706 INFO hadoop.gateway (JettySSLService.java:init(117)) - Keystore for the gateway instance found - no need to create one. 2017-08-11 16:03:38,709 INFO hadoop.gateway (JettySSLService.java:logAndValidateCertificate(146)) - The Gateway SSL certificate is issued to hostname: xxx.yyy.zz. 2017-08-11 16:03:38,710 INFO hadoop.gateway (JettySSLService.java:logAndValidateCertificate(149)) - The Gateway SSL certificate is valid between: 8/11/17 4:03 PM and 8/11/18 4:03 PM. 2017-08-11 16:03:38,945 INFO hadoop.gateway (GatewayServer.java:startGateway(283)) - Starting gateway... 2017-08-11 16:03:39,054 FATAL hadoop.gateway (GatewayServer.java:main(155)) - Failed to start gateway: java.net.BindException: Address already in use (Bind failed) (Source: /var/log/knox/gateway.log) So, "Address already in use" is the problem, which I try to solve. I assume that port 8443 is meant. I don't understand that. Nothing different than HDP is running on the machine, that could occupy the port, I also didn't change anything corresponding during the cluster-configuration, so all ports are the default ones and there shouldn't be any conflicts. Can anybody help me with this problem? ... View more