<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=&#39;10&#39;, len_values=&#39;11&#39;</div><div>Error initializing dest driver; dest=&#39;d_apache_mysql&#39;, id=&#39;d_apache_mysql#0&#39;</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>&quot;APACHE.CLIENT_IP&quot;,</div><div>&quot;APACHE.IDENT_NAME&quot;,</div>
<div>&quot;APACHE.USER_NAME&quot;,</div><div>&quot;APACHE.TIMESTAMP&quot;,</div><div>&quot;APACHE.REQUEST_URL&quot;,</div><div>&quot;APACHE.REQUEST_STATUS&quot;,</div><div>&quot;APACHE.CONTENT_LENGTH&quot;,</div><div>&quot;APACHE.REFERER&quot;,</div>
<div>&quot;APACHE.USER_AGENT&quot;,</div><div>&quot;APACHE.VIRTUAL_HOST&quot;,</div><div>&quot;APACHE.SERVER_NAME&quot;)</div><div>flags(escape-none,escape-backslash,escape-double-char,escape-double-char,strip-whitespace)</div>
<div>delimiters(&quot; &quot;)</div><div>quote-pairs(&#39;&quot;&quot;[]&#39;)</div><div>);</div><div>};</div><div><br></div><div>destination d_apache_mysql {</div><div>sql(type(mysql)</div><div>host(&quot;localhost&quot;) username(&quot;root&quot;) password(&quot;xxxxx&quot;)</div>
<div>database(&quot;data&quot;)</div><div>table(&quot;accesslog&quot;)</div><div>columns(&quot;1&quot;, &quot;2&quot;, &quot;3&quot;, &quot;4&quot;, &quot;5&quot;, &quot;6&quot;, &quot;7&quot;, &quot;8&quot;,&quot;9&quot;,&quot;10&quot;)</div>
<div>values(&quot;$APACHE.CLIENT_IP&quot;,&quot;$APACHE.IDENT_NAME&quot;,&quot;$APACHE.USER_NAME&quot;,&quot;$APACHE.TIMESTAMP&quot;,&quot;$APACHE.REQUEST_URL&quot;,&quot;$APACHE.REQUEST_STATUS&quot;,&quot;$APACHE.CONTENT_LENGTH&quot;,&quot;$APACHE.REFERER&quot;,&quot;$APACHE.USER_AGENT&quot;,&quot;$APACHE.VIRTUAL_HOST&quot;,&quot;$APACHE.SERVER_NAME&quot;)</div>
<div>indexes(&quot;1&quot;, &quot;2&quot;, &quot;3&quot;, &quot;4&quot;, &quot;5&quot;, &quot;6&quot;, &quot;7&quot;, &quot;8&quot;,&quot;9&quot;,&quot;10&quot;));</div><div>};</div><div><br></div><div>destination d_apache_me { file(&quot;/var/log/test.me.log&quot;); };</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>