Hi,
I am having problem inserting logs into MySQL using match() that
returns more than 10 arguements.
destination d_mysql {
pipe("/tmp/mysql.pipe"
template("INSERT INTO mydatabase (content_name) VALUES ('$10');\n")
template-escape(yes));
};
filter f_filter { match ("^.*?:
\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)$");
};
log { source(s_stunnel); filter(f_filter); destination(d_mysql); };
incoming log message is as followed:
"test1","test2","test3","test4","test5","test6","test7","test8","test9","testN","testN1"
catting mysql.pipe:
$>cat /tmp/mysql.pipe
INSERT INTO mydatabase (content_name) VALUES ('test10');
So instead of 'testN', I am getting the 'test1' appends with 0 which is
'test10'
Thanks for the help!