求doris catalog trino有ssl证书方式的连接方式

Viewed 23

doris版本:2.1.6
业务需求:doris catalog 增加trino,但是后端的小伙伴只提供了trino的用户名和密码以及证书,官网的连接样例是:
CREATE CATALOG trino_catalog PROPERTIES (
"type"="jdbc",
"user"="hadoop",
"password"="",
"jdbc_url" = "jdbc:trino://localhost:8080/hive",
"driver_url" = "file:///path/to/trino-jdbc-389.jar",
"driver_class" = "io.trino.jdbc.TrinoDriver"
);
无法添加证书,增加时提示:ERROR 1105 (HY000): errCode = 2, detailMessage = Test FE Connection to JDBC Failed: Can not connect to jdbc due to error: Authentication using username/password requires SSL to be enabled, Catalog name: trino_catalog
请各位高手提供一下带有ssl证书的配置段

1 Answers

参考下这块文档:https://doris.apache.org/zh-CN/docs/dev/admin-manual/auth/certificate?_highlight=%E8%AF%81%E4%B9%A6#%E8%87%AA%E5%AE%9A%E4%B9%89%E5%AF%86%E9%92%A5%E8%AF%81%E4%B9%A6%E6%96%87%E4%BB%B6