722450 - adding custom fields to bmo

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

We got these e-mails:

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_tracking_esr10` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_tracking_esr10) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_status_esr10` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_esr10) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_tracking_firefox13` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_tracking_firefox13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_status_firefox13` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_firefox13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_tracking_thunderbird13` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_tracking_thunderbird13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_status_thunderbird13` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_thunderbird13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_tracking_seamonkey210` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_tracking_seamonkey210) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

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

Please run the following on tm-bugs01-master01:
  GRANT SELECT ON `bugs`.`cf_status_seamonkey210` TO 'metrics'@'10.2.70.20_';
  GRANT SELECT (cf_status_seamonkey210) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';

Comment 1

[Sheeri Cabral [:sheeri]]

GRANT statements have been issued, resolving:

mysql> 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
mysql> show variables like 'hostname';
+---------------+--------------------+
| Variable_name | Value              |
+---------------+--------------------+
| hostname      | tm-bugs01-master01 | 
+---------------+--------------------+
1 row in set (0.00 sec)

mysql> use bugs;
Database changed
mysql>   GRANT SELECT ON `bugs`.`cf_tracking_esr10` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_tracking_esr10) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.01 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_status_esr10` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.01 sec)

mysql>   GRANT SELECT (cf_status_esr10) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql>   GRANT SELECT ON `bugs`.`cf_tracking_firefox13` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_tracking_firefox13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT ON `bugs`.`cf_status_firefox13` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_status_firefox13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql>   GRANT SELECT ON `bugs`.`cf_tracking_thunderbird13` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.01 sec)

mysql>   GRANT SELECT (cf_tracking_thunderbird13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql>   GRANT SELECT ON `bugs`.`cf_status_thunderbird13` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_status_thunderbird13) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.01 sec)

mysql> 
mysql>   GRANT SELECT ON `bugs`.`cf_tracking_seamonkey210` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>   GRANT SELECT (cf_tracking_seamonkey210) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql>   GRANT SELECT ON `bugs`.`cf_status_seamonkey210` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.01 sec)

mysql>   GRANT SELECT (cf_status_seamonkey210) ON `bugs`.`bugs` TO 'metrics'@'10.2.70.20_';
Query OK, 0 rows affected (0.00 sec)

mysql>