The macros related to the date of the message (for example: ${ISODATE}, ${HOUR}, and so on) have three further variants each:<\/p>\n\n\n\n
- S_ prefix, for example, ${S_DATE}: The ${S_DATE} macro represents the date found in the log message, that is, when the message was sent by the original application.
Caution: To use the S_ macros, the keep-timestamp() option must be enabled (this is the default behavior of syslog-ng OSE).<\/li>
- R_ prefix, for example, ${R_DATE}: ${R_DATE} is the date when syslog-ng OSE has received the message.<\/li>
- C_ prefix, for example, ${C_DATE}: ${C_DATE} is the current date, that is when syslog-ng OSE processes the message and resolves the macro.<\/li><\/ul>\n\n\n\n
The ${DATE} macro equals the ${S_DATE} macro.<\/p>\n\n\n\n
The values of the date-related macros are calculated using the original timezone information of the message. To convert it to a different timezone, use the time-zone() option. You can set the time-zone() option as a global option, or per destination. For sources, it applies only if the original message does not contain timezone information. Converting the timezone changes the values of the following date-related macros (macros MSEC and USEC are not changed):<\/p>\n\n\n\n
- AMPM<\/li>
- DATE<\/li>
- DAY<\/li>
- FULLDATE<\/li>
- HOUR<\/li>
- HOUR12<\/li>
- ISODATE<\/li>
- MIN<\/li>
- MONTH<\/li>
- MONTH_ABBREV<\/li>
- MONTH_NAME<\/li>
- MONTH_WEEK<\/li>
- SEC<\/li>
- STAMP<\/li>
- TZ<\/li>
- TZOFFSET<\/li>
- UNIXTIME<\/li>
- WEEK<\/li>
- WEEK_DAY<\/li>
- WEEK_DAY_ABBREV<\/li>
- WEEK_DAY_NAME<\/li>
- YEAR<\/li>
- YEAR_DAY<\/li><\/ul>\n\n\n\n
Zdroj:<\/p>\n\n\n\n
https://www.syslog-ng.com\/technical-documents\/doc\/syslog-ng-open-source-edition\/3.18\/administration-guide\/60<\/code><\/pre>\n\n\n\nnastavenie logovania do MYSQL<\/p>\n\n\n\n
destination d_mysql_vala {\n\n\nsql(\ntype(mysql)\nhost(\"192.168.191.21\")\nusername(\"syslogadmin\")\npassword(\"remotelog\")\ndatabase(\"lmsfin\")\ntable(\"logs\")\ncolumns(\"host\", \"facility\", \"priority\", \"level\", \"tag\", \"date\", \"time\", \"program\", \"msg\")\n#values(\"$HOST\", \"$FACILITY\", \"$PRIORITY\", \"$LEVEL\", \"$TAG\",\"$YEAR-$MONTH-$DAY\", \"$HOUR:$MIN:$SEC\",\"$PROGRAM\", \"$MSG\")\nvalues(\"$HOST\", \"$FACILITY\", \"$PRIORITY\", \"$LEVEL\", \"$TAG\",\"$C_YEAR-$C_MONTH-$C_DAY\", \"$C_HOUR:$C_MIN:$C_SEC\",\"$PROGRAM\", \"$MSG\")\n\nindexes(\"datetime\", \"host\", \"program\", \"msg\")\n);\n\n\n\n };\n<\/code><\/pre>\n\t