I have synced Users and groups in Ambari UI using, ambari-server sync-ldap --users /home/centos/users.txt --groups /tmp/groups.txt Using python /usr/bin/python Syncing with LDAP... Enter Ambari Admin login: admin Enter Ambari Admin password: Syncing specified users and groups... Completed LDAP Sync. Summary: memberships: removed = 0 created = 0 users: skipped = 0 removed = 0 updated = 0 created = 4 groups: updated = 0 removed = 0 created = 0 But users are not mapped to any group, but it does not add users to the group. Which parameters should I check in ambari.properties. ... View more

I checked the Ambari DB and Saw some inconsistencies while upgrading it, mysql> select cluster_id,resource_id,upgrade_id,provisioning_state,security_type,desired_stack_id from clusters; +------------+-------------+------------+--------------------+---------------+------------------+ | cluster_id | resource_id | upgrade_id | provisioning_state | security_type | desired_stack_id | +------------+-------------+------------+--------------------+---------------+------------------+ | 2 | 4 | NULL | INSTALLED | KERBEROS | 2 | +------------+-------------+------------+--------------------+---------------+------------------+ 1 row in set (0.00 sec) mysql> update clusters SET upgrade_id = '' where cluster_id = 2; ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`ambari`.`clusters`, CONSTRAINT `FK_clusters_upgrade_id` FOREIGN KEY (`upgrade_id`) REFERENCES `upgrade` (`upgrade_id`)) Getting the Above error while updating the Upgrade_id. How to update it. Please help. ... View more

WARN [qtp-ambari-agent-4198] HeartBeatHandler:411 - Received registration request from host with non compatible agent version, hostname=xxx, agentVersion=2.4.3.0, serverVersion=2.5.1.0 ... View more