https://github.com/osquery/osquery logo
#fleet
Title
# fleet
d

demonbhao

11/09/2020, 7:49 AM
Hello。Such an error occurred when Upgrading Fleet, indicating that the connection was rejected, but It was normal for me to link to the database
n

Noah Talerman

11/09/2020, 6:29 PM
Hi! The serve command will not set up the database. You can pass the database configuration (mysql_address, mysql_database, mysql_username and mysql_password params) to the prepare db command. Let me know if you continue to have issues!
d

demonbhao

11/10/2020, 2:42 AM
Then I should have used./ fleet prepare db --mysql_address = XXX :3306 \ --mysql_database = XXX \ --mysql_username = XXX \ --mysql_password = XXX?
n

Noah Talerman

11/10/2020, 6:32 PM
Correct. Let me know how this goes!
d

demonbhao

11/12/2020, 2:44 AM
Below is my result, indicating that I don't know the port, but my port is 3306
I also made various errors in the test environment😢
n

Noah Talerman

11/12/2020, 7:08 PM
@zwass I’m past my current level of understanding. Initially (first screenshot) was incorrectly trying to connect to localhost. It seems like the address change was registered (third screenshot)? Maybe incorrectly.
z

zwass

11/12/2020, 7:11 PM
@demonbhao those backslashes are incorrect
if you replace
prepare db
with
config_dump
you will see that those backslashes are causing Fleet to read different values than you expect.
d

demonbhao

11/13/2020, 3:16 AM
Hello, I have successfully upgraded Fleet, but now I cannot display the IP address of the agent in fleet UI after the successful upgrade😂
n

Noah Talerman

11/13/2020, 6:32 PM
Do you mind checking what the response object looks like for the
/hosts
endpoint? In this screenshot I’m using the network tab in chrome’s dev tools.
d

demonbhao

11/16/2020, 2:04 AM
Hello, this is my response
Hello, after the client restarts the osquery service, the IP address will be displayed normally again Do you need to restart the osquery service of the client in this way after upgrading the Fleet server?
z

zwass

11/16/2020, 5:34 PM
Normally you do not need to restart osquery after upgrading the Fleet server. It's possible something went wrong in this scenario and it was fixed when osquery restarted.
👍 1
d

demonbhao

11/17/2020, 2:08 AM
Ok, I see
z

zwass

11/17/2020, 2:10 AM
If you see something like this again or find a way to reproduce it please let us know so we can investigate further.
d

demonbhao

11/17/2020, 3:38 AM
Okay, I will.
2 Views