https://www.cnblogs.com/mchina/p/linux-centos-rsyslog-loganalyzer-mysql-log-server.html
安裝LNMP
一鍵安裝包：https://lnmp.org/download.html
下載下傳穩定版
nginx 1.12.2 + PHP5.5.38 + mysql 5.7.18
nginx配置：
cat loganalyzer.conf
server {
listen 80;
#listen [::]:80 default_server ipv6only=on;
server_name localhost;
index index.html index.htm index.php;
root /var/webroot/loganalyzer;
include enable-php.conf;
location ~ /\. {
deny all;
}
access_log /data/log/loganalyzer.access.log;
}
cat enable-php.conf
location ~ [^/]\.php(/|$)
{
try_files $uri =404;
fastcgi_pass unix:/tmp/php-cgi.sock;
fastcgi_index index.php;
include fastcgi.conf;
}
顯示IP
rsyslog 終端彈出消息 Message from [email protected] at Jan 16 13:59:34 ...
解決方法：删除edac子產品，是在開機前将外在的usb光驅拔掉引起的
先停止syslog：
systemctl stop rsyslog
lsmod | grep edac # 是否有以下兩個子產品
sb_edac 32018 0
edac_core 58151 1 sb_edac
把/etc/rsyslog/conf OmitLocalLogging 改成如下值
$OmitLocalLogging off
rmmod sb_eda
rmmod edac_core
再開啟rsyslog
systemctl start rsyslog
添加字段提示：Field 'Sortable' doesn't have a default value
解決方法：在/etc/my.conf的 [mysqld] 塊中添加下面這行
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
ESXi 設定 syslog
防火牆開放syslog端口
Dell iDrac設定遠端syslog