Mailing List Archive: Selector and MySQL

> -----Original Message-----
> From: rsyslog-bounces at lists.adiscon.com [mailto:rsyslog-
> bounces at lists.adiscon.com] On Behalf Of leitstelle at bnet.li
> Sent: Monday, March 03, 2008 3:07 PM
> To: rsyslog at lists.adiscon.com
> Subject: [rsyslog] Selector and MySQL
>
> Hi all,
>
> i tried to write data into a DB with a selector
>
> in rsyslog.conf:
> ...
> !dhcpd
> $template test, "...",sql
> :msg, contains, "dinfo" >127.0.0.1,db,user,pw;test
> #eof
>
> one of the messages, which rsyslog is like:
> 2008-03-03 14:14.20 dhcpd : dinfo:, myipadress and mac

Umm... That message format looks strange. I guess the parser gets
confused by it. Can you please run rsyslogd in interactively in debug
mode (-d -n) and post the resulting log while such a message is
received.

Thanks,
Rainer

>
> So from my point of view the selector should write this message to the
> DB.
> BUT it doesn`t.
>
> If i replace the selector e.g. with *.info it works (but then all
> message are written to the DB)
>
> Thanks for your support
> Andre
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog