You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@linkis.apache.org by GitBox <gi...@apache.org> on 2022/02/16 06:53:29 UTC
[GitHub] [incubator-linkis] Andywli opened a new issue #1487: [Bug] The database on the right side of Scriptis cannot be refreshed
Andywli opened a new issue #1487:
URL: https://github.com/apache/incubator-linkis/issues/1487
### Search before asking
- [X] I searched the [issues](https://github.com/apache/incubator-linkis/issues) and found no similar issues.
### Linkis Component
linkis-commons
### What happened + What you expected to happen
Scriptis的右侧刷不出来数据库，一直在刷新中（需要注意的是linkis的metadata暂时不支持对接sentry和Ranger只支持hive原生的权限控制），错误信息: 前端数据库tab一直处于刷新状态
The database on the right side of Scriptis cannot be refreshed, and it is being refreshed all the time (it should be noted that the metadata of linkis does not support docking with sentry and Ranger and only supports native permission control of hive),
error message: The front-end database tab is always in the refreshed state
### Relevent platform
·
### Reproduction script
·
### Anything else
这个问题来自Linkis社区的QA文档
This question comes from the QA documentation of the Linkis community
QA Doc Link：https://docs.qq.com/doc/DSGZhdnpMV3lTUUxq
### Are you willing to submit a PR?
- [ ] Yes I am willing to submit a PR!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For additional commands, e-mail: commits-help@linkis.apache.org
[GitHub] [incubator-linkis] Andywli commented on issue #1487: [Bug] The database on the right side of Scriptis cannot be refreshed
Posted by GitBox <gi...@apache.org>.
Andywli commented on issue #1487:
URL: https://github.com/apache/incubator-linkis/issues/1487#issuecomment-1041175932
这是因为右侧的数据库我们是限制了权限的，而这个依赖hive开启授权访问：
hive.security.authorization.enabled=true;
具体可以参考：https://blog.csdn.t/yancychas/article/details/84202[](https://blog.csdn.t/yancychas/article/details/84202)
开启如果配置了该参数还没有的话，那就需要给这个用户授予相应的库表权限，执行grant语句，可以参考相同的链接授权部分。
> #授权参考以hadoop为例:
> #进入hive client 查看hadoop用户数据库授权情况：
> show grant user hadoop on database default;
> #给用户数据库授权情况：
> grant all on database default to user hadoop;
如果不想开启权限控制，即每个用户都可以看到库表，可以修改：com/webank/wedatasphere/linkis/metadata/hive/dao/impl/HiveMetaDao.xml的sql去掉权限控制部分
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For additional commands, e-mail: commits-help@linkis.apache.org
[GitHub] [incubator-linkis] Andywli closed issue #1487: [Bug] The database on the right side of Scriptis cannot be refreshed
Posted by GitBox <gi...@apache.org>.
Andywli closed issue #1487:
URL: https://github.com/apache/incubator-linkis/issues/1487
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For additional commands, e-mail: commits-help@linkis.apache.org
[GitHub] [incubator-linkis] Andywli edited a comment on issue #1487: [Bug] The database on the right side of Scriptis cannot be refreshed
Posted by GitBox <gi...@apache.org>.
Andywli edited a comment on issue #1487:
URL: https://github.com/apache/incubator-linkis/issues/1487#issuecomment-1041173202
We have restricted permissions for the database on the right, and this relies on hive to enable authorized
> access:hive.security.authorization.enabled=true;
Reference：https://blog.csdn.t/yancychas/article/details/84202[](https://blog.csdn.t/yancychas/article/details/84202)
If this parameter is configured, it is necessary to grant the corresponding library table permission to the user and execute the grant statement. You can refer to the same link authorization section.
> # 授权参考以hadoop为例:
> # 进入hive client 查看hadoop用户数据库授权情况：
> show grant user hadoop on database default;
> # 给用户数据库授权情况：
> grant all on database default to user hadoop;
If you don't want to turn on permission control, that is, every user can see the library table, you can modify:com/webank/wedatasphere/linkis/metadata/hive/dao/impl/HiveMetaDao.xml
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For additional commands, e-mail: commits-help@linkis.apache.org
[GitHub] [incubator-linkis] Andywli edited a comment on issue #1487: [Bug] The database on the right side of Scriptis cannot be refreshed
Posted by GitBox <gi...@apache.org>.
Andywli edited a comment on issue #1487:
URL: https://github.com/apache/incubator-linkis/issues/1487#issuecomment-1041173202
We have restricted permissions for the database on the right, and this relies on hive to enable authorized
> access:hive.security.authorization.enabled=true;
Reference：https://blog.csdn.t/yancychas/article/details/84202[](https://blog.csdn.t/yancychas/article/details/84202)
If this parameter is configured, it is necessary to grant the corresponding library table permission to the user and execute the grant statement. You can refer to the same link authorization section.
> #授权参考以hadoop为例:
> #进入hive client 查看hadoop用户数据库授权情况：
> show grant user hadoop on database default;
> #给用户数据库授权情况：
> grant all on database default to user hadoop;
If you don't want to turn on permission control, that is, every user can see the library table, you can modify:com/webank/wedatasphere/linkis/metadata/hive/dao/impl/HiveMetaDao.xml
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For additional commands, e-mail: commits-help@linkis.apache.org
[GitHub] [incubator-linkis] Andywli commented on issue #1487: [Bug] The database on the right side of Scriptis cannot be refreshed
Posted by GitBox <gi...@apache.org>.
Andywli commented on issue #1487:
URL: https://github.com/apache/incubator-linkis/issues/1487#issuecomment-1041173202
We have restricted permissions for the database on the right, and this relies on hive to enable authorized
> access:hive.security.authorization.enabled=true;
Reference：https://blog.csdn.t/yancychas/article/details/84202[](https://blog.csdn.t/yancychas/article/details/84202)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For additional commands, e-mail: commits-help@linkis.apache.org