Hi Li,   Thank you for your valuable response, We are using Cloudera Enterprise 5.8.1. Is there any other option here in ? Or can i upgrade CDH version to little higher ? so when we doing upgrade again it will ask License Key right, so it will convert into Express right ?   Please provide some suggestions.   Best Regards, Vinod     ... View more

Hi Eric,   Thanks for your valuable response and i have restarted twice but no luck. Still i can see Cloudera Enterprise 5.8.1 version.   Thanks & Regards, Vinod ... View more

Hello Shelton,   Thanks for your reply...! I have tried as you suggested but the thing is am seeing the same issue not even its related to password mismatch. If any password related mismatch may be we can do something else to fix it. Still facing same issue. Any suggestions are appreciated.   Thanks, Vinod ... View more

Hi Bgooley,   Thanks for response, Find few more details below,   $ netstat -na | grep 7432 tcp 0 0 0.0.0.0:7432 0.0.0.0:* LISTEN tcp 0 0 hostname:7432 hostname:51538 ESTABLISHED tcp 0 0 hostname:7432 hostname:51786 ESTABLISHED tcp 0 0 hostname:7432 hostname:51776 ESTABLISHED tcp 0 0 hostname:51766 hostname:7432 ESTABLISHED tcp 0 0 hostname:51542 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51778 ESTABLISHED tcp 0 0 hostname:7432 hostname:51746 ESTABLISHED tcp 0 0 hostname:7432 hostname:51758 ESTABLISHED tcp 0 0 hostname:51776 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51754 ESTABLISHED tcp 0 0 hostname:51536 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51788 ESTABLISHED tcp 0 0 hostname:51772 hostname:7432 ESTABLISHED tcp 0 0 hostname:51752 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51742 ESTABLISHED tcp 0 0 hostname:51762 hostname:7432 ESTABLISHED tcp 0 0 hostname:51756 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51790 ESTABLISHED tcp 0 0 hostname:7432 hostname:34766 ESTABLISHED tcp 0 0 hostname:34766 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51772 ESTABLISHED tcp 0 0 hostname:51792 hostname:7432 ESTABLISHED tcp 0 0 hostname:51750 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51539 ESTABLISHED tcp 0 0 hostname:51784 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51782 ESTABLISHED tcp 0 0 hostname:51774 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51760 ESTABLISHED tcp 0 0 hostname:7432 hostname:51542 ESTABLISHED tcp 0 0 hostname:51770 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51756 ESTABLISHED tcp 0 0 hostname:7432 hostname:51764 ESTABLISHED tcp 0 0 hostname:34768 hostname:7432 ESTABLISHED tcp 0 0 hostname:51754 hostname:7432 ESTABLISHED tcp 0 0 hostname:51768 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:34764 ESTABLISHED tcp 0 0 hostname:51544 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51752 ESTABLISHED tcp 0 0 hostname:7432 hostname:51792 ESTABLISHED tcp 0 0 hostname:51782 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:34768 ESTABLISHED tcp 0 0 hostname:51778 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51750 ESTABLISHED tcp 0 0 hostname:51758 hostname:7432 ESTABLISHED tcp 0 0 hostname:51538 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51770 ESTABLISHED tcp 0 0 hostname:51744 hostname:7432 ESTABLISHED tcp 0 0 hostname:51764 hostname:7432 ESTABLISHED tcp 0 0 hostname:51790 hostname:7432 ESTABLISHED tcp 0 0 hostname:51539 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51744 ESTABLISHED tcp 0 0 hostname:34764 hostname:7432 ESTABLISHED tcp 0 0 hostname:51760 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51766 ESTABLISHED tcp 0 0 hostname:34770 hostname:7432 ESTABLISHED tcp 0 0 hostname:51788 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51784 ESTABLISHED tcp 0 0 hostname:7432 hostname:51536 ESTABLISHED tcp 0 0 hostname:7432 hostname:51544 ESTABLISHED tcp 0 0 hostname:7432 hostname:51762 ESTABLISHED tcp 0 0 hostname:7432 hostname:34770 ESTABLISHED tcp 0 0 hostname:51786 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51768 ESTABLISHED tcp 0 0 hostname:51746 hostname:7432 ESTABLISHED tcp 0 0 hostname:51742 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51774 ESTABLISHED tcp 0 0 :::7432 :::* LISTEN unix 2 [ ACC ] STREAM LISTENING 27666 /tmp/.s.PGSQL.7432 mcaf@tparhelmhp001:~:HADOOP PROD]$ netstat -na | grep 5432 tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN tcp 0 0 hostname:54322 10.8.53.154:60020 TIME_WAIT tcp 0 0 ::1:5432 :::* LISTEN unix 2 [ ACC ] STREAM LISTENING 27649 /tmp/.s.PGSQL.5432     As you said if i am trying to add CMS to cloudera automatically i can see Activity and Reports manager in list, how can i remove them in a list ?     And i can see below error's in stderr.log for acivity monitor,   log4j:ERROR Could not find value for key log4j.appender.A log4j:ERROR Could not instantiate appender named "A".   And i can see below error's in stderr.log for reports manager,   log4j:ERROR Could not find value for key log4j.appender.A log4j:ERROR Could not instantiate appender named "A".   Please revert me back.   Best Regards, Vinod ... View more

