On Tue, Apr 29, 2003 at 10:59:09AM +0200, Peter Osterberg wrote:
Since I had macros that didn't expand at all using rc2 I was happy to see the release of rc3.
Unfortunately there still are some macro issues in rc3 when using it on Slackware 9.0
The following conf file: destination d_mysql { pipe("/tmp/mysql.pipe" template("INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ('$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$DATE', '$TIME', '$PROGRAM', $MSG');\n") template-escape(yes) ); };
Epand like this INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ('hansen', 'syslog', 'notice', 'notice', '2d', 'Apr 28 22:23:37', '', 'syslog-ng', syslog-ng[13070]: STATS: dropped 0');
As you can see both date and time are expanded in $DATE and $TIME isn't expanded at all.
Result in the database table looks like this:
There's no such macro as time. These are the time related macros: { "DATE", M_DATE }, { "FULLDATE", M_FULLDATE }, { "ISODATE", M_ISODATE }, { "YEAR", M_YEAR }, { "MONTH", M_MONTH }, { "DAY", M_DAY }, { "HOUR", M_HOUR }, { "MIN", M_MIN }, { "SEC", M_SEC }, { "WEEKDAY", M_WEEKDAY }, { "UNIXTIME", M_UNIXTIME }, { "TZOFFSET", M_TZOFFSET }, { "TZ", M_TZ }, -- Bazsi PGP info: KeyID 9AF8D0A9 Fingerprint CD27 CFB0 802C 0944 9CFD 804E C82C 8EB1