Howdy folks I m trying to login after an update from version

Question

Howdy folks I m trying to login after an update from version 3 to 4 and my basic auth user credentials aren t working Any idea what the change may be here I think the account I m using is the initial admin account which is created when installing version 3 0

Artem · Answer

try login with email

Chris B · Answer

I have tried to switch to emails which could have possibly been used with the username but none work with the known good password I also had the idea to login to MySQL to check for a users table to double check which email if any was associated with that but I m getting a connection error

Rachel Perkins · Answer

Maybe try resetting your password and see if it sends an email to you

Chris B · Answer

Thanks but tried that and pretty sure it won t work anyway because smtp config is incorrect

Rachel Perkins · Answer

Sorry just to clarify Which version did you upgrade from It s so odd because this is the first time I ve heard this error so trying to get more details

Chris B · Answer

Version 3 0 to latest

zwass · Answer

When you say basic auth are you referring to HTTP Basic Auth not supported by Fleet or Fleet s standard authentication

Chris B · Answer

Hey wave I meant standard auth I had to roll back and create a new user but got up and running Have some weird label related issues now failed to save labels insert label query executions

Rachel Perkins · Answer

For the label issue are you on ctl or the UI Where is this outputting Can you screenshot for more context

Chris B · Answer

< Rachel Perkins> this is fleet serve stdout output logged onto one of our app servers ` component service err failed to save labels insert label query executions 2021 07 30 19 32 56 627941726 +0000 UTC m=+1463 434697612 19 32 56 627941726 +0000 UTC m=+1463 434697612 19 32 56 627941726 +0000 UTC m=+1463 434697612 21 914 Error 1452 Cannot add or update a child row a foreign key constraint fails `kolide` `label membership` CONSTRAINT `fk lm label id` FOREIGN KEY `label id` REFERENCES `labels` `id` ON DELETE CASCADE ON UPDATE CASCADE ip addr 72 194 121 199 54316 level info method SubmitDistributedQueryResults took 2 570134ms ts 2021 07 30T19 32 56 628788844Z x for ip addr `

Chris B · Answer

It s happening repeatedly from hundreds of hosts It s like they re trying to push results from label queries from our old fleet instance which no longer exist

Rachel Perkins · Answer

Ack okay < zwass> will follow up on this he has some suspicions with osquery but not sure