FreeBSD 5.4 minimal install (fresh).
No Linux Binary Compatibility.
Mysql41-client installed using, "pkg_add -r mysql41-client".
Configured Makefile lines 20, 21, 29.
Compile: OK.
Fixed Runtime Error:
sample.conf [/etc/rsyslog.conf]
line 178: *.* >hostname,dbname,userid,password; #requires semi-colon
Debug Output:
test# rsyslogd -d
Allocated parts table for 2656 file descriptors.
Starting.
Called init.
cfsysline --> template TraditionalFormat,"%timegenerated% %HOSTNAME% %syslogtag%%msg:::drop-last-lf%\n"
cfsysline --> template precise,"%syslogpriority%,%syslogfacility%,%timegenerated:::fulltime%,%HOSTNAME%,%syslogtag%,%msg%\n"
Invalid field option 'fulltime' specified - ignored.
cfsysline --> template RFC3164fmt,"<%PRI%>%TIMESTAMP% %HOSTNAME% %syslogtag%%msg%"
cfsysline --> template wallmsg,"\r\n\7Message from syslogd@%HOSTNAME% at %timegenerated% ...\r\n %syslogtag%%msg%\n\r"
cfsysline --> template WinSyslogFmt,"%HOSTNAME%,%timegenerated:1:10:date-rfc3339%,%timegenerated:12:19:date-rfc3339%,%timegenerated:1:10:date-rfc3339%,%timegenerated:12:19:date-rfc3339%,%syslogfacility%,%syslogpriority%,%syslogtag%%msg%\n"
cfsysline --> template dbFormat,"insert into SystemEvents (Message, Facility,FromHost, Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag) values ('%msg%', %syslogfacility%, '%HOSTNAME%',%syslogpriority%, '%timereported:::date-mysql%', '%timegenerated:::date-mysql%', %iut%, '%syslogtag%')",sql
cfline(*.* >mysql.carcass.us,rsyslogtest,dennisolvany,password)
symbolic name: * ==> 255
leading char in action: >
in init() - WITH_DB case
logmsg: syslog.err<43>, flags 4, from test, msg rsyslogd: Could not find template 'password'
Called fprintlog, logging to CONSOLE
Called fprintlog, logging to TTY
Jun 28 14:23:27 test rsyslogd: Could not find template 'password'
rsyslogd: Could not find template 'password'
template 'password'
Segmentation fault (core dumped)
test#
After above procedures, rsyslog-0.9.1 is logging to database. Seems to be running properly.
No Linux Binary Compatibility.
Mysql41-client installed using, "pkg_add -r mysql41-client".
Configured Makefile lines 20, 21, 29.
Compile: OK.
Fixed Runtime Error:
sample.conf [/etc/rsyslog.conf]
line 178: *.* >hostname,dbname,userid,password; #requires semi-colon
Debug Output:
test# rsyslogd -d
Allocated parts table for 2656 file descriptors.
Starting.
Called init.
cfsysline --> template TraditionalFormat,"%timegenerated% %HOSTNAME% %syslogtag%%msg:::drop-last-lf%\n"
cfsysline --> template precise,"%syslogpriority%,%syslogfacility%,%timegenerated:::fulltime%,%HOSTNAME%,%syslogtag%,%msg%\n"
Invalid field option 'fulltime' specified - ignored.
cfsysline --> template RFC3164fmt,"<%PRI%>%TIMESTAMP% %HOSTNAME% %syslogtag%%msg%"
cfsysline --> template wallmsg,"\r\n\7Message from syslogd@%HOSTNAME% at %timegenerated% ...\r\n %syslogtag%%msg%\n\r"
cfsysline --> template WinSyslogFmt,"%HOSTNAME%,%timegenerated:1:10:date-rfc3339%,%timegenerated:12:19:date-rfc3339%,%timegenerated:1:10:date-rfc3339%,%timegenerated:12:19:date-rfc3339%,%syslogfacility%,%syslogpriority%,%syslogtag%%msg%\n"
cfsysline --> template dbFormat,"insert into SystemEvents (Message, Facility,FromHost, Priority, DeviceReportedTime, ReceivedAt, InfoUnitID, SysLogTag) values ('%msg%', %syslogfacility%, '%HOSTNAME%',%syslogpriority%, '%timereported:::date-mysql%', '%timegenerated:::date-mysql%', %iut%, '%syslogtag%')",sql
cfline(*.* >mysql.carcass.us,rsyslogtest,dennisolvany,password)
symbolic name: * ==> 255
leading char in action: >
in init() - WITH_DB case
logmsg: syslog.err<43>, flags 4, from test, msg rsyslogd: Could not find template 'password'
Called fprintlog, logging to CONSOLE
Called fprintlog, logging to TTY
Jun 28 14:23:27 test rsyslogd: Could not find template 'password'
rsyslogd: Could not find template 'password'
template 'password'
Segmentation fault (core dumped)
test#
After above procedures, rsyslog-0.9.1 is logging to database. Seems to be running properly.