{"id":990,"date":"2014-04-17T10:20:14","date_gmt":"2014-04-17T10:20:14","guid":{"rendered":"http:\/\/blog.zhukunqian.com\/?p=990"},"modified":"2014-04-17T10:20:14","modified_gmt":"2014-04-17T10:20:14","slug":"rsyslog%e6%8e%a5%e6%94%b6%e6%97%a5%e5%bf%97%e5%86%99%e5%85%a5mysql%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"http:\/\/blog.zhukunqian.com\/?p=990","title":{"rendered":"rsyslog\u63a5\u6536\u65e5\u5fd7\u5199\u5165mysql\u914d\u7f6e"},"content":{"rendered":"<pre class=\"brush: shell; gutter: true\">$EscapeControlCharactersOnReceive off\r\n\r\n$template TraditionalFormat2,&quot;%msg%\\n&quot;\r\n$template TraditionalFormat3,&quot;%syslogtag% %msg%\\n&quot;\r\n$template TraditionalFormat4,&quot;%syslogtag% %msg%\\n&quot;\r\n$template StdSQLFormat,&quot;insert into bi_action(id,serverId,`date`,`%msg:R,ERE,1,DFLT:\\w+ \\w+ (\\w+)--end%`) values(%msg:R,ERE,1,DFLT:(\\w+)--end%,%msg:R,ERE,1,DFLT:\\w+ (\\w+) \\w+--end%,%$year%%$month%%$day%,1) on duplicate key update `%msg:R,ERE,1,DFLT:\\w+ \\w+ (\\w+)--end%`=`%msg:R,ERE,1,DFLT:\\w+ \\w+ (\\w+)--end%`+1  &quot;,SQL\r\n\r\n\r\n\r\n        if re_match($syslogtag,&#039;^moon[0-9]+-[a-zA-Z_]+.log$&#039;) then {\r\n                $ActionFileDefaultTemplate TraditionalFormat2\r\n                $template DynFile2,&quot;\/opt\/logs\/router-log\/%syslogtag:R,ERE,1,DFLT:(.*)-.*.log--end%\/%timegenerated:1:10:date-rfc3339%\/%syslogtag:R,ERE,1,DFLT:.*-(.*).log--end%.log&quot;\r\n                *.* -?DynFile2\r\n                $ModLoad ommysql\r\n                *.* :ommysql:127.0.0.1,Syslog,root,\r\n                stop\r\n        } else if re_match($syslogtag,&#039;^moon[0-9]+$&#039;) then {\r\n                        $ActionFileDefaultTemplate TraditionalFormat3\r\n                        $template DynFile3,&quot;\/opt\/logs\/router-log\/moon-alert.log&quot;\r\n                        *.* -?DynFile3\r\n                        stop\r\n        } else if re_match($syslogtag,&#039;^moon[0-9]+\\\\-BI$&#039;) then {\r\n                        $ActionFileDefaultTemplate TraditionalFormat4\r\n                        $template DynFile4,&quot;\/opt\/logs\/router-log\/moon-BI.log&quot;\r\n                        *.* -?DynFile4\r\n                        *.*     &gt;127.0.0.1,Syslog,root,;StdSQLFormat\r\n\r\n                        stop\r\n        }<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>$EscapeControlCharactersOnReceive off $t &hellip;<\/p>\n<p class=\"read-more\"><a href=\"http:\/\/blog.zhukunqian.com\/?p=990\">\u7ee7\u7eed\u9605\u8bfb &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/990"}],"collection":[{"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=990"}],"version-history":[{"count":2,"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/990\/revisions"}],"predecessor-version":[{"id":992,"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=\/wp\/v2\/posts\/990\/revisions\/992"}],"wp:attachment":[{"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=990"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.zhukunqian.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}