On Mon, 12 Mar 2012, Vlad Grigorescu wrote:
Hello,
I'm curious if anyone has tried receiving logs from a database into
rsyslog. I know there are several database output modules available, but
I have a number of systems that can only be configured to log to a
MS-SQL or MySQL database.
Other systems handle this by connecting to the database, running a
custom select statement, and receiving any new rows. Most often, the
timestamp (or other similar field) of the last record is saved, and the
next query uses this information to add a WHERE Timestamp >
$Saved_Timestamp clause.
Has anyone come across something that would do this? Ideally an rsyslog
input module, but if there was a program that could do this and output
the data to a flat file, that would obviously work as well.
Thanks in advance,
I don't know of any stock programs that would do this, but it seems like
it should be pretty trivial to write a small perl script that would read
the database, format the message, and send it to the standard syslog
interface.
David Lang
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
