Skip to content

jcjones/ct-sql

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code
This branch is 84 commits ahead of jmhodges:master.

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
cmd
 
 
db
 
 
 
 
 
 
 
 
 
 

This tool imports one CT log at a time into a MySQL database for ease of querying.

It can be used with multiple CT logs by changing the -log flag.

Quick Start:

# Acquire CT data
go get github.com/jcjones/ct-sql/cmd/ct-sql

# Configure ct-sql
echo "dbConnect = mysql+tcp://root@localhost:3306/ctdb" > ./ct-sql.ini

# Prepare the Database (using Goose migration took)
go get bitbucket.org/liamstask/goose/cmd/goose

pushd $GOPATH/src/github.com/jcjones/ct-sql
cat db/dbconf.yml
# Edit dbconf.yml as needed for user/pass
goose up
goose status
popd

# Scan a CT log
ct-sql -config ./ct-sql.ini -log https://log.certly.io -limit 10000

# Scan a Censys.io Export
ct-sql -config ./ct-sql.ini -censysUrl https://url_to_censys/path/certificates.json

# Resolve sites to determine their server locations
go get github.com/jcjones/ct-sql/cmd/ct-sql-netscan
ct-sql-netscan -config ./ct-sql.ini -limit 10

Vendored Packages

We're using [godep](https://github.com/tools/godep) to handle vendored dependencies. godep save ./cmd/ct-sql/ ./cmd/ct-sql-netscan/ ./cmd/telemetry-update/ ./cmd/get-cert/

About

Certificate Transparency stuff

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Go 100.0%