Add permissions for new AMO tables

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
RESOLVED FIXED
9 years ago
3 years ago

People

(Reporter: clouserw, Assigned: oremj)

Tracking

Details

(Reporter)

Description

9 years ago
Bug 475919 gave us permissions for the current tables.  

Additionally we need to add SELECT,INSERT,UPDATE,DELETE on the new tables from bug 477919: stats_addons_collections_counts and stats_collections_counts for both metrics boxes.
(Reporter)

Updated

9 years ago
Depends on: 477919
(Assignee)

Comment 1

9 years ago
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON `addons_remora`.`stats_addons_collections_counts` TO 'metrics'@'10.2.72.28';
Query OK, 0 rows affected (0.03 sec)

mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON `addons_remora`.`stats_collections_counts` TO 'metrics'@'10.2.72.28';
Query OK, 0 rows affected (0.01 sec)
(Assignee)

Updated

9 years ago
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
(Assignee)

Updated

9 years ago
Blocks: 475919
(Reporter)

Comment 2

9 years ago
What about 10.2.72.34?
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Assignee: server-ops → oremj
Component: Server Operations: Web Content Push → Server Operations
(Assignee)

Comment 3

9 years ago
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON `addons_remora`.`stats_addons_collections_counts` TO 'metrics'@'10.2.72.34';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON `addons_remora`.`stats_collections_counts` TO 'metrics'@'10.2.72.34';
Query OK, 0 rows affected (0.01 sec)
Status: REOPENED → RESOLVED
Last Resolved: 9 years ago9 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.