Sysadmin ααΆαα αααΎαααααΎααΆαααΆαααΆαααα»α ααααα»αααααααααΆααααα αΆα’αααΈαα½αααΎαα‘αΎα αα·αααΌαααΆαα’αααα αααα»αααα½ααα»αααααΌαααΆαααα½αααΆαααααΎα’αααΈαα»ααααααα Syslog ααΆαααααα Log System αααααΆααααααΆαααα½αα’αα Sysadmin ααΆαααΆαααα½ααα»αααααΌαα αααΎαααΆααα»α αα·αααα½αααααΆααααα α»αααααααα½αααΆαααααΎαα ααΎ System α¬ Server αα½αα
Syslog Server α’αΆα α’αα Server α¬ Router ααΆα αααΎαααα log report ααααΆαα Syslog Centralized Server ααΎααααΈα’αα System admin ααΆααααα½ααααα½ααα·αα·αααααΎαααΆααΎααΆαα’αααααααΆααΆαααΆααααααααΆααα αΌααα αααα»α System α¬ Router ααα¬αααααααα·αααΎαααα»αα αα»ααα½αααΆα Server α αααΎα ααΆαα·αααΆαααααααΆαααΆααααα½αααΆαααααααΆαα Syadmin ααααΎααΆαααΆαααααΆααααααααααΆααΌα ααΆαααααααααααααααΆααΎαα
ααΆαααααααααααΆααΆα Setup Syslog Server αα ααΎ Linux Centos 6.4
yum install -y rsyslog.* ααΎααααΈαααααΎα rsyslog server αα
αααα»αααΈαα»α
αααααΆαααα Restart Service
ααΆαααααααααααΆααΆαααααΆαα Syslog ααΆαα½α Database ααΎααααΈαααα»αααΆαα log file α’ααααΆαα αααΎααα αααα»α Database Mysql
Script αααααΆαααααααΎα database αααα Syslog
cat /usr/share/doc/rsyslog-mysql-*/createDB.sql | mysql -u root -p
αααααΆααααα αΌααα ααΆαα mysql ααΎααααΈααααααα·αααα’ααααΆα’αΆα Read/write αα ααΎ Database αααααΆαα
α
αΌααα
αα file /etc/rsyslog.confααΎααααΈααα SQL authentication α’αα Syslog α’αΆα
ααααα·ααααααα
αΌααααα»α Database ααΆα
αααααΆααααΈαααα½α restart service rsyslog αα½α α αΎαα αΌααα ααΎααα αααα»α database ααΎααααΈααααΆααααΆ αα·ααααααααΆαα αΌααα αααα»α database ααααΉαααααΌαααΌα αααααΆααα·ααα»αα¬αα α¬ αα»αα’αααΈαα½α?
ααΆααα·ααααααααΌα ααΌαααΆαααΎααααααααΆααααΆααααΉαααααΌα
ααΆααααααααααααααααα Mikrotik Router ααααΎααΆ Syslog client αααααΆααααααααααΆαα’αααα Syslog Server αααααΆ Linux ααΆα IP 192.168.153.144 port 514
Syslog αα·αααΆα Graphic ααΎαααααα ααΆααΆText Base ααΌα αααααααα·αααΎα ααααΆα Graphic ααΎαα’αΆα αααα‘αΌααα Loganalyzer ααααααΎααααΆααααΆα ααΎααααΈααΆααααα·ααααααααΈ MySQL Server αα αααα αΆαααΆαααααΆααα ααΎ Web base ααΆαα
αααααΆααααΈαααα‘αΌαααΆαα αΎαα’αΆα ααΆαααα ααΈααΆααααΆααααΆα ααααααΌαααααΆααααΆαα αααα»α linux server ααΆααααααΎα Php αα·α web server αα½α ααΆααααα ααΎααααΈααααΎαααΆααααααΎα Loganalyzer
ααΌαααΆααααααααα loganalyzer ααααΌαααΆαααΆαααα αααα»α /var/www/html/syslog
αααααΆααααα α»α ααΆαααΆαααααΆα αααα α»α Next ααΎααααΈααΆααα αααααααααααααα ααααα database, username,password
α α»α Next αααααα ααααα αΌααααα αα
Systemevent ααααΌαααααΌαα ααΆαα SystemEvents ααΎααααΈα’ααααααΌααα·α Database Table αα αααα»αLinux αααααΆααα Linux αααααΆααα’ααααααΌα αα
ααΆααααααααα ααΆ Report αααααΆαα αααΎααααααααα·αααΎαα·αααΆα Report ααααααΌα αααααΎα php-gd ααΎααααΈα’αΆα ααααΎ Report ααΆα
α α»ααααααα’ααααα·αααΆα Log Server αα½ααααα’αΆα α’ααααΎααααααααααααΆαααΆααΎαααΆααΆαα αΌααα ααααΎα’αααΈαααααα αααα»α Server, Router αα·α System αααααααααααΆα Function Syslogα