[pmacct-discussion] No Sqlite3 logging

2009-11-09 Thread JF Cliche
Hi, I have successfully compiled pmacct-0.12.0rc3 on a Dlink DNS-323 Network Attached Storage which runs Linux on an ARM processor. I was able to run pmacctd using the memory plug-in and get traffic statistics all right. Great program! I then re-compiled with the Sqlite3 support, initialized a

Re: [pmacct-discussion] No Sqlite3 logging

2009-11-09 Thread Paolo Lucente
Hi JF, On Mon, Nov 09, 2009 at 05:09:40AM -0500, JF Cliche wrote: debug: true syslog: kern plugin_buffer_size: 10240 plugin_pipe_size: 10240 interface: egiga0 daemonize: false promisc: false sql_cache_entries: 2 plugins: sqlite3[in] sql_max_writers: 2 pidfile: /vol1/pmacct.pid

Re: [pmacct-discussion] No Sqlite3 logging

2009-11-09 Thread JF Cliche
Hello Paolo, I had played with many options in order to force the buffer to flush into the database file or test other hypotheses, but that did not help. But I admit I do not have a deep understanding of what every option does. In any case, I cleaned- up my config file and made sure I filter

Re: [pmacct-discussion] No Sqlite3 logging

2009-11-09 Thread Paolo Lucente
Hi JF, On Mon, Nov 09, 2009 at 10:26:35AM -0500, JF Cliche wrote: In any case, I cleaned- up my config file and made sure I filter nothing (see config below). I rechecked pmacctd using the memory plugin and data is being gathered. Then I relaunched with the sqlite3 plugin. 'pmacct -s' still

Re: [pmacct-discussion] No Sqlite3 logging

2009-11-09 Thread JF Cliche
Hello Paolo, Testing MySQL was my next step, but I'll need to learn how to set it up first. So I'll do my homeworks and I'll keep you posted. Thanks, JF On Mon, Nov 9, 2009 at 12:38 PM, Paolo Lucente pa...@pmacct.net wrote: Hi JF, On Mon, Nov 09, 2009 at 10:26:35AM -0500, JF Cliche wrote:

Re: [pmacct-discussion] No Sqlite3 logging

2009-11-09 Thread JF Cliche
Hello Paolo, I configured mySQL and everything works like a charm now. Due to the low CPU power on my NAS I had to increase the `plugin_buffer_size` to 102400 to make sure I do not miss any packets. The memory plugin was very useful to do the tuning. Note: in DEBUG mode, I had the impression