Channels
android_tests
apple-silicon
arm-architecture
auditing-warroom
aws
carving
code-review
community-feeds
core
darkbytes
doorman
ebpf
eclecticiq-polylogyx-extension
extensions
file-carving
fim
fleet
fleet-dev
fleetosquery
foundation
fuzzing
general
golang
goquery
infrastructure
jobs
kolide
linen-dev
linux
macos
officehours
osctrl
plugins
process-auditing
querycon
queryhub
random
selfgroup
sql
tls
uptycs
vendor-feeds
website
windows
zeek
zentral
zercurity
Title
w
wennan.he
09/26/2022, 6:06 PMHi fleet team, we have a fleet server just set up a new db but we got this err when we start fleet service:
Sep 23 23:53:02 n121-011-134 fleet[2423897]: ts=2022-09-23T23:53:02.009530884Z mysql="could not connect to db: dial tcp 127.0.0.1:3306: connect: connection refused, sleeping 7s"
but in our fleet.service cfg file, we had a different db
b
Benjamin Edwards
09/26/2022, 6:09 PMMaybe try reloading the daemon?
systemctl daemon-reload
w
wennan.he
09/26/2022, 6:10 PMi did it not working, but i will retry it again.
not working.
root@n121-011-134:~# systemctl start fleet.service
root@n121-011-134:~# systemctl status fleet.service
● fleet.service - Fleet
Loaded: loaded (/etc/systemd/system/fleet.service; disabled; vendor preset: enabled)
Active: active (running) since Mon 2022-09-26 22:05:07 UTC; 2s ago
Main PID: 224234 (fleet)
Tasks: 22 (limit: 39321)
Memory: 19.9M
CGroup: /system.slice/fleet.service
└─224234 /usr/bin/fleet serve \
Sep 26 22:05:07 n121-011-134 fleet[224234]: ts=2022-09-26T22:05:07.63953727Z mysql="could not connect to db: dial tcp 127.0.0.1:3306: connect: connection refused, sleeping 0s"
Sep 26 22:05:07 n121-011-134 fleet[224234]: ts=2022-09-26T22:05:07.639753047Z mysql="could not connect to db: dial tcp 127.0.0.1:3306: connect: connection refused, sleeping 1s"
Sep 26 22:05:08 n121-011-134 fleet[224234]: ts=2022-09-26T22:05:08.640153129Z mysql="could not connect to db: dial tcp 127.0.0.1:3306: connect: connection refused, sleeping 2s"
I dump the cfg of fleet and it is showing
fleet config_dump
mysql:
protocol: tcp
address: localhost:3306
username: fleet
password: ""
password_path: ""
database: fleet
tls_cert: ""
tls_key: ""
tls_ca: ""
tls_server_name: ""
tls_config: ""
max_open_conns: 50
max_idle_conns: 50
conn_max_lifetime: 0
sql_mode: ""
i would like to where does it come?
b
Benjamin Edwards
09/26/2022, 10:11 PMIt's the default value
w
wennan.he
09/26/2022, 10:13 PMbut hey it is loading the default val?
why doesn't it load my fleet.service?
i resolved the problem by removing another file with same prefix.