Skip to content

Instantly share code, notes, and snippets.

View robstradling's full-sized avatar

Rob Stradling robstradling

216 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 / 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 / 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 / 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 / main.go
Created September 6, 2023 13:52
Demonstrate some go-ora regressions since v2.7.14
package main
@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 / finalTBSCertificateFromPrecertificate.go
Created June 16, 2023 13:12
Produce final certificate from precertificate
package main
import (
"crypto/x509/pkix"
"encoding/asn1"
"encoding/base64"
"encoding/pem"
"fmt"
"math/big"
"time"
@robstradling
robstradling / affected_smime_subca_certs.csv
Last active May 3, 2023 11:26
Pre-existing S/MIME Sub-CA Certificates that cannot comply with the certificate policy requirements in SMIME BR 7.1.6.3
crt.sh URL Included Certificate Owner Certificate Name Trusted By
https://crt.sh/?id=2116242286 AC Camerfirma, S.A. CAMERFIRMA COLOMBIA SAS CERTIFICADOS - 001 Microsoft
https://crt.sh/?id=2116243541 AC Camerfirma, S.A. CAMERFIRMA COLOMBIA SAS CERTIFICADOS - 002 Microsoft
https://crt.sh/?id=1251 AC Camerfirma, S.A. Chambers of Commerce Root Apple,Microsoft
https://crt.sh/?id=10249844 AC Camerfirma, S.A. Global Chambersign Root Apple
https://crt.sh/?id=255724030 Actalis AgID CA1 Apple,Microsoft,Mozilla
https://crt.sh/?id=408583239 Actalis AgID CA1 Apple,Microsoft,Mozilla
https://crt.sh/?id=541765524 Actalis AgID CA1 Apple,Microsoft,Mozilla
https://crt.sh/?id=626725015 Actalis AgID CA1 Apple,Microsoft,Mozilla
https://crt.sh/?id=968143407 Actalis AgID CA1 Apple,Microsoft,Mozilla
@robstradling
robstradling / empty_arrays_demo.go
Last active May 5, 2023 16:14
go-ora: Unable to process input arrays that have no non-empty values
package main
import (
"context"
"database/sql"
"database/sql/driver"
"flag"
"fmt"
"os"
"time"