How To Install rsyslog-mysql on Ubuntu 20.04
Introduction
In this tutorial we learn how to install rsyslog-mysql on Ubuntu 20.04.
What is rsyslog-mysql
rsyslog-mysql is:
This plugin allows rsyslog to write syslog messages into a MySQL database.
Package: rsyslog-mysql Architecture: amd64 Version: 8.2001.0-1ubuntu1 Priority: extra Section: universe/admin Source: rsyslog Origin: Ubuntu Maintainer: Ubuntu Developers [email protected] Original-Maintainer: Michael Biebl [email protected] Bugs: https://bugs.launchpad.net/ubuntu/+filebug Installed-Size: 75 Depends: libc6 (>= 2.4), libmysqlclient21 (>= 8.0.11), debconf (>= 0.5) | debconf-2.0, rsyslog (= 8.2001.0-1ubuntu1), dbconfig-common, ucf Recommends: default-mysql-client | virtual-mysql-client Suggests: default-mysql-server | virtual-mysql-server Filename: pool/universe/r/rsyslog/rsyslog-mysql_8.2001.0-1ubuntu1_amd64.deb Size: 10480 MD5sum: 0f763f7698d1caa002ac391eb458745b SHA1: 0502d7d2c0f078d7396438cd4212cea7d867dec4 SHA256: 60c25a32e2f4ac2ee238f068be10ab57e6fb90ccccdd8816f9dc6b0e2ebf2ffc Homepage: http://www.rsyslog.com/ Description-en: MySQL output plugin for rsyslog This plugin allows rsyslog to write syslog messages into a MySQL database.
There are three methods to install rsyslog-mysql on Ubuntu 20.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.
Install rsyslog-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 rsyslog-mysql using apt-get by running the following command:
sudo apt-get -y install rsyslog-mysql
Install rsyslog-mysql Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install rsyslog-mysql using apt by running the following command:
sudo apt -y install rsyslog-mysql
Install rsyslog-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 Ubuntu. Update apt database with aptitude using the following command.
sudo aptitude update
After updating apt database, We can install rsyslog-mysql using aptitude by running the following command:
sudo aptitude -y install rsyslog-mysql
How To Uninstall rsyslog-mysql on Ubuntu 20.04
To uninstall only the rsyslog-mysql package we can use the following command:
sudo apt-get remove rsyslog-mysql
Uninstall rsyslog-mysql And Its Dependencies
To uninstall rsyslog-mysql and its dependencies that are no longer needed by Ubuntu 20.04, we can use the command below:
sudo apt-get -y autoremove rsyslog-mysql
Remove rsyslog-mysql Configurations and Data
To remove rsyslog-mysql configuration and data from Ubuntu 20.04 we can use the following command:
sudo apt-get -y purge rsyslog-mysql
Remove rsyslog-mysql configuration, data, and all of its dependencies
We can use the following command to remove rsyslog-mysql configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge rsyslog-mysql
References
Summary
In this tutorial we learn how to install rsyslog-mysql package on Ubuntu 20.04 using different package management tools: apt, apt-get and aptitude.
