Google BigQuery - P12 Key Encryption

Hello together,

I’m trying to use a secure encrypted P12 Key to access Bigquery Data.
The Key is already created over the BigQuery service account but it comes with a unsecure password.
Im not able to change that password on Google side. It seems that also KNIME is fix connected with that password. A encryption afterwards (i use Java’s Keytool) leads to a failure of the Google Authentication (API Key) Node .

knime_error

I get the following error message: “java.io.IOException: keystore password was incorrect”
Do you know if it’s possible to configure the new PW in the Authentication node?

With the unsecure PW everything works fine!

What i’ve done:

  • create Key Pair with service account
  • connect KNIME to BigQuery with the [Google Authentication (API Key) ] Node.

Thank you in advance!

Hi @Basti_Walz,

I’m not quite sure what exactly you’re doing, but if you are using your own Java keystore, you can specify that (and it’s password) in the knime.ini file (replace the <> entries):

-Djavax.net.ssl.keyStore=<C:/path/to/keystore.jks>
-Djavax.net.ssl.keyStorePassword=<PWD>

Is that what you were looking for?

Kind regards
Marvin

1 Like

Hi @marvin.kickuth ,

sorry for the late reply.
It works now!

Thanks

Kind regards
Basti

1 Like

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