Skip to content

Instantly share code, notes, and snippets.

View robstradling's full-sized avatar

Rob Stradling robstradling

217 followers · 1 following
View GitHub Profile
@robstradling
robstradling / check_extension_criticality.go
Last active April 9, 2024 11:35
TLSBRv2 §7.1.2.7.6 Subscriber Certificate Extensions: Survey of critical flag non-compliance
package main
import (
"context"
"flag"
"fmt"
"math"
"os/signal"
"syscall"
"time"
@robstradling
robstradling / query.sql
Last active February 20, 2024 14:31
2023-10-27: CA Owner "?" on https://crt.sh/cert-populations
WITH cas AS (
SELECT cac.CA_ID
FROM ccadb_certificate cc
JOIN ca_certificate cac ON cc.CERTIFICATE_ID = cac.CERTIFICATE_ID
WHERE cc.INCLUDED_CERTIFICATE_OWNER IS NULL
EXCEPT
SELECT cac.CA_ID
FROM ccadb_certificate cc
JOIN ca_certificate cac ON cc.CERTIFICATE_ID = cac.CERTIFICATE_ID
GROUP BY cac.CA_ID
@robstradling
robstradling / go.mod
Last active February 16, 2024 11:16
go-ora integer precision
module gist.github.com/robstradling/363b54e979b879e0450cfa36e238cca6
go 1.21.6
require github.com/sijms/go-ora/v2 v2.8.9
@robstradling
robstradling / cant_assign_value.go
Last active February 16, 2024 09:23
go-ora: Regression since v2.8.7 for simple SELECTs into integer and floating point variables
package main
import (
"context"
"database/sql"
"flag"
"fmt"
"os"
go_ora "github.com/sijms/go-ora/v2"
@robstradling
robstradling / startcom_base_domains.txt
Last active January 10, 2024 20:07
Unique base domains (PSL+1) in all logged, unexpired certs issued by WoSign and StartCom
This file has been truncated, but you can view the full file.
00002-mitherz.hopto.org
0001.ca
00076.accountant
00078.accountant
000casino.com
0010.ca
001-cloud.com
0026.cc
0049241.com
0049241.net
@robstradling
robstradling / dequeue_array.go
Last active December 11, 2023 20:11
go-ora: Regression since v2.7.23 when using DBMS_AQ.DEQUEUE_ARRAY
package main
import (
"database/sql"
"flag"
"fmt"
"os"
"time"
go_ora "github.com/sijms/go-ora/v2"
@robstradling
robstradling / 20210625_intermediates_with_questionable_eku.csv
Created June 25, 2021 13:18
Intermediate certificates that might not comply with Mozilla Root Store Policy section 5.3
crt.sh ID notBefore Subject CA Issuer CA
2657659203 2019-11-28 08:48:09 AC Sector Público AC RAIZ FNMT-RCM
2657658668 2019-11-28 08:50:02 AC Unidades de Sellado de Tiempo AC RAIZ FNMT-RCM
1849145005 2018-12-20 10:15:49 AC SERVIDORES SEGUROS TIPO1 AC RAIZ FNMT-RCM SERVIDORES SEGUROS
1849145003 2018-12-20 10:20:38 AC SERVIDORES SEGUROS TIPO2 AC RAIZ FNMT-RCM SERVIDORES SEGUROS
1287935739 2019-03-12 09:29:48 Actalis Domain Validation Server CA G1 Actalis Authentication Root CA
1283820374 2019-03-13 08:27:08 Actalis Extended Validation Server CA G2 Actalis Authentication Root CA
1435438944 2019-04-15 12:36:04 AgID CA1 Actalis Authentication Root CA
3517096458 2020-10-13 06:10:10 AgID CA1 Actalis Authentication Root CA
2620763357 2020-02-19 09:58:32 AgID CA1 Actalis Authentication Root CA
@robstradling
robstradling / go.mod
Last active November 15, 2023 12:31
go-ora issue 323
module gist.github.com/robstradling/3bf7c340bc4479f3b3a71c58a9842657
go 1.19
require github.com/sijms/go-ora/v2 v2.7.21
@robstradling
robstradling / go.mod
Last active November 15, 2023 12:30
module gist.github.com/robstradling/f8f8c04b73af72e7f137c1eedb523d15
go 1.20
require github.com/sijms/go-ora/v2 v2.7.21
@robstradling
robstradling / main.go
Created September 6, 2023 13:52
Demonstrate some go-ora regressions since v2.7.14
package main