How To Install ulogd2-mysql on Debian 9

In this tutorial we learn how to install ulogd2-mysql on Debian 9. ulogd2-mysql is MySQL extension to ulogd

Introduction

In this tutorial we learn how to install ulogd2-mysql on Debian 9.

What is ulogd2-mysql

ulogd2-mysql is:

ulogd is an advanced netfilter logging daemon. It can act as a replacement for syslog for logging netfilter ruleset violations (via the NFLOG or ULOG iptables targets), can gather per-connection accounting using NFCT, or gather per-rule accounting using NFACCT. Output can be sent to plain text log files, a variety of SQL database formats, XML files, pcap files, syslog, and many other formats.

This module adds MySQL support to ulogd. If you install this package, you can send netfilter logs or accounting data to a MySQL database.

There are three methods to install ulogd2-mysql on Debian 9. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install ulogd2-mysql Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install ulogd2-mysql using apt-get by running the following command:

sudo apt-get -y install ulogd2-mysql

Install ulogd2-mysql Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install ulogd2-mysql using apt by running the following command:

sudo apt -y install ulogd2-mysql

Install ulogd2-mysql Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Debian. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install ulogd2-mysql using aptitude by running the following command:

sudo aptitude -y install ulogd2-mysql

How To Uninstall ulogd2-mysql on Debian 9

To uninstall only the ulogd2-mysql package we can use the following command:

sudo apt-get remove ulogd2-mysql

Uninstall ulogd2-mysql And Its Dependencies

To uninstall ulogd2-mysql and its dependencies that are no longer needed by Debian 9, we can use the command below:

sudo apt-get -y autoremove ulogd2-mysql

Remove ulogd2-mysql Configurations and Data

To remove ulogd2-mysql configuration and data from Debian 9 we can use the following command:

sudo apt-get -y purge ulogd2-mysql

Remove ulogd2-mysql configuration, data, and all of its dependencies

We can use the following command to remove ulogd2-mysql configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge ulogd2-mysql

Dependencies

ulogd2-mysql have the following dependencies:

References

Summary

In this tutorial we learn how to install ulogd2-mysql package on Debian 9 using different package management tools: apt, apt-get and aptitude.