<div>Hello!</div><div><br></div><div>I have problem for Centos 6.Rebuild syslog-ng package for epel repo, because not have SQL support. </div><div>But i have this problem:</div><div><br></div><div><div>Error:</div><div><br>
</div><div>The number of columns and values do not match; len_columns='10', len_values='11'</div><div>Error initializing dest driver; dest='d_apache_mysql', id='d_apache_mysql#0'</div><div>
Error initializing message pipeline;</div><div><br></div><div>Config:</div><div><br></div><div><div>parser p_apache {</div><div>csv-parser(</div><div>columns(</div><div>"APACHE.CLIENT_IP",</div><div>"APACHE.IDENT_NAME",</div>
<div>"APACHE.USER_NAME",</div><div>"APACHE.TIMESTAMP",</div><div>"APACHE.REQUEST_URL",</div><div>"APACHE.REQUEST_STATUS",</div><div>"APACHE.CONTENT_LENGTH",</div><div>"APACHE.REFERER",</div>
<div>"APACHE.USER_AGENT",</div><div>"APACHE.VIRTUAL_HOST",</div><div>"APACHE.SERVER_NAME")</div><div>flags(escape-none,escape-backslash,escape-double-char,escape-double-char,strip-whitespace)</div>
<div>delimiters(" ")</div><div>quote-pairs('""[]')</div><div>);</div><div>};</div><div><br></div><div>destination d_apache_mysql {</div><div>sql(type(mysql)</div><div>host("localhost") username("root") password("xxxxx")</div>
<div>database("data")</div><div>table("accesslog")</div><div>columns("1", "2", "3", "4", "5", "6", "7", "8","9","10")</div>
<div>values("$APACHE.CLIENT_IP","$APACHE.IDENT_NAME","$APACHE.USER_NAME","$APACHE.TIMESTAMP","$APACHE.REQUEST_URL","$APACHE.REQUEST_STATUS","$APACHE.CONTENT_LENGTH","$APACHE.REFERER","$APACHE.USER_AGENT","$APACHE.VIRTUAL_HOST","$APACHE.SERVER_NAME")</div>
<div>indexes("1", "2", "3", "4", "5", "6", "7", "8","9","10"));</div><div>};</div><div><br></div><div>destination d_apache_me { file("/var/log/test.me.log"); };</div>
<div>filter f_apache_edata { facility(local6) and program(<a href="http://test.me">test.me</a>); };</div><div>log { source(s_sys); parser(p_apache); filter(f_apache_edata); destination(d_apache_mysql); };</div></div><div>
<br></div><div><br></div><div>Version:</div><div><br></div><div>LIBDBI:</div><div>Version : 0.8.3</div><br>Syslog-ng:
</div><div><div><br></div><div>syslog-ng 3.2.5</div><div>Installer-Version: 3.2.5</div><div>Revision: ssh+git://bazsi@git.balabit//var/scm/git/syslog-ng/syslog-ng-ose--mainline--3.2#master#9d4bea28198bd731df1a61e980a2af5b88d81116</div>
<div>Compile-Date: Jan 8 2012 22:19:13</div><div>Enable-Threads: on</div><div>Enable-Debug: off</div><div>Enable-GProf: off</div><div>Enable-Memtrace: off</div><div>Enable-Sun-STREAMS: off</div><div>Enable-IPv6: on</div>
<div>Enable-Spoof-Source: on</div><div>Enable-TCP-Wrapper: on</div><div>Enable-SSL: on</div><div>Enable-SQL: on</div><div>Enable-Linux-Caps: off</div><div>Enable-Pcre: on</div><div>Enable-Pacct: off</div></div><div><br></div>
<div>Strace:</div><div><br></div><div><a href="http://dl.dropbox.com/u/4683046/debug">http://dl.dropbox.com/u/4683046/debug</a></div><div><br></div><div>Thank you for all.</div><div><br></div><div>Best regards,</div><div>
<br></div><div>pigri</div>