[Discussing] Can I add SSH connections to JDBC data sources?

[mdzz9527]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

jdbc数据源是否可以增加ssh的连接方式

Use case

No response

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[Zzm0809]

请详细描述一下

[mdzz9527]

出于安全考虑,或者是其他,有些数据源不能直接连接,是通过SSH的跳板机的方式连接的,大部分数据库连接工具是支持这种连接方式的,比如navicat

[Zzm0809]

非必须功能,目前社区暂无此计划,如你对此功能有兴趣可以实现,欢迎贡献社区

[Zzm0809]

你可以使用 jsch 库完成以上需求

  <!-- https://mvnrepository.com/artifact/com.github.mwiede/jsch -->
            <dependency>
                <groupId>com.github.mwiede</groupId>
                <artifactId>jsch</artifactId>
                <version>${jssh.version}</version>
            </dependency>

2. 创建 jdbc 的 ssh 链接配置类

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class JdbcSSHConnectConfig {



    @ApiModelProperty(
            value = "SSH host",
            dataType = "String",
            example = "192.168.127.12",
            notes = "SSH host")
    private String sshHost;

    @ApiModelProperty(
            value = "SSH port",
            dataType = "Integer",
            example = "22",
            notes = "SSH port")
    private int sshPort;

    @ApiModelProperty(
            value = "SSH username",
            dataType = "String",
            example = "root",
            notes = "SSH username")
    private String sshUsername;

    @ApiModelProperty(
            value = "SSH password",
            dataType = "String",
            example = "root",
            notes = "SSH password")
    private String sshPassword;

    @ApiModelProperty(
            value = "Local forward port",
            dataType = "Integer",
            example = "3306",
            notes = "Local forward port")
    private int localForwardPort;
}

3. 在org.dinky.metadata.config.AbstractJdbcConfig 中添加如下属性

    @ApiModelProperty(
            value = "Whether to use ssh tunnel", example = "true", notes = "Whether to use ssh tunnel")
    private boolean useSshTunnel = false;
    @ApiModelProperty(
            value = "Whether to use ssh tunnel", example = "true", notes = "Whether to use ssh tunnel")
    private JdbcSSHConnectConfig sshConnectConfig;

其他代码自行根据逻辑实现

[github-actions]

Hello @, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好 @, 这个 issue 30 天内没有活跃，7 天后将关闭，如需回复，可以评论回复。

[mdzz9527]

好的,谢谢