@hardik desai It's basically a "connection reset" error. 17/08/05 19:02:46 ERROR manager.SqlManager: Error reading database metadata: java.sql.SQLRecoverableException: IO Error: Connection reset java.sql.SQLRecoverableException: IO Error: Connection reset - This either indicates a N/W issue or Oracle Terminating the connection. - Is it happening for every connection request, or if you are throttling the connection requests to a couple per second, does it work better? - Sometimes the DBMS can't handle lots of near-simultaneous connection requests. But If it happens with each request, every time, then it might be a DB a n/w issue. - Another possible reason could be that for some reason the software cannot read from "dev/random" In such cases you should try with the "java.security.egd" property as following, Because sometimes due to the lack of a fast random number generation device on the host where the map tasks execute. export HADOOP_OPTS=-Djava.security.egd=file:/dev/../dev/urandom sqoop import -Dmapred.child.java.opts="-Djava.security.egd=file:/dev/../dev/urandom" https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_oracle_connection_reset_errors . ... View more

@Chiranjeevi Nimmala As you using Python version "python-2.7.5" or higher, hence you should try to either downgrade the python version to lower than python-2.7.5 as it causes this issue. [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:579)<br> (OR) Else you will need to following the steps mentioned in the following doc to fix the "certificate verify failed (_ssl.c" issue while using RHEL7: Controlling and troubleshooting certificate verification https://access.redhat.com/articles/2039753#controlling-certificate-verification-7 . Also we will suggest you to remove the Ambari Server certificates as mentioned in the following doc so that new certificates can be generated by ambari. https://cwiki.apache.org/confluence/display/AMBARI/Handling+Expired+HTTPS+Certificates https://community.hortonworks.com/articles/68799/steps-to-fix-ambari-server-agent-expired-certs.html . ... View more

@Suhel Which process was consuming More memory on your Operating System when you noticed the new process died with the following error? # Native memory allocation (mmap) failed to map 977797120 bytes for committing reserved memory. . What is the version of ambari that you are using? Did you find ambari agent process was consuming more memory? In some older version of ambari agent there was a memory leak issue detected as mentioned in the https://issues.apache.org/jira/browse/AMBARI-17065 This causes ambari agent to consume many GB of memory over a period of 2-3 days and keep growing. . ... View more

@john matthews I am able to see the service on HDP 2.6 sandbox # service ambari-server status Using python /usr/bin/python Ambari-server status Ambari Server running Found Ambari Server PID: 351 at: /var/run/ambari-server/ambari-server.pid . Are you doing ssh to Sandbox using port 2222 ? (Using port 2222 is correct approach) # ssh root@localhost -p 2222 . ... View more

@nshelke When we perform "ambari-server sync-ldap" then ambari actually invokes the following ambari API on "127.0.0.1" address (not on the ambari FQDN) http://127.0.0.1:8080/api/v1/ldap_sync_events - Python code snippet from "setupSecurity.py" that is used for ldap sync url = get_ambari_server_api_base(properties) + SERVER_API_LDAP_URL admin_auth = base64.encodestring('%s:%s' % (admin_login, admin_password)).replace('\n', '') request = urllib2.Request(url) request.add_header('Authorization', 'Basic %s' % admin_auth) request.add_header('X-Requested-By', 'ambari') Because ambari uses the following python script (not java) to perform the following python script [1], Hence the "-Dhttp.nonProxyHosts" proxy setting will not be used here because that property is Java specific, Python modules will not respect that property. So you should try setting the proxy settings at the OS level inside the "~/.profile", "~/.bash_profile", ENV level. Like: http_proxy="http://proxy.com:8080" no_proxy="127.0.0.1, localhost" [1] https://github.com/apache/ambari/blob/release-2.5.1/ambari-server/src/main/python/ambari_server/setupSecurity.py#L315-L319 . ... View more

@Robin Dong The "ambari-admin-password-reset" utility command is present only on HDP Sandbox to reset ambari admin credentials. These does not come with default Ambari or HDP installation. So if you forgot your ambari admin credentials and if you wan tto reset them to admin/admin then you will have to run the following Ambari DB sql query (For example if ambari DB is postgres and the DB password is "bigdata" (default) then we can try the following): # psql -U ambari ambari Password for user ambari: bigdata psql (8.4.20) Type "help" for help. ambari=> update ambari.users set user_password='538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00' where user_name='admin'; . Followed by ambari restart and then you should be able to login to ambari using admin/admin credentials. - The issue you reported is strange, usually creating a new user (admin1) does not alter default admin credentials. May be we can check the ambari db "users" table to see the encrypted passwords or the DB logs to see if someone executed some Db queries which caused ambari admin user credential changes. ... View more

@sandeep Koutarapu 4200 web terminal port is opened by the service "shellinabox". So can you please check if that service is running or not? - I do not have Azur VM ready at my end currently to check the same. However in HDP sandbox for Linux i see that this service is up as following: # shellinaboxd -u shellinabox -g shellinabox --cert=/var/lib/shellinabox --port=4200 --background=/var/run/shellinaboxd.pid -t -s /:SSH:sandbox.hortonworks.com --css white-on-black.css . ... View more

@Joshua Adeleke The error says : -bash: /var/lib/ambari-agent/cache/common-services/NIFI/1.0.0/package/scripts/run_ca.sh: Permission denied . Can you please check if you have that file existing and if it has the correct permissions? Can you please check and share the permission of this file? Are you starting ambari-agent as "root" user or non-root user? You also might want to clear the ambari-agent "cache" directory and then try restarting the agent so that it can pull fresh files from ambari server. . ... View more