在studio中配置sftp上传文件,选择sftp方式查询不到文件

提问参考模版:

  • nebula 版本:3.5
  • nebula-studio 版本:3.7.0
  • 部署方式:单机
  • 安装方式:Docker
  • 是否上生产环境 N
  • 硬件信息
    • 磁盘( 推荐使用 SSD)
    • CPU、内存信息
  • 问题的具体描述
    因为需要导入的文件超出本地文件最大限制200M,在导入数据选择基于sftp的数据源文件时出现问题
  • 相关的 meta / storage / graph info 日志信息

以下是在终端访问的sftp截图,sftp根目录下是有文件存在,但是studio中确提示报错

{
	"@timestamp": "2023-06-09T14:45:05.950+08:00",
	"level": "error",
	"content": "servicecontext.go:53 [/api/datasources] request failed 40004000(ErrBadRequest::connect the sftp client error: failed to dial SSH server: ssh: handshake failed: ssh: unable to authenticate, attempted methods [none password], no supported methods remain):connect the sftp client error: failed to dial SSH server: ssh: handshake failed: ssh: unable to authenticate, attempted methods [none password], no supported methods remain\ngithub.com/vesoft-inc/nebula-studio/server/api/studio/pkg/ecode.WithErrorMessage\n\t/__w/nebula-studio/nebula-studio/source/nebula-graph-studio/server/api/studio/pkg/ecode/codes.go:57\ngithub.com/vesoft-inc/nebula-studio/server/api/studio/internal/service.(*datasourceService).Add\n\t/__w/nebula-studio/nebula-studio/source/nebula-graph-studio/server/api/studio/internal/service/datasource.go:65\ngithub.com/vesoft-inc/nebula-studio/server/api/studio/internal/logic/datasource.(*DatasourceAddLogic).DatasourceAdd\n\t/__w/nebula-studio/nebula-studio/source/nebula-graph-studio/server/api/studio/internal/logic/datasource/datasourceaddlogic.go:28\ngithub.com/vesoft-inc/nebula-studio/server/api/studio/internal/handler/datasource.DatasourceAddHandler.func1\n\t/__w/nebula-studio/nebula-studio/source/nebula-graph-studio/server/api/studio/internal/handler/datasource/datasourceaddhandler.go:30\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/vesoft-inc/go-pkg/middleware.ReserveResponseWriter.func1.1\n\t/github/home/go/pkg/mod/github.com/vesoft-inc/go-pkg@v0.0.0-20230307111816-a43d6a342d23/middleware/keep_request_responce.go:74\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/vesoft-inc/go-pkg/middleware.ReserveRequest.func1.1\n\t/github/home/go/pkg/mod/github.com/vesoft-inc/go-pkg@v0.0.0-20230307111816-a43d6a342d23/middleware/keep_request_responce.go:49\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/vesoft-inc/nebula-studio/server/api/studio/pkg/auth.AuthMiddlewareWithCtx.func1.1\n\t/__w/nebula-studio/nebula-studio/source/nebula-graph-studio/server/api/studio/pkg/auth/authorize.go:200\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/zeromicro/go-zero/rest/handler.GunzipHandler.func1\n\t/github/home/go/pkg/mod/github.com/zeromicro/go-zero@v1.3.3/rest/handler/gunziphandler.go:26\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/zeromicro/go-zero/rest/handler.MaxBytesHandler.func2.1\n\t/github/home/go/pkg/mod/github.com/zeromicro/go-zero@v1.3.3/rest/handler/maxbyteshandler.go:24\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/zeromicro/go-zero/rest/handler.MetricHandler.func1.1\n\t/github/home/go/pkg/mod/github.com/zeromicro/go-zero@v1.3.3/rest/handler/metrichandler.go:21\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/zeromicro/go-zero/rest/handler.RecoverHandler.func1\n\t/github/home/go/pkg/mod/github.com/zeromicro/go-zero@v1.3.3/rest/handler/recoverhandler.go:21\nnet/http.HandlerFunc.ServeHTTP\n\t/__w/_tool/go/1.19.2/x64/src/net/http/server.go:2109\ngithub.com/zeromicro/go-zero/rest/handler.(*timeoutHandler).ServeHTTP.func1\n\t/github/home/go/pkg/mod/github.com/zeromicro/go-zero@v1.3.3/rest/handler/timeouthandler.go:79\nruntime.goexit\n\t/__w/_tool/go/1.19.2/x64/src/runtime/asm_amd64.s:1594",
	"trace": "59caf2ef8932025f05270e7e64510058",
	"span": "841970e3a97f3959"
}

页面上操作流程是什么样的,选择 data source type 后立即就报这个错吗,还是选择后又执行了什么步骤。以及看看 studio 安装目录下 error.log 是否有相关记录

error.log里面的记录我看了下,没啥问题,选择data source type后立即就报错了,
在新建sftp数据源时是正常添加成功,没有报错

新建数据源和终端登录用的是同一个账号名么
另外方便的话看下根目录下有没有隐藏文件之类的
还有,因为 path 没有传,用 echo $HOME 查一下你的根目录是不是 /

您后,可以加您一下好友吗,我studio使用的是root用户,sftp用的是mysftp用户,用户是不一样的,
image

在这里记录解决过程吧。那你在添加数据源时候用 mysftp 会有什么问题么。或者你用 root 登录看根目录下有什么

可以在这里记录啊,就是有些事情和您直接联系比较清楚,问题解决了,我在这里记录一遍如何解决的也可以

此话题已在最后回复的 30 天后被自动关闭。不再允许新回复。