Unable to log-in with admin/non-Google user when autologin is activated in Google Auth settings

1

Hi there,
Here is the context: following the least privilege principle, we have a dedicated admin user account that we use to manage PMM and we have normal user accounts on the side that we use in our day to day working with PMM.

These user accounts are signing in using Google auth and everything is fine.

The problem is that, we just tried and activated a config called “Auto-login” or something like that in the Google Auth settings, and sure enough we don’t see PMM login page anymore, we are directly redirected to Google authentication.

The problem is that, since our “admin” user is “Google free” and since we cannot access the login page anymore, we are basically unable to login with our admin user anymore… and we cannot modify the config since our normal users are not admin.

I’m sure there is a way we can restore this “auto-login” configuration and disable it like it was before. We installed PMM as a docker container and we have access to the host machine, so no problem on this side.

Any help would be appreciated,

Thanks !

2

We figured out a solution which basically involves connecting to grafana postgre SQL database

docker exec -it pmm-server psql -U grafana

And then, fiddling around until we saw the auto_login property in the value of the settings column of the sso_setting table.

1 Like