While try to login to the PMM interface we facing invalid user and password issue

[Raja_Chandra_Sekaran]

Could somebody help us with this issue? According to the PMM documentation we have configured this pmm. This PMM Version: 2.42.0 we are using for MySQL server 8.0.34 version

[Vadim_Yalovets]

Hi @Raja_Chandra_Sekaran

Please take a look at this blog post

[Raja_Chandra_Sekaran]

Hello @Vadim_Yalovets
Also, we tried to change the password for the admin user successfully. During the PMM configuration, we didn’t get any errors. But still, we were facing the same issue as we mentioned in the screenshot above.

[Vadim_Yalovets]

Was is indicated that password was successfully changed?

e.g.

[Raja_Chandra_Sekaran]

@Vadim_Yalovets
yes, the password has been successfully changed. each and every step has been executed without error while we try to open the PMM login page its show like invalid user and password.

[VASANTHAKUMAR_M]

Hi Mr. @Vadim_Yalovets

Good Morning!!!

Any good update on this?

we are tried all the possiblities from our end but finally we are getting same issue like invalid username and password

Please give a proper solution we already took more days regarding this issue.

[Vadim_Yalovets]

Hi @VASANTHAKUMAR_M,
Could you check grafana logs?
e.g.

docker exec -it pmm-server bash -c "less /srv/logs/grafana.log | grep error"

[Raja_Chandra_Sekaran]

Hi @Vadim_Yalovets
Sure we will check this, Thanks for the update.

[Raja_Chandra_Sekaran]

Hi @Vadim_Yalovets

Good Morning

While we checked the error log we faced this error as we mentioned below
kindly give some solutions regarding this error which we have shared here

[ademidoff]

Hi,

from what I see in the logs - in particular, 3306: connect: connection refused error - it seems like PMM Server is trying to connect to a MySQL database, which we don’t support for PMM Server persistence.

[Raja_Chandra_Sekaran]

Hi @ademidoff

Thanks for the reply the version that you are pointing to here is MySQL or PMM?

Currently, we are using:

MySQL version - 8.0.34
PMM server version - 2.42.0
OS VERSION -“24.04 LTS (Noble Numbat)”

Do we need to configure any other specific version of PMM kindly let us know.

Note: We also tried to install the older version of PMM 2.38.0 still facing the same issues.

For every time we tried to resolve this issue at last we came up with the error invalid user and password.

[VASANTHAKUMAR_M]

Hi Team,

Good morining !!!

If there are any findings from your end. Please share here.

[Sarath_VS]

Hi team
I am also trying to successfully change password for admin user using these commands
docker exec -it pmm-server bash
** grafana-cli --homepath /usr/share/grafana admin reset-admin-password admin123**
** supervisorctl restart grafana**

But when trying to login PMM console it shows as invalid username or password.
Can you give me a solution.

[VASANTHAKUMAR_M]

Someone explain here. when I try to login to pmm I get an error like Invalid username and password.

we checked all the points which we got from your end

Note : pmm installation - no errors are encountered

[pravata_dash]

@ademidoff
I am also facing the same invalid password issue while resetting PWD for admin user, tried all above mentioned options, still same issue.

The login is working fine for other non-admin users, how to reset the admin PWD OR create a new admin user!!
Do we have any solution here?

Tried ones:

docker exec pmm-server change-admin-password admin@123
docker restart xxxxx```

docker exec -it pmm-server bash
grafana-cli --homepath /usr/share/grafana admin reset-admin-password admin@123
supervisorctl restart grafana```

[ademidoff]

Hey!

I’ve just tested it one more time on percona/pmm-server:2.44.0 and it worked fine. I used the same password “admin@123”. However, if your password contains special characters, like “!/$&%#?*”, you should wrap it in double quotes.

So the syntax is as follows: docker exec -it pmm-server change-admin-password "admin@123". Upon completion you should see the message “Admin password changed successfully ” in the console. There is actually no need to restart grafana, it works without restarting.

Depending on PMM version, the command syntax may vary. You can refer to FAQ - Percona Monitoring and Management.

Please let us know if it helped.

Alex

[pravata_dash]

@ademidoff
Our PMM version is 2.39.0.
As mentioned in the doc, I had tried and also got success response, but still its showing invalid username OR pwd!!
“Admin password changed successfully :heavy_check_mark:”
Also, our PWD is not having any special character, it’s a plain text.

As admin user was being used for pushing metrics, its failing for all clusters now.
Any alternative here to login using admin user and also to push metrics???
PFA

[ademidoff]

Hi!

Sorry to hear it didn’t work for you We tested 2.39.0 as well and didn’t see what could be wrong with the password reset.

Well, one option to reset the admin user’s password is if you have at least one more admin user. If that’s the case, you can log in to PMM, go to https://pmm-server/graph/admin/users, select the admin user whose password you need to change, and change it via the user interface.

Otherwise, what is the output of docker exec -it pmm-server change-admin-password ...?

Alex

[Raja_Chandra_Sekaran]

Hi @ademidoff,
Thanks for your valuable reply we tried that method too.

[Marvin_Stelter]

had this problem too. I solved it by stopping every PMM client, then resetting the password and waiting a few hours.

I’m not sure, but I guess that the client tried to log in with an incorrect password, and Grafana/PMM blocked every login attempt even when the password was correct.

After a few minutes / hours it worked again, then I updated the pmm-client config with the new password and restarted the clients.