Member since
03-14-2016
4721
Posts
1111
Kudos Received
874
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2448 | 04-27-2020 03:48 AM | |
4885 | 04-26-2020 06:18 PM | |
3976 | 04-26-2020 06:05 PM | |
3220 | 04-13-2020 08:53 PM | |
4927 | 03-31-2020 02:10 AM |
03-02-2017
04:21 AM
@Sunile Manjee I see it in ambari 2.4.2 docs as well: http://docs.hortonworks.com/HDPDocuments/Ambari-2.4.2.0/bk_ambari-troubleshooting/content/resolving_cluster_install_and_configuration_problems.html "3.10. Problem: DataNode Fails to Install on RHEL/CentOS 7" The explanation of this section makes sense "Hadoop requires the snappy-devel package that is a lower version that what is on
the machine already. Run the following on the host and retry."
... View more
03-02-2017
04:17 AM
@Sunile Manjee There are some known issues reported for older version of ambari (like 2.2.2) to resolve the "snappy-devel" conflict. That seems to be true even for the later version (Specially CentOS7/RHEL7): http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.0/bk_ambari_troubleshooting/content/_resolving_cluster_install_and_configuration_problems.html Hadoop requires the snappy-devel package that is a lower version that what is on the machine already. Run the following on the host and retry.
# yum remove snappy
# yum install snappy-devel
... View more
03-01-2017
05:26 PM
1 Kudo
@Oriane In Sandbox the default mysql password will be "hadoop" So please try this: # mysql -u root -p
Enter password: hadoop . Then once you are inside the mysql prompt you can run the following kind of queries: mysql> use mysql
mysql> show tables;
mysql> select * from help_keyword; .
Then from Sqoop try the following: # sqoop list-databases --connect "jdbc:mysql://localhost:3306" --username root --password hadoop .
... View more
03-01-2017
04:21 PM
@Oriane
Can you check if your "mysql" is listening to which host? (localhost or any specific hostname)?
Mysql should by default open 3306 port.
nstatst -tnlpa | grep 3306
try restarting mysql service mysqld restart . Also try to enclose the --connection string inside Double Quotation mark. As mentioned in my previous example.
... View more
03-01-2017
02:17 PM
@Oriane There are two issues in your attached screen shots: 1. "access denied" you should use the "-p" option while connecting to mysql as following: mysql -u root -p If it still does not work then Try the following: Reset the root password: mysqladmin -u root password newPassword
Then try to connect to mysql as following: mysql -u root -p 2. Regarding the Sqoop connection string, I see that there are extra "//" sybmol in the connection string. jdbc://hive2://sandbox.hortonworks.com:2181/default
Should be following i guess: jdbc:hive2://sandbox.hortonworks.com:2181/default
- You might want to try the SQOOP command as following: sqoop list-databases --connect "jdbc:mysql://localhost:3306" --username root --password newPassword
OR
sqoop list-tables --connect "jdbc:mysql://localhost:3306/testDB" --username root --password ewPassword
... View more
03-01-2017
08:51 AM
@Jayadeep Jayaraman I see there is an issue opened that is targeted to be addressed in Ambari 2.5 Hive view not working on LLAP enabled cluster: https://issues.apache.org/jira/browse/AMBARI-18437 .
... View more
02-27-2017
04:16 AM
2 Kudos
@Yukti Agrawal Can you please try the following to see if it fixes your issue? 1. Edit /etc/ambari-server/conf/ambari.properties to set the empty values: http.strict-transport-security=
views.http.strict-transport-security= 2. Restart ambari server ambari-server restart 3. Clear the browsers cache (or for testing open the browser in "Incognito mode") then access the grafana UI. Please have a look at the HSTS setting of browsers : http://classically.me/blogs/how-clear-hsts-settings-major-browsers .
... View more
02-25-2017
07:12 AM
@Sachin Ambardekar The following doc talks about starting manually various HDP components: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_reference/content/starting_hdp_services.html Regarding HADOOP_HOME you can get more detailed information from the following discussion https://community.hortonworks.com/questions/20694/hadoop-installation-directory.html Example: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_upgrading_hdp_manually/content/start-mahout-20.html export HADOOP_HOME=/usr/hdp/current/hadoop-client .
... View more
02-24-2017
10:37 AM
1 Kudo
In order to setup HTTPs access for LogSearch Portal UI first of all we will need to create the keystore. We will also create truststore as well using the "$JAVA_HOME/bin/keytool" utility. In this example we will be using the self signed certificates. # mkdir -p /etc/security/serverKeys/
# keytool -genkey -v -alias logsearch -keyalg RSA -keysize 1024 -keystore /etc/security/serverKeys/logsearch.keyStore.jks -validity 3650 -keypass logsearch -storepass logsearch -dname 'CN=erie1.example.com, OU=hwx, O=test, L=Pune, S=Maharashtra, C=IN'
# keytool -genkeypair -alias logsearch -keyalg RSA -keysize 2048 -keypass logsearch -storepass logsearch -validity 3650 -keystore /etc/security/serverKeys/logsearch.trustStore.jks -dname 'CN=erie1.example.com, OU=hwx, O=test, L=Pune, S=Maharashtra, C=IN' -rfc
. - In the above example i used CN=erie1.example.com as my LogSearch service is running on the same host. - Now we will need to make sure that those files has proper read permissions and ownership set correctly. # chown -R logsearch:hadoop /etc/security/serverKeys/
# ls -la /etc/security/serverKeys/
-rw-r--r--. 1 logsearch hadoop 1399 Feb 24 07:19 logsearch.keyStore.jks
-rw-r--r--. 1 logsearch hadoop 2245 Feb 24 07:38 logsearch.trustStore.jks .
- Now we can login to ambari UI and navigate to "Log Search" --> "Configs" --> "Advanced" --> "Advanced logsearch-env" and then provide the following details there: Log Search UI Protocol: https
Log Search UI Port: 61888
Log Search trust store location: /etc/security/serverKeys/logsearch.trustStore.jks
Log Search trust store type: JKS
Log Search trust store password: logsearch
Log Search key store location: /etc/security/serverKeys/logsearch.keyStore.jks
Log Search key store type: logsearch
Log Search key store password: logsearch
. - Once we enter the above details then we can "Save" the settings and then restart the "Log Search" service. - Now we should be able to access the "Log Search" using the HTTPs protocol . And then the Log Search UI dashboard: . Troubleshooting Common Issues: If we encounter any issue while while running starting up the Log Search after enabling the https then we can look at the file "/var/log/ambari-logsearch-portal/logsearch/logsearch.err", For example if we enter incorrect credentials of store then we might see the following kind of error in our logs: [main] WARN org.eclipse.jetty.util.component.AbstractLifeCycle (AbstractLifeCycle.java:212) - FAILED ServerConnector@1cb37ee4{SSL-http/1.1}{0.0.0.0:61888}: java.io.IOException: Keystore was tampered with, or password was incorrect
java.io.IOException: Keystore was tampered with, or password was incorrect
at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:780)
at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:56)
at sun.security.provider.KeyStoreDelegator.engineLoad(KeyStoreDelegator.java:225)
at sun.security.provider.JavaKeyStore$DualFormatJKS.engineLoad(JavaKeyStore.java:70)
at java.security.KeyStore.load(KeyStore.java:1445)
at org.eclipse.jetty.util.security.CertificateUtils.getKeyStore(CertificateUtils.java:55)
at org.eclipse.jetty.util.ssl.SslContextFactory.loadTrustStore(SslContextFactory.java:884)
at org.eclipse.jetty.util.ssl.SslContextFactory.doStart(SslContextFactory.java:274)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
at org.eclipse.jetty.server.SslConnectionFactory.doStart(SslConnectionFactory.java:64)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
at org.eclipse.jetty.server.AbstractConnector.doStart(AbstractConnector.java:256)
at org.eclipse.jetty.server.AbstractNetworkConnector.doStart(AbstractNetworkConnector.java:81)
at org.eclipse.jetty.server.ServerConnector.doStart(ServerConnector.java:236)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.eclipse.jetty.server.Server.doStart(Server.java:366)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.apache.ambari.logsearch.LogSearch.run(LogSearch.java:89)
at org.apache.ambari.logsearch.LogSearch.main(LogSearch.java:73)
Caused by: java.security.UnrecoverableKeyException: Password verification failed
at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:778)
... 22 more .
... View more
Labels:
02-24-2017
08:02 AM
@Sanaz Janbakhsh Can you please accept the answer and close the thread.
... View more