Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-2024-05-13· OpenAIAi2 WildChat-4.8M (AI2)

请用中文解释下面的solution: This is not a DBeaver client tool issue. Access to PaaS services…

  1. User

    请用中文解释下面的solution: This is not a DBeaver client tool issue. Access to PaaS services using private endpoint is not working, when you are in HO. IP address will not work as well, because:

    Zscaler don’t route the DNS domains for FQDN’s like s1nc0777.privatelink.database.windows.net on the Zscaler ZPA side (where we natively route only DNS domains like *.sanofi-aventis.com, *.f2.enterprise just to name a few). So perhaps creating a DNS entry like s1nc0777.pharma.aventis.com or s1nc0777.sanofi-aventis.com and accessing then the database using that FQDN will solve the issue.

    Please keep in mind that above mentioned string is just an example. Your Endpoint f.e. for the “Winch-dev-postgres-emea” would be “winch-dev-postgres-emea.crlwohqomjiq.eu-west-1.rds.amazonaws.com” and Zscaler behaviour is similar for AWS.

    As another alternative: if you have an EC2 inside AWS, you can RDP and connect from there.

  2. Assistant

    这个解决方案不是关于DBeaver客户端工具的问题。当你在总部(HO)时,通过私有端点访问PaaS服务无法正常工作,使用IP地址也行不通,原因是:

    Zscaler不会在Zscaler ZPA一侧路由像s1nc0777.privatelink.database.windows.net这样的FQDN(完全限定域名)的DNS域。Zscaler ZPA端只会原生路由像*.sanofi-aventis.com、*.f2.enterprise这样的DNS域名。

    因此,可以尝试创建一个类似s1nc0777.pharma.aventis.com或s1nc0777.sanofi-aventis.com的DNS条目,然后使用该FQDN访问数据库,这可能会解决问题。

    请记住,上述字符串只是一个例子。比如说,你的端点为“Winch-dev-postgres-emea”,那么对应的FQDN可能是winch-dev-postgres-emea.crlwohqomjiq.eu-west-1.rds.amazonaws.com,在AWS上的Zscaler行为也是类似的。

    另一个替代方案:如果你在AWS中有一个EC2实例,你可以通过RDP(远程桌面协议)连接并从那里进行连接。