Difference between revisions of "Setup rsyslog"
From rdkwiki
m |
m |
||
Line 17: | Line 17: | ||
== mysql configuration == | == 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. | * 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. | + | * create a user on your MySQL-server that's only allowed to access the new syslog database. (for example: '''grant all on Syslog.* to <user>@<host> identified by '<password>';''') |
+ | * reload rights on MySQL. ('''flush privileges;''') |
Revision as of 18:58, 6 November 2016
Contents
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. (for example: grant all on Syslog.* to <user>@<host> identified by '<password>';)
- reload rights on MySQL. (flush privileges;)