Mailing List Archive

Rsyslog-0.9.1 w/MySQL on FreeBSD 5.4: One Issue
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.
Rsyslog-0.9.1 w/MySQL on FreeBSD 5.4: One Issue [ In reply to ]
Will see that I remove the semicolon bug soon. Can't be a big issue, but
obviously annoying... All in all, I think I will move the database write
to outchannel definitions, but that's more work ;) well... a lot to do.
The next things I'd like to do is support for larger size messages and
TCP logging. let me see ;)

Thanks for the test,
Rainer

> -----Original Message-----
> From: rsyslog-bounces@lists.adiscon.com
> [mailto:rsyslog-bounces@lists.adiscon.com] On Behalf Of Dennis Olvany
> Sent: Tuesday, June 28, 2005 5:05 PM
> To: rsyslog@lists.adiscon.com
> Subject: [rsyslog] Rsyslog-0.9.1 w/MySQL on FreeBSD 5.4: One Issue
>
> 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:::fu
lltime%,%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%,%ti
megenerated: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.
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
>