<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Hi,<br><br>I am having problem inserting logs into MySQL using match() that returns more than 10 arguements.<br><br><br>destination d_mysql {<br>pipe("/tmp/mysql.pipe"<br>template("INSERT INTO mydatabase (content_name) VALUES ('$10');\n") template-escape(yes));<br>};<br><br>filter f_filter { match ("^.*?: \"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)\",\"(.*)$"); };<br><br>log { source(s_stunnel); filter(f_filter); destination(d_mysql); };<br><br><br>incoming log message is as followed:<br>"test1","test2","test3","test4","test5","test6","test7","test8","test9","testN","testN1"<br><br>catting mysql.pipe:<br>$>cat /tmp/mysql.pipe<br><br>INSERT INTO mydatabase (content_name) VALUES
('test10');<br><br>So instead of 'testN', I am getting the 'test1' appends with 0 which is 'test10'<br><br>Thanks for the help!<br></div></div><br>
<hr size=1>Finding fabulous fares is fun.<br><a href="http://farechase.yahoo.com/promo-generic-14795097;_ylc=X3oDMTFtNW45amVpBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzEEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--
">Let Yahoo! FareChase search your favorite travel sites</a> to find flight and hotel bargains.</body></html>