写进syslog_有什么简单的办法把syslog日志写入mysql中?

现在/var/log下有ns.log和win.log二个日志文件内容如下,多谢

Aug 13 13:32:19 192.168.1.2 NtServicePack: 4377: SERVER01\mw: 安装了 Windows Server 2003 修补程序 KB952954。

ug 13 13:32:20 192.168.1.2 Cannot format event ID 19: 找不到映像文件中指定的资源类型。

Aug 13 13:32:20 192.168.1.2 Windows Update Agent: 19: (Facility: 0, Status: Success)

Aug 13 13:32:20 192.168.1.7 Security: 538: SERVER02\mw: 用户注销: 用户名: mw 域: SERVER02 登录 ID: (0x0,0xBEA2E99) 登录类型: 3

Aug 13 13:32:22 192.168.1.7 Security: 680: SERVER02\mw: 尝试登录的用户: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 登录帐户: mw 源工作站: SERVER01 错误代码: 0x0

Aug 13 13:32:28 192.168.1.7 Security: 538: SERVER02\mw: 用户注销: 用户名: mw 域: SERVER02 登录 ID: (0x0,0xBEA55EC) 登录类型: 3

Aug 13 13:32:29 192.168.1.7 Security: 680: SERVER02\mw: 尝试登录的用户: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 登录帐户: mw 源工作站: SERVER01 错误代码: 0x0

ug 13 13:32:32 192.168.1.2 Cannot format event ID 19: 找不到映像文件中指定的资源类型。

Aug 13 13:32:32 192.168.1.2 Windows Update Agent: 19: (Facility: 0, Status: Success)

Aug 13 13:32:35 192.168.1.7 Security: 538: SERVER02\mw: 用户注销: 用户名: mw 域: SERVER02 登录 ID: (0x0,0xBEA6B64) 登录类型: 3

Aug 13 13:33:35 192.168.1.1 ns25: NetScreen device_id=0096072007000125  [Root]system-notification-00257(traffic): start_time="2008-08-13 13:36:44" duration=0 policy_id=14 service=https proto=6 src zone=Trust dst zone=Untrust action=Permit sent=0 rcvd=0 src=192.168.1.98 dst=124.161.68.195 src_port=2537 dst_port=443 src-xlated ip=192.168.16.3 port=9558 dst-xlated ip=124.161.68.195 port=443 session_id=30791 reason=Creation

Aug 13 13:33:35 192.168.1.1 ns25: NetScreen device_id=0096072007000125  [Root]system-notification-00257(traffic): start_time="2008-08-13 13:36:44" duration=0 policy_id=9 service=http proto=6 src zone=Trust dst zone=Untrust action=Permit sent=0 rcvd=0 src=192.168.1.131 dst=219.232.237.15 src_port=2158 dst_port=80 src-xlated ip=192.168.16.3 port=27414 dst-xlated ip=219.232.237.15 port=80 session_id=30265 reason=Creation

Aug 13 13:33:35 192.168.1.1 ns25: NetScreen device_id=0096072007000125  [Root]system-notification-00257(traffic): start_time="2008-08-13 13:36:44" duration=0 policy_id=14 service=https proto=6 src zone=Trust dst zone=Untrust action=Permit sent=0 rcvd=0 src=192.168.1.85 dst=123.185.134.222 src_port=3262 dst_port=443 src-xlated ip=192.168.16.3 port=3377 dst-xlated ip=123.185.134.222 port=443 session_id=30369 reason=Creation

Aug 13 13:33:36 192.168.1.1 ns25: NetScreen device_id=0096072007000125  [Root]system-notification-00257(traffic): start_time="2008-08-13 13:36:44" duration=0 policy_id=14 service=https proto=6 src zone=Trust dst zone=Untrust action=Permit sent=0 rcvd=0 src=192.168.1.74 dst=58.51.151.221 src_port=2383 dst_port=443 src-xlated ip=192.168.16.3 port=2039 dst-xlated ip=58.51.151.221 port=443 session_id=30526 reason=Creation

Aug 13 13:33:36 192.168.1.1 ns25: NetScreen device_id=0096072007000125  [Root]system-notification-00257(traffic): start_time="2008-08-13 13:36:45" duration=0 policy_id=14 service=https proto=6 src zone=Trust dst zone=Untrust action=Permit sent=0 rcvd=0 src=192.168.1.85 dst=60.15.211.185 src_port=3263 dst_port=443 src-xlated ip=192.168.16.3 port=8570 dst-xlated ip=60.15.211.185 port=443 session_id=30465 reason=Creation

作者: orrinchen

发布时间: 2008-08-13