Install Kolide Fleet Osquery Fleet Manager on Debian 10


Welcome to our guide on how to install Kolide Fleet Osquery fleet manager on Debian 10. Kolide Fleet is an opensource Osquery manager that expands the capabilities of osquery by enabling you to track, manage, and monitor entire osquery fleet.

Install Kolide Fleet Osquery Fleet Manager on Debian 10

Kolide Fleet is available as binary that can be just downloaded and installed by placing it on the binaries directory.

Download Kolide Fleet

Run the command below to download Kolide Fleet zipped binary.

wget -P /tmp 

Once the download is complete, extract the Kolide Fleet binaries for Linux platform.

cd /tmp
unzip 'linux/*' -d fleet

Install Kolide Fleet Binaries

The Kolide FLeet binaries, the fleet and fleetctl binaries are extracted to fleet/linux directory.

ls /tmp/fleet/linux/
 fleet  fleetctl

To install Kolide Fleet binaries, copy the binaries to /usr/bin directory.

cp /tmp/fleet/linux/{fleet,fleetctl} /usr/bin/

The Kolide Fleet binaries is now installed.

ls /usr/bin/fleet*
/usr/bin/fleet    /usr/bin/fleetctl

Install and Configure Kolide Fleet Dependencies

Kolide Fleet requires MySQL for its database and Redis server for ingesting and queueing the results of distributed queries, cache data, etc.

Install MySQL Database

Run the command install MySQL/MariaDB server.

apt install mariadb-server mariadb-client

Running MariaDB

MariaDB server is set to run and enabled to run on system boot upon installation. You can check the status;

systemctl status mariadb
systemctl is-enabled mariadb

Run the initial MySQL security script, mysql_secure_installation, to remove anonymous database users, test tables, disable remote root login.

Create Kolide Fleet Database and Database User

By default, MariaDB 10.3 uses unix_socket for authentication and hence, can login by just running, mysql -u root. If have however enabled password authentication, simply run;

mysql -u root -p

Next, create the Kolide database and user with all grants on Kollide DB.

create database kolide;
grant all on kolide.* to [email protected] identified by '[email protected]';
flush privileges;

Install Redis

Run the command below to install Redis.

apt install redis

Redis is set to start and enabled on system boot upon installation.

Running Kolide Fleet Server

Once you have installed and setup all the prerequisites for Kolide Fleet, you need to initializing Fleet infrastructure using the fleet prepare db as follows;

fleet prepare db --mysql_address= --mysql_database=kolide --mysql_username=kolideadmin [email protected]

If the initialization is complete, you should get the output,

Migrations completed.

Fleet serve is used to run the main HTTPS server. Hence, run the command below to generate self-signed certificates.

openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/ssl/private/kolide.key -out /etc/ssl/certs/kolide.cert

If you can, use the commercial TLS certificates.

Generate a random Json Web Token key for signing and verify session tokens. This will be required when running the fleet serve command for use with –auth_jwt_key option. It is however auto-generated when you do not provide this option with a random key value.

Testing Kolide Fleet

Kolide Fleet is setup and thus you need to run the command below to verify that it can run successfully using the fleet serve command as shown below

fleet serve --mysql_address= --mysql_database=kolide --mysql_username=kolideadmin \
   --mysql_password=hacker --server_cert=/etc/ssl/certs/kolide.cert --server_key=/etc/ssl/private/kolide.key \
   --logging_json --auth_jwt_key=yi+/uPJ0XvdrcEvTsZYKWz4oagO+8o57 

If all is well, you should see that Fleet server is now running on and hence can be accessed on https://<server-IP>:8080.


Create Kolide Fleet Systemd Service Unit

Once you have verified that Kolide Fleet is running fine, create a systemd service file.

vim /etc/systemd/system/kolide-fleet.service
Description=Kolide Fleet Osquery Fleet Manager

ExecStart=/usr/bin/fleet serve \
  --mysql_address= \
  --mysql_database=kolide \
  --mysql_username=kolideadmin \
  --mysql_password=hacker \
  --redis_address= \
  --server_cert=/etc/ssl/certs/kolide.cert \
  --server_key=/etc/ssl/private/kolide.key \
  --auth_jwt_key=yi+/uPJ0XvdrcEvTsZYKWz4oagO+8o57 \
ExecStop=kill -15 $(ps aux | grep "fleet serve" | grep -v grep | awk '{print$2}')


Save the file and reload systemd configurations.

systemctl daemon-reload

Start and enable Kolide Fleet service.

systemctl start kolide-fleet.service
systemctl enable kolide-fleet.service

Check the status;

