Hello!
I’ve seen several posts here that loosely relate to my issue, but I wasn’t able to figure out what I am missing to get it working.
To access my Google Big Query tables, it was given to our service account a credentials.json file, that I use as a file on PowerBI and Tableau, for example. I saw that this file is currently not supported by this extension. Our IT department cannot provide me a P12 file. No reason given from their side.
So I searched on how to create a P12 file from the JSON, and after digging and creating the .pem and .cer I was able to create the P12 using this command:
openssl pkcs12 -inkey privatekey.pem -in cert.cer -password pass:changeit -export -out key.p12
As stated on the command, I’ve set the password to “changeit”, as seen on some other threads, but even though it is correct, the error is still showing.
WARN Google Authentication (API Key) 6:1 java.io.IOException: keystore password was incorrect
I’ve even tested this p12 file on the KeyStore Explorer and it’s a valid PKCS #12 with the password changeit.
Could you please help me to figure out, what I am still missing for this to work?
Thank you!