Hello everyone,
I am trying to connect to Looker Studio my Postgres Database that is hosted in Google Cloud SQL using the PostgreSQL google connector for days and have the same problem: " Sorry, we encountered an error and were unable to complete your request. Error ID: 3323e234"
My database has SSL certificates.
Host Name: The Public IP address found in SQL Instance
Port: 5432
Database: foo-database
Username: postgres
Password: ****
I have ticked "Enable SSL" and "Enable Client authentication" and imported the certificates that I use to also connect to PGAdmin.
I have included the 142.251.74.0/23 address as instructed in the docs in the Authorized networks of my db.
I still cant connect and cant find why.
Any ideas?
Solved! Go to Solution.
I had converted my client key with openssl to PKCS-8 but it didn't work. Someone gave me the solution that actually works in stackoverflow. For anyone interested:
https://stackoverflow.com/questions/78951870/cannot-connect-looker-studio-to-postgres-database-hoste...
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |