|
@_robstr | |||||
|
Direct access to the crt.sh DB. groups.google.com/d/msg/crtsh/sU…
|
||||||
|
||||||
|
Rob Stradling
@_robstr
|
7. lip 2017. |
|
LOL! I reserve the right to not answer questions that are out of scope. ;-)
|
||
|
|
||
|
Rob Stradling
@_robstr
|
7. lip 2017. |
|
$1 is a placeholder. Try changing $1 to (for example) 'comodo.com'.
|
||
|
|
||
|
Rob Stradling
@_robstr
|
7. lip 2017. |
|
From that error message, I'm guessing that your SQL client is automatically appending a LIMIT clause to the query. Try trimming the ";".
|
||
|
|
||
|
BenBE
@BenBE1987
|
7. lip 2017. |
|
Ist the SQL schema available/documented somewhere? Are there tables for the plain SPKI?
|
||
|
|
||
|
Rob Stradling
@_robstr
|
8. lip 2017. |
|
Schema created by github.com/crtsh/certwatc…. There's no SPKI table, but the "certificate" and "ca" tables have indexes relating to SPKI.
|
||
|
|
||
|
Julien Vehent
@jvehent
|
12. lip 2017. |
|
I've been wanting to provide SQL access to TLS Observatory for a while. How did you build it? A dedicated read-only slave? Any rate limits?
|
||
|
|
||
|
Rob Stradling
@_robstr
|
13. lip 2017. |
|
Yes, some dedicated read-only slaves. No rate limits yet (and we'll just have to see how that goes... ;-) ).
|
||
|
|
||