先安装mysql数据库(可以是别的服务器的)
再安装rsyslog对接mysql的rpm包
yum install -y rsyslog-mysql.x86_64
查看sql文件所在位置
rpm -ql rsyslog-mysql.x86_64
执行如下命令,替换路径为自己服务器路径
mysql -h192.168.1.188 -uroot -pPASSWORD < /usr/share/doc/rsyslog-8.24.0/mysql-createDB.sql
备份rsyslog默认配置文件
mv /etc/rsyslog.conf{,.bak}
重新生成rsyslog.conf
vim /etc/rsyslog.conf
粘贴下面的配置文件数据库IP、数据库名称、用户名、密码
$ModLoad imuxsock # provides support for local system logging (e.g. via logger command)
$ModLoad imjournal # provides access to the systemd journal
$Modload ommysql
$WorkDirectory /var/lib/rsyslog
$ActionFileDefaultTemplate RSYSLOG_TraditionalFileFormat
$IncludeConfig /etc/rsyslog.d/*.conf
$OmitLocalLogging on
$IMJournalStateFile imjournal.state
*.info;mail.none;authpriv.none;cron.none :ommysql:192.168.1.188,syslog,username,password
authpriv.* /var/log/secure
mail.* -/var/log/maillog
cron.* /var/log/cron
*.emerg :omusrmsg:*
uucp,news.crit /var/log/spooler
local7.* /var/log/boot.log
修改环境变量
vim /etc/profile
在末尾添加下面一行
PROMPT_COMMAND='{ msg=$(history 1 | { read x y; echo $y; });logger "[euid=$(whoami)]":$(who am i):[pwd]"$msg"; }'
在终端执行
source /etc/profile
重新启动rsyslog服务
systemctl restart rsyslog
OK