{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":41802272,"defaultBranch":"master","name":"certwatch_db","ownerLogin":"crtsh","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2015-09-02T13:22:19.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/12831199?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1441200139.0","currentOid":""},"activityList":{"items":[{"before":"35fa5468661e473c30554ce0560047951ddc9cf7","after":"0906761889fe46ef66e9152cac786d9e5e16d367","ref":"refs/heads/master","pushedAt":"2024-08-23T19:25:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Show linter finding codes, where available, in pkimetal results.","shortMessageHtmlLink":"Show linter finding codes, where available, in pkimetal results."}},{"before":"25950a2d4f6f7526678e7a139c092ea9e93a3e02","after":"35fa5468661e473c30554ce0560047951ddc9cf7","ref":"refs/heads/master","pushedAt":"2024-08-16T18:31:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Make the pki_hierarchy function a bit more robust.","shortMessageHtmlLink":"Make the pki_hierarchy function a bit more robust."}},{"before":"76e8273f76f4f5cd9e86fd4e351a41c86338ae32","after":"25950a2d4f6f7526678e7a139c092ea9e93a3e02","ref":"refs/heads/master","pushedAt":"2024-08-14T17:52:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Fix some bugs with parsing the pkimetal results.","shortMessageHtmlLink":"Fix some bugs with parsing the pkimetal results."}},{"before":"a8313b28f24a1a145af4f5985ebdfa96e8c043c5","after":"76e8273f76f4f5cd9e86fd4e351a41c86338ae32","ref":"refs/heads/master","pushedAt":"2024-08-14T14:25:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Use https://pkimet.al/ for on demand linting, instead of the built-in cablint, x509lint, and zlint integrations.","shortMessageHtmlLink":"Use <a href=\"https://pkimet.al/\" rel=\"nofollow\">https://pkimet.al/</a> for on demand linting, instead of the built-in…"}},{"before":"dea2bb5b461be1ea9dc4fb6861e7467e6eb69516","after":"a8313b28f24a1a145af4f5985ebdfa96e8c043c5","ref":"refs/heads/master","pushedAt":"2024-08-06T19:58:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Automatically prepend '00' to serial number searches when necessary.","shortMessageHtmlLink":"Automatically prepend '00' to serial number searches when necessary."}},{"before":"d8e232c826f190d659692b6944910c0abe7cf861","after":"dea2bb5b461be1ea9dc4fb6861e7467e6eb69516","ref":"refs/heads/master","pushedAt":"2024-07-31T15:48:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Log inclusion tickets have moved from code.google.com to issues.chromium.org.","shortMessageHtmlLink":"Log inclusion tickets have moved from code.google.com to issues.chrom…"}},{"before":"cdca69f53a757faa1d59d8b5dcc31a6bd742089b","after":"d8e232c826f190d659692b6944910c0abe7cf861","ref":"refs/heads/master","pushedAt":"2024-07-08T17:16:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Missing accepted roots: Don't consider as missing those roots that are disabled or have 'not before' timestamps >398-days in the past.","shortMessageHtmlLink":"Missing accepted roots: Don't consider as missing those roots that ar…"}},{"before":"adb801412fb36a7f6a23669fa7e8c5f6a52b2227","after":"cdca69f53a757faa1d59d8b5dcc31a6bd742089b","ref":"refs/heads/master","pushedAt":"2024-05-02T20:21:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Handle new fields in the CCADB AllCertificateRecordsCSVFormatv2 report.","shortMessageHtmlLink":"Handle new fields in the CCADB AllCertificateRecordsCSVFormatv2 report."}},{"before":"bf1d067a97d4d8b11aa51a7707d174af7e8f7840","after":"adb801412fb36a7f6a23669fa7e8c5f6a52b2227","ref":"refs/heads/master","pushedAt":"2024-04-30T14:22:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Add Time Stamping to the applicable purposes for Adobe trust contexts.","shortMessageHtmlLink":"Add Time Stamping to the applicable purposes for Adobe trust contexts."}},{"before":"6d5693026283b428826f617d63ca727791dd42e2","after":"bf1d067a97d4d8b11aa51a7707d174af7e8f7840","ref":"refs/heads/master","pushedAt":"2024-04-22T15:38:00.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Fix an XSS.","shortMessageHtmlLink":"Fix an XSS."}},{"before":"753cbd22de925693f9e45f01c958c4a5206201b5","after":"6d5693026283b428826f617d63ca727791dd42e2","ref":"refs/heads/master","pushedAt":"2024-04-16T20:47:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Add index on crl_revoked.{CA_ID,REVOCATION_DATE}.","shortMessageHtmlLink":"Add index on crl_revoked.{CA_ID,REVOCATION_DATE}."}},{"before":"13bbfc6f0b98297460cdaa722e3deb7cbc832a70","after":"753cbd22de925693f9e45f01c958c4a5206201b5","ref":"refs/heads/master","pushedAt":"2024-04-15T11:43:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Fix applicable purposes for the Apple root program.","shortMessageHtmlLink":"Fix applicable purposes for the Apple root program."}},{"before":"4d08a2e2bd861eaa49f3de49996171403f275e8c","after":"13bbfc6f0b98297460cdaa722e3deb7cbc832a70","ref":"refs/heads/master","pushedAt":"2024-04-09T14:46:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Use currently relevant Bugzilla program and component names.","shortMessageHtmlLink":"Use currently relevant Bugzilla program and component names."}},{"before":"c4bc3eb9cda5d306acd293f52b2b10285374d3c6","after":"4d08a2e2bd861eaa49f3de49996171403f275e8c","ref":"refs/heads/master","pushedAt":"2024-03-15T21:43:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"cert-populations: Alternative view, grouped by Root Owner (instead of CA Owner).","shortMessageHtmlLink":"cert-populations: Alternative view, grouped by Root Owner (instead of…"}},{"before":"52c1d3b04a16fab24ee8237c516126f11b3aaffa","after":"c4bc3eb9cda5d306acd293f52b2b10285374d3c6","ref":"refs/heads/master","pushedAt":"2024-02-28T14:21:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"monitored-logs: Show which logs are included in Microsoft's log list.","shortMessageHtmlLink":"monitored-logs: Show which logs are included in Microsoft's log list."}},{"before":"0586d2a8c2d34459b52245cbeb7787506b99b758","after":"52c1d3b04a16fab24ee8237c516126f11b3aaffa","ref":"refs/heads/master","pushedAt":"2024-02-28T11:31:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Microsoft now has a CT log list.","shortMessageHtmlLink":"Microsoft now has a CT log list."}},{"before":"e9e4f89a60bc9b8e12cae080ab163501570900a4","after":"0586d2a8c2d34459b52245cbeb7787506b99b758","ref":"refs/heads/master","pushedAt":"2024-02-12T11:34:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"update_ccadb_certificates: Handle inheritance of CP/CPS Last Updated field.","shortMessageHtmlLink":"update_ccadb_certificates: Handle inheritance of CP/CPS Last Updated …"}},{"before":"277b04a1c1ace5ddf992ae9d8b470fc42d10e01c","after":"e9e4f89a60bc9b8e12cae080ab163501570900a4","ref":"refs/heads/master","pushedAt":"2024-01-25T20:45:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"CCADB disclosures: For Mozilla, add explanation for CRL checking errors.","shortMessageHtmlLink":"CCADB disclosures: For Mozilla, add explanation for CRL checking errors."}},{"before":"c80fe651f088bd2361728b70d6d9563624519a7c","after":"277b04a1c1ace5ddf992ae9d8b470fc42d10e01c","ref":"refs/heads/master","pushedAt":"2024-01-18T10:38:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Add option to filter monitored logs by operator.","shortMessageHtmlLink":"Add option to filter monitored logs by operator."}},{"before":"217091ad6ddb9819cd99f46d301bed8a105e0325","after":"c80fe651f088bd2361728b70d6d9563624519a7c","ref":"refs/heads/master","pushedAt":"2024-01-12T16:44:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Add new columns for AllCertificateRecordsCSVFormatv2.","shortMessageHtmlLink":"Add new columns for AllCertificateRecordsCSVFormatv2."}},{"before":"ee2948a6ebf9239dd502c32d7cff2087c5b68868","after":"217091ad6ddb9819cd99f46d301bed8a105e0325","ref":"refs/heads/master","pushedAt":"2024-01-12T16:36:24.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"update_ccadb_certificates: Switch to the new 'All Cert Information v2' CSV report from CCADB.","shortMessageHtmlLink":"update_ccadb_certificates: Switch to the new 'All Cert Information v2…"}},{"before":"13b336b4b1005e077db1c5c9d7250885f92ac323","after":"ee2948a6ebf9239dd502c32d7cff2087c5b68868","ref":"refs/heads/master","pushedAt":"2023-12-28T10:18:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Add 2023 and 2024 partitions for ct_log_entry.","shortMessageHtmlLink":"Add 2023 and 2024 partitions for ct_log_entry."}},{"before":"f48e75a15305235bb0623196afa0d4b712d877c5","after":"13b336b4b1005e077db1c5c9d7250885f92ac323","ref":"refs/heads/master","pushedAt":"2023-12-04T22:58:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Add Cisco trust context.","shortMessageHtmlLink":"Add Cisco trust context."}},{"before":"f04845044e61ef9f5c4c5f2d5170b09bbe973c5c","after":"f48e75a15305235bb0623196afa0d4b712d877c5","ref":"refs/heads/master","pushedAt":"2023-11-27T22:38:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"In identities(), specify the schema when calling safe_convert_utf8, to avoid occasional 'function does not exist' errors during indexing.","shortMessageHtmlLink":"In identities(), specify the schema when calling safe_convert_utf8, t…"}},{"before":"8b0946043a7d07c6dc315d951bc5627428c8591c","after":"f04845044e61ef9f5c4c5f2d5170b09bbe973c5c","ref":"refs/heads/master","pushedAt":"2023-11-23T22:56:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Update technical constraints checks.","shortMessageHtmlLink":"Update technical constraints checks."}},{"before":"bad78df22585966445980a3ed9c76e20a095535f","after":"8b0946043a7d07c6dc315d951bc5627428c8591c","ref":"refs/heads/master","pushedAt":"2023-11-21T13:48:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Handle result counts for grouped vs non-grouped queries differently, to avoid breaking some query types.","shortMessageHtmlLink":"Handle result counts for grouped vs non-grouped queries differently, …"}},{"before":"4e391327da82ce38d9af67d4eb33608d4b0baf88","after":"bad78df22585966445980a3ed9c76e20a095535f","ref":"refs/heads/master","pushedAt":"2023-11-21T10:02:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Only include result truncation notice in HTML output.","shortMessageHtmlLink":"Only include result truncation notice in HTML output."}},{"before":"e681e47e84126d7266f30abe184344c6b0b1691a","after":"4e391327da82ce38d9af67d4eb33608d4b0baf88","ref":"refs/heads/master","pushedAt":"2023-11-17T12:22:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Ensure gin_clean_pending_list doesn't cause psql to wait for user input.","shortMessageHtmlLink":"Ensure gin_clean_pending_list doesn't cause psql to wait for user input."}},{"before":"b4d446e79c2ab77370fde8d20d683b61aa9ff91c","after":"e681e47e84126d7266f30abe184344c6b0b1691a","ref":"refs/heads/master","pushedAt":"2023-11-16T15:24:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Gracefully handle invalid UTF-8 characters when building the identity search indexes.","shortMessageHtmlLink":"Gracefully handle invalid UTF-8 characters when building the identity…"}},{"before":"405cb9773167145b2f1f2860ea7587fde82d93ff","after":"b4d446e79c2ab77370fde8d20d683b61aa9ff91c","ref":"refs/heads/master","pushedAt":"2023-11-16T12:17:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"robstradling","name":"Rob Stradling","path":"/robstradling","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/958624?s=80&v=4"},"commit":{"message":"Support non-ASCII characters in identity searches.","shortMessageHtmlLink":"Support non-ASCII characters in identity searches."}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0yM1QxOToyNTozMC4wMDAwMDBazwAAAASiqjZh","startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0yM1QxOToyNTozMC4wMDAwMDBazwAAAASiqjZh","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0xMS0xNlQxMjoxNzoyMy4wMDAwMDBazwAAAAOwoJoU"}},"title":"Activity · crtsh/certwatch_db"}