[syslog-ng]Logging to mysql

[Richard Wallace]

Hello,
I've setup a rule to send all log messages received for the local0
facility to a program which then inserts info into a local mysql
database.  The problem is this isn't working.  The script doesn't appear
to be being called, since there are no messages in the mysql.log file
stating that anyone has tried to connect.

Here are the lines I've added.  Any help would be greatly appreciated.

destination local0 { program("/usr/local/sbin/rsynclog.pl"); };
filter f_local0 { facility(local0); };
log { source(src); filter(f_local0); destination(local0); };

Thanks
-- 
                                                 _
Richard Wallace                        /\       | |  /\          /|
AIM, Inc. (www.a--i--m.com)           /  \      | | /  \        / |
Information Systems Consultants       \   \     | | \   \      /  |
                                      /    \    | |  |   \    /   | 
"Providing New Technology,           / /\   \   | |  |    \  /    | 
     the Old-Fashioned Way"         / /  \   \  | |  | |\  \//|   | 
                                   / / /\ \   \ | |  | | \  / |   | 
                                  / /  \/  \  / | |  | |  \/  |   | 
                                  \/        \/  |_|  |_|      |___|