Closed Bug 740006 Opened 12 years ago Closed 12 years ago

DB ACLs from autoland to MySQL schedulerdb

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: dustin, Assigned: scabral)

References

Details

10.22.72.16 and 10.22.72.17 (autoland1/2) need read-only access to the buildbot schedulerdb:

10:18 < catlee> dustin: the current one is 'buildbot' on tm-b01-master01/slave01
10:18 < catlee> dustin: the new one is also 'buildbot' on buildbot{1,2}.db.scl3

So please set up both ACLs.
Correction: we'll only need the buildbot{1,2}.db.scl3 flows.
Blocks: 707203
hold off on this - we're moving the hosts to phx1.  I'll have updated IPs soon.
10.8.72.12/31 (autoland1/2) both need read-only access to the buildbot schedulerdb.  This should be both tm-b01-master01/slave01 in sjc1 (for now) and the buildbot db VIP in scl3 (for later).
Blocks: 731763
Assignee: server-ops-database → scabral
[root@autoland1.shared.phx1 src]# nc -vz buildbot-ro-vip.db.scl3.mozilla.com 3306
Connection to buildbot-ro-vip.db.scl3.mozilla.com 3306 port [tcp/mysql] succeeded!

and a test connection works just fine, hoorj!
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.