英文:
Cannot connect to Redshift using dbVisulizer - SSL error (from Mac OS)
问题
当我尝试连接时，出现以下错误：
PKIX路径构建失败：无法找到到所请求目标的有效认证路径
我从此页面下载了证书，并将其添加到KeyChain Access，如下所示
我尝试通过将ssl属性设置为false来禁用连接上的SSL，但这并没有起作用。
那么我该如何使用dbVisualizer连接？
英文:
When I try to connect I get this error:
PKIX path building failed: unable to find valid certification path to requested target
I downloaded the certificate from this page and added it to KeyChain Access as you can see
I tried disabling ssl on the connection by setting ssl property to false, but that did not work.
So how can I connect using dbVisualizer?
答案1
得分: 1
我认为您需要在连接属性中指定证书文件的位置。
首先，在您的计算机上找到下载的证书文件，然后在dbVisualizer中打开您正在尝试建立的Redshift连接的连接属性。
现在，在“高级”选项卡下，将"sslrootcert="替换为您下载的证书文件的实际文件路径，并完成。
英文:
I think you need to specify the location of the certificate file in the connection properties.
so at first locate the downloaded certificate file on your computer, then in dbVisualizer, open the connection properties for the Redshift connection you are trying to establish.
Now Under the Advanced tab, replace "" with the actual file path to the certificate file you downloaded
"sslrootcert="
and done.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论