Page MenuHomePhabricator

Please remove zarcillo grants for prometheus[12]00[34]
Closed, ResolvedPublic

Description

These four hosts are decommissioned, thank you!

User: prometheus-mysqld-exporter

IPs:

prometheus1003  1H  IN A    10.64.0.123
prometheus1004  1H  IN A    10.64.16.38
prometheus2003   1H IN A    10.192.0.145
prometheus2004   1H IN A    10.192.16.189

There will be grants for prometheus[12]00[56] (i.e. the new prometheus hw), me and @Marostegui chatted about replacing individual host grants with codfw/eqiad network grants which would work fine for me.

Event Timeline

Marostegui triaged this task as Medium priority.Feb 15 2022, 3:26 PM
Marostegui edited projects, added: DBA; removed: Data-Persistence.

The IPs for the ones we had grants for and no longer resolve are:

10.192.0.145
10.64.0.123
10.64.16.38

We are missing one IP for the prometheus-mysqld-exporter, so maybe we never had that host?
@godog can you confirm those IPs used to belong to these hosts?

Marostegui moved this task from Triage to In progress on the DBA board.

prometheus2004 is: 10.192.16.189

Removed all those four these are the ones we currently have:

root@db1115.eqiad.wmnet[mysql]> select user,host from user where user like 'prometheus-mysqld-exporter';
+----------------------------+--------------+
| User                       | Host         |
+----------------------------+--------------+
| prometheus-mysqld-exporter | 10.128.0.34  |
| prometheus-mysqld-exporter | 10.132.0.33  |
| prometheus-mysqld-exporter | 10.192.16.75 |
| prometheus-mysqld-exporter | 10.192.32.67 |
| prometheus-mysqld-exporter | 10.20.0.104  |
| prometheus-mysqld-exporter | 10.64.0.82   |
| prometheus-mysqld-exporter | 10.64.16.62  |
| prometheus-mysqld-exporter | 10.64.32.25  |
+----------------------------+--------------+
8 rows in set (0.003 sec)