Configuring rsyslog

Ubuntu 10.04.3 comes with rsyslog 4.2.0 as its default logger. You can add MySQL output support and the Reliable Event Logging Protocol (RELP). Enter the following command:

About this task

root@linux:~$sudo apt-get install rsyslog-mysql rsyslog-relp
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
		dbconfig-common librelp0
The following NEW packages will be installed:
		dbconfig-common librelp0 rsyslog-mysql rsyslog-relp
0 upgraded, 4 newly installed, 0 to remove and 0 not upgraded.
Need to get 677kB of archives.
After this operation, 2,335kB of additional disk space will be used.
Do you want to continue [Y/n]? y

During the installation process, complete the following steps:

Procedure

Create the tables that are needed in MySQL when prompted.
Set the MySQL root password.
Create a password that the rsyslog processes will use in the configuration files.