Google BigQuery Output Plugin Authentication Issue


(Jeremy Toce) #1

Hey all - I am struggling a bit with authenticating BigQuery for Logstash output use.

I have an issue that I am sure is a matter of clarification, but haven't been able to solve for several days.

I am receiving an invalid key or passphrase error, even though I have confirmed that the key and passphrase are indeed correct and it is my active service account. I have tried regenerating my service account credentials, but to no avail. Here is my configuration file:

# The # character at the beginning of a line indicates a comment. Use
# comments to describe your configuration.
input {
	beats {
    	port => "5043"
	}
}
# The filter part of this file is commented out to indicate that it is
# optional.
filter {
grok {
    match => { "message" => "%{COMBINEDAPACHELOG}"}
}
}
output {
   google_bigquery {
 project_id => "leanplum-staging"                          
 dataset => "test-arr-digest"                                         
 csv_schema => "path:STRING,status:INTEGER,score:FLOAT"
 key_path => "/company-07ed8561600a.p12"                 
 key_password => "notasecret"                            
 service_account => "test-arr-digest@company.iam.gserviceaccount.com" 
  }
}

And my error message is "Pipeline aborted due to error {:exception=>#<ArgumentError: Invalid keyfile or passphrase>"

Thanks in advance for the assistance!


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.