Change Details

Similar to {T296274} but running for wikiuser, that user handles webrequests. Result of check: == General issues == **DB unavaiable** No further check was done on this db [] db1102.eqiad.wmnet:3312 (s2) [] db1102.eqiad.wmnet:3313 (s3) ---- **10.64.% user missing** No further check was done on this grants of 10.64.% user in these dbs [] db1140.eqiad.wmnet:3311 (s1) [] db1133.eqiad.wmnet:3306 (s1) [] db1128.eqiad.wmnet:3306 (s1) [] db1125.eqiad.wmnet:3306 (s4) [] db1124.eqiad.wmnet:3306 (s4) ---- **10.192.% user missing** No further check was done on this grants of 10.192.% user in these dbs [] db1140.eqiad.wmnet:3311 (s1) [] db1133.eqiad.wmnet:3306 (s1) [] db1128.eqiad.wmnet:3306 (s1) [] db1125.eqiad.wmnet:3306 (s4) [] db1124.eqiad.wmnet:3306 (s4) ---- **localhost user found** [x] db2130.codfw.wmnet:3306 (s1) [x] db2101.codfw.wmnet:3312 (s2) [x] db2074.codfw.wmnet:3306 (s3) ---- ==10.64.%== **appserver grant missing** None! ---- **replication grant missing** None! ---- **heartbeat grant missing** None! ---- **Extra grant #1** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* TO `wikiuser`@`10.64.%```` [] db1163.eqiad.wmnet:3306 (s1) [] db1156.eqiad.wmnet:3306 (s2) [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s7) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s7) ---- **Extra grant #2** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `%a%`.* TO `wikiuser`@`10.64.%```` [] db2149.codfw.wmnet:3306 (s3) [] db2139.codfw.wmnet:3313 (s3) [] db2127.codfw.wmnet:3306 (s3) [] db2109.codfw.wmnet:3306 (s3) [] db2105.codfw.wmnet:3306 (s3) [] db2074.codfw.wmnet:3306 (s3) [] db1179.eqiad.wmnet:3306 (s3) [] db1175.eqiad.wmnet:3306 (s3) [] db1166.eqiad.wmnet:3306 (s3) [] db1157.eqiad.wmnet:3306 (s3) [] db1123.eqiad.wmnet:3306 (s3) [] db1112.eqiad.wmnet:3306 (s3) [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s7) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s7) [] db1181.eqiad.wmnet:3306 (s7) [] db1174.eqiad.wmnet:3306 (s7) [] db1171.eqiad.wmnet:3317 (s7) [] db1170.eqiad.wmnet:3317 (s7) [] db1158.eqiad.wmnet:3306 (s7) [] db1136.eqiad.wmnet:3306 (s7) [] db1127.eqiad.wmnet:3306 (s7) [] db1101.eqiad.wmnet:3317 (s7) [] db1098.eqiad.wmnet:3317 (s7) ---- **Extra grant #3** The extra grant: ```lang=mysql GRANT SELECT ON `heartbeat`.* TO `wikiuser`@`10.64.%```` [x] db2074.codfw.wmnet:3306 (s3) ---- ==10.192.%== **appserver grant missing** None! ---- **replication grant missing** None! ---- **heartbeat grant missing** None! ---- **Extra grant #1** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* TO `wikiuser`@`10.192.%```` [] db1163.eqiad.wmnet:3306 (s1) [] db1156.eqiad.wmnet:3306 (s2) [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s7) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s7) ---- **Extra grant #2** The extra grant: ```lang=mysql GRANT SELECT ON `heartbeat`.* TO `wikiuser`@`10.192.%```` [x] db2074.codfw.wmnet:3306 (s3) ---- **Extra grant #3** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `%a%`.* TO `wikiuser`@`10.192.%```` [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s7) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s7) [] db1181.eqiad.wmnet:3306 (s7) [] db1174.eqiad.wmnet:3306 (s7) [] db1171.eqiad.wmnet:3317 (s7) [] db1170.eqiad.wmnet:3317 (s7) [] db1158.eqiad.wmnet:3306 (s7) [] db1136.eqiad.wmnet:3306 (s7) [] db1127.eqiad.wmnet:3306 (s7) [] db1101.eqiad.wmnet:3317 (s7) [] db1098.eqiad.wmnet:3317 (s7)

