将Google Cloud SQL Postgres数据库连接到Google Data Studio [英] Connecting a Google Cloud SQL Postgres Database to Google Data Studio

问题描述

我正在经历与此处找到的答案完全相同的过程（将Google CloudSQL Postgres数据库连接到Data Studio ），但是我不像大多数用户那样高级。我遇到了与上述问题中提到的问题类似的问题，然后遇到了一些问题：

I am going through the exact same process as the answered question found here (Connect a Google CloudSQL Postgres database to Data Studio), but I am not as advanced a user as most. I am encountering a similar problem to what was mentioned in the above question, and then some:

1. 我已经创建了客户端证书并下载了
   client-cert.pem，client-key.pem和server-ca.pem文件存储到我的
   本地计算机上。



2. 我收到了相同的消息尝试将
   Data Studio作为数据
   源链接到我们的Google Cloud SQL Postgres数据库时出错。 无法访问主机。请仔细检查您的连接参数。在此处了解有关数据库连接器的更多信息。

我尝试过运行以下命令 openssl pkcs8 -topk8 -inform PEM -outform DER -in client-key.pem -out client-key.pkcs8 -nocrypt 以更改
客户端的格式键，但我收到此错误
pkcs8：无法打开输入文件client-key.pem，没有这样的文件或
目录。

I tried running the following command " openssl pkcs8 -topk8 -inform PEM -outform DER -in client-key.pem -out client-key.pkcs8 -nocrypt " to change the format of the client key in our Cloud Shell Project, but I received this error " pkcs8: Cannot open input file client-key.pem, No such file or directory ".

我认为那时候不应该从Cloud Shell Project终端运行此命令。有人知道我应该在哪里运行此命令吗？如果需要，我可以提供任何其他材料。

I would assume that I should not be running this command from the Cloud Shell Project terminal then. Would anybody know where I should be running this command instead? I can provide any extra material if needed. Thank you in advance - much appreciated.

推荐答案

听起来好像文件在您运行命令的位置不存在。您是否将client-key.pem上传到Cloud Shell？

It sounds like the file doesn't exist location where you are running the command. Did you upload the client-key.pem into Cloud Shell?

这篇关于将Google Cloud SQL Postgres数据库连接到Google Data Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！