CA/CCADB Dashboard

From MozillaWiki
< CA
Jump to: navigation, search

Dashboard for Common CA Database Updates

CCADB API Access

Requests for API access to the CCADB as per https://github.com/mozilla/CCADB-Tools/tree/master/API_AddUpdateIntermediateCert

To file a CCADB API Access Request, use:
Product: CA Program
Component: Common CA Database
Whiteboard: [ccadb-api]

Full Query
Whiteboard ID Summary Last change time
[ccadb-api] in sandbox 1770056 Google Trust Services - Request for access to CCADB API 2022-11-14T22:22:21Z
[ccadb-api] in sandbox 1779692 NAVER Cloud - Request for access to CCADB API 2023-01-12T18:25:21Z
[ccadb-api] in sandbox 1793511 Microsoft - Request for access to CCADB API 2023-09-18T16:26:31Z
[ccadb-api] 1901864 Certainly: Request for access to CCADB API 2024-06-17T16:41:41Z
[ccadb-api] 1916851 Amazon Trust Services - Request for Access to CCADB API 2024-09-13T16:08:07Z

5 Total; 5 Open (100%); 0 Resolved (0%); 0 Verified (0%);


Bugs

Bugs that unintentionally remove pre-existing functionality or negatively impact CCADB users should have priority over Enhancements, and should be set to P1. Low impact bugs will start at P4 and be considered with ERs. If it's a low LOE bug (less than 4 hours of work) it can go from P4 to P1 without prioritization/design.

To file a CCADB Bug, use:
Product: CA Program
Component: Common CA Database
Whiteboard: [ccadb-bug]

Full Query
Priority ID Summary Last change time
P3 1747829 Disable the pull-down (Edit and Change Owner) in all tab views for CAs and Root Store Operators 2022-11-14T22:22:21Z
P4 1715341 Root Inclusion Cases used to get automatically closed when completed 2022-11-14T22:22:21Z
-- 1740635 Make public CSV reports consistent in regards to line endings (e.g. CR or LF) 2022-11-14T22:22:21Z

3 Total; 3 Open (100%); 0 Resolved (0%); 0 Verified (0%);


Enhancement Requests

The Priority values are used as follows:

  • P1 - Development in progress
  • P2 - Design in progress or complete
  • P3 - Prioritized, design document started
  • P4 or not set - To be prioritized and scheduled later

Important: Do not enter a value into the Whiteboard field to file a CCADB Enhancement Request.

Full Query
Priority ID Summary Whiteboard Last change time
P3 1826969 Present audit criteria output in 'Audit ALV Results' 2023-08-14T20:52:12Z
P3 1826965 Update 'Audit Deviation' behavior 2024-07-15T18:41:58Z
P3 1712154 Make it easier for CAs and Auditors to preflight their new (draft) audit statements 2023-05-03T21:19:26Z
P3 1821762 Resolve NULL value in Trust Bits for root not included in any Root Stores 2023-08-14T20:53:16Z
P3 1815933 Make Derived Trust Bits and EV-Enabled logic match crt.sh 2023-05-03T21:20:14Z
P3 1747829 Disable the pull-down (Edit and Change Owner) in all tab views for CAs and Root Store Operators [ccadb-bug] 2022-11-14T22:22:21Z
P3 1739529 Enable CAs to subscribe to notifications about updates to their task list items 2023-08-14T20:53:31Z
P4 1860187 Add “Filter on Case Status” to the root store Common Task Lists 2023-10-19T22:31:30Z
P4 1715341 Root Inclusion Cases used to get automatically closed when completed [ccadb-bug] 2022-11-14T22:22:21Z
P4 1810898 Add info to pre-ALV check on Add/Update Root Request 2023-08-14T21:25:49Z
-- 1718139 Make fields with lists consistent 2023-05-03T20:34:30Z
-- 1718141 Add Prompts to help CAs complete their Cases 2023-05-03T20:34:24Z
-- 1718145 Update the report on the history of overdue audits 2023-05-03T20:34:31Z
-- 1718146 Add a CA Task List item/report for failed test websites 2023-05-03T20:34:16Z
-- 1718147 Run ALV over full hierarchies in Audit and Root Inclusion Cases 2023-08-14T23:31:10Z
-- 1718148 Create public reports for overdue audit statements and audit statements with ALV errors 2023-05-03T20:34:20Z
-- 1718150 Enable CAs to add Historic audit statements to the CCADB 2023-05-03T20:34:33Z
-- 1718151 Cleanup CCADB Reports and Report Folders 2023-05-03T20:34:30Z
-- 1719376 Consider Localization and Translations for the CCADB 2023-05-03T20:58:40Z
-- 1727204 Add automated checks of Subordinate CA Owner names on intermediate certificates 2023-05-03T20:34:29Z
-- 1727205 Adding fields for clarifying CA and subCA ownership details 2023-05-03T20:34:33Z
-- 1733229 Indicate expired certificates in the CA hierarchy view 2023-05-03T20:34:15Z
-- 1717938 Add Detailed CP/CPS/Document Reviews to Root Inclusion Cases 2023-05-03T20:58:40Z
-- 1740635 Make public CSV reports consistent in regards to line endings (e.g. CR or LF) [ccadb-bug] 2022-11-14T22:22:21Z
-- 1744333 Redesign the way that CCADB handles audits for new intermediate certificates 2023-05-03T20:58:38Z
-- 1717937 Make tabs more consistent between Root Store Operators and CA Community Users 2023-05-03T20:34:25Z
-- 1748937 Create public report for entries to remove from OneCRL [ca-onecrl] 2023-05-03T20:35:12Z
-- 1754567 Feature Enhancement Request: Extend CA organization and system data collection 2023-05-03T20:34:17Z
-- 1754880 Update the logic for the EV SSL Capable checkbox to include Apple and Chrome 2023-09-26T21:56:33Z
-- 1758774 Have our Salesforce instance use an updated root store 2023-05-03T20:34:24Z
-- 1760654 Provide Public-Facing report about root certificates that contains more information 2023-05-03T20:34:23Z
-- 1763469 Requesting CCADB have the ability to show diffs between policy documents 2023-05-03T20:58:37Z
-- 1770056 Google Trust Services - Request for access to CCADB API [ccadb-api] in sandbox 2022-11-14T22:22:21Z
-- 1778589 In Add/Update Root Request Cases prevent CAs from adding intermediate certs as root certs 2023-05-03T20:34:25Z
-- 1779065 Update CCADB Access Request Form 2023-05-03T20:34:19Z
-- 1779067 New CA Owner Workflow - Collapse Description Information + Comments 2023-05-03T20:34:18Z
-- 1779068 New CA Owner Workflow - Decouple CA Owner/Certificate Information names 2023-05-03T20:34:30Z
-- 1779079 Add Fields to New Intermediate Certificate 2023-05-03T20:34:32Z
-- 1779692 NAVER Cloud - Request for access to CCADB API [ccadb-api] in sandbox 2023-01-12T18:25:21Z
-- 1781144 Add UI to filter the table for selecting root certs in Cases 2023-05-03T20:34:20Z
-- 1781146 Add UI for using SHA256 list to specify root certs in Cases 2023-05-03T20:34:31Z
-- 1782106 Add Report for Monitoring Monthly Community Logins 2023-05-03T20:34:34Z
-- 1786970 CAs should be able to delete intermediate certificate records that they create 2023-06-01T21:13:24Z
-- 1789472 Add a "Warnings" column to the "Case Progress" table 2023-05-03T20:34:26Z
-- 1789473 Remove "Success" from the green popup for saving updates 2023-05-03T20:34:34Z
-- 1791452 Add "New Case" button to the top level Cases tab 2023-05-03T20:34:34Z
-- 1791844 Technically enforce two POCs are populated for the CA Owner Record 2023-05-03T20:34:33Z
-- 1793457 Visibility of new Root Certificate information in "CA Providing Data" Cases 2023-05-03T20:34:18Z
-- 1793511 Microsoft - Request for access to CCADB API [ccadb-api] in sandbox 2023-09-18T16:26:31Z
-- 1796686 Add some more EKU OID mappings 2023-05-03T20:34:29Z
-- 1796693 Reminder for CAs to click on the 'Submit to Root Store' button in Add/Update Root Request cases 2023-05-03T20:34:19Z
-- 1798894 Chrome Root Program - Provide OAuth and API for Chrome to automate root store updates to the CCADB 2024-04-28T07:08:48Z
-- 1799000 Automatically post summary of audit reminder email to public@ccadb.org 2023-07-07T03:02:19Z
-- 1808386 Generalize the email for Need Audit or CP/CPS for Intermediate Certificates 2023-01-03T18:46:04Z
-- 1717935 Improve Re-parenting logic 2023-05-03T20:34:33Z
-- 1717928 Automatically create Mozilla Bugzilla Bug for new Root Inclusion Cases 2024-02-27T16:37:02Z
-- 1817438 Add Google Chrome to logic for ALV, Derived Trust Bits, and EV SSL Capable 2023-09-26T21:54:45Z
-- 1712157 consider adding prompts and walkthroughs to improve the flow/interface 2023-05-03T20:58:41Z
-- 1822209 Enable public reports to use resources.ccadb.org instead of ccadb.my.salesforce-sites.com 2023-05-03T20:34:26Z
-- 1712152 Extend Root Inclusion Cases to Microsoft 2023-05-03T20:58:40Z
-- 1712010 Display logic in report outputs 2023-05-03T20:34:23Z
-- 1826970 Obsolete Root Certificates 2023-04-07T14:41:36Z
-- 1843942 Define incident report conclusion & summary artifact format 2023-07-20T15:05:56Z
-- 1850030 Update visibility (and possibly behavior) of Store-specific status fields on Intermediate Certificate records 2023-08-25T17:40:17Z
-- 1711588 All Programs: Add standardized header and add to Custom Reports and Processes list 2023-05-03T20:34:22Z
-- 1891800 Consider adopting RFC2119 for CCADB Guidance 2024-04-22T14:31:02Z
-- 1892639 Consider requiring UTC and only UTC for the timeline section of Incident Reporting 2024-04-23T15:32:59Z
-- 1893852 Chrome Root Program - Provide OAuth and API for Chrome to automate root store updates to the CCADB 2024-04-28T07:09:32Z
-- 1896487 Add signature checking for uploaded CA certificates 2024-05-13T19:55:00Z
-- 1901864 Certainly: Request for access to CCADB API [ccadb-api] 2024-06-17T16:41:41Z
-- 1904350 Enable ALV with automation to read JSON or XML-formatted audit letters 2024-06-24T14:18:37Z
-- 1908743 Allow only http for Full CRL Issued By This CA 2024-07-18T18:47:18Z
-- 1909725 Enhancement Request: Change "Case Assigned To" value when a case is submitted to root store 2024-07-24T18:49:38Z
-- 1913191 Update Subject Key Identifier and Authority Key Identifier fields from b64 to hex 2024-08-14T16:47:20Z
-- 1916851 Amazon Trust Services - Request for Access to CCADB API [ccadb-api] 2024-09-13T16:08:07Z
-- 1917592 Unable to Submit MC Inclusion Request to Apple w/out Assessment 2024-09-09T13:48:02Z
-- 1922647 Develop GET API 2024-10-03T19:26:39Z
-- 1926319 Archive expired CA certificates 2024-10-22T14:43:42Z

78 Total; 78 Open (100%); 0 Resolved (0%); 0 Verified (0%);


Closed

A historical view of past CCADB updates (from May 2021 onward) may be found here: