Howdy folks - I’m trying to login after an update ...
# fleet
c
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
try login with email
c
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.
r
Maybe try resetting your password and see if it sends an email to you?
c
Thanks, but tried that and pretty sure it won’t work anyway because smtp config is incorrect.
r
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
Version 3.0 to latest
z
When you say "basic auth" are you referring to HTTP Basic Auth (not supported by Fleet), or Fleet's standard authentication?
c
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”
r
For the label issue, are you on ctl or the UI? Where is this outputting? Can you screenshot for more context?
c
@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 193256.627941726 +0000 UTC m=+1463.434697612 6 914 2021-07-30 193256.627941726 +0000 UTC m=+1463.434697612 7 914 2021-07-30 193256.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-30T193256.628788844Z","x_for_ip_addr":""}`
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.
r
Ack, okay, @zwass will follow up on this, he has some suspicions with osquery but not sure