systemctl status kolide-fleet.service
● kolide-fleet.service - Kolide Fleet Osquery Fleet Manager
   Loaded: loaded (/etc/systemd/system/kolide-fleet.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2019-08-12 21:16:32 EAT; 7min ago
 Main PID: 14406 (fleet)
    Tasks: 7 (limit: 1150)
   Memory: 14.1M
   CGroup: /system.slice/kolide-fleet.service
           └─14406 /usr/bin/fleet serve --mysql_address= --mysql_database=kolide --mysql_username=kolideadmin --mysql_password=hacker --redis_address=127.0.

Aug 12 21:16:32 systemd[1]: Started Kolide Fleet Osquery Fleet Manager.
Aug 12 21:16:32 fleet[14406]: {"component":"service","err":null,"method":"ListUsers","took":"272.605µs","ts":"2019-08-12T18:16:32.206172973Z","user":
Aug 12 21:16:32 fleet[14406]: {"address":"","msg":"listening","transport":"https","ts":"2019-08-12T18:16:32.208622615Z"}

Access Kolide Fleet

Now that Kolide Fleet is running, you can access it on the browser using the URL https://<server-IP>:8080.

Install Kolide Fleet Osquery Fleet Manager on Debian 10

Create your fist Fleet account and by providing the username, password, email, organization name, confirm the fleet web address. Click submit and login to your Kolide Fleet server.

Install Kolide Fleet Osquery Fleet Manager on Debian 10

Adding New Hosts to Kolide

Next, you can begin by installing osquery on your Kolide Fleet server. We have already covered the installation of osquery on Debian 10 in our previous guide, see the link below;

Install Osquery on Debian 10 Buster

Once osquery is installed, add your host to Kolide by navigating to Hosts > Add New Hosts. When you click Add new host, a wizard like in below pops with the instructions on how to add hosts to flight instance.

Add Kolide Fleet host

To enroll your osquery, you need the secret key and the TLS certificate. Hence, click reveal secret to see the key and click fetch flee certificate to download and install the certificate on the host as follows;

echo "t3wa+W7C2S47AZ24/ETi8xPXK2BuiLWO" > /var/osquery/secret
cp /var/osquery/server.pem

Next, stop the osqueryd if it is running;

systemctl stop osqueryd

Run osqueryd with the following options, replacing the –enroll_secret_path and –tls_server_certs accordingly.

/usr/bin/osqueryd --enroll_secret_path=/var/osquery/enroll_secret \
--tls_server_certs=/var/osquery/server.pem \
--tls_hostname=localhost:8080 \
--host_identifier=uuid \
--enroll_tls_endpoint=/api/v1/osquery/enroll \
--config_plugin=tls \
--config_tls_endpoint=/api/v1/osquery/config \
--config_refresh=10 \
--disable_distributed=false \
--distributed_plugin=tls \
--distributed_interval=3 \
--distributed_tls_max_attempts=3 \
--distributed_tls_read_endpoint=/api/v1/osquery/distributed/read \
--distributed_tls_write_endpoint=/api/v1/osquery/distributed/write \
-logger_plugin=tls \
--logger_tls_endpoint=/api/v1/osquery/log \

If all goes well, your host should be enrolled.

kolide osquery first fleet enrollment

Next, edit osqueryd service and add the options used above such such that the service configuration file looks like;

cat /lib/systemd/system/osqueryd.service
Description=The osquery Daemon
After=network.service syslog.service

ExecStartPre=/bin/sh -c "if [ ! -f $FLAG_FILE ]; then touch $FLAG_FILE; fi"
ExecStartPre=/bin/sh -c "if [ -f $LOCAL_PIDFILE ]; then mv $LOCAL_PIDFILE $PIDFILE; fi"
ExecStart=/usr/bin/osqueryd \
  --flagfile $FLAG_FILE \
  --config_path $CONFIG_FILE \
  --enroll_secret_path=/var/osquery/enroll_secret \
  --tls_server_certs=/var/osquery/server.pem \
  --tls_hostname=localhost:8080 \
  --host_identifier=uuid \
  --enroll_tls_endpoint=/api/v1/osquery/enroll \
  --config_plugin=tls \
  --config_tls_endpoint=/api/v1/osquery/config \
  --config_refresh=10 \
  --disable_distributed=false \
  --distributed_plugin=tls \
  --distributed_interval=3 \
  --distributed_tls_max_attempts=3 \
  --distributed_tls_read_endpoint=/api/v1/osquery/distributed/read \
  --distributed_tls_write_endpoint=/api/v1/osquery/distributed/write \
  -logger_plugin=tls \
  --logger_tls_endpoint=/api/v1/osquery/log \


Reload system daemons.

systemctl daemon-reload

Start osqueryd.

systemctl start osqueryd

You can now query your host from Kolide Fleet server. For example, to query non system users with the query, select username,directory,uid,gid,shell from users where uid >= 1000;

Kolide Fleet host queries

There you go. You have successfully setup Kolide Fleet Osquery Fleet Manager on Debian 10 Buster and you now add other fleets so that you can manage the querying from a single dashboard. Enjoy.


Please enter your comment!
Please enter your name here