868133 - New bugzilla custom field

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

The custom field 'cf_tracking_relnote_b2g' has been added to the BMO database.

Please run the following on bugzilla1.db.scl3.mozilla.com:
  GRANT SELECT ON `bugs`.`cf_tracking_relnote_b2g` TO 'metrics'@'10.22.70.20_';
  GRANT SELECT (cf_tracking_relnote_b2g) ON `bugs`.`bugs` TO 'metrics'@'10.22.70.20_';
  GRANT SELECT ON `bugs`.`cf_tracking_relnote_b2g` TO 'metrics'@'10.22.70.21_';
  GRANT SELECT (cf_tracking_relnote_b2g) ON `bugs`.`bugs` TO 'metrics'@'10.22.70.21_';

Comment 1

[Sheeri Cabral [:sheeri]]

Done!

[[e-mail]3 ~]$ bugzilla2
Last login: Fri Apr 26 10:22:14 2013 from admin1a.private.scl3.mozilla.com
This is a Master MySQL server for bugzilla.


MariaDB [(none)]> use bugs;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [bugs]>   GRANT SELECT ON `bugs`.`cf_tracking_relnote_b2g` TO 'metrics'@'10.22.70.20_';
Query OK, 0 rows affected (0.00 sec)

MariaDB [bugs]>   GRANT SELECT (cf_tracking_relnote_b2g) ON `bugs`.`bugs` TO 'metrics'@'10.22.70.20_';
Query OK, 0 rows affected (0.00 sec)

MariaDB [bugs]>   GRANT SELECT ON `bugs`.`cf_tracking_relnote_b2g` TO 'metrics'@'10.22.70.21_';
Query OK, 0 rows affected (0.00 sec)

MariaDB [bugs]>   GRANT SELECT (cf_tracking_relnote_b2g) ON `bugs`.`bugs` TO 'metrics'@'10.22.70.21_';
Query OK, 0 rows affected (0.00 sec)