700441 - MW: BZ ETL : To change UIDs to match central DB, for all internal users

Status: RESOLVED FIXED

(Mozilla Metrics :: Metrics Operations, task)

Description

[T [:tmary] Meyarivan]

mkurze@:

This would require changing UIDs and restarting all processes which currently run as the old UID

Given that there are many production processes (BZ ETL) running as user mkurze@ on *.generic.sjc1 hosts, they would need to be shutdown cleanly before making changes and restarted afterwards.

Please update the ticket with steps etc for stopping/starting the services.

--

Comment 1

[Michael Kurze [:michaelk]]

Let me first make a list of the processes started under my ID (got using `ps fxU mkurze`):

* Solr on node18, node19
  start: ( cd /usr/local/bugzilla_dwh/solr_shard/ ; ./bin/run_solr )
  stop: ( cd /usr/local/bugzilla_dwh/solr_shard/ ; ./bin/stop_solr )

* LilyCMS on node21, node22
  start: ( cd /usr/local/bugzilla_dwh/lily ; ./service/lily-service start )
  stop: ( cd /usr/local/bugzilla_dwh/lily ; ./service/lily-service stop )

* ES on node18-24
  start: ( cd /home/mkurze/bugzilla_dwh_es/elasticsearch/ ; ./bin/service/elasticsearch start )
  stop: ( cd /home/mkurze/bugzilla_dwh_es/elasticsearch/ ; ./bin/service/elasticsearch stop )

* ssh tunnel - all nodes, not a service (headless subshell):
  start: ssh -NL 3306:tm-bugs01-ro-zeus:3306 [e-mail] 


All these processes are shut down now.

Comment 2

[T [:tmary] Meyarivan]

Uids on node[18-24].generic, admin3.generic have been changed.

--