enable mysql access from buildbot-master{11..14}.build.scl1.m.c and buildbot-master{07..10}.build.sjc1.m.c to buildbot_schedulers & buildbot dbs on tm-b01-master01

RESOLVED FIXED

Status

RESOLVED FIXED
7 years ago
5 years ago

People

(Reporter: catlee, Assigned: arzhel)

Tracking

Details

(Reporter)

Description

7 years ago
Probably need both mysql ACLs and firewall access granted.
Assignee: server-ops-releng → server-ops
Component: Server Operations: RelEng → Server Operations
QA Contact: zandr → mrz

Updated

7 years ago
Assignee: server-ops → server-ops-database
Component: Server Operations → Server Operations: Database
(Reporter)

Updated

7 years ago
Summary: enable mysql access from buildbot-master{11..14}.build.scl1.m.c to buildbot_schedulers db on tm-b01-master01 → enable mysql access from buildbot-master{11..14}.build.scl1.m.c and buildbot-master{07..10}.build.sjc1.m.c to buildbot_schedulers db on tm-b01-master01
These need the same access as the existing buildbot user that's on from several other hosts?
Assignee: server-ops-database → justdave
That's right, actually accessing both the buildbot_schedulers and buildbot DBs.
Summary: enable mysql access from buildbot-master{11..14}.build.scl1.m.c and buildbot-master{07..10}.build.sjc1.m.c to buildbot_schedulers db on tm-b01-master01 → enable mysql access from buildbot-master{11..14}.build.scl1.m.c and buildbot-master{07..10}.build.sjc1.m.c to buildbot_schedulers & buildbot dbs on tm-b01-master01

Comment 3

7 years ago
Any ETA?
ok, so the affected hosts are:

buildbot-master07.build.sjc1.mozilla.com   10.2.71.132
buildbot-master08.build.sjc1.mozilla.com   10.2.71.133
buildbot-master09.build.sjc1.mozilla.com   10.2.71.134
buildbot-master10.build.sjc1.mozilla.com   10.2.71.142
buildbot-master11.build.scl1.mozilla.com   10.12.49.11
buildbot-master12.build.scl1.mozilla.com   10.12.49.12
buildbot-master13.build.scl1.mozilla.com   10.12.49.13
buildbot-master14.build.scl1.mozilla.com   10.12.49.14
Status: NEW → ASSIGNED
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.2.71.132';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.2.71.132';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.2.71.133';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.2.71.133';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.2.71.134';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.2.71.134';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.2.71.142';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.2.71.142';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.250.48.246';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.250.48.246';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.12.49.11';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.12.49.11';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.12.49.12';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.12.49.12';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.12.49.13';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.12.49.13';
GRANT ALL PRIVILEGES ON `buildbot_schedulers`.* TO 'buildbot'@'10.12.49.14';
GRANT ALL PRIVILEGES ON `buildbot`.* TO 'buildbot'@'10.12.49.14';

Same password as used by the buildbot user from elsewhere.

Netops, need the following opened on the firewall:

10.2.71.132 -> 10.2.70.105:3306
10.2.71.132 -> 10.2.70.106:3306
10.2.71.133 -> 10.2.70.105:3306
10.2.71.133 -> 10.2.70.106:3306
10.2.71.134 -> 10.2.70.105:3306
10.2.71.134 -> 10.2.70.106:3306
10.2.71.142 -> 10.2.70.105:3306
10.2.71.142 -> 10.2.70.106:3306
10.12.49.11 -> 10.2.70.105:3306
10.12.49.11 -> 10.2.70.106:3306
10.12.49.12 -> 10.2.70.105:3306
10.12.49.12 -> 10.2.70.106:3306
10.12.49.13 -> 10.2.70.105:3306
10.12.49.13 -> 10.2.70.106:3306
10.12.49.14 -> 10.2.70.105:3306
10.12.49.14 -> 10.2.70.106:3306
Assignee: justdave → network-operations
Component: Server Operations: Database → Server Operations: Netops
(all TCP of course)

Comment 7

7 years ago
Thanks!
(Assignee)

Updated

7 years ago
Assignee: network-operations → arzhel
(Assignee)

Comment 8

7 years ago
Opened

[root@buildbot-master11 ~]# telnet 10.2.70.105 3306
Trying 10.2.70.105...
Connected to tm-b01-master01.mozilla.org (10.2.70.105).


etc...
Status: ASSIGNED → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.