Setup rsyslog

Intro

The steps below will configure a working rsyslog server. The steps assume that you have a (fresh) CentOS 7 server running.

MySQL installation

You can find how to install the MySQL database-server here: installing MySQL

Apache installation

You can find how to install the Apache webserver here: Installing Apache webserver

Download and install rsyslog

• wget http://rpms.adiscon.com/v8-stable/rsyslog.repo --> download the rsyslog repository
• mv rsyslog.repo /etc/yum.repos.d/ --> move the repo to the local repository
• yum install rsyslog* --skip-broken --> install rsyslog
• systemctl start rsyslog --> start the rsyslog server
• systemctl enable rsyslog --> start the rsyslog server during boot

mysql configuration

• run the script /usr/share/doc/rsyslog-mysql-8.xx.x/createDB.sql on your MySQL-server. This will create the database for rsyslog.
• create a user on your MySQL-server that's only allowed to access the new syslog database.