556391 - Production database for schedulerdb

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Chris AtLee [:catlee]]

Please create a new database for our production buildbot masters to use.

It should be called 'buildbot_schedulers' and be accessible by the 'buildbot' user, which should already have permissions on the 'buildbot' database.

It should be accessible for read/write access (including create/alter table) from production-master, production-master02, and production-master01,03 (from bug 556390).

Comment 1

[Shyam Mani [:fox2mike]]

Done.

mysql> create database buildbot_schedulers;
Query OK, 1 row affected (0.04 sec)

mysql> grant all on buildbot_schedulers.* to buildbot@'10.2.71.90';
Query OK, 0 rows affected (0.03 sec)

mysql> grant all on buildbot_schedulers.* to buildbot@'10.2.71.96';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on buildbot_schedulers.* to buildbot@'10.2.71.7';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on buildbot_schedulers.* to buildbot@'10.2.71.98';
Query OK, 0 rows affected (0.00 sec)

Also, I've poked holes in the firewall to allow 96 and 98 to connect to the DB.

Comment 2

[Chris AtLee [:catlee]]

On production-master01:
mysql -u buildbot -p -h tm-b01-master01.mozilla.org buildbot_schedulers

ERROR 2003 (HY000): Can't connect to MySQL server on 'tm-b01-master01.mozilla.org' (110)

Works fine from production-master, so looks like a firewall issue?

Comment 3

[Shyam Mani [:fox2mike]]

Access rules added on build-outbound.

Comment 4

[Shyam Mani [:fox2mike]]

And fixed the DB access issues.

Sorry Chris!