Title
#fleet
c

Chris B

07/30/2021, 3:19 PM
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.
a

Artem

07/30/2021, 3:21 PM
try login with email
c

Chris B

07/30/2021, 3:21 PM
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

Rachel Perkins

07/30/2021, 3:37 PM
Maybe try resetting your password and see if it sends an email to you?
c

Chris B

07/30/2021, 3:42 PM
Thanks, but tried that and pretty sure it won’t work anyway because smtp config is incorrect.
Rachel Perkins

Rachel Perkins

07/30/2021, 3:47 PM
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
c

Chris B

07/30/2021, 3:48 PM
Version 3.0 to latest
zwass

zwass

07/30/2021, 7:26 PM
When you say "basic auth" are you referring to HTTP Basic Auth (not supported by Fleet), or Fleet's standard authentication?
c

Chris B

07/30/2021, 7:42 PM
Hey 👋, 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

Rachel Perkins

07/30/2021, 8:15 PM
For the label issue, are you on ctl or the UI? Where is this outputting? Can you screenshot for more context?
c

Chris B

07/30/2021, 8:53 PM
@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 6 914 2021-07-30 19:32:56.627941726 +0000 UTC m=+1463.434697612 7 914 2021-07-30 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":""}`
8:54 PM
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

Rachel Perkins

07/30/2021, 9:06 PM
Ack, okay, @zwass will follow up on this, he has some suspicions with osquery but not sure