Similar to {T296274} but running for wikiuser, that user handles webrequests. Result of check: == General issues == **DB unavaiable** No further check was done on this db None! ---- **10.64.% user missing** No further check was done on this grants of 10.64.% user in these dbs [] db1140.eqiad.wmnet:3311 (s1) [] db1133.eqiad.wmnet:3306 (s1) [] db1128.eqiad.wmnet:3306 (s1) [] db1125.eqiad.wmnet:3306 (s4) [] db1124.eqiad.wmnet:3306 (s4) ---- **10.192.% user missing** No further check was done on this grants of 10.192.% user in these dbs [] db1140.eqiad.wmnet:3311 (s1) [] db1133.eqiad.wmnet:3306 (s1) [] db1128.eqiad.wmnet:3306 (s1) [] db1125.eqiad.wmnet:3306 (s4) [] db1124.eqiad.wmnet:3306 (s4) ---- **localhost user found** [] db1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:3313 (s3) ---- ==10.64.%== **appserver grant missing** None! ---- **replication grant missing** None! ---- **heartbeat grant missing** [] db1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:3313 (s3) ---- **centralauth grant missing** None! ---- **Extra grant #1** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* TO `wikiuser`@`10.64.%```` [] db1139.eqiad.wmnet:3312 (s2) [] db1102.eqiad.wmnet:3312 (s2) ---- **Extra grant #2** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `%a%`.* TO `wikiuser`@`10.64.%```` [] db2149.codfw.wmnet:3306 (s3) [] db2139.codfw.wmnet:3313 (s3) [] db2127.codfw.wmnet:3306 (s3) [] db2109.codfw.wmnet:3306 (s3) [] db2105.codfw.wmnet:3306 (s3) [] db2074.codfw.wmnet:3306 (s3) [] db1179.eqiad.wmnet:3306 (s3) [] db1175.eqiad.wmnet:3306 (s3) [] db1166.eqiad.wmnet:3306 (s3) [] db1157.eqiad.wmnet:3306 (s3) [] db1145.eqiad.wmnet:3313 (s3) [] db1112.eqiad.wmnet:3306 (s3) [] db1102.eqiad.wmnet:3313 (s3) ---- **Extra grant #3** The extra grant: ```lang=mysql GRANT SELECT ON `heartbeat`.* TO `wikiuser`@`10.64.%```` [] db1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:3313 (s3) ---- ==10.192.%== **appserver grant missing** None! ---- **replication grant missing** None! ---- **heartbeat grant missing** [] db1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:3313 (s3) ---- **centralauth grant missing** None! ---- **Extra grant #1** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* TO `wikiuser`@`10.192.%```` [] db1139.eqiad.wmnet:3312 (s2) [] db1102.eqiad.wmnet:3312 (s2) ---- **Extra grant #2** The extra grant: ```lang=mysql GRANT SELECT ON `heartbeat`.* TO `wikiuser`@`10.192.%```` [] db1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:3313 (s3) ----