Team,   Any solutions will be appreciated. Still am facing the same issue and can some one help me on this.   Thanks, Vinod ... View more

Hello Bgooley,   Can you please give me some inputs to over come this issue.   Thanks, Vinod ... View more

Hi Bgooley,   Thanks a lot for quick responce, Find below details,       $ netstat -na | grep 7432 tcp 0 0 0.0.0.0:7432 0.0.0.0:* LISTEN tcp 0 0 hostname:7432 hostname:51538 ESTABLISHED tcp 0 0 hostname:44734 hostname:7432 ESTABLISHED tcp 0 0 hostname:7432 hostname:51786 ESTABLISHED ]$ ps -ef | grep postgres postgres 8253 1 0 Aug27 ? 00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data 498 8292 1 0 Aug27 ? 00:00:02 /usr/bin/postgres -D /var/lib/cloudera-scm-server-db/data postgres 8293 8253 0 Aug27 ? 00:00:09 postgres: logger process postgres 8295 8253 0 Aug27 ? 00:00:39 postgres: writer process postgres 8296 8253 0 Aug27 ? 00:00:38 postgres: wal writer process postgres 8297 8253 0 Aug27 ? 00:00:09 postgres: autovacuum launcher process postgres 8298 8253 0 Aug27 ? 00:00:05 postgres: stats collector process 498 8299 8292 0 Aug27 ? 00:00:09 postgres: logger process 498 8302 8292 0 Aug27 ? 00:00:44 postgres: writer process 498 8303 8292 0 Aug27 ? 00:00:37 postgres: wal writer process 498 8304 8292 0 Aug27 ? 00:00:11 postgres: autovacuum launcher process 498 8305 8292 0 Aug27 ? 00:00:24 postgres: stats collector process 498 8338 8292 0 12:27 ? 00:00:00 postgres: hive2 hive2 hostname(44730) idle 498 8339 8292 0 12:27 ? 00:00:00 postgres: hive2 hive2 hostname(44732) idle 498 8340 8292 0 12:27 ? 00:00:00 postgres: hive2 hive2 hostname(44734) idle 498 8341 8292 0 12:27 ? 00:00:00 postgres: hive2 hive2 hostname(44736) idle 498 9357 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51536) idle 498 9358 8292 0 Aug27 ? 00:00:01 postgres: scm scm hostname(51539) idle 498 9360 8292 0 Aug27 ? 00:01:02 postgres: scm scm hostname(51538) idle 498 9429 8292 0 Aug27 ? 00:02:11 postgres: scm scm hostname(51542) idle 498 9430 8292 0 Aug27 ? 00:01:49 postgres: scm scm hostname(51544) idle 498 12916 8292 0 Aug27 ? 00:00:08 postgres: scm scm hostname(51742) idle 498 12917 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51744) idle 498 12918 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51746) idle 498 13248 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51750) idle 498 13249 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51752) idle 498 13250 8292 0 Aug27 ? 00:01:41 postgres: scm scm hostname(51754) idle 498 13254 8292 0 Aug27 ? 00:01:26 postgres: scm scm hostname(51756) idle 498 13255 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51758) idle 498 13256 8292 0 Aug27 ? 00:01:08 postgres: scm scm hostname(51760) idle 498 13260 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51762) idle 498 13261 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51764) idle 498 13262 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51766) idle 498 13266 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51768) idle 498 13267 8292 0 Aug27 ? 00:00:56 postgres: scm scm hostname(51770) idle 498 13268 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51772) idle 498 13272 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51774) idle 498 13273 8292 0 Aug27 ? 00:00:29 postgres: scm scm hostname(51776) idle 498 13274 8292 0 Aug27 ? 00:01:25 postgres: scm scm hostname(51778) idle 498 13278 8292 0 Aug27 ? 00:02:40 postgres: scm scm hostname(51782) idle 498 13279 8292 0 Aug27 ? 00:00:36 postgres: scm scm hostname(51784) idle 498 13280 8292 0 Aug27 ? 00:02:13 postgres: scm scm hostname(51786) idle 498 13856 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51788) idle 498 13859 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51790) idle 498 13860 8292 0 Aug27 ? 00:00:00 postgres: scm scm hostname(51792) idle mcaf 19041 17708 0 12:35 pts/1 00:00:00 grep postgres     $ sudo vi /etc/cloudera-scm-server/db.mgmt.properties # The source of truth for these settings # is the Cloudera Manager databases and # changes made here will not be reflected # there automatically. # com.cloudera.cmf.ACTIVITYMONITOR.db.type=postgresql com.cloudera.cmf.ACTIVITYMONITOR.db.host=hostname:7432 com.cloudera.cmf.ACTIVITYMONITOR.db.name=amon com.cloudera.cmf.ACTIVITYMONITOR.db.user=amon com.cloudera.cmf.ACTIVITYMONITOR.db.password=4WB4R5yxnp com.cloudera.cmf.REPORTSMANAGER.db.type=postgresql com.cloudera.cmf.REPORTSMANAGER.db.host=hostname:7432 com.cloudera.cmf.REPORTSMANAGER.db.name=rman com.cloudera.cmf.REPORTSMANAGER.db.user=rman com.cloudera.cmf.REPORTSMANAGER.db.password=WceGeruLNG com.cloudera.cmf.NAVIGATOR.db.type=postgresql com.cloudera.cmf.NAVIGATOR.db.host=hostname:7432 com.cloudera.cmf.NAVIGATOR.db.name=nav com.cloudera.cmf.NAVIGATOR.db.user=nav com.cloudera.cmf.NAVIGATOR.db.password=D2tjw5xjoE com.cloudera.cmf.ACTIVITYMONITOR.db.type=postgresql com.cloudera.cmf.ACTIVITYMONITOR.db.host=hostname:7432 com.cloudera.cmf.ACTIVITYMONITOR.db.name=amon com.cloudera.cmf.ACTIVITYMONITOR.db.user=amon com.cloudera.cmf.ACTIVITYMONITOR.db.password=O31A60K5SN com.cloudera.cmf.REPORTSMANAGER.db.type=postgresql com.cloudera.cmf.REPORTSMANAGER.db.host=hostname:7432 com.cloudera.cmf.REPORTSMANAGER.db.name=rman com.cloudera.cmf.REPORTSMANAGER.db.user=rman com.cloudera.cmf.REPORTSMANAGER.db.password=BPPShP0O9k com.cloudera.cmf.NAVIGATOR.db.type=postgresql com.cloudera.cmf.NAVIGATOR.db.host=hostname:7432 com.cloudera.cmf.NAVIGATOR.db.name=nav com.cloudera.cmf.NAVIGATOR.db.user=nav com.cloudera.cmf.NAVIGATOR.db.password=QHYL7zUSQe com.cloudera.cmf.NAVIGATORMETASERVER.db.type=postgresql com.cloudera.cmf.NAVIGATORMETASERVER.db.host=hostname:7432 com.cloudera.cmf.NAVIGATORMETASERVER.db.name=navms com.cloudera.cmf.NAVIGATORMETASERVER.db.user=navms com.cloudera.cmf.NAVIGATORMETASERVER.db.password=elJRINTAth My db.mgmt properties file is looking like this and i can see two different activity monitor entries and two for reports manager entries.   And i have already tried using these user name and passwords while adding CMS. Please update me with your valuable comments.     Best Regards, Vinod     ... View more

Hi Bgooly,   Thanks for responding..!! Actually the same server i can see the status of embedded db,   $ sudo service cloudera-scm-server-db status pg_ctl: server is running (PID: 8292) /usr/bin/postgres "-D" "/var/lib/cloudera-scm-server-db/data"   $ sudo service cloudera-scm-server status cloudera-scm-server (pid 8475) is running... $ sudo service cloudera-scm-agent status cloudera-scm-agent (pid 8407) is running...   We are using embedded DB only and the cluster we are using for testing purpose and there are some data processing was happening. So in this case how i can install the external DB of postgresql where already postgress is installed ?   Is there any way the cloudera manager to recognize the DB for that step ? Is there any config file we have for that to modify or anything ?   Can you please help me on this issue. And you can find my present cluster health and i mentioned there the arrow mark, from there i am trying to add the cloudera management services.   Best Regards, Vinod ... View more