Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

运行一段时间后提示无权限访问 #4549

Closed
testnet0 opened this issue Sep 4, 2023 · 7 comments · Fixed by #4552
Closed

运行一段时间后提示无权限访问 #4549

testnet0 opened this issue Sep 4, 2023 · 7 comments · Fixed by #4552
Assignees
@JohnNiang
Labels
kind/bug Categorizes issue or PR as related to a bug.
Milestone
2.9.1

Comments

@testnet0
Copy link

testnet0 commented Sep 4, 2023

是什么版本出现了此问题？

2.6

使用的什么数据库？

MySQL 8.x

使用的哪种方式部署？

Docker

在线站点地址

No response

发生了什么？

docker-compose启动的，过段时间发现没办法登录后台，提示无权限访问：
image

相关日志输出

No response

附加信息

No response
@testnet0
Copy link
Author

testnet0 commented Sep 5, 2023

image

@testnet0
Copy link
Author

testnet0 commented Sep 5, 2023

image /actuator/globalinfo请求是正常的，其他路径都提示Access Denied，docker-compose重装升级都不行

@testnet0
Copy link
Author

testnet0 commented Sep 5, 2023

image

@JohnNiang
Copy link
Member

JohnNiang commented Sep 5, 2023 •
edited
Loading

建议升级到最新版本（2.9）后再试试。

目前我们无法复现该问题。

参考：#4332

/triage needs-information

@f2c-ci-robot f2c-ci-robot bot added the triage/needs-information Indicates an issue needs more information in order to work on it. label Sep 5, 2023
@testnet0
Copy link
Author

testnet0 commented Sep 5, 2023

定位到问题了，登录的时候用户名不区分大小写，但是登入后台后权限判断会区分大小写，导致用户没办法正常使用

@ruibaby
Copy link
Member

ruibaby commented Sep 5, 2023

定位到问题了，登录的时候用户名不区分大小写，但是登入后台后权限判断会区分大小写，导致用户没办法正常使用

应该和 #4372 是相同的问题。

@JohnNiang
Copy link
Member

那我先临时解决一下因为大小写问题导致仍然能够登录的问题。

/assign

@JohnNiang JohnNiang added kind/bug Categorizes issue or PR as related to a bug. and removed triage/needs-information Indicates an issue needs more information in order to work on it. labels Sep 5, 2023
@JohnNiang JohnNiang mentioned this issue Sep 5, 2023
Merged
f2c-ci-robot bot pushed a commit that referenced this issue Sep 7, 2023
@JohnNiang
Fix the problem of username being case-insensitive and logging in wit…
9c3e603 
…hout permissions (#4552)

#### What type of PR is this?

/kind bug
/area core
/milestone 2.10.x

#### What this PR does / why we need it:

This PR fixes the problem of username being case-insensitive and logging in without permissions. Please note that the problem only occurs with MySQL.

#### Which issue(s) this PR fixes:

Fixes #4549

#### Special notes for your reviewer:

```bash
docker run -it --rm --name halodb -p 3306:3306 -e MYSQL_ROOT_PASSWORD=openmysql -e MYSQL_DATABASE=halo mysql:8

./gradlew bootRun --args="--spring.profiles.active=dev,mysql --halo.plugin.runtime-mode=deployment"
```

#### Does this PR introduce a user-facing change?

```release-note
修复因大小写问题导致登录后无权限的问题
```
@JohnNiang JohnNiang added this to the 2.9.1 milestone Dec 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@JohnNiang JohnNiang

Labels
kind/bug Categorizes issue or PR as related to a bug.
Projects
None yet
Milestone
2.9.1
Development

Successfully merging a pull request may close this issue.

Fix the problem of username being case-insensitive and logging in without permissions JohnNiang/halo
3 participants
@JohnNiang @testnet0 @ruibaby