apache / dolphinscheduler

Apache DolphinScheduler is the modern data orchestration platform. Agile to create high performance workflow with low-code
https://dolphinscheduler.apache.org/
Apache License 2.0
12.73k stars 4.58k forks source link

dolphin scheduler default admin user password correct but can not login #16391

Closed lgb861213 closed 2 months ago

lgb861213 commented 2 months ago

Search before asking

What happened

I not change the default user user admin. After running for a while, the password suddenly cannot be logged in normally. This exception occurred after I enabled the access token for admin. How can I reset the password?

What you expected to happen

how to reset default user admin password via cli

How to reproduce

After running for a while, the password suddenly cannot be logged in normally. This exception occurred after I enabled the access token for admin. How can I reset the password?

Anything else

No response

Version

3.2.x

Are you willing to submit PR?

Code of Conduct

lgb861213 commented 2 months ago

and the error message that is following: docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 46a35cea9eef ghcr.io/apache/dolphinscheduler/dolphinscheduler-worker:latest "/bin/bash /cacert…" 2 minutes ago Up About a minute (healthy) 1235/tcp docker-dolphinscheduler-worker-1 085cb31ba8c4 ghcr.io/apache/dolphinscheduler/dolphinscheduler-master:latest "/bin/bash /cacert…" 2 minutes ago Up About a minute (healthy) 5678-5679/tcp docker-dolphinscheduler-master-1 bdfe323d6865 ghcr.io/apache/dolphinscheduler/dolphinscheduler-alert-server:latest "/bin/bash /cacert…" 2 minutes ago Up About a minute (healthy) 50052-50053/tcp docker-dolphinscheduler-alert-1 3f9f0785e5c4 ghcr.io/apache/dolphinscheduler/dolphinscheduler-api:latest "/bin/bash /cacert…" 2 minutes ago Up About a minute (healthy) 0.0.0.0:12345->12345/tcp, :::12345->12345/tcp, 0.0.0.0:25333-25334->25333-25334/tcp, :::25333-25334->25333-25334/tcp docker-dolphinscheduler-api-1 8095619bcf42 bitnami/postgresql:15.2.0 "/opt/bitnami/script…" 2 minutes ago Up 2 minutes (healthy) 0.0.0.0:5432->5432/tcp, :::5432->5432/tcp docker-dolphinscheduler-postgresql-1 d9ac617fe9f8 bitnami/zookeeper:3.7.1 "/opt/bitnami/script…" 2 minutes ago Up 2 minutes (healthy) 2181/tcp, 2888/tcp, 3888/tcp, 8080/tcp docker-dolphinscheduler-zookeeper-1 [ec2-user@schedulerServer docker]$ docker logs -f --tail=10 docker-dolphinscheduler-api-1 127.0.0.1 - - [30/Jul/2024:00:40:49 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 5ms [ERROR] 2024-07-30 08:41:17.523 +0800 o.a.d.a.s.i.AbstractAuthenticator:[78] - Username or password entered incorrectly. 18.139.75.134 - - [30/Jul/2024:00:41:17 +0000] "POST /dolphinscheduler/login HTTP/1.1" 200 98 6ms 127.0.0.1 - - [30/Jul/2024:00:41:19 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 5ms 127.0.0.1 - - [30/Jul/2024:00:41:50 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 5ms 127.0.0.1 - - [30/Jul/2024:00:42:20 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 5ms 127.0.0.1 - - [30/Jul/2024:00:42:50 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 7ms 127.0.0.1 - - [30/Jul/2024:00:43:20 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 5ms 127.0.0.1 - - [30/Jul/2024:00:43:50 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 7ms 127.0.0.1 - - [30/Jul/2024:00:44:20 +0000] "GET /dolphinscheduler/actuator/health HTTP/1.1" 200 149 4ms

I use docker compose deploy the application

lgb861213 commented 2 months ago

login the postgresql sql container

docker exec -it docker-dolphinscheduler-postgresql-1 /bin/bash psql -Uroot -d dolphinscheduler 【login the pq database】

Generate an encrypted string of new password using md5

echo -n "Aa123456#" | md5

update the new password

update t_ds_user set user_password='c96da3623f1434248c7ee7f0be47a51d' where user_name='admin';

and then it can success login

lgb861213 commented 2 months ago

When I modify the application configuration file under the docker-dolphinscheduler-api-1 container to enable gateway and restart the container, the password is correct, but when logging in, the password is wrong. This should be a bug. Please fix it. Thank you.