636254 - Run SQL on AMO to blocklist some drivers

Status: RESOLVED FIXED

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

Description

[Justin Scott [:fligtar]]

Please run the below SQL on AMO prod to blocklist some graphics drivers. Thanks.

INSERT INTO `blgfxdrivers` VALUES (NULL, NULL, 'WINNT 6.1', '0x10de', '0x0a6c',
'DIRECT2D', 'BLOCKED_DRIVER_VERSION', '8.17.12.5896', 'LESS_THAN_OR_EQUAL',
NOW(), NOW());

INSERT INTO `blgfxdrivers` VALUES (NULL, NULL, 'WINNT 6.1', '0x10de', '0x0a6c',
'DIRECT3D_9_LAYERS', 'BLOCKED_DRIVER_VERSION', '8.17.12.5896',
'LESS_THAN_OR_EQUAL', NOW(), NOW());

Comment 1

[Shyam Mani [:fox2mike]]

Mike, ack?

Comment 2

[Joe Drew (not getting mail)]

Morgamic, ping? (I presume it's you that we need approval from)

Comment 3

[Shyam Mani [:fox2mike]]

(In reply to comment #2)
> Morgamic, ping? (I presume it's you that we need approval from)

Yeah. Past blocklist stuff hasn't gone in unless it's had an ack from him :)

Comment 4

[Justin Scott [:fligtar]]

This is no longer needed; I blocked these another way.

Comment 5

[Justin Scott [:fligtar]]

Our admin tool for this has a bug, so we still need this SQL run.

I'm managing the blocklist right now, this is SQL on the add-ons site that I'm responsible for, and this is blocking a Firefox 4 hardblocker; please run it. Thanks.

Comment 6

[Jeremy Orem [:oremj]]

Still need ack from morgamic.

Comment 7

[Joe Drew (not getting mail)]

Why does this need an ack for morgamic, anyways?

Comment 8

[Jeremy Orem [:oremj]]

He's always submitted them in the past. If someone else is in charge of blocklist now that is fine. We just need to know who should sign off on these.

Comment 9

[Justin Scott [:fligtar]]

I'm managing the blocklist now and usually just use our django admin tools, but gfx driver blocks are new in Firefox 4 and we don't have an admin tool that works properly yet.

Comment 10

[Jeremy Orem [:oremj]]

mysql> INSERT INTO `blgfxdrivers` VALUES (NULL, NULL, 'WINNT 6.1', '0x10de', '0x0a6c',
    -> 'DIRECT2D', 'BLOCKED_DRIVER_VERSION', '8.17.12.5896', 'LESS_THAN_OR_EQUAL',
    -> NOW(), NOW());
Query OK, 1 row affected (0.01 sec)

mysql> 
mysql> INSERT INTO `blgfxdrivers` VALUES (NULL, NULL, 'WINNT 6.1', '0x10de', '0x0a6c',
    -> 'DIRECT3D_9_LAYERS', 'BLOCKED_DRIVER_VERSION', '8.17.12.5896',
    -> 'LESS_THAN_OR_EQUAL', NOW(), NOW());
Query OK, 1 row affected (0.00 sec)

Comment 11

[Michael Morgan [:morgamic]]

This looks good, thought fligtar had it under control.  Justin - can you file a but about adding this to the blocklist tool on AMO?

Comment 12

[Shyam Mani [:fox2mike]]

Re-opening since this broke the tree, I'm trying to revert it.

Comment 13

[Shyam Mani [:fox2mike]]

mysql> select * from blgfxdrivers;
+----+------+-----------+--------+---------+-------------------+------------------------+----------------+---------------------------+---------------------+---------------------+
| id | guid | os        | vendor | devices | feature           | feature_status         | driver_version | driver_version_comparator | created             | modified            |
+----+------+-----------+--------+---------+-------------------+------------------------+----------------+---------------------------+---------------------+---------------------+
| 12 | NULL | WINNT 6.1 | 0x10de | 0x0a6c  | DIRECT2D          | BLOCKED_DRIVER_VERSION | 8.17.12.5896   | LESS_THAN_OR_EQUAL        | 2011-02-25 14:26:19 | 2011-02-25 14:26:19 | 
| 13 | NULL | WINNT 6.1 | 0x10de | 0x0a6c  | DIRECT3D_9_LAYERS | BLOCKED_DRIVER_VERSION | 8.17.12.5896   | LESS_THAN_OR_EQUAL        | 2011-02-25 14:26:20 | 2011-02-25 14:26:20 | 
+----+------+-----------+--------+---------+-------------------+------------------------+----------------+---------------------------+---------------------+---------------------+
2 rows in set (0.00 sec)

mysql> delete from blgfxdrivers where id='12';
Query OK, 1 row affected (0.01 sec)

mysql> delete from blgfxdrivers where id='13';
Query OK, 1 row affected (0.00 sec)

mysql> select * from blgfxdrivers;
Empty set (0.00 sec)

Done, this change is now reverted.

Comment 14

[Jeremy Orem [:oremj]]

Looks like this can be closed?

Comment 15

[Joe Drew (not getting mail)]

No, we'll need this to be run again soon.

Comment 16

[Jeremy Orem [:oremj]]

Are we running the SQL in comment 0 again? Won't that break the tree?

Comment 17

[Justin Scott [:fligtar]]

We'll reopen when it's ready to be run.

Comment 18

[Joe Drew (not getting mail)]

This SQL can now be run in production.

Comment 19

[Damon Sicore (:damons)]

Please expedite.  We need all the time we can get to address any issues we find here.

Comment 20

[John O'Duinn [:joduinn] (please use "needinfo?" flag)]

Raising to blocker. This needs to land on this embargoed machines, because of impact to beta12.

Comment 21

[Corey Shields [:cshields]]

Jeremy, go ahead and make this change per joduinn

Comment 22

[Jeremy Orem [:oremj]]

mysql> INSERT INTO `blgfxdrivers` VALUES (NULL, NULL, 'WINNT 6.1', '0x10de', '0x0a6c',
    -> 'DIRECT2D', 'BLOCKED_DRIVER_VERSION', '8.17.12.5896', 'LESS_THAN_OR_EQUAL',
    -> NOW(), NOW());
Query OK, 1 row affected (0.00 sec)

mysql> 
mysql> INSERT INTO `blgfxdrivers` VALUES (NULL, NULL, 'WINNT 6.1', '0x10de', '0x0a6c',
    -> 'DIRECT3D_9_LAYERS', 'BLOCKED_DRIVER_VERSION', '8.17.12.5896',
    -> 'LESS_THAN_OR_EQUAL', NOW(), NOW());
Query OK, 1 row affected (0.01 sec)

mysql>