https://github.com/osquery/osquery logo
Title
a

Anoop K V

02/01/2023, 6:20 AM
Hi Fleet team, I was trying to upgrade my Fleet running 3.11 to 4.25 and unfortunately after the upgrade, my previous username/password combination is not being accepted. Thinking probably configs are lost, tried to set the Fleet up and that gets erred out with error "Error: Fleet has already been setup". Is there anyway I could force reset the fleet or recover password?
r

Rachel Perkins

02/01/2023, 2:22 PM
Ack, there's a forgot password link in the UI on the login page that will email you instructions to reset your password. Let us know if that doesn't work for your case.
b

Benjamin Edwards

02/01/2023, 2:33 PM
Note this only works of SMTP is configured.
a

Anoop K V

02/01/2023, 4:17 PM
Forgot password didn't work as it seems the SMTP configuration is as well got deleted. Same happened with the SSO configuration as well
r

Rachel Perkins

02/01/2023, 4:39 PM
So sorry, please hang tight
3.11 is pre-teams, policies, schedules, software inventory, vulnerable software, integrations--you're in for a treat. We have an engineer looking into a work around
z

zwass

02/01/2023, 5:54 PM
I think we may have changed from logging in with username to logging in with email?
r

Rachel Perkins

02/01/2023, 6:54 PM
It has since changed to email. Can you try this work around from one of our awesome engineers:
yeah I just managed to test it locally, so assuming they can connect to their mysql database, in the CLI or a mysql GUI:
insert into password_reset_requests (user_id, token, expires_at) values ((select id from users where name = 'martin'), 'secrettoken', date_add(current_timestamp, interval 10 minute));
(replace 'martin' by their username, 'secrettoken' with a secret)
then visit: https://localhost:8080/login/reset?token=secrettoken
(replace localhost:8080 by their Fleet server URL, and 'secrettoken' with the secret used above)
@Anoop K V Hope this does the trick!
a

Anoop K V

02/03/2023, 9:03 AM
Hi @Rachel Perkins, Thanks for the input. I have already deleted the DB and now the setup is running 3.11. I will probably be trying again to upgrade in next week and if needed, will follow the steps mentioned.