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

Hi Shelton,   Thanks for responding. Actually after deleting the CMS i am not finding the logs to attach, And as you suggested i have already created and trying to test the connections using those credentials. But i am getting error and you can see it in screen shot. The same server db also running Can i install my sql and create a DB and user and can i update them here ? Was it work for me ? Please suggest me with your valuable comments.   Best Regards, Vinod     ... View more

Hello,   If the data was present for the same issue, then what is the best way of sollution ? Can you please help me.   Thanks ... View more

Hi Manu,   Yes i am able to ping the hostname.   Regards, Vinod ... View more

Hi Manu,   Thanks for immediate responce and yes i have tried with IP also but No luck.   Regards, Vinod ... View more

Hello Can any one please respond on this issue, i am seeing frequent service monitor failures and getting it paused for some time and then it comes online.   Thanks in advance....! Vinod ... View more