Similar to {T296274} but running for wikiuser, that user handles webrequests. Result of check: == General issues == **DB unavaiable** No further check was done on this db [] db1102.eqiad.wmnet:3312 (s2) [] db1102.eqiad.wmnet:3313 (s3)None! ---- **10.64.% user missing** No further check was done on this grants of 10.64.% user in these dbs [] db1140.eqiad.wmnet:3311 (s1) [] db1133.eqiad.wmnet:3306 (s1) [] db1128.eqiad.wmnet:3306 (s1) [] db1125.eqiad.wmnet:3306 (s4) [] db1124.eqiad.wmnet:3306 (s4) ---- **10.192.% user missing** No further check was done on this grants of 10.192.% user in these dbs [] db1140.eqiad.wmnet:3311 (s1) [] db1133.eqiad.wmnet:3306 (s1) [] db1128.eqiad.wmnet:3306 (s1) [] db1125.eqiad.wmnet:3306 (s4) [] db1124.eqiad.wmnet:3306 (s4) ---- **localhost user found** [x] db2130.codfw.wmnet:3306 (s1) [x] db2101.codfw1145.eqiad.wmnet:3312 (s23 (s3) [x] db2074.codfw1102.eqiad.wmnet:330613 (s3) ---- ==10.64.%== **appserver grant missing** None! ---- **replication grant missing** None! ---- **heartbeat grant missing** [] db1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:3313 (s3) ---- **centralauth grant missing** None! ---- **Extra grant #1** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* TO `wikiuser`@`10.64.%```` [] db116339.eqiad.wmnet:3306 (s112 (s2) [] db115602.eqiad.wmnet:3306 (s2) [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s7) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s712 (s2) ---- **Extra grant #2** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `%a%`.* TO `wikiuser`@`10.64.%```` [] db2149.codfw.wmnet:3306 (s3) [] db2139.codfw.wmnet:3313 (s3) [] db2127.codfw.wmnet:3306 (s3) [] db2109.codfw.wmnet:3306 (s3) [] db2105.codfw.wmnet:3306 (s3) [] db2074.codfw.wmnet:3306 (s3) [] db1179.eqiad.wmnet:3306 (s3) [] db1175.eqiad.wmnet:3306 (s3) [] db1166.eqiad.wmnet:3306 (s3) [] db1157.eqiad.wmnet:3306 (s3) [] db112345.eqiad.wmnet:330613 (s3) [] db1112.eqiad.wmnet:3306 (s3) [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s7) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s7) [] db1181.eqiad.wmnet:3306 (s7) [] db1174.eqiad.wmnet:3306 (s7) [] db1171.eqiad.wmnet:3317 (s7) [] db1170.eqiad.wmnet:3317 (s7) [] db1158.eqiad.wmnet:3306 (s7) [] db1136.eqiad.wmnet:3306 (s7) [] db1127.eqiad.wmnet:3306 (s7) [] db1101.eqiad.wmnet:3317 (s7) [] db10981102.eqiad.wmnet:3317 (s73 (s3) ---- **Extra grant #3** The extra grant: ```lang=mysql GRANT SELECT ON `heartbeat`.* TO `wikiuser`@`10.64.%```` [x] db2074.codfw1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:330613 (s3) ---- ==10.192.%== **appserver grant missing** None! ---- **replication grant missing** None! ---- **heartbeat grant missing** [] db1145.eqiad.wmnet:3313 (s3) [] db1102.eqiad.wmnet:3313 (s3) ---- **centralauth grant missing** None! ---- **Extra grant #1** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `centralauth`.* TO `wikiuser`@`10.192.%```` [] db1163.eqiad.wmnet:3306 (s1) [] db115639.eqiad.wmnet:3306 (s2) [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s712 (s2) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s71102.eqiad.wmnet:3312 (s2) ---- **Extra grant #2** The extra grant: ```lang=mysql GRANT SELECT ON `heartbeat`.* TO `wikiuser`@`10.192.%```` [x] db2074.codfw.wmnet:3306 (s3) ---- **Extra grant #3** The extra grant: ```lang=mysql GRANT SELECT, INSERT, UPDATE, DELETE ON `%a%`.* TO `wikiuser`@`10.192.%````] db1145.eqiad.wmnet:3313 (s3) [] db2150.codfw.wmnet:3306 (s7) [] db2122.codfw.wmnet:3306 (s7) [] db2121.codfw.wmnet:3306 (s7) [] db2120.codfw.wmnet:3306 (s7) [] db2118.codfw.wmnet:3306 (s7) [] db2108.codfw.wmnet:3306 (s7) [] db2098.codfw.wmnet:3317 (s7) [] db2087.codfw.wmnet:3317 (s7) [] db2086.codfw.wmnet:3317 (s7) [] db2077.codfw.wmnet:3306 (s7) [] db1181.eqiad.wmnet:3306 (s7) [] db1174.eqiad.wmnet:3306 (s7) [] db1171.eqiad.wmnet:3317 (s7) [] db1170.eqiad.wmnet:3317 (s7) [] db1158.eqiad.wmnet:3306 (s7) [] db1136.eqiad.wmnet:3306 (s7) [] db1127.eqiad.wmnet:3306 (s7) [] db11011102.eqiad.wmnet:3317 (s7) [] db1098.eqiad.wmnet:3317 (s7)3 (s3) ----