search

assetnote / commonspeak2

Leverages publicly available datasets from Google BigQuery to generate content discovery and subdomain wordlists
Apache License 2.0
697 stars 102 forks source link

Error 403 Access Denied #12

Closed 0xspade closed 4 years ago

0xspade commented 4 years ago

Hi,

I'm getting this error when getting a subdomain list with this command:

commonspeak2 --project crunchbox-160315 --credentials creds.json subdomains -o subdomains.txt

and this as a result:

INFO[0000] Generated SQL template for HackerNews.        Mode=Subdomains
INFO[0000] Generated SQL template for HTTPArchive.       Mode=Subdomains
INFO[0000] Executing BigQuery SQL... this could take some time.  Mode=Subdomains Source=hackernews
FATA[0001] Error executing BigQuery SQL.                 Error="googleapi: Error 403: Access Denied: Project crunchbox-160315: User does not have bigquery.jobs.create permission in project crunchbox-160315., accessDenied" Mode=Subdomains Source=hackernews

How to fix this?

cqsd commented 4 years ago

crunchbox-160315 is the example project from the README. You need to provide your own.

commonspeak2 --project ${YOUR_PROJECT_ID} ...
0xspade commented 4 years ago

Hi @cqsd,

Now it runs but still returns 400 response status code I guess it's already reported.

cqsd commented 4 years ago

I have a PR for that in #11. You can also try running the queries in data/sql on BigQuery directly.