I'm trying to upgrade from 2.6.0 to 3.1.0 and I'm ...
# kolided
darren
09/23/2020, 3:30 PMI'm trying to upgrade from 2.6.0 to 3.1.0 and I'm getting authentication errors for http and service components. Has anyone else come across this when upgrading from v2 to v3? If i roll back to version 2.6.0 everything works fine. Also the below error.
Copy code
{
"component": "http",
"err": "authentication error: missing node key",
"ts": "2020-09-23T15:18:39.879218643Z"
}z
zwass
09/23/2020, 4:17 PM
Are you certain those errors are only happening on 3.1.0? I can't think of anything that changed that would cause these errors. It indicates that requests from osquery agents do not include the node key used for authentication.
d
darren
09/23/2020, 4:18 PMyep, only happening on 3.0.0 and 3.1.0, if I roll back to any instance of version 2 everything works perfectly again
darren
09/23/2020, 4:20 PMOnce restarted if I try and load the hosts section of the web interface I get a 500 error
z
zwass
09/23/2020, 4:29 PM
Did you run the db migrations?
d
darren
09/23/2020, 4:31 PMyup
darren
09/23/2020, 4:31 PMi'll run them again
z
zwass
09/23/2020, 4:35 PM
When you were downgrading to 2.6.0 were you restoring from a backup? Because 2.6.0 should stop working after the migrations run.
d
darren
09/23/2020, 4:36 PMjust realised it's trying to do local migrations. Our DB is an RDS instance in AWS
z
zwass
09/23/2020, 4:37 PM
Pass the same env vars/config file/flags as the serve command and it will connect to the same DB.
zwass
09/23/2020, 4:37 PM
I think this should sort your issue.
zwass
09/23/2020, 4:37 PM
You'll probably find warnings in your logs that there are migrations that have not run.
zwass
09/23/2020, 4:37 PM
Not sure why it would have resulted in the particular error you saw though.
d
darren
09/23/2020, 4:37 PMokay will give it a go
darren
09/23/2020, 4:40 PM@zwass that has fixed it! thanks. Will update my chef cookbook to add a migration step 🙂
z
zwass
09/23/2020, 4:41 PM
Glad to hear it 🍻