Add Service Wizard won't load?

[#1]

Hello every body , i m trying to add services to HDP but it stills showing loading page, ! does anyone have an idea how to resolve this issue ?thank you.

capture-decran-2017-05-02-a-120545.pngcapture-decran-2017-05-02-a-120545.png

[#2]

@tita titouf

One of the reason of such issue might be because some of your Host might be in 'OUT_OF_SYNC' state.

Try to execute the following SQL commands on the ambari DB to find if there was any host in "Out_Of_Sync" state Or check the hosts page?

SELECT host_id, state FROM host_version WHERE state = "OUT_OF_SYNC";

SELECT host_id, host_name FROM hosts where host_id IN (SELECT host_id FROM host_version WHERE state = "OUT_OF_SYNC");

Before adding new service to the cluster try to set the Maintenance Mode for those host to "ON" and then added the services.

.

[#3]

thank you for your quick answer ! unfortunately it shows ERROR 1046 (3D000): No database selected

[#4]

@tita titouf

Are you selecting to "ambari" database before running the mentioned command? Example:

# mysql -u ambari ambari -pbigdata 

mysql> SELECT host_id, state FROM host_version WHERE state = "OUT_OF_SYNC";

mysql> SELECT host_id, host_name FROM hosts where host_id IN (SELECT host_id FROM host_version WHERE state = "OUT_OF_SYNC");

Here arguments are as following:

-u ambari => username)

ambari => database name

-pbigdata => password is default 'bigdata' for ambari, there should be no space between -p & bigdata)

- Also do you see any ERROR/WARN in "/var/log/ambari-server/ambari-server.log" after clicking on Add Service button on UI? Please share the log.

.

[#5]

thank you very much for you support:

mysql -u ambari ambari -pbigdata 

ERROR 1045 (28000): Access denied for user 'ambari'@'localhost' (using password: YES)

capture-decran-2017-05-02-a-120545.png

capture-decran-2017-05-02-a-181048.png

capture-decran-2017-05-02-a-181239.pngcapture-decran-2017-05-02-a-181239.png

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Monaco; color: #f5f5f5; background-color: #000000} span.s1 {font-variant-ligatures: no-common-ligatures}

13:38,553 WARN [ambari-heartbeat-processor-0] HeartbeatProcessor:701 - Received a live status with invalid payload service, clusterName=pfe, serviceName=HDFS, componentName=DATANODE, hostname=hdfs-hdp.pfe.test.com, error=Name is null

02 mai 2017 18:13:38,554 WARN [ambari-heartbeat-processor-0] HeartbeatProcessor:701 - Received a live status with invalid payload service, clusterName=pfe, serviceName=HDFS, componentName=NAMENODE, hostname=hdfs-hdp.pfe.test.com, error=Name is null

02 mai 2017 18:13:42,838 INFO [qtp-ambari-agent-233] HeartBeatHandler:289 - Recovery configuration set to RecoveryConfig{, type=AUTO_START, maxCount=6, windowInMinutes=60, retryGap=5, maxLifetimeCount=1024, components=, recoveryTimestamp=1493741622836}

02 mai 2017 18:13:47,938 INFO [qtp-ambari-agent-206] HeartBeatHandler:289 - Recovery configuration set to RecoveryConfig{, type=AUTO_START, maxCount=6, windowInMinutes=60, retryGap=5, maxLifetimeCount=1024, components=, recoveryTimestamp=1493741627936}

02 mai 2017 18:13:53,130 INFO [qtp-ambari-agent-206] HeartBeatHandler:289 - Recovery configuration set to RecoveryConfig{, type=AUTO_START, maxCount=6, windowInMinutes=60, retryGap=5, maxLifetimeCount=1024, components=, recoveryTimestamp=1493741633128}

02 mai 2017 18:13:53,986 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/debian7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:53,986 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/debian7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:53,988 ERROR [ambari-client-thread-170] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:53,988 ERROR [ambari-client-thread-170] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:53,989 ERROR [ambari-client-thread-26] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:53,990 ERROR [ambari-client-thread-26] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:53,991 ERROR [ambari-client-thread-104] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/debian6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:53,991 ERROR [ambari-client-thread-104] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/debian6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,002 ERROR [ambari-client-thread-28] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos6/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,003 ERROR [ambari-client-thread-28] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos6/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,003 ERROR [ambari-client-thread-25] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos7 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,004 ERROR [ambari-client-thread-25] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos7 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,040 ERROR [ambari-client-thread-244] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/suse11sp3/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,041 ERROR [ambari-client-thread-244] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/suse11sp3/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,043 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,043 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,044 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu14/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,045 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu14/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,046 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,047 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,048 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu12/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,048 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu12/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,050 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/suse11sp3 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,050 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/suse11sp3 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,052 ERROR [ambari-client-thread-25] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/debian7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,053 ERROR [ambari-client-thread-25] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/debian7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,054 ERROR [ambari-client-thread-25] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/debian6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,054 ERROR [ambari-client-thread-25] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/debian6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,056 ERROR [ambari-client-thread-25] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos6/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,056 ERROR [ambari-client-thread-25] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos6/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,058 ERROR [ambari-client-thread-244] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,059 ERROR [ambari-client-thread-244] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos6 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,060 ERROR [ambari-client-thread-244] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,060 ERROR [ambari-client-thread-244] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/centos7/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,070 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos7 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,071 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/centos7 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,072 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/suse11sp3/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,073 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/suse11sp3/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,074 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/suse11sp3 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,074 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/suse11sp3 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,076 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu12/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,076 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu12/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,078 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,078 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,080 ERROR [ambari-client-thread-225] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu14/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,163 ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu14/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,081 ERROR [ambari-client-thread-26] AmbariManagementControllerImpl:4203 - Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:54,164 ERROR [ambari-client-thread-26] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP-UTILS-1.1.0.20/repos/ubuntu12 . public-repo-1.hortonworks.com

02 mai 2017 18:13:58,237 INFO [qtp-ambari-agent-206] HeartBeatHandler:289 - Recovery configuration set to RecoveryConfig{, type=AUTO_START, maxCount=6, windowInMinutes=60, retryGap=5, maxLifetimeCount=1024, components=, recoveryTimestamp=1493741638236}

02 mai 2017 18:14:03,350 INFO [qtp-ambari-agent-233] HeartBeatHandler:289 - Recovery configuration set to RecoveryConfig{, type=AUTO_START, maxCount=6, windowInMinutes=60, retryGap=5, maxLifetimeCount=1024, components=, recoveryTimestamp=1493741643349}

02 mai 2017 18:14:08,454 INFO [qtp-ambari-agent-233] HeartBeatHandler:289 - Recovery configuration set to RecoveryConfig{, type=AUTO_START, maxCount=6, windowInMinutes=60, retryGap=5, maxLifetimeCount=1024, components=, recoveryTimestamp=1493741648452}

02 mai 2017 18:14:13,558 INFO [qtp-ambari-agent-233] HeartBeatHandler:289 - Recovery configuration set to RecoveryConfig{, type=AUTO_START, maxCount=6, windowInMinutes=60, retryGap=5, maxLifetimeCount=1024, components=, recoveryTimestamp=1493741653556

[#6]

@tita titouf

Couple of things are strange and you should check:

1. We see in your screenshot '14995-capture-decran-2017-05-02-a-181239.png' that the IP Address resolution is not happening for host "hdfs-hdp.pfe.test.com" and hence we see:

WARN [ambari-heartbeat-processor-0] HeartbeatProcessor:701 - Received a 
live status with invalid payload service, clusterName=pfe, 
serviceName=HDFS, componentName=NAMENODE, hostname=hdfs-hdp.pfe.test.com, error=Name is null

So please check if your NameNode is having correct hostname defined in HDFS configs.

Check the output of the following commands to see if IPAddress resolution is correct:

# ifconfig
# hostname -f

.

Also verify if the ambari-agent log shows any ERROR/WARNING in this host?

# less /var/log/ambari-agent/ambari-agent.log

And check the RPM of ambari-agent if it's version is same as ambari-server.

Example:

# rpm -qa | grep ambari
ambari-agent-2.4.0.0-1225.x86_64
ambari-server-2.4.0.0-1225.x86_64

.

2. The following error indicates that you might not have internet access from ambari server/agent hosts. So you should first check if the internet access is there or not else you need to make sure that at least Off line Local repository is configured as mentioned in: http://docs.hortonworks.com/HDPDocuments/Ambari-2.5.0.3/bk_ambari-installation/content/setting_up_a_...

ERROR [ambari-client-thread-225] BaseManagementHandler:67 - Bad request received: Could not access base url . http://public-repo-1.hortonworks.com/HDP/ubuntu12/2.x/updates/2.4.0.0 . public-repo-1.hortonworks.com

You can verify the same. Check if the ambari repo is accessible and if youa re able to access the "hdp.repo" file from your cluster nodes/ambari host.

# ping public-repo-1.hortonworks.com
# wget http://public-repo-1.hortonworks.com/HDP/ubuntu12/2.x/updates/2.4.0.0/hdp.repo 

.

3. The error that you are getting while attempting to MySQL Database indicates wither you do not have correct permissions specified for mysql user or you might be entering incorrect credentials (or your Ambari DB is not using the default password 'bigdata'.

Please check the following section of the DOC to know what pre-configuration is needed in order to use MySQL as ambari DB. https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.0.3/bk_ambari-administration/content/using_amba...

# mysql -u ambari ambari -pbigdata 
ERROR 1045 (28000): Access denied for user 'ambari'@'localhost' (using password: YES)

Also please check the file specified in the following property to see if the password is correct.

# grep 'server.jdbc.user.passwd' /etc/ambari-server/conf/ambari.properties 
server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat

# cat /etc/ambari-server/conf/password.dat
bigdata

.